Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
August 11, 2006
Database problems in MySQL/PHP Applications
Article about database design problems is being discussed by Kristian. Both article itself and responce cause mixed feellings so I [...]
August 10, 2006
Using UNION to implement loose index scan in MySQL
One little known fact about MySQL Indexing, however very important for successfull MySQL Performance Optimization is understanding when exactly MySQL [...]
August 9, 2006
Cache Performance Comparison
Jay Pipes continues cache experiements and has compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark [...]
August 8, 2006
Caching techinques
Recently Jay Pipes published great article about lazy connecting and caching which reminded me my post on this matter is [...]
August 6, 2006
SELECT LOCK IN SHARE MODE and SELECT FOR UPDATE
Baron wrote a nice article comparing locking hints in MySQL and SQL Server. In MySQL/Innodb SELECT LOCK IN SHARE MODE [...]
August 2, 2006
MySQL Prepared Statements
If you care about archiving best performance in your application using MySQL you should learn about prepared statements. These do [...]
July 24, 2006
Extended EXPLAIN
One nice feature added for EXPLAIN statement in MySQL 4.1 is EXTENDED keyword which provides you with some helpful additional [...]
July 24, 2006
MySQL EXPLAIN limits and errors.
Running EXPLAIN for problematic queries is very powerful tool for MySQL Performance optimization. If you’ve been using this tool a [...]
July 17, 2006
eWeek tests OpenSource stacks and .NET
Have you seen recent eWeek benchmarks which test OpenSource stacks and compare them to .NET ? Here is what was [...]