Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
July 6, 2007
PHP Large result sets and summary tables.
We’re working with web site preparing for massive growth. To make sure it handles large data sets as part of [...]
July 5, 2007
Working with large data sets in MySQL
What does working with large data sets in mySQL teach you ? Of course you have to learn a lot [...]
July 1, 2007
Implementing efficient counters with MySQL
On many web sites you would see a counter how many time given object – blog post, forum thread, image, [...]
June 18, 2007
Using CHAR keys for joins, how much is the overhead ?
I prefer to use Integers for joins whenever possible and today I worked with client which used character keys, in [...]
June 16, 2007
MySQL 5.1 Command line client improvements
Just found this little handy feature today: [crayon-69cf05f8cfe79714069968/] So now if you press CTRL-C MySQL Command Line Client will not [...]
June 12, 2007
MySQL Stored Procedures: Explanation and Best Practices
To be honest I’m not a big fan of Stored Procedures, at least not in the form they are currently [...]
April 11, 2007
How simple answer are you looking for ?
I’ve got an interesting comment the other day saying “I’ve heard Jay Pipes saying indexes with cardinality lower than 30% [...]
April 10, 2007
COUNT(*) vs COUNT(col)
Looking at how people are using COUNT(*) and COUNT(col) it looks like most of them think they are synonyms and [...]
April 6, 2007
Using delayed JOIN to optimize count(*) and LIMIT queries
In many Search/Browse applications you would see main (fact) table which contains search fields and dimension tables which contain more [...]