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
2425
January 27, 2012 10:38PM
1166
January 28, 2012 06:41PM
2176
January 28, 2012 10:16PM
1255
January 29, 2012 07:09PM
1276
January 30, 2012 02:18AM
Re: Query with variables very slow
1283
January 30, 2012 03:39AM
1125
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.