I find that with databases in general, and MySQl in particular, that you CPU is bound up in a io wait state, that is, waiting for disk reads and/or writes. You may be disk bound. In that case, adding another CPU will only give you nominal improvement.
You would need to check to see if I/O is the issue by checking the I/O wait states and see if the kernel is just blocking the CPU waiting for disk read/writes. If so, are you using SCSI? IDE? Got RAID? Striping will improve the situation, as well as turning off mirroring disks, if you have that setup. Ben Ricker Wellinx.com On Fri, 2002-11-01 at 14:50, Brandon Cruz wrote: > > I have an overloaded linux server running Apache>Tomcat 3.2.4>MySQL. It has > 512MB Ram, which seems to be doing fine, but the 1Ghz CPU being used by > Tomcat is constantly 35-60%. Before I spend the money, does tomcat take > advantage of multiple processors, and will it help me to upgrade to a Dual > 1Ghz CPU machine? > > Brandon > > > -- > To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org> > -- To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>
