MySQL Forums
Forum List  »  Performance

Re: Creating Sort Index Slow
Posted by: Rick James
Date: March 17, 2014 11:59AM

> max_connections=10000

Excessive. Most sites don't need more than 100.

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

SHOW CREATE TABLE artran;

This compound index might help:
INDEX(type, wos_date, refno)

> key_buffer_size=128M

If you are using only MyISAM, change that to 20% of available RAM.

> there have a process of creating sort index which is very slow

Elaborate on what you mean.

> around 20 seconds for the first time and around 5 seconds for the second time.

That speedup is probably due to caching.

> It only happen to myisam table.

InnoDB is preferred. At which point, the most important setting is innodb_buffer_pool_size.

Options: ReplyQuote


Subject
Views
Written By
Posted
41577
March 14, 2014 09:59PM
Re: Creating Sort Index Slow
15843
March 17, 2014 11:59AM
10818
March 17, 2014 08:20PM
8179
March 17, 2014 08:46PM
6778
March 17, 2014 10:31PM
5370
March 18, 2014 01:13AM
5090
March 19, 2014 04:56PM
4780
March 19, 2014 05:04PM
4073
March 19, 2014 10:06PM
7205
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.