MySQL Forums
Forum List  »  Optimizer & Parser

Re: MySQL cash optimization
Posted by: Sasha Katsman
Date: December 09, 2014 04:33AM

Hi Peter,

Thank you for your response.

> Is there any way to prevent from the mysql making this cashing?
> To make repeat runs as slow as the first? Why would you wish to do that?

Because i am doing this process only once, so i think the caching is take a time.
And i want to save a maximum time, because i don't have an idea how i can make it faster.

> Also, if these are InnoDB tables, what's innodb_buffer_pool_size, how much RAM is there?

Yes it's InnoDB tables.
innodb_buffer_pool_size = 128mb.

Mine tables sizes:
Rows Size
items 4,000,0000 7.86Gb
items_cat 22,000,000 2Gb
items_tag 40,000,000 1.56Gb

How its looks that all joins take very very long time.

Any help would be greatly appreciated!


Options: ReplyQuote

Written By
November 27, 2014 06:33AM
November 27, 2014 04:34PM
Re: MySQL cash optimization
December 09, 2014 04:33AM
December 09, 2014 12:28PM

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.