MySQL Forums :: Performance :: speed of query/can index help?


Advanced Search

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? 2928 Ray Chambers 06/26/2009 06:15PM
Re: speed of query/can index help? 1714 Elli 06/26/2009 08:56PM
Re: speed of query/can index help? 1656 Ray Chambers 06/26/2009 09:39PM
Re: speed of query/can index help? 1718 Elli 06/27/2009 03:04AM
Re: speed of query/can index help? 1653 Ray Chambers 06/27/2009 06:59AM
Re: speed of query/can index help? 1650 Ray Chambers 06/27/2009 07:38AM
Re: speed of query/can index help? 1680 Ray Chambers 06/27/2009 07:45AM
Re: speed of query/can index help? 1595 Rick James 06/27/2009 10:39AM
Re: speed of query/can index help? 1660 Ray Chambers 06/29/2009 07:13AM
Re: speed of query/can index help? 1603 Rick James 06/30/2009 12:26AM
Re: speed of query/can index help? 1590 Ray Chambers 06/30/2009 08:08AM
Re: speed of query/can index help? 1646 Rick James 06/30/2009 10:36PM
Re: speed of query/can index help? 1618 Ray Chambers 07/01/2009 01:33PM
Re: speed of query/can index help? 1537 Rick James 07/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.