Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
March 31, 2008
MySQL Performance on Memory Appliance
Recently I have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be [...]
March 25, 2008
MySQL 6.0 vs 5.1 in TPC-H queries
Last week I played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, [...]
March 21, 2008
MySQL File System Fragmentation Benchmarks
Few days ago I wrote about testing writing to many files and seeing how this affects sequential read performance. I [...]
March 5, 2008
Evaluating IO subsystem performance for MySQL Needs
I’m often asked how one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve [...]
February 27, 2008
A piece of Sun/MySQL Marketing
I got first Sun/MySQL Newsletter Today which among other things lead to the site publishing among other things links to [...]
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 24, 2008
Enum Fields VS Varchar VS Int + Joined table: What is Faster?
Really often in customers’ application we can see a huge tables with varchar/char fields, with small sets of possible values. [...]
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 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 17, 2007
MySQL: What read_buffer_size Value is Optimal?
The more I work with MySQL Performance Optimization and Optimization for other applications the better I understand I have to [...]
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 28, 2007
Do you always need index on WHERE column ?
I believe we wrote about this before, but this topic popups again and again. Today I’ve read opinion that if [...]
August 28, 2007
Redundant index is not always bad
About year ago Peter wrote about redundant indexes and mentioned sometimes it is good to leave two indexes, even one [...]
August 18, 2007
How fast can you sort data with MySQL ?
I took the same table as I used for MySQL Group by Performance Tests to see how much MySQL can [...]
August 16, 2007
How much overhead is caused by on disk temporary tables
As you might know while running GROUP BY and some other kinds of queries MySQL needs to create temporary tables, [...]
July 25, 2007
MySQL and PostgreSQL SpecJAppServer benchmark results
Listening to Josh Berkus presentation on OSCON today I decided to take a closer look at SpecJAppServer benchmarks results which [...]
April 8, 2007
PBXT benchmarks
The PBXT Storage Engine (http://www.primebase.com/xt/) is getting stable and we decided to benchmark it in different workloads. This time I [...]
January 10, 2007
Getting real life query speeds with MySQL
To check for query performance improvements followed indexing/query changes or MySQL configuration changes our customers often decide to run the [...]
January 8, 2007
InnoDB vs MyISAM vs Falcon benchmarks – part 1
Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and [...]
January 3, 2007
InnoDB benchmarks
There was several changes in InnoDB to fix scalabilty problems, so I ran benchmark to check new results and also [...]