… the intermediate server, thus resulting in less binary log data being sent down to the lower-level … that MySQL is up and running. That said, there are plenty of other MySQL and OS-level status variables … MySQL Cluster installation are going to be talking to the same set of data nodes on the back …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…. Bug fixed #1104977 (Ignacio Nin). Running the DDL statement while variable innodb_lazy_drop_table was enabled could cause assertion failure… fixed #1163439 (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…. Bug fixed #1104977 (Ignacio Nin). Running the DDL statement while variable innodb_lazy_drop_table was enabled could cause assertion failure… fixed #1163439 (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…log_at_trx_commit != 1), or work around it with by fsyncing to memory (Battery or capacitor-backed… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication… number of times specified by this variable (default is 1 retry). This means more…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 23 Comments
… the back_log, which effectively serves as a queue for new connections on operating system size to allow MySQL to handle spikes. Although MySQL… will cause for some connection attempts to be refused. What back_log variable specifies is second parameter to listen() operating system call. The…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…MySQL 5.6 with default configuration back_log…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables…back…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… changes are rather puzzling for me. Lets go over them: back_log = 50 + ( max_connections / 5 ) capped at 900 – The large backlog…. Very few users actually need DOS prevention this variable strives to provide as MySQL is typically protected by Firewall to begin with… means it makes it even more important to set this variable to higher values for sessions executing complicated queries. I think…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… about the all-important battery-backed write cache, how it’…/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 …’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… thing to check for. VARIABLE=${VARIABLE:-Threads_connected} You need to change the threshold to 15, and the variable to Threads_running. Check… that the script can log into MySQL (if necessary, put a password into .my.cnf, or in the MYSQLOPTIONS variable). Now you can… anything but print a timestamp line every 30 seconds. Come back later and see what it found, or set the EMAIL…
