…to insert another value on the second session: transaction2 > START TRANSACTION; transaction2 > INSERT INTO t VALUES(26); ERROR 1205 (HY000): Lock wait timeout…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…to add a little context. What problem were we trying to solve with these plugins? Why yet another set of MySQL… (and lock wait timeouts, covered…mysql-processlist plugin checks SHOW FULL PROCESSLIST for patterns that indicate similar problems to those discussed within InnoDB… surprising how often …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…to disable them. The MySQL Settings are probably what is the most interesting: MySQL…innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_spin_loops = 40 innodb_locks_unsafe_for_binlog = 1 innodb_max_dirty_pages_pct=15 innodb_support_xa=0 innodb…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…how do you determine the memory consumption per connection in average? This leads to… ’0′ ‘Com_select’, ’378247551′ ‘Com_set_option’, ’285487367′ ‘Com_…to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…innodb-use-sys-stats-table innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout…mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…innodb_force_recovery 0 innodb_io_capacity 200 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb_log_buffer_size 8388608 innodb_log_file_size 134217728 innodb…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…Lock wait timeout exceeded; try restarting transaction So as we can see Solid does not have instant deadlock detection as Innodb and have to…to the user you’re forced to wait. Setting lock wait timeout to some small value is not optimal solution ether as it would make some transactions to…
