Re: Slow Update on large table myisam

[Rick James]

> >>>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.