Re: Query with variables very slow
> The cache size is too small; see
>
http://mysql.rjweb.org/doc.php/memory
What should be reasonable values?
I tried to increase key_buffer_size up to 300M and I tried also to change innodb_buffer_pool_size (but maybe the second test is useless because the engine of the table is Isam).
Do you think that I need to change also other buffers?
Thanks for your time
Gianni
Subject
Views
Written By
Posted
2433
January 27, 2012 10:38PM
1171
January 28, 2012 06:41PM
2184
January 28, 2012 10:16PM
1260
January 29, 2012 07:09PM
1280
January 30, 2012 02:18AM
Re: Query with variables very slow
1288
January 30, 2012 03:39AM
1131
January 31, 2012 03:20AM
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.