D Hill schrieb:
>
> 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 = '$from_name\@$from_dom' OR
> wite_what = '$rcpt_name\@$rcpt_dom' OR
> wite_what = '$from_dom' OR
> wite_what = '$rcpt_dom';

did you tried (result depending on your MySQL version):

WHERE wite_what IN ('$oct1', '$oct1.$oct2', '$oct1.$oct2.$oct3',
'$oct1.$oct2.$oct3.$oct4', '$from_name\@$from_dom',
'$rcpt_name\@$rcpt_dom', '$from_dom', '$rcpt_dom');

you could also vary with thee index length if wite_what.

and what indexes do you have currently exactly?

--
Sebastian Mendel