show table status extremely slow

2005-02-10 Thread Zhe Wang
Hi, there, We have a huge database (84 tables of about 360 G of data in MyISAM tables). Recently, we converted the entire database to InnoDB (in one table space) and set up replication. Then we experienced some slower performance. For example, show table status on the master took more

Re: show table status extremely slow

2005-02-10 Thread Eric Bergen
My experience with innodb is that show table status is slow. It's better to do show table status like 'my_table' -Eric On Thu, 10 Feb 2005 16:47:41 -0500, Zhe Wang [EMAIL PROTECTED] wrote: Hi, there, We have a huge database (84 tables of about 360 G of data in MyISAM tables). Recently,