… used a 10GB key buffer. I used ALTER TABLE DISABLE KEYS and built the keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld…=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to prevent…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… perfectly restart the servers one by one. Second try: GTIDs enabled, mixing regular replication and GTID replication This time, we will… key); Executing SHOW TABLES FROM test on both slaves shows that the table has been created everywhere. So once GTIDs are enabled…> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion Enabling GTID-based replication can be tricky if your application does…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
…pem Generating a 2048 bit RSA private key …………..+++ ……………………………………………………….+++ writing new private key to ‘key.pem’ —– You are about to be …first node is restarted with SSL enabled, all future nodes must also have it enabled. Other SSL options It is…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…_updates is REQUIRED You need to have log_slave_updates enabled on the cluster node acting as async slave for replicated… to the slave’s binary unless log_slave_updates is enabled, this is similar to Percona XtraDB Cluster in that if… when wsrep_certify_nonPK is enabled, you can still hit issues like when automatic creation of primary keys for use during certification…
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 …the DDL statement while variable innodb_lazy_drop_table was enabled could cause assertion failure. Bugs fixed #1086227 and #1128848 (Laurynas…
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 …the DDL statement while variable innodb_lazy_drop_table was enabled could cause assertion failure. Bugs fixed #1086227 and #1128848 (Laurynas…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… 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… could cause a server to hang when binary log is enabled. Bug fixed #1162085. Percona Server would re-create the test…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… from the vCache test where the time-based flushing is enabled. As we’d expect, the HDD-only solution barely registered… interesting item here is that vCache with time-based flushing enabled actually produces better and more consistent performance than vCache without… thread_stack = 192K tmp_table_size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
….fc_factor If fc_limit controls when flow control is enabled, then fc_factor addresses when it is released. The factor… size of the transactions, which translates into number of unique key lookups into the certification index, which is a hash table…
Post: Crashes while using MyISAM with multiple key caches
July 18, 2009 By Leave a Comment
… have ran into random MySQL crashes in production when multiple key caches were used. Unfortunately this never was frequent or critical… – the bug is not really related to multiple key caches but to online key cache resize. It is just this code most…’d like to see them disabled as run time and enabled with –enable-buggy-features switch (I’m sure marketing can come…
