MySQL Forums
Forum List  »  Performance

Re: Utilize maximum system resources for better performance
Posted by: Rick James
Date: October 02, 2015 08:50PM

> looking in to it, as when 6mil rows gets updated daily , only their seeders,leechers,verified, last_updated fields gets updated

It copies the entire record over, regardless of how little is changed.

> > Did you specify "ROW_FORMAT=FIXED"? If so, why?
> nope i didnt specify it , i convrted this table from myisam to innodb

Yeah, I don't know what, if anything, it means for InnoDB.

> generating xml

Perhaps much of the time is in this step?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Utilize maximum system resources for better performance
1049
October 02, 2015 08:50PM


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.