… sec) mysql> reset slave; Query OK, 0 rows affected (0.04 sec) mysql> show slave status\G Empty set (0.00 sec) mysql> start…-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the situation has slightly changed. First the master-xxx variables are no longer supported, which is a great improvement. But the RESET SLAVE statement also behaves differently: mysql> stop…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable…. Bug fixed #1104977 (Ignacio Nin). Running the DDL statement while variable innodb_lazy_drop_table was enabled could cause assertion failure…_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL client to abort…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding… queue (visible via the wsrep_local_recv_queue global status variable). Donor/Desynced nodes do not apply flow control, though they… they are all configured via the wsrep_provider_options global variable. gcs.fc_limit This setting controls when flow control engages…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… LRU_scan. I tried to increase innodb_lru_scan_depth variable to 8k,16k,32k but that had no notably impact… we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… in MySQL 5.5) for metadata locks. Now –set-vars is used to set both of these (or any) system variables. For… a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 -u me”. pt-stalk 2.2 and pt-mysql-summary 2.2 have all the standard MySQL options built-in, like other tools…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… is retried only the number of times specified by this variable (default is 1 retry). This means more waiting, and after… to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think about the…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…? mysql> select version()\G *************************** 1. row *************************** version(): 5.5.25a-27.1-log 1 row in set (0.00 sec) mysql> show variables like ‘%thread_handling%’\G *************************** 1. row *************************** Variable_name: thread_handling Value: one-thread…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
The thread_handling variable is a legacy of the first version of this type ….x for a MySQL customer in 2007 that I worked with. While this was a custom build, this variable definition (and effectively…
Comment: Percona XtraBackup 2.0.7 for MySQL available for download
May 14, 2013 By 1 Comment
…_buffer_pool_filename’ option in group ‘mysqld’ in MySQL options” My server is MySQL 5.5, my command is “innobackupex –defaults-file…_3/201305″ innodb_buffer_pool_filename is not a global variable of MySQL 5.5, why this error? thanks!
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
During the Percona Live MySQL Conference & Expo 2013 the week before last, we quietly released … tools use @@hostname without /*!50038*/ pt-stalk prints the wrong variable name in verbose mode when –function is used And more…
