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                                          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)
Thread
Problem with accessing char fieldDirk Rodemer16 Jun
  • Re: Problem with accessing char fieldSasha Pachev16 Jun