# Looking for some MySQL  improvements

**URL:** <https://forums.percona.com/t/looking-for-some-mysql-improvements/1174>\
**Category:** Other MySQL® Questions\
**Created:** [May 15, 2009, 12:04pm UTC](https://forums.percona.com/t/looking-for-some-mysql-improvements/1174 "2009-05-15T12:04:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gustavo](https://avatars.discourse-cdn.com/v4/letter/g/a9adbd/32.png) [@gustavo](https://forums.percona.com/u/gustavo)\
**Post date:** [May 15, 2009, 12:04pm UTC](https://forums.percona.com/t/looking-for-some-mysql-improvements/1174/1 "2009-05-15T12:04:13Z")

</div>

I’m with heavy use in MySQL MyIsam and want to make some improvements. I’m kindly asking your advice and suggestions.

Current situation:

Since las 11 days, 6 million pages served (taking into account also crawlers) with 2 billion mysql queries at a rate of 350 queries per page and 2.3 k queries per second. I’ve run the slow queries log and I’ve take a tour creating few missing indexes. Some things cannot be improved easily by design. So in the meanwhile I’ll to attack concurrently the cnf file.

Red values are:

Handler\_read\_rnd 904 M  
Handler\_read\_rnd\_next 30 G  
Qcache\_lowmem\_prunes 132 M  
Created\_tmp\_disk\_tables 13 M  
Key\_reads 46 M  
Key\_writes 27 M  
Select\_full\_join 45 k  
Select\_range\_check 46  
Sort\_merge\_passes 21 k   
Opened\_tables 2,597 k  
Table\_locks\_waited 1,069 k

I’ve some extra memory to use so I’m think to changes these settings:

join\_buffer\_size = 131072 → 64M  
key\_bufer\_size = 32M → 256M  
query\_cache\_size = 64M → 512M  
read\_buffer\_size = 2M → 64M (deleting “read\_buffer” line)  
sort\_buffer\_size = 2M → 256M  
table\_cache = 256 → table\_open\_cache = 1024  
query\_cache\_type = 1 (today not present)  
myisam\_sort\_buffer\_size = 64M → 256M

I’ll appreciate your suggestions.  
Thanks and Regards  
Gustavo

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [December 25, 2009, 7:12am UTC](https://forums.percona.com/t/looking-for-some-mysql-improvements/1174/2 "2009-12-25T07:12:32Z")

</div>

Suggestions: change only one thing at a time, then benchmark. Do not change sort\_buffer\_size or read\_buffer\_size. Read the server documentation on each variable you are thinking about changing.