MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: How long does a query take?
Posted by: Rick James
Date: June 17, 2010 10:51PM

SHOW CREATE TABLE
Maybe some of the indexes can be removed.
Maybe you can presort the data to help.

SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
That is used for caching; it should be about 70% of _available_ RAM.

Again, that link may be mostly for MyISAM.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
How long does a query take?
Sus Andersson
June 17, 2010 06:46AM
Re: How long does a query take?
Large Arnaud
June 17, 2010 07:21AM
Re: How long does a query take?
Sus Andersson
June 17, 2010 08:15AM
Re: How long does a query take?
Large Arnaud
June 17, 2010 08:37AM
Re: How long does a query take?
Rick James
June 17, 2010 10:51PM
Re: How long does a query take?
Sus Andersson
June 18, 2010 05:46AM
Re: How long does a query take?
Rick James
June 18, 2010 10:14AM
Re: How long does a query take?
Sus Andersson
June 21, 2010 01:28PM
Re: How long does a query take?
Rick James
June 21, 2010 06:35PM
Re: How long does a query take?
Sus Andersson
June 22, 2010 04:37AM


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.