Brent,
Would you be so kind to throw out some links to "tweaking" mysql to run
to its full performance. I am googling right now for the answeres. Is
there books you would recommend?
THANKS!!!!!!!!!!!!!!!!
On Tue, 2004-11-23 at 14:29 -0500, Brent Baisley wrote:
> 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
>
>
--
-------------
Vasiliy Boulytchev
Colorado Information Technologies Inc.
http://www.coinfotech.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
