June 20, 2013

Comment: Is Synchronous Replication right for your app?

Jay – Yoshinori found one performance bug for semi-sync — http://bugs.mysql.com/bug.php?id=69341. Wonder if there are others.

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

Yes, and I also filed http://bugs.mysql.com/bug.php?id=69001 some time ago

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

subscribe to http://bugs.mysql.com/bug.php?id=69059

Comment: Are PHP persistent connections evil ?

… should use: whether to use MYSQL_CONNECT(), or MYSQL_PCONNECT or MYSQLI_CONNECT. Please clarify all these connections with details and without…

Comment: Derived Tables and Views Performance

…: http://phptechnicalgroups.blogspot.co.il/2013/05/simple-mysql-and-php-prodcuts-and-cart.html create dynamic main menu and sub menu using php and mysql php CREATE TABLE `menu` ( `id` int(11) NOT NULL auto…

Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster

… Details (Dedicated Server): Software: Apache Version – 2.2.15 (CentOS) PHP Version – 5.3.3 MySQL – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware: Node:2 CPU = Quard…

Comment: Galera Flow Control in Percona XtraDB Cluster for MySQL

Anthony, that’s an excellent question. The supported method is to use the Galera arbitration daemon and you can find documentation on that here: http://www.codership.com/wiki/doku.php?id=data_backup This is a good topic for a followup blog post, stay tuned…

Comment: MySQL and Percona Server in LinkBench benchmark

….mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql.com/bug.php?id=68555 http://bugs.mysql.com/bug.php?id=68481 I… has a fix for it – http://bugs.mysql.com/bug.php?id=45892

Comment: MySQL and Percona Server in LinkBench benchmark

One more bug that explains why LRU page flushing rate is much less than innodb_lru_scan_depth even if innodb_lru_scan_depth is large enough. Apparently fixed in 5.6.12 — http://bugs.mysql.com/bug.php?id=69170

Comment: MySQL and Percona Server in LinkBench benchmark

….mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql.com/bug.php?id=68555 http://bugs.mysql.com/bug.php?id=68481 I… has a fix for it – http://bugs.mysql.com/bug.php?id=45892