MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Harald Tijink Date:September 18 2003 11:20am
Subject:Re: Performance Problems
View as plain text  
Do you use indexes?

See http://www.mysql.com/doc/en/CREATE_INDEX.html.

In my system a retrieval from a 24 million records table (3 columns) with a
result of 25 records only took 0.09 sec and 24 million records table with 5
columns 0.25 sec

Harald

----- Original Message ----- 
From: "Schonder, Matthias" <Matthias.Schonder@stripped>
To: <mysql@stripped>
Sent: Thursday, September 18, 2003 11:24 AM
Subject: Performance Problems


> Hei :)
>
> I have an extreme performance problem with a MySQL-DB.
> The database consists of 21 tables where all except three are storing only
a
> few records. Two have about 150.000 records but they are only used
> temporary. The main table is rather huge, it has 90 columns and now after
> three month it has 500.000 records... but in the end it has to store data
of
> 36 month.
> But since the table has grown to over 350.000 records I ran into massive
> performance problems. Querying for one record (Example: SELECT sendnr FROM
> pool where sendnr = 111073101180) takes 8 seconds via command line!
> The table is indexed and i put the my-huge.cnf into /etc/ as my.cnf
>
> How can I get more performance out of the mysql?
> The server which currently only hosts this database and is running
apache1.3
> with php4 for providing results via intranet.
> The OS is FreeBSD 5.1.
> We are running two servers with the same enviroment
> One is a DualXeon 2.4ghz (with HT), 3GB RAM, 105GB HD (RAID5)
> the other one is a P4 with 2.4ghz, 1GB RAM and 120GB HD
>
> The Dual is the Productionserver, the P4 the developement- and test
server.
> The querey takes that long on BOTH machines so it seems clear the DB
itself
> is causing the performance problem.
>
> So anyone can help? This is really urgend and will save my life :)
>
> Big thanks in advance.
>
> Pacem,
>
> Matthias Schonder
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>

Thread
Performance ProblemsMatthias Schonder18 Sep
  • RE: Performance ProblemsAndy Eastham18 Sep
  • Re: Performance ProblemsHarald Tijink18 Sep
  • Re: Performance ProblemsScott Helms18 Sep