… MySQL 5.1 or aren’t using RBR, then it is possible to set up a dedicated MySQL slave which has log_slave_updates=1… written in PHP so it is portable. Setting up FlexCDC FlexCDC has some basic requirements: MySQL 5.1+ row based logging (binlog_format=1) unique server_id in the my.cnf log_slave_updates=1, if this is a MySQL slave…
Post: XtraDB storage engine release 1.0.3-7
August 17, 2009 By 6 Comments
… plugin version 1.0.3, as you might know Innobase has released 1.0.4. The release includes following new features: MySQL 5.1.37…_bug42101 fails on 5.1.36†This fixes also http://bugs.mysql.com/bug.php?id=45749 and http://bugs.mysql.com/bug.php?id=42101 The builds for RedHat4,5 and Debian are located on http://www.percona.com/mysql/xtradb/5.1.37…
Post: When EXPLAIN estimates can go wrong!
October 13, 2011 By 7 Comments
… MySQL to pick and choose indexes and hence is irrelevant to this problem. Next, I proceeded to test using MySQL 5.1.58 and 5.5.15 vanilla releases. Following is the definition of the table that I used for the test: mysql [localhost… bug in MySQL 5.1 and how it calculates the row estimates. This bug was tracked down to http://bugs.mysql.com/bug.php?id…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now there are plugable… were released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit still works in 5.0 and… Query Cache support for Prepared Statements is only fixed in MySQL 5.1 and Most of other items are still open. Well may…
Post: Tools and Techniques for Index Design Webinar Questions Followup
October 4, 2012 By 5 Comments
… 29 – November 2, 2012. See http://store.percona.com/catalog.php?category=17 for details on this training class and how…: Given that the book was written in 2005, before MySQL 5.1 and 5.5 were released, is it still relevant? That book is designed… changes in MySQL 5.6 change the best practices for index design? Fundamentally, index design best practices will not change. MySQL 5.6 is…
Post: Drop table performance
April 20, 2011 By 22 Comments
… these bug reports: http://bugs.mysql.com/bug.php?id=51325 and http://bugs.mysql.com/bug.php?id=56332.) It may not sound… drop 1000 times in MySQL 5.1.56, in Percona Server 5.1.56 with “innodb_lazy_drop_table”, and in MySQL 5.6.2. Here are… slower DROP TABLE operates. MySQL 5.6.2 shows some improvement compared to MySQL 5.1.56, but Percona Server 5.1.56 has a better result…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… for running these tests. Tests were done with PHP 5.2.5 and Apache 2.0.59. Results were …very serious limitation in practice when you’re using MySQL with PHP as you can have single runaway query … (spending this time on MySQL time) one is doing single query another 1000 queries 1 second length each. …
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
… where val like “%c%”; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.00 sec) mysql> select /* my little comment2 */ count(*) from …use MySQL Command Line Client for any tests involving comments Repeating queries from PHP instead we can learn the following about MySQL 5….
Post: MySQL Server Upgrade
August 11, 2006 By 9 Comments
… works with MySQL 5.0. Second – I know my applications designed to work with MySQL 4.1, they avoid queries which MySQL 4.1 does not optimize well and so MySQL 5.0 will likely reduce… MySQL 5.0 than on 4.1 This is upgrade strategy I follow for this server which has mix of various third party PHP/MySQL…
Comment: Percona-XtraDB version 9.1
March 15, 2010 By 16 Comments
Is there planned support in your yum repo for php-mysql with php 5.2.10(the test builds for centos)? I had quite a time trying to get that working on my dev machine and ended up rolling back to mysql 5.1 or 5.0 (can’t remember off the top of my head).
