Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
March 27, 2007
Integers in PHP, running with scissors, and portability
Until recently I thought that currently popular scripting languages, which mostly evolved over last 10 years or something, must allow [...]
March 27, 2007
PHP Sessions – Files vs Database Based
One may think changing PHP session handler from file based to database driven is fully transparent. In many cases it [...]
March 26, 2007
Only Design What You Can Implement
Working with various projects using MySQL I observe a lot of problems are coming from very simple fact – product [...]
March 13, 2007
Mail clients and Databases
I get a lot of mail and I prefer to store it for long time if not forever. With modern [...]
March 6, 2007
Is it query which needs to be optimized ?
Last few days I had a lot of a lot of questions at MySQL Performance Forum as well as from [...]
February 27, 2007
System size and Performance Optimization
Performance optimization is never ending story, you can virtually always find something else to optimize but while on generic system, [...]
February 19, 2007
MySQL Error control changes
In MySQL 5.0 mainly error control was improved, such as strict mode was added to change famous MySQL behavior of [...]
February 16, 2007
Using index for ORDER BY vs restricting number of rows.
One interesting problem with MySQL Optimizer I frequently run into is making poor decision when it comes to choosing between [...]
February 14, 2007
Getting use of Slave in MySQL Replication
MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as it can contain stale [...]
February 11, 2007
Content delivery system design mistakes
This week I helped dealing with performance problems (part MySQL related and part related to LAMP in general) of system [...]
February 5, 2007
Why do you need many apache children ?
I already wrote kind of about same topic a while ago and now interesting real life case makes me to [...]
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 [...]