MySQL Forums
Forum List  »  MyISAM

Re: Database Engine Error
Posted by: Ingo Strüwing
Date: January 02, 2006 05:46AM

1. I admit that this is a reasonable assumption. But I still don't think that it is storage engine related. The ODBC trace result can also show that everything from ODBC downwards behaves identically. If there would be an error message from MySQL, it should show up in the trace.

2. I see.

3. Thank you. In this case I can say that the statistics increment (Table_locks_immediate) results from a weakness of our "SHOW STATUS" implementation. It has at least to check for permission, which leads to a system table access, which needs a table lock... MyISAM does not do row-level locking, but locks all tables needed in a command at the beginning of the command. "immediate" is increased if a lock succeeds immediately. "waited" is increased if the table was in use when the lock was requested.

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
3313
December 29, 2005 10:40AM
1918
December 30, 2005 03:53AM
1953
December 30, 2005 11:39AM
Re: Database Engine Error
1904
January 02, 2006 05:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.