Re: MySQL 5.5.8 - Configuration Settings Suggestions
Can you please share EXPLAIN outputs? regardless of what EXPLAIN output says did you try to run SQL? What's the execution time of this SQL? and as a whole how long does that SQL takes (as you see in the slow query log)?
And I would like to see how this index would work?
ALTER TABLE unv_p4_rule_rtv_static
ADD KEY `test_2` ( t_eftto, t_eftfrom);
In each please do provide all requested information.
Edited 1 time(s). Last edit at 06/30/2012 06:08AM by Aftab Khan.
Subject
Views
Written By
Posted
2354
June 19, 2012 03:53AM
1232
June 25, 2012 05:44AM
1729
June 25, 2012 11:00AM
1342
June 25, 2012 11:01AM
1071
June 25, 2012 11:03AM
1327
June 25, 2012 12:23PM
1135
June 26, 2012 02:20AM
1237
June 26, 2012 03:18AM
1684
June 26, 2012 03:36AM
1243
June 26, 2012 05:01AM
1153
June 28, 2012 02:01AM
1587
June 29, 2012 12:59AM
1106
June 29, 2012 01:12AM
1221
June 29, 2012 02:14AM
1378
June 29, 2012 02:46AM
1104
June 29, 2012 03:27AM
1157
June 29, 2012 07:43AM
1402
June 29, 2012 07:22PM
1201
June 29, 2012 06:14PM
1241
June 29, 2012 07:39PM
1341
June 30, 2012 01:27AM
1111
June 30, 2012 01:48AM
1149
June 30, 2012 01:53AM
1276
June 30, 2012 02:20AM
1023
June 30, 2012 02:39AM
1146
June 30, 2012 04:35AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions
1057
June 30, 2012 06:02AM
1091
July 03, 2012 09:57AM
1103
July 04, 2012 06:39AM
1120
July 05, 2012 02:18AM
1067
July 05, 2012 11:01AM
1137
July 05, 2012 12:53PM
1081
July 06, 2012 03:41PM
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.