MySQL Forums
Forum List  »  Performance

Re: MySQL tuning
Posted by: Rick James
Date: June 24, 2013 08:07PM

> Can you share me some tips to improve performance for select queries in myiasam tables ?

Not that easily -- Give me 100 MyISAM queries; I'll give you 70 tips.

Here are some generic tips:
http://mysql.rjweb.org/doc.php/ricksrots
Novices (don't know if you are such) often need to understand the basics of indexing:
http://mysql.rjweb.org/doc.php/index1

A caution about the /memory link... It may be too generous for a 2GB machine like yours.
> key_buffer = 1024M
is much too big -- That is for MyISAM indexes only. That does not leave much room for _data_. Suggest 200M instead.

> thread_cache_size = 512
--> 5

> query_cache_size = 256M
--> 10M
At 256M (1) You are using too much of your limited RAM, and (2) the query cache becomes inefficient at even that size.

> query_prealloc_size = 65536
> query_alloc_block_size = 131072
Leave them at their defaults.

Options: ReplyQuote


Subject
Views
Written By
Posted
1907
June 23, 2013 07:58PM
862
June 23, 2013 08:42PM
878
June 23, 2013 09:06PM
Re: MySQL tuning
948
June 24, 2013 08:07PM


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.