Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
January 3, 2007
MySQL/Innodb scalability tests after fix
This is not freshest news ever but I simply have not yet had a time to comment on it. I [...]
November 30, 2006
Interesting MySQL and PostgreSQL Benchmarks
I had found pile of MySQL and PostgreSQL benchmarks on various platforms which I have not seen before. Very interesting [...]
November 12, 2006
Trying Archive Storage Engine
Today I noticed one of server used for web request profiling stats logging is taking about 2GB per day for [...]
August 29, 2006
MySQL wins C’T Database Contest
Today MySQL published the press release with results of Database Contest (results on German available here http://www.mysql.de/ct-dbcontest). Peter and me [...]
August 23, 2006
Watch out for Marketing benchmarks
Whenever I see benchmark results I try to understand if it is technical benchmark – made by people seeking the [...]
August 18, 2006
SysBench – benchmark tool
Sysbench is benchmark developed by Alexey Kopytov (software engineer @ MySQL AB) – http://sysbench.sourceforge.net/ and I want to write a [...]