Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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-68c74856389d2860832920/] 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 [...]
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 [...]