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 locks in both InnoDB and MyIsam. I know that I can change to InnoDB and that would alleviate the problem, but I am curious as to what the problem is. This is a new problem for the application has been running for 4 years. The server is a 64bit server with 16GB of memory, raid 10, and a quad core CPU. The size of the database is 600MB. The lock occurred while two users were accessing the same table. Thanks for any insight, /ZK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 wal...@openquery.com wrote: From: Walter Heck wal...@openquery.com Subject: Re: Corrupted table To: Zakai Kinan titanyen2...@yahoo.com Cc: mysql@lists.mysql.com Date: Wednesday, March 10, 2010, 8:29 AM That message usually means you ran out of space in your temp folder location. cheers, Walter Heck -- Engineer @ Open Query http://openquery.com | http://openquery.com/blog On Thu, Mar 11, 2010 at 02:16, Zakai Kinan titanyen2...@yahoo.com wrote: 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 unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=titanyen2...@yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Information_schema permission error
Thanks for the answer. ZK --- On Wed, 2/17/10, Mikhail Berman mikhail...@gmail.com wrote: From: Mikhail Berman mikhail...@gmail.com Subject: Re: Information_schema permission error To: Zakai Kinan titanyen2...@yahoo.com Cc: mysql@lists.mysql.com Date: Wednesday, February 17, 2010, 5:49 AM On 02/16/2010 17:30, Zakai Kinan wrote: 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 Hi Zak, information_schema database is not a set of real tables, it is a set of views - http://dev.mysql.com/doc/refman/5.1/en/information-schema.html, and because of that you cannot backup information_schema tables as there are not any. The error message you are getting is simply confusing and incorrectly represents the situation. Hoping this helps Mikhail Berman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Table problem
two servers were having the same problem and they each have 1GB of space in the temp dir. I was able to fix the problem by recreating the biggest table in the database. The total space in each database is 350MB. The deleted table's size was 500kb. The mysql version is 5.0.51a. I am afraid that when the table gets to that size it is going to crapped out again. Is there anything that I may not be taking into consideration. Thanks, ZK --- On Thu, 7/9/09, kabel li...@voidship.net wrote: From: kabel li...@voidship.net Subject: Re: Table problem To: mysql@lists.mysql.com Date: Thursday, July 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 this error? TIA, ZK You could be running out of space on your temp partition.. if a query is either creating an explicit temporary table or generating one as part of execution, it may be filling it up. kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=titanyen2...@yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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/[EMAIL PROTECTED]