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
2346
June 19, 2012 03:53AM
1231
June 25, 2012 05:44AM
1726
June 25, 2012 11:00AM
1339
June 25, 2012 11:01AM
1070
June 25, 2012 11:03AM
1323
June 25, 2012 12:23PM
1133
June 26, 2012 02:20AM
1235
June 26, 2012 03:18AM
1679
June 26, 2012 03:36AM
1240
June 26, 2012 05:01AM
1147
June 28, 2012 02:01AM
1583
June 29, 2012 12:59AM
1103
June 29, 2012 01:12AM
1217
June 29, 2012 02:14AM
1375
June 29, 2012 02:46AM
1100
June 29, 2012 03:27AM
1154
June 29, 2012 07:43AM
1397
June 29, 2012 07:22PM
1197
June 29, 2012 06:14PM
1235
June 29, 2012 07:39PM
1334
June 30, 2012 01:27AM
1105
June 30, 2012 01:48AM
1144
June 30, 2012 01:53AM
1273
June 30, 2012 02:20AM
1022
June 30, 2012 02:39AM
1143
June 30, 2012 04:35AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions
1054
June 30, 2012 06:02AM
1088
July 03, 2012 09:57AM
1101
July 04, 2012 06:39AM
1114
July 05, 2012 02:18AM
1065
July 05, 2012 11:01AM
1134
July 05, 2012 12:53PM
1076
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.