Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
January 18, 2007
INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
Jonathan Haddad writes about REPLACE INTO and INSERT ON DUPLICATE KEY UPDATE. Really, Why MySQL has both of these, especially [...]
January 17, 2007
Performance impact of complex queries
What is often underestimated is impact of MySQL Performance by complex queries on large data sets(ie some large aggregate queries) [...]
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 9, 2007
MySQL automatic data truncation can backfire
I had a fun case today. There is set of cache tables which cache certain content in MyISAM tables and [...]
December 28, 2006
MySQL Session variables and Hints
MySQL has two ways to find tune execution of particular query. First is MySQL Hints, such as SQL_BIG_RESULT, STRAIGHT_JOIN, FORCE [...]
December 20, 2006
Are you designing IO bound or CPU bound application ?
This topic may look boring and obvious but it is extremely important for MySQL Performance Optimization. In fact I probably [...]
December 1, 2006
COUNT(*) for Innodb Tables
I guess note number one about MyISAM to Innodb migration is warning what Innodb is very slow in COUNT(*) queries. [...]
November 27, 2006
Trailing spaces in MySQL
In the past life was easy in MySQL. Both CHAR and VARCHAR types meant the same, only being difference in [...]
November 12, 2006
Are PHP persistent connections evil ?
As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which is [...]
November 12, 2006
When EXPLAIN can be misleading
One think I can see with people using EXPLAIN is trusting it too much, ie assuming if number of rows [...]
October 30, 2006
Using Sphinx as MySQL data retrieval accelerator
I’ve run into the following thread couple of days ago: Basically someone is using sphinx to perform search simply on [...]
October 28, 2006
Wishes for new “Pure PHP” MySQL driver
If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If [...]
October 8, 2006
Small things are better
Yesterday I had fun time repairing 1.5Tb ext3 partition, containing many millions of files. Of course it should have never [...]
September 27, 2006
APC or Memcached
A while back I did Cache Performance Comparison for LAMP Stack. Looking at this data you can see memcached is [...]
September 12, 2006
Database Performance Optimization in Web Applications
This is a pretty simple approach I often use called to optimize web application performance if problem happens with few [...]
September 9, 2006
Alternatives of PHP ?
When I loaded GigaBytes of XMLs into mysql database with PHP script, I was thinking about PHP alternatives. Why do [...]
September 6, 2006
Wrong GROUP BY makes your queries fragile
This is probably well known issue for everyone having some MySQL experience or experience with any other SQL database. Still [...]
September 4, 2006
GROUP_CONCAT useful GROUP BY extension
(There is an updated version of this post here) MySQL has useful extention to the GROUP BY operation: function GROUP_CONCAT: [...]
August 31, 2006
Derived Tables and Views Performance
Starting MySQL 4.1, MySQL had support for what is called derived tables, inline views or basically subselects in the from [...]
August 14, 2006
UNION and Double IN methods for Query Optimization
Loose Index Scan with Double IN Few days ago I wrote an article about using UNION to implement loose index [...]