Inserts & backups locking tables!?!
Posted by:
Matt Ryan
Date: August 22, 2006 05:40PM
We just updated to 5.0.24, and have never had table locking issues before
all the tables are insert only setups, nothing is deleted, some get updated columns, but never a delete, so there should be no holes in the data
the past week, sense the update, the tables are locked, and the users cant pull the data
the nightly backup locks the tables, for 3 hours
was anything changed? all our tables are myisam, here's the backup jobs I use
mysqldump -d -f --quote-names --skip-add-locks database > /backup/datastr.sql
mysqldump -t -f database --skip-add-locks database > /backup/database.sql
sugestions?
Subject
Views
Written By
Posted
Inserts & backups locking tables!?!
2384
August 22, 2006 05:40PM
1450
August 23, 2006 07:28AM
1380
September 05, 2006 01:50AM
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.