Re: Adding index kills query
Posted by:
Rick James
Date: April 25, 2014 02:25PM
Messages like "Sending data" tend to be 99% of the time, hence provide little information.
"Analytics"? Consider building and maintaining "summary tables". They tend to be much smaller and much faster.
http://mysql.rjweb.org/doc.php/datawarehouse
Show us some more specifics (schema; SELECTs other than just COUNT(*), etc), and I can provide more suggestions.
Subject
Views
Written By
Posted
2287
April 23, 2014 06:10PM
1019
April 23, 2014 06:14PM
1059
April 24, 2014 02:44AM
1205
April 24, 2014 09:07AM
1009
April 25, 2014 07:39AM
1140
April 25, 2014 11:54AM
Re: Adding index kills query
1063
April 25, 2014 02:25PM
1107
April 28, 2014 06:06AM
923
April 24, 2014 09:37AM
981
April 24, 2014 06:31PM
1267
April 24, 2014 07:10PM
1085
April 24, 2014 07:19PM
1224
April 25, 2014 10:55AM
942
April 25, 2014 11:02PM
1898
April 27, 2014 07:53PM
1024
April 27, 2014 08:50PM
1008
April 27, 2014 09:00PM
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.