Hello,
I work on a large database. I make use of cron job to
cluster certain database table periodically.
I found when updating a table and clusterdb cron job
happens to run at exactly the same time clustering
that table, then both updating and clustering stuck.
Database server hault. This cause my system hault.
I tried to lock that table using 'lock tableName'
command before updating that table, I run 'clusterdb
-t tableName dbName', I found clusterdb ignore the
fact that the table is locked and go ahead finishing
cluster job.
So how can I protect the table when I update it to
avoid cluster cron job interrupt the update?
Any suggestion will be greatly appreciated!
jing
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
