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

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