MySQL Forums
Forum List  »  Performance

Re: Adding index kills query
Posted by: Peter Brawley
Date: April 27, 2014 08:50PM

resource throttling?

With innodb did you try increasing innodb_buffer_pool_size to 75% of ram and key_buffer_size to 0?

With myisam did you try increasing key_buffer_size to 20% of ram?

Options: ReplyQuote


Subject
Views
Written By
Posted
2279
April 23, 2014 06:10PM
1017
April 23, 2014 06:14PM
1055
April 24, 2014 02:44AM
1201
April 24, 2014 09:07AM
1008
April 25, 2014 07:39AM
1139
April 25, 2014 11:54AM
1061
April 25, 2014 02:25PM
1102
April 28, 2014 06:06AM
920
April 24, 2014 09:37AM
979
April 24, 2014 06:31PM
1262
April 24, 2014 07:10PM
1083
April 24, 2014 07:19PM
1223
April 25, 2014 10:55AM
941
April 25, 2014 11:02PM
1895
April 27, 2014 07:53PM
Re: Adding index kills query
1018
April 27, 2014 08:50PM
1004
April 27, 2014 09:00PM


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.