MySQL Forums
Forum List  »  Newbie

Re: SELECT took lengthy of time
Posted by: Rick James
Date: August 26, 2010 08:10PM

Look in my.cnf (my.ini) to see if it is set there. If so change it.
For example, if you have 4GB of RAM, you would need a line like
innodb_buffer_pool_size = 2500M

Then restart mysql.

Options: ReplyQuote


Subject
Written By
Posted
August 23, 2010 07:23PM
August 23, 2010 09:51PM
August 24, 2010 09:26PM
August 26, 2010 07:05PM
Re: SELECT took lengthy of time
August 26, 2010 08:10PM
August 26, 2010 10:05PM
August 28, 2010 05:42AM
August 29, 2010 10:20PM
August 23, 2010 11:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.