------_=_NextPart_001_01C7EDBF.8F7AEBD0
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
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=3D16986
<BLOCKED::http://bugs.mysql.com/bug.php?id=3D16986> 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 [at] pacificwireless.com.au
<BLOCKED::blocked::mailto:lsharpe [at] 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 [at] pacificwireless.com.au
<blocked::mailto:lsharpe [at] pacificwireless.com.au>
web www.pacificwireless.com.au
<blocked::http://www.pacificwireless.com.au/>
------_=_NextPart_001_01C7EDBF.8F7AEBD0--
