…/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 percona1 ] [root@percona1 ~]# cat /etc/redhat-release CentOS release 6.3 (Final) [root..._MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql… percona1 2 M 64 2013-05-23 09:52:03 percona2 3 M 64 2013-05-23 09:52:03 percona3 [root@percona3…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are available from…: Fixed yum dependencies that were causing conflicts in CentOS 6.3 during installation. Bug fixed #1031427 (Ignacio Nin). In case the… leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by design… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding… 0 0.9 1 109 0 0 09:22:23 myclu P 3 3 node3 Sync T/T 0 29 0 0 0…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and… S3. Why? The push to S3 was especially puzzling since MySQL was not involved. The server was running with nearly 7GB… 355136 138844 7197992 0 47872 3350 125712 24148 21633 3 4 70 23 0 Fri Mar 22 10:03:40 UTC 2013…
Comment: Is MySQL 5.6 slower than MySQL 5.5?
March 27, 2013 By 23 Comments
… your build of mysql-5.6! On 64bit Win7 host running 512 MB VirtulBox Ubuntu 12.04 guest(3.2.0-39… : GenuineIntel cpu family : 6 model : 23 model name : Intel(R) Core(TM)2 Duo CPU E8400 @ 3.00GHz stepping : 10 cpu MHz… (538.76 per sec.) # using skip-performance-schema with standard mysql-5.6.10-debian6.0-x86_64.deb package ! You…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… MySQL 3.23 when there would only handful of places where memory could be allocated but it is a lot larger problems with MySQL… have created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Post: Looking for MySQL 4.0 Support post EOL ?
December 14, 2008 By 9 Comments
… having with MySQL 3.23 or 4.0 and will be happy to backport bug fixes to MySQL 3.23 and 4.0 Supporting MySQL 3.23 and MySQL 4.0 environment is indeed more expensive than current MySQL versions because we can’t relay on Sun/MySQL doing…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… what serious bugs are. Large Team, Tricky Code During MySQL 3.23 and MySQL 4.0 team the small tight knit team was working…’m not sure if MySQL user base is growing any more but it surely has grown dramatically since MySQL 3.23 or 4.0… The MySQL 3.23 received quality was at some extent because there were no bugs.mysql.com – bugs were reported to bugs@lists.mysql.com…
Post: MySQL 5.1 went to GA. Was it a good move ?
December 10, 2008 By 4 Comments
… do I think MySQL 5.1 Quality Stands ? I’ve been MySQL user for years since version 3.22 and when MySQL 3.23 came out we were using it in production since 3.23.3 or… at least 3 minor releases or waiting 6 months after release people use for Commercial databases this gets transfered to MySQL too…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… to HardCore MySQL business – foreign Keys. MySQL supported Foreign Keys for Innodb for many years, yet rudimentary support initially added in MySQL 3.23.44…_checks=1; Query OK, 0 rows affected (0.00 sec) mysql> select * from child; +———–+——+ | parent_id | v | +———–+——+ | 1 | NULL | +———–+——+ 1 row…
