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.
Subject
Views
Written By
Posted
42721
March 14, 2014 09:59PM
Re: Creating Sort Index Slow
16102
March 17, 2014 11:59AM
11275
March 17, 2014 08:20PM
8358
March 17, 2014 08:46PM
6966
March 17, 2014 10:31PM
5580
March 18, 2014 01:13AM
5282
March 19, 2014 04:56PM
4993
March 19, 2014 05:04PM
4257
March 19, 2014 10:06PM
7386
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.