Hmm, well... It really shouldn't take 2 min to select from an empty table, no matter what you have in my.cnf.
So, something else is happening. One way that InnoDB can take forever to read from an empty table is if there's a transaction still in progress that was started some time ago. Perhaps there's a process that's looking at the database, having started a transaction, and has never committed. Are you sure this isn't the case? Or, perhaps you have many transactions which get interval locks on your empty table? Does the problem go away if you stop and restart the server? How about if you do a TRUNCATE TABLE on your offending empty table, which will discard it and recreate it? If that's not it, perhaps something is wrong with the InnoDB database files. Can you dump the data with mysqldump, delete the InnoDB database files, and recreate the database? If that doesn't help, or if the problem returns, you should post the result of a SHOW INNODB STATUS when the problem is happening. You may need to pay MySQL AB or InnoDB Oy for some help. ===== original message follows ===== From: "Ronan Lucio" <[EMAIL PROTECTED]> To: "Mayuran Yogarajah" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: Re: huge innodb data files Date: Fri, 27 Aug 2004 09:49:51 -0300 Mayuran, Well, I´m not a MySQL expert, but I think that a good configuration in the my.cf file can make it better. Ronan ----- Original Message ----- From: "Mayuran Yogarajah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 26, 2004 5:37 PM Subject: huge innodb data files Our DB in production currently has 2 innodb data files, the second one (which is marked autoextend) has now grown past 26 gigs. We are experiencing weird speed problems with one of the tables. Even though there are no rows in this table, performing any kind of select takes about 2 minutes to execute. Has anyone had a similar problem before ? What can I do to speed up queries to this table ? thanks, M -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
