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?
4060
June 26, 2009 06:15PM
1891
June 26, 2009 08:56PM
1898
June 26, 2009 09:39PM
1968
June 27, 2009 03:04AM
1857
June 27, 2009 06:59AM
1866
June 27, 2009 07:38AM
1913
June 27, 2009 07:45AM
1823
June 27, 2009 10:39AM
1856
June 29, 2009 07:13AM
1782
June 30, 2009 12:26AM
1859
June 30, 2009 08:08AM
1927
June 30, 2009 10:36PM
1807
July 01, 2009 01:33PM
1734
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.