Re: Mysql Performance

[Brent Baisley]

I could see how the Pentium 4 may be faster for certain things. In some 
cases, older Pentiums with larger caches (i.e. 2MB) would outperform a 
Pentium 4. Rumor has it that MySQL loves level 2 cache, but don't tell 
PHP. But in this case, the Pentium 4 and Xeon I'm pretty sure both have 
512K level 2 cache. However, the Xeon is designed as a server 
processor, meaning it can handle many tasks very well. Give the Xeon 
just one task and it's kind of mediocre. This is fairly evident with 
reviews comparing the Xeon to the AMD fx5X series. The AMD chip beats 
the Xeon pretty convincingly in single tasks. But the Xeon really 
shines when the system is doing multiple tasks and there may be a lot 
of context switching. The Pentium is like the AMD, it can do one task 
very well.
The Xeon should perform much better then the Pentium under heavy load, 
multitasking loads.

Also, I think the Xeon's interface to memory is DDR266, where the 
Pentium is DDR400. That can be a pretty significant speed difference 
when you are really pumping data around.

What's the difference in hard drive speeds? 500GB doesn't really say 
much except that if it's just one drive, it's probably some sort of ATA 
with a slow rotation speed (i.e. 7200). An 18GB SCSI would probably 
outperform the 500GB ATA drive under heavy multitasking loads because 
of command queuing. Command queueing is just starting to become 
available in SATA drives. What kind of drive is in the Pentium? The 
cache on the drive matters too.

So, that said, I'm assuming you didn't try the "lowly" Pentium 4 under 
the typical heavy load you expect.

Now, since this is a MySQL discussion area, I think I should move away 
from hardware. You should serialize your insert queries if you haven't 
already. Meaning, run them one at a time instead of concurrently. And 
of course, before you do anything, make sure you've tweaked your MySQL 
configuration settings.

On Nov 23, 2004, at 12:41 PM, Carlos Augusto wrote:
Well that´s me again with a new problem. I am runnig another database
with 7gb of data and this db can´t stop. All the time we have queries
being inserted by a plain text file and all the time customers get
information of this database. I obvserved that for  a insert query is
taking about 5 to 15 seconds for each insert. I saw some variables
like: slow_query that output me a number of 1388 slow queries. I am
new in mysql and database stuff and i have a task to improve mysql´s
performance. I need help since in a simple Pentium 4 the same
operations are almost 10 times higher(in time of inserting a querie)
and this machine that is too slow for inserting is an dual xeon, 4gb
ram and 500gb hard disk.
I aprecciate if some one has a solution for improving this server 
performance.

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


--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]