Tag Archives: mysql

Round Robin Data Storage in MySQL

Posted on June 22, 2008 by Silvan Mühlemann

If you want to store large amount of volatile data (e.g. log file entries) in a database with a constant storage memory footprint and no maintenance to purge the old entries, a round robin database is the best solution. But … Continue reading →

Posted in Database, PHP | Tagged | 14 Comments

Pitfalls with MySQL and auto_increment

Posted on April 13, 2008 by Silvan Mühlemann

There’s a number of pitfalls one should be aware of when working with AUTO_INCREMENT fields in MySQL. Last week, we fell in each of them: We have the table photos which contains all 15 million pictures on tilllate.com. This table … Continue reading →

Posted in Database | Tagged | 4 Comments

Comparing queries with mk-query-profiler and diff

Posted on February 5, 2008 by Silvan Mühlemann

EXPLAIN is not the only way to analyze query perfomance im MySql because some things are not being taken into account. For example LIMIT clauses or the cost of the optimizer. There is also the mk-query-profiler. An interesting way to … Continue reading →

Posted in Database | Tagged , | Comments Off on Comparing queries with mk-query-profiler and diff