… table test.t (id int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…) NOT NULL default ’0′, `sort` int(11) default NULL, PRIMARY KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…)+k; COMMIT; So this workload produces SEQUENTIAL inserts into Primary Key, that this is quite suitable for InnoDB, and in it… NULL, `k` int(10) unsigned NOT NULL DEFAULT ’0′, PRIMARY KEY (`hid`,`mid`,`id`) ) and transactions are: $HID=rand(0,10000… tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… cert.pem Generating a 2048 bit RSA private key …………..+++ ……………………………………………………….+++ writing new private key to ‘key.pem’ —– You are about to be asked to… = “socket.ssl_cert=/etc/mysql/cert.pem; socket.ssl_key=/etc/mysql/key.pem” We simply configure the wsrep provider with our…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…) unsigned DEFAULT NULL, `PREC` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`TABLE_ID`,`POS`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Here `TABLE… | COL_NAME | +———-+—–+———-+ | 1679 | 0 | actor_id | +———-+—–+———-+ Which means the primary key of the table is one field actor_id. Now we…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… fixed #1108165 (Alex Yurchenko). In some cases non-uniform foreign key reference could cause a slave crash. Fixed by using primary… mixed CHAR and VARCHAR columns would be used in foreign key definitions. Bug fixed #1100496 (Seppo Jaakola). Debian packages included the… shell was used. Bug fixed #1108431 (Alex Yurchenko). Cascading foreign key constraint could lead to unresolved replication conflict and leave a…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… by detecting such cases and omitting the corresponding secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server…). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would be lost. Bug fixed #989253…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… #1031427 and #1051874. When mysqldump was used with –innodb-optimize-keys option it produced invalid SQL for cases when there was… by detecting such cases and omitting the corresponding secondary keys from deferred key creation optimization. Bug fixed #1081016. When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would be lost. Bug fixed #989253…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… by detecting such cases and omitting the corresponding secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server…). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would be lost. Bug fixed #989253…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…(); for ($i = 0; $i < 100000; $i++) { $cache->save(new Object(), “key_$i”); } $totalTimeStore = $timer->stop(); $avgTimeStore = $totalTimeStore / 100000; $timer->start(); for…; $i++) { for ($i = 0; $i < 100000; $i++) { $obj = $cache->load(“key_$i”); } } $totalTimeFetch = $timer->stop(); $avgTimeFetch = $totalTimeFetch / 1000000; While this benchmark…
