I have something I am trying to resolve with an over abundant number of
slow queries. Perhaps it is because of some additional indexes needed. As
soon as I enabled the option 'log_queries_not_using_indexes = 1' in the
configuration file, I started getting messages relating to the select
query:
SELECT wite_what, wite_desc FROM witelist
WHERE
wite_what = '$oct1' OR
wite_what = '$oct1.$oct2' OR
wite_what = '$oct1.$oct2.$oct3' OR
wite_what = '$oct1.$oct2.$oct3.$oct4' OR
wite_what = '[EMAIL PROTECTED]' OR
wite_what = '[EMAIL PROTECTED]' OR
wite_what = '$from_dom' OR
wite_what = '$rcpt_dom';
The table used is defined as such:
mysql> desc witelist;
+-----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| wite_what | varchar(128) | NO | UNI | NULL | |
| wite_desc | varchar(128) | NO | | NULL | |
+-----------+------------------+------+-----+---------+----------------+
Can anyone shed some light if I should index wite_desc to speed things up?
-d
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
