…-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion Enabling GTID-based replication can be…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…(100) NOT NULL default ‘#’, `parent` int(11) NOT NULL default ‘0‘, `sort` int(11) default NULL, PRIMARY KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db(‘test’,$mysql); function display_menu…
Comment: How to Monitor MySQL with Percona's Nagios Plugins
May 20, 2013 By 11 Comments
… and my output is CRIT Uptime = 4951 | Uptime=4951;;5;0; so how can i change it to alert only when…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 20, 2013 By 13 Comments
…% of the computer market; number 2 had no more than 4%. It was _very_ closed back then. When you bought an… auto manufacturers. By the 1970s there were only the “Big 4“; then the “Big 3″. Also, European manufacturers were fading away…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… on MacBook Pro) Centos 6.4 Single core VM 528M …’ => true ); $memcacheOpts = array( ‘servers’ =>array( array( ‘host’ => ‘192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ =>… $frontendOpts, $memcacheOpts); $timer->start(); for ($i = 0; $i < 100000; $i++) { $cache->save(new Object(),…
Comment: Percona XtraBackup 2.0.7 for MySQL available for download
May 14, 2013 By 1 Comment
….net/percona-xtrabackup/+bug/945161 while using percona-xtrabackup-2.0.6, so I update this software to 2.0.7. But my backup script get this error: “innobackupex: fatal …, my command is “innobackupex –defaults-file=/etc/my3.cnf –host=192.168.10.118 –user=backup –password=23khfisF –slave-info –no-lock…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 2, 2013 By 10 Comments
… need an extra IP because you move from 127.0.0.1 to 192.168.x.x it’s a whole lot simpler (and…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… T/T 0 0 0 18 0 28K 0.0 0 108 0 0 09:22:19 myclu P 3 3 node3 Sync T/T 0 4 0 3 0 4.3K 0.0 0 109 0 0 09:22:20 myclu P 3 3 node3 Sync T/T 0 18 0 0 0 0 0.0 0 109 0 0 09:22:21 myclu P 3 3 node3 Sync T/T 0 27 0 0 0 0 0.0 0 109 0 0 09:22…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…_ID | MIX_LEN | CLUSTER_NAME | SPACE | +————–+—–+——–+——+——–+———+————–+——-+ | sakila/actor | 741 | 4 | 1 | 0 | 0 | | 738 | +————–+—–+——–+——+——–+———+————–+——-+ SYS_INDEXES This table lists all indexes the table…_INDEXES, SYS_COLUMNS and SYS_FIELDS from indexes 0-1, 0-3, 0-2 and 0-4 respectively. ./bin/constraints_parser.SYS_FIELDS -4f pages-ibdata1/FIL_PAGE_INDEX/
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… 138836 7216444 0 4080 53400 53714 18422 16234 2 7 72 18 0 Fri Mar 22 10:03:38 UTC 2013 0 4 395888 355136 138844 7197992 0 47872 3350 125712 24148 21633 3 4 70 23 0 Fri Mar 22 10:03:40 UTC 2013 4 4…
