Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 09-07-2009
Member
 
Join Date: Jan 2009
Posts: 124
How to speed up mysql

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.
Reply With Quote
  #2  
Old 09-07-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: How to speed up mysql

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.
Reply With Quote
  #3  
Old 09-07-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: How to speed up mysql

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)
Reply With Quote
  #4  
Old 09-07-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: How to speed up mysql

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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to speed up mysql"
Thread Thread Starter Forum Replies Last Post
Unable to install MySQL and MySQL Workbench on Linux mint 10 Zared Windows Software 4 13-01-2011 01:08 AM
mysql config file in MySQL Netorious Software Development 4 18-03-2010 09:43 PM
How to speed up the MySQL database Kalanidhi Software Development 5 27-02-2010 01:33 AM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM
Turn on MySQL query cache to speed up query performance DMA2Superman Software Development 3 07-07-2009 10:26 AM


All times are GMT +5.5. The time now is 02:03 AM.