OPTIMIZE and LOCK TABLES

Hi All,
 Is it essential to lock tables when optimizing them? I have a scheduled task which loops over all of my tables and optimises them, but it seems to be causing some problems. I notice that in this bug report:
http://bugs.mysql.com/bug.php?id=16986
<BLOCKED::http://bugs.mysql.com/bug.php?id=16986> there is some mention
of mysql deadlocking under exactl the conditions that my optimiser is creating.  

However, it looks like I could get away with it if I don't lock the tables I am optimizing. Given that I expect to get updates to the tables concerned, I want to know if I can get away with optimising a table without locking it first.    

Regards,

             Leigh  

Leigh Sharpe
Network Systems Engineer
Pacific Wireless
Ph +61 3 9584 8966
Mob 0408 009 502
Helpdesk 1300 300 616
email lsharpe@pacificwireless.com.au
<BLOCKED::blocked::mailto:lsharpe@pacificwireless.com.au>
web www.pacificwireless.com.au
<BLOCKED::blocked::http://www.pacificwireless.com.au/>
   

Regards,

             Leigh  

Leigh Sharpe
Network Systems Engineer
Pacific Wireless
Ph +61 3 9584 8966
Mob 0408 009 502
Helpdesk 1300 300 616
email lsharpe@pacificwireless.com.au
<blocked::mailto:lsharpe@pacificwireless.com.au>
web www.pacificwireless.com.au
<blocked::http://www.pacificwireless.com.au/>
  Received on Sun Sep 2 20:15:39 2007

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek