How to prevent MySQL queries from taking too long | Thread profile

Hi, I have a very busy database with some tables having hundreds of thousands of records. I am running MySQL 5.0.16 on Windows. Some of the queries running on my database are not fined-tuned enough, and need improvement. However, the system is live in production and I am looking for a way to prevent MYSQL from committing Harakiri, i.e. from running very slow queries forever, taking the cpu to 50% and beyond for hours. My scripting language is...

are your tables properly indexed? is your server properly tuned? those two things alone can make significant differences in the time taken for your queries.

You need to optimise query and add index sensibly. Don't over index as it will slow it down more! It's a fine balance. Index on the right column can increase performance for SELECT and UPDATE statement on a large table but slow performance on INSERT & DELETE as the engine has to update the index. You have to decide based on whether the table is SELECT & UPDATE heavy or INSERT & DELETE heavy. Once a query is executing, I...