How do I make MySQL use more resources?

[oboeguy]

Dual P4 Xeons with HT. I'm running two programs at once. One is writing lots of data to a DB the other is reading from the same table in the same DB. My question is:
why is MySQL using so little of the resources available? Shouldn't each query be in its own thread, chewing-up a huge amount of CPU, preferably on different CPUs? Is the problem that MySQL isn't dual-CPU aware?

I ask because it's taking way too long to do this stuff. Yes, there are still optimizations I can do but regardless, not using resources makes no sense to me.

Edit: tried to fix link

 

[nweaver]

not sure why it's not using multiple CPU's, I could have sworn it's a multithreaded app. Have you tried on a *nix mysql server? Perhaps it windows related?

 

[oboeguy]

I don't have the option of another machine with a different OS.