MySQL Settings (also known as Server Variables) have interesting property. When you set variable… verbose TRUE wait-timeout 28800 Which …mysql> set global sort_buffer_size=DEFAULT; Query OK, 0 rows affected (0.00 sec) mysql> select @@global.sort_buffer_size; +—————————+ | @@global…
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 a… http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses …
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…MySQL versions did not bother naming variables…, delayed_insert_timeout, delayed_queue_…variables. Obviously only apply to MyISAM as key_buffer itself. large_pages – Use of Large Pages for allocation of large global…updates and waiting update …variable. sort_buffer_size Buffer used to sort result set…
Comment: Too many connections? No problem!
March 24, 2010 By 28 Comments
…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…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set…joe’, MASTER_PASSWORD=’secret’; # # OR # # 2) Set the variables below. However, in case you choose this… 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-…
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 YES… innodb_io_capacity 200 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog…
