How to speed up mysql

[Taipai]

I have a mysql select query that scans a range of data in a large table. It works very slow on my system. I had tried to create the necessary indexes in optimized and analyzed the table. I had tried everything to speed up my mysql, but it didn't work out for me. So can any body tell me that how to speed up mysql? Does any body knows about it? Kindly provide me the correct solution for the above issue.

[Praetor]

According to me, in mysql you need to enable query cache in order to speed up your query performance. Whenever query cache is enable, it will cache the query in memory and boost query performance.

[Katty]

The first thing you?ll want to do is make sure that your installation of MySQL actually has query caching support available. To speed up query, enable the MySQL query cache, before that you need to set few variables in mysql configuration file (usually is my.cnf or my.ini)

[kelfro]

It might be that your data is much bigger than your memory. Try to use a storage engine with row-level locking, like InnoDB. Use column default value, and insert only those values that differs from the default. Try to use less RAM per row by declaring columns only as large as they need to be to hold the values stored in them.This reduces the query parsing time.