MySQL Forums
Forum List  »  MyISAM

Re: MySQL reports no errors on inserts and updates but takes no action
Posted by: Joao Silva
Date: August 01, 2006 03:17AM

Dear Ingo:

First thanks for answering.

I'm using a mysql version 4.0.25.

Answering to your second question, yes I need to reinsert and re update (re-run) all the statments from that point forward.

Escapes me if the index (just primary autoincrement) gets corrupted, but possibly. But if that's the case why it corrupts in index in 5 diferent tables all at once? I can understand that a certain table index gets currupted but not even in tables where we don't make inserts, just updates, that one may get currupted as well and all other 5 tables indexes get currupted at the same time? I think it's unlikelly.

The process goes as:
UPDATE wrd_words ... (5 million updates a day, inserts < 200 a day)
UPDATE adgroup_word ... (5 million updates a day, inserts < 100 a day)
UPDATE ads_ads ... (5 million updates a day, inserts < 100 a day)
INSERT INTO usr_impressions ... (5 million inserts a day/ 1200 updates per day)

The number of selects over this tables are very small just a few hundred per day.
The database dosen't use relationships between tables (for performance).

Best regards
Joao

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL reports no errors on inserts and updates but takes no action
1445
August 01, 2006 03:17AM


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.