Mysql creating high load average

Every few days the load ave开发者_Go百科rage on my Linux server goes through the roof 10.0+ and mysql is at the top of "top". Does anyone have an idea of how I can track down where this mysterious load is coming from?

Thanks for any advice.

Chris

When the load average peaks log in to MySql and type command "show processlist". This will give you the queries that MySql is executing currently. From there you can track down the ones that cause you problems.