Table locking generally

I have a problem that I can't understand readily. I have a database that has a couple of tables that lock for a recognizable period of time. The reason I know is because during the lock the application stops responding totally. The storage engine is MyIsam. I have reread everything about loc

Re: Corrupted table

I switched the tmp directory to a much bigger partition and I am still getting the error. Any other ideas? TIA, Zak --- On Wed, 3/10/10, Walter Heck wrote: > From: Walter Heck > Subject: Re: Corrupted table > To: "Zakai Kinan" > Cc: mysql@lists.mysql.com > Date:

Corrupted table

Is there a way to know exactly which table is corrupted with such an error: [ERROR] /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_7885_0.MYI'; try to repair it. TIA, ZK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Re: Information_schema permission error

Thanks for the answer. ZK --- On Wed, 2/17/10, Mikhail Berman wrote: > From: Mikhail Berman > Subject: Re: Information_schema permission error > To: "Zakai Kinan" > Cc: mysql@lists.mysql.com > Date: Wednesday, February 17, 2010, 5:49 AM > On 02/16/2010 17:30, Z

Information_schema permission error

I am getting this error - mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES. I am using 5.1.45. I don't understand what is causing this problem. Does anyone have a clue? TIA, Zak -- MySQL General Mailing

Re: Table problem

ly 9, 2009, 11:07 AM > On Thursday 09 July 2009 01:56:37 pm > Zakai Kinan wrote: > >   I have been getting this error on a > database:  Incorrect key file for > > table '/tmp/#sql_a99_0.MYI'; try to repair it.  > How do I know which table > > is causing

Table problem

I have been getting this error on a database: Incorrect key file for table '/tmp/#sql_a99_0.MYI'; try to repair it. How do I know which table is causing this error? TIA, ZK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://l

Table encryption

I searched google and the archives of this list, but I am not cleared about the support of table encryption in mysql. Can someone clarify for me? thanks, ZK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAI