…set it up on crontab so that schema changes are automatically picked up. Nice, eh? Usage … `parent_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_B`… NULL instead of the actual SQL NULL value. This is basically a quick sanity check …
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… leave some blank For some fields there will be a default value, If you enter ‘.’, the field will be left blank. —– Country…. If you use the default expiration of 1 year, your cluster will fail on the first state change after the expiration date… seem to have sane defaults to me): socket.ssl_cipher = AES128-SHA by default socket.ssl_compression = yes by default Other questions Will…
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… all the nasty consequences we can imagine. Even worse, the CHANGE MASTER TO MASTER_HOST=” trick no longer works: mysql> stop slave; Query OK, 0 rows affected (0,01 sec) mysql> change master to master_host=”; ERROR 1210 (HY000): Incorrect arguments to…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… number of times specified by this variable (default is 1 retry). This means more waiting, … SET count = $last_count where achievement = ‘killed_troll’”; } change your schema In Example 2, above, how …INTO users_groups (user_id, group_id, joined) VALUES (100, 1, NOW()); Conclusion Choosing a system …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… errors in the log parser or bad changed page data. Bug fixed #1108613 (Laurynas Biveinis). … on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187… Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… errors in the log parser or bad changed page data. Bug fixed #1108613 (Laurynas Biveinis). … on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187… Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU …
Post: pt-online-schema-change and default values
June 21, 2012 By 1 Comment
… 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
… is good change to reduce the potential of blocked host errors though I think one 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: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
…`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> INSERT INTO `huge_table` (text) VALUES (‘test’); ERROR 1062… really careful with that one. Default values. MySQL rebuilds table even if we only want to change the default value for new records so this… that changing a comment does not to require table to be rebuilt, while things like removing auto_increment or changing a default value still…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… bytes for integer as it requires, not storing column value if it is default etc. This is nice even though may show strange effects if you do not know about this feature, for example changing default value needs table rebuild even though for other storage engines it often could be done simply by changing meta data…
