…Global setup… [ OK ] Loading kernel modules… [ OK ] Mounting configfs… [ OK ] Starting cman… [ OK ] Waiting…Set: ms_MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql…
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… by setting 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
… updatable-views-with-limit YES userstat FALSE verbose TRUE wait-timeout 28800 Which is however rather ugly and only works …read 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
… 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 a local variable set…
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 … http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data…_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
…MySQL; they are very careful about upgrades. The RDS instance was a Quadruple Extra Large DB Instance. I used default settings…). Here are the settings, for the record: grep innodb ./global-variables.txt have_innodb …0 innodb_io_capacity 200 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog …
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… so 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…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…memory tables. So first MySQL versions did not bother…delayed_insert_limit, delayed_insert_timeout, delayed_queue_size Delayed … Pages for allocation of large global areas such as Innodb Buffer…priority than updates and waiting update will not stall… used to sort result set (allocated by each thread…
Post: Sell-an-Elephant-to-your-Boss-HOWTO
August 28, 2012 By 3 Comments
…unstable response times”, “get timeout for every 10th request”, “need to wait 10s for page to… we are working on in the global picture and what not. 2. …go to your manager or whoever sets project priorities and make it clear:…, optimizing indexes or queries, tuning MySQL etc. which we can offload 80…
