Re: Adding index kills query
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?
Subject
Views
Written By
Posted
2287
April 23, 2014 06:10PM
1019
April 23, 2014 06:14PM
1059
April 24, 2014 02:44AM
1205
April 24, 2014 09:07AM
1009
April 25, 2014 07:39AM
1140
April 25, 2014 11:54AM
1063
April 25, 2014 02:25PM
1107
April 28, 2014 06:06AM
923
April 24, 2014 09:37AM
981
April 24, 2014 06:31PM
1267
April 24, 2014 07:10PM
1085
April 24, 2014 07:19PM
1224
April 25, 2014 10:55AM
942
April 25, 2014 11:02PM
1898
April 27, 2014 07:53PM
Re: Adding index kills query
1023
April 27, 2014 08:50PM
1008
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.