MySQL Forums
Forum List  »  MyISAM

Re: Slow Update on large table myisam
Posted by: Rick James
Date: January 16, 2014 10:59PM

> >>>nacimientos is with 5 million record

OK, so you are changing only 1 million records. Still takes a long time.

> >>>The reason I use myisam is cause the UPDATE procedure it is made no more than one a month and the database is getting a lot of SELECT query by customers. So as I understand innodb is slow with SELECT.

Are there INSERTs during the month? They might interfere with the SELECTs.

InnoDB is _usually_ as fast as MyISAM for SELECTs. (It depends on the details of the query.)

No, I cannot make a case for changing to InnoDB; the effort would be significant.

> >>>The reason I duplicate if cause I think it is fast to do a select in just 1 single table with less records the in 2 tables, one with 5 million records.

Maybe, maybe not. It depends on what the SELECTs look like.

Options: ReplyQuote


Subject
Views
Written By
Posted
1802
January 16, 2014 08:10PM
Re: Slow Update on large table myisam
2111
January 16, 2014 10:59PM


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.