speed of query/can index help?
still fairly new to mysql so just staring to look at indexes...
to say the least i am clueless...
here is my question..
mysql> select count('syslogD.syslogD_key') from syslogD;
+------------------------------+
| count('syslogD.syslogD_key') |
+------------------------------+
| 7099286 |
+------------------------------+
1 row in set (0.00 sec)
select syslogD.sev, syslogD.msgNum, count('syslogD.sev'), syslogD.message from syslogD where day='26' group by msgNum;
i want to speed the above up.. when i join other tables it gets REALLY slow..
from wat i understand indexing will not help with things like <=> where()...
the book "the definitive guid to mysql 5" doesn't give a great deal of help in understanding what indexs provide or what i need to do to set them up..
in the example above.. if i want to add an index with full text and msgid's/numbers.. how do i even start?
Subject
Views
Written By
Posted
speed of query/can index help?
4044
June 26, 2009 06:15PM
1888
June 26, 2009 08:56PM
1894
June 26, 2009 09:39PM
1961
June 27, 2009 03:04AM
1852
June 27, 2009 06:59AM
1861
June 27, 2009 07:38AM
1909
June 27, 2009 07:45AM
1820
June 27, 2009 10:39AM
1853
June 29, 2009 07:13AM
1779
June 30, 2009 12:26AM
1849
June 30, 2009 08:08AM
1922
June 30, 2009 10:36PM
1803
July 01, 2009 01:33PM
1729
July 01, 2009 08:22PM
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.