Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
December 19, 2007
MVCC: Transaction IDs, Log Sequence numbers and Snapshots
MySQL Storage Engines implementing Multi Version Concurrency Control have several internal identifiers related to MVCC. I see a lot of [...]
December 18, 2007
Fixing Column Encoding Mess in MySQL
Just had an interesting issue with an encoding mess on a column containing non-ASCII (Russian) text. The solution was not [...]
November 22, 2007
Pitfall of proxying HTTP requests through Lighttpd
Recently I had a case with a web server farm where a random node went down every few minutes. I [...]
November 18, 2007
MySQL: Data Storage or Data Processing
I was thinking today of how people tend to use MySQL in modern applications and it stroke me in many [...]
November 4, 2007
Heikki Tuuri answers to Innodb questions, Part II
I now got answers to the second portions of the questions you asked Heikki. If you have not seen the [...]
November 1, 2007
Nginx Powers Hulu.com ?
Look at this post recently published on TechCrunch – It is ugly standard 404 error message, but what is interesting [...]
October 26, 2007
Heikki Tuuri Innodb answers – Part I
Its almost a month since I promised Heikki Tuuri to answer Innodb Questions. Heikki is a busy man so I [...]
October 17, 2007
MySQL Performance – eliminating ORDER BY function
One of the first rules you would learn about MySQL Performance Optimization is to avoid using functions when comparing constants [...]
October 16, 2007
Be Careful when Joining on CONCAT
The other day I had a case with an awful performance of a rather simple join. It was a join [...]
October 5, 2007
UNION vs UNION ALL Performance
When I was comparing performance of UNION vs MySQL 5.0 index merge algorithm Sinisa pointed out I should be using [...]
September 28, 2007
Heikki Tuuri to answer your in depth Innodb questions
Have you ever had a question about Innodb internal design or behavior which is not well covered in MySQL manual [...]
September 28, 2007
Using VIEW to reduce number of tables used
Many Open Source software solutions use database per user (or set of tables per user) which starts to cause problems [...]
September 18, 2007
Possible optimization for sort_merge and UNION ORDER BY LIMIT
Every so often you need to perform sort results retrieved from MySQL when your WHERE clause goes beyound col=const values [...]
September 17, 2007
Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
Quite typical query for reporting applications is to find top X values. If you analyze Web Site logs you would [...]
September 12, 2007
Query Profiling with MySQL: Bypassing caches
Quite frequently I run into question like this “I’m using SQL_NO_CACHE but my query is still much faster second time [...]
September 5, 2007
What would make MySQL Multiple Queries Usable ?
MySQL Has API to run Multiple Queries at once. This feature was designed mainly with saving network round trip in [...]
August 28, 2007
To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
When we optimize clients’ SQL queries I pretty often see a queries with SQL_CALC_FOUND_ROWS option used. Many people think, that [...]
August 17, 2007
Should MySQL Extend GROUP BY Syntax ?
Jan has a good article about finding the row matching some value in the group: This is one illustration of [...]
August 6, 2007
Query_cache and column level privileges
Recently we were puzzled by question how query_cache works with column level privileges. The question was appeared as we discovered [...]
July 23, 2007
Sphinx: Going Beyond full text search
I’ve already wrote a few times about various projects using Sphinx with MySQL for scalable Full Text Search applications. For [...]