MySQL Forums
Forum List  »  Performance

Creating Sort Index Slow
Posted by: SHI CAI LING
Date: March 14, 2014 09:59PM

Hi,

I am running on MYSQL SERVER 5.6.15 and when select from a table with 100k row with sorting and limit as query below, there have a process of creating sort index which is very slow around 20 seconds for the first time and around 5 seconds for the second time. It only happen to myisam table.


Select * from artran where type = "SO" order by wos_date desc, refno desc limit 20

May I know what should I do to make the creating sort index part faster?

MySQL configuration as below

max_connections=10000
query_cache_size=0
table_open_cache=10000
tmp_table_size=150M
thread_cache_size=10
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=175M
key_buffer_size=128M
read_buffer_size=1M
read_rnd_buffer_size=4M

Your help is really appreciated!

Options: ReplyQuote


Subject
Views
Written By
Posted
Creating Sort Index Slow
41573
March 14, 2014 09:59PM
15843
March 17, 2014 11:59AM
10817
March 17, 2014 08:20PM
8179
March 17, 2014 08:46PM
6778
March 17, 2014 10:31PM
5370
March 18, 2014 01:13AM
5089
March 19, 2014 04:56PM
4779
March 19, 2014 05:04PM
4073
March 19, 2014 10:06PM
7204
March 19, 2014 11:23PM


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.