[thelist] Re: To table lock or not to

[sinisa at mysql.com]

CDitty writes:
 > I am having some problems with my mysql server crashing.  I THINK I have 
 > narrowed it down to multiple records being written a the same 
 > time.   Atleast today that's the case.  There are several entries in the db 
 > around the same time the server crashed, however, there are other entries 
 > earlier in the day at the same time and the server didn't crash.  Who 
 > knows.....
 > 
 > Anyone?  Why wouldn't I want to lock the table?
 > 
 > Thanks for the help.
 > 
 > CDitty
 > 
 > 


HI!

Try to build a test case, which would always result in MySQL crash.

Also let us know of your MySQL version, how have you built it, with
what compiler, which compile and configure options, what is your OS,
it's version, versions of C and thread libs.

Regards,

Sinisa

+----------------------------------------------------------------------+
|      ____  __     _____   _____  ___     ==  MySQL AB                |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa at mysql.com     |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+