Dirk Rodemer wrote:
>
> Hello !
>
> I have a table with a fixed char fiel which is indexed. Now I am sending
> a select query which uses this field in the where clause. It searches
> for an exact match (no wildcards). If there are many requests ( ~ 20/sec)
> the mysqlds are very CPU-consuming and all slows down. System configuration:
> 2 PII-350, Linux 2.0.36, mysql 3.22.21
>
> Does anybody have any hints how to speed this up.
>
> I have read in the documentation of mysql 3.23 that there is the possibilty
> to keep tables in RAM. When will 3.23 be released or is there a chance
> to get the develpment version for testing purposes.
>
> Thanks for your help
>
> Dirk
>
> --
> Dirk Rodemer http://www.admaster.de
> werbung im netz gmbh Tel. +49 89 74117-684
> Konrad-Celtis-Str. 77 Fax. +49 89 74117-630
> D-81369 Muenchen mailto:dr@stripped
>
Post the output of the following:
DESCRIBE your_table;
EXPLAIN your_query;
SHOW STATUS;
SHOW VARIABLES;
Also how much RAM do you have? How much of it is available to MySQL?
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
