Table lock statistics by TABLE not just server,db

2004-01-09 Thread trevor%tribenetwork.com
Mysqlians, I am trying to determine in some of my database tables should be converted from MyISAM to Innodb. I have read that a collusion on 10-20% is the threshold at which one should convert( current # around .3%). However the table_locks_waited and table_locks_immediate

Re: Table lock statistics by TABLE not just server,db

2004-01-09 Thread Jeremy Zawodny
On Fri, Jan 09, 2004 at 01:43:53PM -0800, trevor%tribenetwork.com wrote: Mysqlians, I am trying to determine in some of my database tables should be converted from MyISAM to Innodb. I have read that a collusion on 10-20% is the threshold at which one should convert( current #