Your not indexing properly this should be a blink of a search.  Or your
looping your loops when you search.

Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183


-----Original Message-----
From: mos [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 1:30 PM
To: MySQL list
Subject: Re: Performance Tuning - Table Joins


At 12:22 PM 4/4/2005, you wrote:
>I have been struggling to maintain decent performance on a web/database
>server for a good 6 months now due to MySQL performance issues. I have
>decided that my best option at this point is to take it to the list, so in
>advance, I thank you all for taking a look.
>
>There is no error messages that can be posted, so I will try and describe
>what's happening as best I can.
>
>I am joining 3 tables in one query. I have had numerous people examine the
>queries and all have given their stamp of approval. What happens when I
>run it is MySQL takes the processor for a ride, spiking it to 100% until I
>restart mysqld.
>
>The tables range from 50,000 to 85,000 records, and the join is only
>supposed to return 1 record.
>
>My question to you is this: are there changes I can make to the
>configuration to improve performance? --or-- is data de-normalization my
>best option?
>
>Is there any more information you need from me to answer this question?
>
>Current setup:
>         2.4ghz Pentium 4, 1gb ram, 360gb 4-disc raid 5 array w/ 3ware
> chassis and card, fedora core 3 w/ all patches and updates, selinux
> -disabled-,  mysql 4.1.10a, MyISAM table format.
>
>Again, thank you all in advance,
>Jason


Jason,
         Try running "Analyze Table" on each of the tables. This will
rebalance the index and get rid of deleted space. Returning one row from a
3 table join should take only ms if you're using indexes properly.

Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to