…our plans to create excellent free tools for MySQL administrators. There is one really big thing to…the stuffing out of it with query failures, deadlocks, high/changing load, replication delay, servers shutting down…2 is released with a few minor bug fixes. For the next release, we’re completely …
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… to retry things like lock wait timeouts and deadlocks, if you so desire. These are areas where… to the ‘ping’ or ‘statistics’ command at the MySQL protocol level, which will increment Com_admin_commands… approach is to use the same code that fixes the race condition. Again, if the connection is …
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… used. Quite possibly it is a bug which will be fixed in the future, if not it will be serious handycap…). Test 1: Deadlock detection: Session1: mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> update test2 set names=’mysql‘ where id = 1… sessions: Test 1: Deadlock detection (deadlock is correctly detected): insert into test2 values (1,’Mysql‘),(2,’Solid’),(3,’MyISAM’); Session1: mysql> begin; Query OK…
Comment: SELECT LOCK IN SHARE MODE and FOR UPDATE
November 20, 2007 By 51 Comments
… an issue where I am running into some deadlocking. Essentially things look like this (MySQL 5.0.45/Windows/Connector-J-5… and UPDATE statements in Transaction-1 and hence the deadlock condition. The MySQL 5.0 Reference Guide has the following advice: Another… and I gave it a try and it didn’t fix the deadlocking so I am assuming I am misunderstanding things. Essentially…
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
…_deadlocks counter to SHOW STATUS, based on a patch by Eric Bergen (issue #569288, issue #590624). Added more tests to the MySQL test framework. Fixed bugs #573100 Can’t compile 5.1.46 #573104… compile with CFLAGS=-DUNIV_DEBUG #569156 CentOS 5: mysql-server conflicts with MySQL-server #589639 Recovery process may hang when tablespaces are…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones…thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The actual number … has any writes be prepared to handle deadlocks which may happen. Third you would like …
