Hi,
I'm building an application which uses Innodb. It is very imperative
that all data is processed as quickly as it possibly can and so the problem
I have is quite a concern. My perl script executes the queries however if if
make an error in the code and the script crashes half way through then the
database becomes REALLY slow. Like 16 seconds to tell me that select
count(*) from table has no rows when really that should take < 1 second. The
only way to then fix it is to shutdown mysql..(which takes 2 minutes in this
state) and then to restart. Any suggestions on the problem would be greatly
appreciated.
Rich
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
