MySQL Forums
Forum List  »  Performance

Re: Utilize maximum system resources for better performance
Posted by: Ronald Brown
Date: October 02, 2015 09:09PM

Rick James Wrote:
-------------------------------------------------------
> It copies the entire record over, regardless of
> how little is changed.

should i dot partitiona as you suggested or create a new table with values changing more often and then do left join ?

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

i guess i should leave it as it is then.

> > generating xml
>
> Perhaps much of the time is in this step?

i guess, coz generating sitemap takes around 6.x minutes for all records.

Thanks for your reply.
i missed you man, are you all right ?
Best Wishes.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Utilize maximum system resources for better performance
936
October 02, 2015 09:09PM


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.