I'm running Windows 7 (professional) with an intel Q8400 and MySQL 5.1. Whenever I have heavy MySQL queries (eg. inserting or updating 10,000-40,000 records, which takes several seconds) my UI stutters and freezes on and off. Applications are generally responsive (not frozen) but they don't do much until the SQL querying finishes.
In CPU usage, MySQL eats up an entire processer (25% in Task Manager) out of four; the other three are unused.
What can I do to make the performance better? These queries run for minutes sometimes, so it's a pretty major nuisance.
Edit: I have a single SATA HD (Samsung HD502HJ)