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 # around .3%). However > the table_locks_waited and table_locks_immediate counters only give > information on a server level. I want to examine this data per table. Does > anyone know how to do this?
MySQL doesn't yet provide locking data more granular than that. Perhaps using a very low "long query time" and enabling the slow query log would help? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 118 days, processed 510,213,828 queries (50/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
