I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program …
Comment: Moving Subtrees in Closure Table Hierarchies
May 2, 2012 By 7 Comments
… closure table hierarchy to store regions in a database using MySQL and I’m wondering how can I create a unordered… so because you’re “walking the path”. I’m using MySQL, PHP or Coldfusion (I have to do it in both languages…
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: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
…) with a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn… that the same title as the O’Reilly “High Performance MySQL” by Jeremy Zawodny & Derek Balling (which I own, but is… for your help and information. I just made the MySQL, apache2 and php updates available to Debian Squeeze avalable on DotDeb.org…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
…; I have my website develop in PHP with MYSQL, these are MYSQL values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_timeout… default-time-zone=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not…_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When I start the database service that starts smoothly…
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 database). It … it with heavy in-memory databases but you can use MySQL if you want to.
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: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
Even killing FLUSH TABLES WITH READ LOCK won’t resolve the deadlock as of MySQL 5.5 – other queries will still be stuck in ‘Waiting for table flush’ even after the FLUSH TABLES WITH READ LOCK goes away. 
http://bugs.mysql.com/bug.php?id=44884
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
March 23, 2012 By 46 Comments
What can you say about http://bugs.mysql.com/bug.php?id=52020 Can you please explain how really locking in …) It is reasonable not to release Lock 1, but why MySQL tries to create Lock 3? Why can’t it use…
