I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a …
Comment: Side load may massively impact your MySQL Performance
May 15, 2012 By 7 Comments
http://bugs.mysql.com/bug.php?id=45015 (InnoDB buffer pool can be severely affected by table scans)
Comment: How to convert MySQL's SHOW PROFILES into a real profile
May 10, 2012 By 10 Comments
There is this bug report: http://bugs.mysql.com/bug.php?id=61328
Comment: Moving Subtrees in Closure Table Hierarchies
May 2, 2012 By 7 Comments
… because you’re “walking the path”. I’m using MySQL, PHP or Coldfusion (I have to do it in both languages…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… help and information. I just made the MySQL, apache2 and php updates available to Debian Squeeze avalable on DotDeb.org, and…
Comment: Alternatives of PHP ?
April 11, 2012 By 28 Comments
You could try WebDNA: it is lighter than php and mysql and is also much faster (resilient in-memory …
Comment: COUNT(*) vs COUNT(col)
April 3, 2012 By 41 Comments
… get all the data and then get the count at PHP end like:- select col1,col2 from table where condition1 and…
Comment: How to diagnose errors in the MySQL error log
April 3, 2012 By 4 Comments
This feature is implemented and will be in version 5.6. http://bugs.mysql.com/bug.php?id=48348 http://dev.mysql.com/doc/refman/5.6/en/news-5-6-4.html
Comment: Percona Server 5.5.21-25.1 released!
March 31, 2012 By 8 Comments
… will incorporate this important bugfix: http://bugs.mysql.com/bug.php?id=61209 We’ve been waiting for this bug to…
Comment: Best kept MySQLDump Secret
March 25, 2012 By 11 Comments
I wrote about the alter table issue a few years ago and filed bug http://bugs.mysql.com/bug.php?id=28432 which was incorrectly closed as fixed. I’m surprised that more people weren’t upset about it. Maybe I should have added notes about mysqldump.
