MySQL Forums
Forum List  »  Performance

speed of query/can index help?
Posted by: Ray Chambers
Date: June 26, 2009 06:15PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
speed of query/can index help?
4044
June 26, 2009 06:15PM
1888
June 26, 2009 08:56PM
1961
June 27, 2009 03:04AM
1820
June 27, 2009 10:39AM
1779
June 30, 2009 12:26AM
1922
June 30, 2009 10:36PM
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.