…to the user you’re forced to wait. Setting lock wait timeout to…mysql> update test2 set names=’mysql2′ where id=1; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction Session1: Query…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30 wait_timeout=15 max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set…mysql and that I am not a DBA. Please do not tell me “if you don’t know how to…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… it better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 …_at_trx_commit = 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_spin…how much this was really investigated. Indeed this is much smaller than default. If you have queries…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…How to make the tools connect to MySQL The slides are now available here, and slide 7 provides a basic introduction to… with a single query. It monitors master load to suspend itself if…abort with a ‘Lock wait timeout exceeded’ error. The table …), or if the data set size, storage engine, network speed…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
…timeouts to know the difference between just transient errors or performance problem and real problem. To be truly prudent it is better not to… information about how exactly things are set up in … When we apply them to MySQL replication we can use …. Developer added bad query to the application and the…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…how do you determine the memory consumption per connection in average? This leads to…’, ’0′ ‘Com_select’, ’378247551′ ‘Com_set_option’, ’285487367′ ‘Com_show…queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout…
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
…to be detailed enough. So back to this case… MySQL was getting overloaded with thousands of same queries… which corresponded to…to timeout…MySQL side instead. “SET GLOBAL max_connections=20″ to limit number of connections to MySQL and so let application to err when it tries to…
