Hi Jay, There are other things that could be affecting the performance besides mysql. If both machines are idle. The long query should run about the same on the new machine. One thread will only run on one processor no matter how you compile mysql. For compiling MySQK on FreeBSD use the ports or see http://www.mysql.com/doc/F/r/FreeBSD.html .
I would suspect other things first such as the my.cnf configuration (show variables) or has the kernel been optimised on the old box. Did you check kernel configurations and disk subsystems? Also the default process size on FreeBSD is 256Meg, so more memory won't help much unless you use it in my.cnf and the kernel configuration allows it! Hope this helps, Ken ----- Original Message ----- From: "Jay Blanchard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 2:04 PM Subject: MySQL Performance on Dual Processor machine > Howdy all, > > We have a curious situation here, and I was wondering if any of you have > encountered this before. > > We have MySQL installed on a FreeBSD machine (733mHz, 256Mb RAM). Compiled > from source. > We installed MySQL on another FreeBSD machine (dual 866mHz, 512Mb RAM). > Compiled from source. > > The reason we went to the new machine is that we have a massive database > that for practical purposes needed to live by itself. We moved this database > from the first machine to the second machine. > > Most of the queries run slightly faster on the new machine, but one query in > particular takes twice the time to run on the new machine. The query ; > > select c10.RecordID, count(*) as Quantity, sum(c10.Minutes) as Minutes > from tblClass10 c10 left outer join tblANI a > on c10.FromNumber = a.ExemptPhone > where c10.RecordID = '100101' > and a.ExemptPhone is null > group by c10.RecordID; > > On the first machine runs in approximately 20 minutes, on the second machine > runs in about 40-45 minutes. tblClass10 has 5.5 million records, tblANI has > 3100 records. Out of tblClass10, the records matching the RecordID criteria > '100101' is approximately 170,000 (today). > > We are thinking that it has something to do with the flags that were used to > compile MySQL with reguards to dual processor machines. I am also up for any > query optimization that would work too. I have tried INSERT ...SELECT the > 100101 records into a new table and then running the query above (replacing > tblClass10 with the new table), with the results being no faster. > > TFAYHIA! > > Jay Blanchard > Applications Development > nii communications, inc. > 210-403-9100 x285 > > > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
