…=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool…32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances…_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to prevent assorted…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… topology. On the top-level master, you leave all filters disabled; on the relay master you add binary log filters; this… the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… existing table could wait on a metadata lock instead of failing or returning immediately if …(Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help … additional work is done when userstat is disabled. Bug fixed #1128066 (Alexey Kopytov). Other bug fixes…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack…modified dynamically if you have fc_master_slave disabled (which it is by default). This mode actually…simply by running “FLUSH TABLES WITH READ LOCK“, or perhaps by “LOCK TABLE”, in which case flow …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from … would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs…innodb56 target didn’t have an option to disable DTrace like innodb55 has. Fixed by adding -…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… existing table could wait on a metadata lock instead of failing or returning immediately if …(Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help … additional work is done when userstat is disabled. Bug fixed #1128066 (Alexey Kopytov). Other bug fixes…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… locks gap before rec If you have lot of gaps locks in your transactions affecting the concurrency and the performance you can disable… no need to create locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except for foreign… source of information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…beginning to prevent dead locks? So you would get a lock wait instead of a dead lock. No, that would …table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? …of the tool does NOT have any features to disable the binary log; my experience has been that …
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…_event_wait_low,sync_array_wait_event,rw_lock_s_lock_spin,pfs_rw_lock_s_lock_fu nc,btr_search_build_page_hash…,sub_select,do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command…,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_connection,handle_one_conne ction,start_thread,clone P.S Disabling…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… a significant performance overhead.1,2 MySQL allows us to set FOREIGN_KEY_CHECKS=0 to disable enforcement of RI when the overhead is too high. But if you later restore enforcement, MySQL does not… and detect orphans early so you can correct them. 1Innodb locking and Foreign Keys 2Instrumentation and the cost of Foreign Keys
