Re: Recommended changes to my.cnf
Posted by:
Rick James
Date: April 20, 2014 04:53PM
> max_allowed_packet = 512M
Unrealistically large; possibly larger than is allowed.
> read_buffer_size = 128M
This is likely to cause trouble -- possibly serious trouble.
* Bigger may be slower
* What version are you using? What Engine are you using? For (1) MyISAM table scan and (2) 5.6 MRR. Alloc entire space < 5.6.4; then grows. But the big issue is that is is allocated per thread.
> sort_buffer_size = 128M
One per thread, malloced at full size until 5.6.4, so keep low; after that bigger is ok.
The most important tunables:
http://mysql.rjweb.org/doc.php/memory
Subject
Views
Written By
Posted
2126
April 19, 2014 01:56PM
Re: Recommended changes to my.cnf
939
April 20, 2014 04:53PM
991
April 20, 2014 05:01PM
891
April 21, 2014 11:24PM
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.