Re: MySQL cash optimization

[Sasha Katsman]

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!

Thanks
Sasha