…TIMEOUT=.*/CMAN_QUORUM_TIMEOUT=0/g” /etc/sysconfig/cman [root@percona2 ~]# sed -i.sed “s/.*CMAN_QUORUM_TIMEOUT=.*/CMAN_QUORUM_TIMEOUT…Global setup… [ OK ] Loading kernel modules… [ OK ] Mounting configfs… [ OK ] Starting cman… [ OK ] Waiting…
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
…. Bugs Fixed: Using Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client introduced a regression… the bigger value for wait_timeout option on the server to prevent server from closing connections if the global wait_timeout value is set too…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
…4096 updatable-views-with-limit YES userstat FALSE verbose TRUE wait-timeout 28800 Which is however rather ugly and only works …it: mysql> set global sort_buffer_size=DEFAULT; Query OK, 0 rows affected (0.00 sec) mysql> select @@global.sort_buffer_size; +—————————+ | @@global.sort_…
Comment: Too many connections? No problem!
March 24, 2010 By 28 Comments
… in mysql server so you have to check the source to figure out what’s what. To change global wait_timeout and interactive_timeout one would set global_system_variables.net_wait_timeout and global_system_variables.net_interactive_timeout however each thread has…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…Lock wait timeout exceeded; try restarting transaction transaction2 > INSERT INTO t VALUES(29); ERROR 1205 (HY000): Lock wait timeout …is that the second one is a global variable that affects all sessions and needs…1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default …
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… that it also allows you to retry things like lock wait timeouts and deadlocks, if you so desire. These are areas where…’ or ‘statistics’ command at the MySQL protocol level, which will increment Com_admin_commands in SHOW GLOBAL STATUS, or a trivial query…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf…-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache…_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…50, to match the client’s version of MySQL; they are very careful about upgrades. The RDS… are the settings, for the record: grep innodb ./global-variables.txt have_innodb YES ignore_builtin_innodb…_recovery 0 innodb_io_capacity 200 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… in memory tables. So first MySQL versions did not bother naming…. delayed_insert_limit, delayed_insert_timeout, delayed_queue_size Delayed inserts …of Large Pages for allocation of large global areas such as Innodb Buffer Pool… higher priority than updates and waiting update will not stall all…
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
… with which items expire due to timeout you may never get a system warmed up. But wait again… was this the first… we did it on MySQL side instead. “SET GLOBAL max_connections=20″ to limit number of connections to MySQL and so let application… err when it tries to put too much load on MySQL as MySQL load stabilizes increasing number of connections higher until you…
