Skip navigation links

MySQL Forums :: MyISAM :: static mysql tables randomly require an optimize to work properly again


Advanced Search

static mysql tables randomly require an optimize to work properly again
Posted by: Alex Spitzer ()
Date: December 02, 2010 03:14PM

specs: mysql-5.0.67-linux-x86_64-icc-glibc23 running on centos 5.4-64bit

We have mysql MYISAM tables that are "rolled" weekly and/or monthly (rolled as in renameing tableX ==> tableX_archive_date) and then from that point on, then are never updated again.

We have a python process that iterates through all the archive_tables periodically and analyzes the data.

It seems like once a month, the python script will hang on a specific row and the cursor will be stuck on it until we do an optimize on the table again. i.e. all of a sudden, every time we run the script, it will always hang on a the same table/row UNTIL we run an optimize on that table.

It is not the same table every time either.

Has anyone else run into this? Having static (not updated) tables suddenly become corrupt for no apparent reason?

Thanks!

(p.s. I cross posted this to serverfault also...)

Options: ReplyQuote


Subject Views Written By Posted
static mysql tables randomly require an optimize to work properly again 1762 Alex Spitzer 12/02/2010 03:14PM
Re: static mysql tables randomly require an optimize to work properly again 757 Aftab Khan 12/07/2010 10:55AM


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.