List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:June 16 1999 11:14am
Subject:Re: Problem with accessing char field
View as plain text  
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                                
> 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;

Also how much RAM do you have?  How much of it is available to MySQL?

Sasha Pachev (home) (work)
Problem with accessing char fieldDirk Rodemer16 Jun
  • Re: Problem with accessing char fieldSasha Pachev16 Jun