Give mysql more CPU power?

[Anonymous]

I am running a delete query on my spanking brand new dual 2.3 Xserve with 4 gb memory,

the table has a couple of million lines,

when I run the query mysql uses up to 3,5% of the CPU power and 94-71 % of the cpu power is idle, can I give mysql more CPU?

the computer is used only for mysql, how do I tune the system for mysql?

here is TOP
—————————————————————
Processes: 54 total, 2 running, 2 stuck, 50 sleeping… 160 threads 13:15:18
Load Avg: 0.09, 0.13, 0.08 CPU usage: 14.8% user, 4.3% sys, 81.0% idle
SharedLibs: num = 99, resident = 21.0M code, 2.55M data, 7.42M LinkEdit
MemRegions: num = 3242, resident = 290M + 8.09M private, 29.0M shared
PhysMem: 170M wired, 71.0M active, 1.04G inactive, 1.27G used, 2.73G free
VM: 3.53G + 70.2M 21501(0) pageins, 4(0) pageouts
—————————————————————
351 mysqld 1.8% 0:51.39 15 52 109 278M+ 3.12M 280M+ 470M
—————————————————————

[Anonymous]

When dealing with databases, most of the performance issues one encounters are caused by I/O (rather than CPU or RAM). As there is no one-size-fits-all approach to database tuning, I would suggest that you take a look at the O’Reilly “High Performance MySQL” book (or the mysql website🙂) to find out the optimizations and/or load balancing techniques that would best fit your setup.

[Author]

Posts