… crontab so that schema changes are automatically picked up. Nice,…: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127…. int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE… the actual SQL NULL value. This is basically a …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… of removing all settings, some of them are reset to default values. This means that if you run START SLAVE (or if… as expected: use CHANGE MASTER TO MASTER_HOST=”: mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> change master to master…, the CHANGE MASTER TO MASTER_HOST=” trick no longer works: mysql> stop slave; Query OK, 0 rows affected (0,01 sec) mysql> change master…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… default value, If you …default expiration of 1 year, your cluster will fail on the first state change…mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… the log parser or bad changed page data. Bug fixed #1108613 (…-only workloads, especially when the default glibc memory allocator is used. Bug … overhead from innodb_pass_corrupt_table value checks by optimizing them for …). Percona Server for MySQL was missing help texts in the MySQL client because …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…specified by this variable (default is 1 retry). This …$last_count where achievement = ‘killed_troll’”; } change your schema In Example 2…user_id, group_id, joined) VALUES (100, 1, NOW()); …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… the log parser or bad changed page data. Bug fixed #1108613 (…-only workloads, especially when the default glibc memory allocator is used. Bug … overhead from innodb_pass_corrupt_table value checks by optimizing them for …). Percona Server for MySQL was missing help texts in the MySQL client because …
Post: pt-online-schema-change and default values
June 21, 2012 By 1 Comment
… not specify default value. MySQL will assign empty string as default default value for varchar column. This however does not work for pt-online-schema-change: root@smt2:~# pt-online-schema-change –execute…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… ON by default in MySQL 5.6 but you can see many options can be scaled down compared to MySQL 5.5 default values. Such… could go with even higher default value. sort_buffer_size was decreased to 256K from 2M. This change should help many small sorts… by default. Very welcome change ! thread_cache_size is enabled by default, though I wonder why default value is 9. In any case very welcome change…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… detect such change easily because MySQL Server does not seems to have an easy way to check what was the default value for given… not always the case. Interesting enough MySQL Allows you to SET variable to default value (compile time default, not the one server was started with) yet there seems not to be a way to read it: mysql…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 8 Comments
… chose best value automatically. Making this change I could bring optimization, and full query execution time to less than 50ms. Low values, such… 0 is automatic selection why do we have value of 62 being default in MySQL 5.5 which can produce very expensive plan… if we assume MySQL users do not join lots of tables (less than 7) when using 0 as default value would not impact…
