Problem with kernel_mutex in MySQL 5.1 and MySQL 5.5 is known: Bug report. In fact in MySQL 5.6 there are some fixes that suppose to provide a solution, but MySQL 5.6 yet has long way ahead before production, and…
Post: kernel_mutex problem. Or double throughput with single variable
December 2, 2011 By 17 Comments
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…and all kinds of other things. In MySQL 5 number of Innodb performance counters were exported and now available in…” is current value for the mutex object (locked=1/free=0) , “waiters flag”…and couple of other values. “Thread declared inside InnoDB 400″ means thread is running inside Innodb kernel and…
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
…kernel should be patches with uprobes patch, which fortunately is included in RedHat based kernels, but not included in vanilla kernel…MySQL. And it seems SystemTap can re-use DTrace probes available in application, as you may know DTrace-probes were added into MySQL 5…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…and replication, and remember that the execution is not serializable. PZ: Cool. This is one of little known new features in MySQL 5.1…MySQL binlog write and the InnoDB log flush with a mutex in 5.1, to implement XA, and switching off the XA will not remove that serialization. MySQL…
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
… graphs provided in these benchmarks and see what value is best for MySQL 5.1 and for MySQL 5.0 …kernel is by far too large (so it is same as 0 – unlimited) but it will add another mutex to deal with for the queue implementation. What would be really interesting to learn though is why MySQL 5.1…
Post: Percona Server version 10
April 13, 2010 By 3 Comments
… 9.1 there are following changes MySQL 5.1.45 as a basis for the release I_S SYS_TABLES New patch page_size_and…_64 and i386) OpenSolaris (x86_64) Fixed bugs in the release: Bug #551379:Change SE Name at mysql start Bug #550867:5.1.45+xtradb….TABLE_STATISTICS is broken in XtraDB 9.1 Bug #509017:srv_table_reserve_slot() should be protected by kernel_mutex Bug #520825:ANALYZE TABLE…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…_STRESS: 32 sessions, RW=1, dbsize = 1000000, no thinktime XtraDB: (mysql-5.1.39 + XtraDB-1.0.4-current) innodb_io_…may be “Mutex at 0x28ce8e0 created file srv/srv0srv.c line 982″. It is kernel_mutex, currently we … 60%up from Normal Plugin 1.0.4) In the end, the faster and more stable performance of …
