MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Creating Sort Index Slow
Posted by: SHI CAI LING
Date: March 19, 2014 10:06PM

Hi Rick,

Thanks so much for your help.

EXPLAIN SELECT ...;
The table is used to store header of the order and used to list out the latest 20 order and customer can search through the order list with name, date and etc.


SHOW VARIABLES LIKE 'max%';

http://netiquette.asia/max.html

The server has 16GB ram and only for MySQL.

SHOW GLOBAL STATUS;

http://netiquette.asia/global.html

SHOW VARIABLES;
http://netiquette.asia/variables.html

Thanks so much for your help.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Creating Sort Index Slow
41672
SHI CAI LING
March 14, 2014 09:59PM
Re: Creating Sort Index Slow
15866
Rick James
March 17, 2014 11:59AM
Re: Creating Sort Index Slow
10839
SHI CAI LING
March 17, 2014 08:20PM
Re: Creating Sort Index Slow
8186
Peter Brawley
March 17, 2014 08:46PM
Re: Creating Sort Index Slow
6790
Rick James
March 17, 2014 10:31PM
Re: Creating Sort Index Slow
5384
SHI CAI LING
March 18, 2014 01:13AM
Re: Creating Sort Index Slow
5098
Rick James
March 19, 2014 04:56PM
Re: Creating Sort Index Slow
4789
Rick James
March 19, 2014 05:04PM
Re: Creating Sort Index Slow
4083
SHI CAI LING
March 19, 2014 10:06PM
Re: Creating Sort Index Slow
7216
Rick James
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.