Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
August 1, 2008
How adding another table to JOIN can improve performance ?
JOINs are expensive and it most typical the fewer tables (for the same database) you join the better performance you [...]
July 20, 2008
Sphinx 0.9.8 is released just in time for OSCON 2008
As you probably already seen in a post by Baron, Sphinx Release 0.9.8 is finally out, just in time for [...]
July 20, 2008
Missing Data – rows used to generate result set
As Baron writes it is not the number of rows returned by the query but number of rows accessed by [...]
July 3, 2008
How to load large files safely into InnoDB with LOAD DATA INFILE
Recently I had a customer ask me about loading two huge files into InnoDB with LOAD DATA INFILE. The goal [...]
June 26, 2008
Web Site Optimization: FrontEnd and BackEnd
I spent Monday and Tuesday this week on Velocity Conference It was quite interesting event worth attending and it was [...]
June 17, 2008
Lighttpd as reverse proxy
We often recommend to set lighttpd in front of apache to handle http requests (more about https://www.percona.com/blog/speedup-your-lamp-stack-with-lighttpd/ ) , redirect dynamic [...]
May 20, 2008
Apache PHP MySQL and Runaway Scripts
Sometimes due to programming error or due to very complex query you can get your PHP script running too long, [...]
April 28, 2008
The MySQL optimizer, the OS cache, and sequential versus random I/O
In my post on estimating query completion time, I wrote about how I measured the performance on a join between [...]
April 23, 2008
Efficient Boolean value storage for Innodb Tables
Sometimes you have the task of storing multiple of boolean values (yes/now or something similar) in the table and if [...]
April 18, 2008
Idea: Couple of more string types
MySQL has a lot of string data types – CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch of variants such as [...]
April 4, 2008
Multi-Column IN clause – Unexpected MySQL Issue
We have an application which stores massive amount of urls. To save on indexes instead of using URL we index [...]
April 2, 2008
Stored Function to generate Sequences
Today a customer asked me to help them to convert their sequence generation process to the stored procedure and even [...]
March 13, 2008
Economics of Performance Optimization
I think every person responsible for Development or Operations of growing application sooner or later have to decide on couple [...]
March 7, 2008
Speeding up GROUP BY if you want aproximate results
Doing performance analyzes today I wanted to count how many hits come to the pages which get more than couple [...]
March 6, 2008
Sphinx 0.9.8 reaches RC stage, Docs updated
Andrew Aksenoff is pretty slow with release numbers for Sphinx. By MySQL Users Conference 2007 Sphinx version 0.9.7 was released [...]
February 15, 2008
MySQL Performance Blog now uses Sphinx for Site Search
I never liked how build in WordPress search works. it shows full documents rather than snippets it does not search [...]
February 7, 2008
MySQL Full Text Search in Action
Preparing to move I’m selling stuff on GumTree which is UK based clone of Craigslist offering similar functionality but with [...]
February 1, 2008
Performance gotcha of MySQL memory tables
One performance gotcha with MEMORY tables you might know about comes from the fact it is the only MySQL storage [...]
January 10, 2008
PHP vs. BIGINT vs. float conversion caveat
Sometimes you need to work with big numbers in PHP (gulp). For example, sometimes 32-bit identifiers are not enough and [...]
December 20, 2007
Large result sets vs. compression protocol
mysql_connect() function in PHP’s MySQL interface (which for reference maps to mysql_real_connect() function in MySQL C API) has a $client_flags [...]