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
2297
April 23, 2014 06:10PM
1027
April 23, 2014 06:14PM
1065
April 24, 2014 02:44AM
1208
April 24, 2014 09:07AM
1024
April 25, 2014 07:39AM
1146
April 25, 2014 11:54AM
1069
April 25, 2014 02:25PM
1124
April 28, 2014 06:06AM
944
April 24, 2014 09:37AM
992
April 24, 2014 06:31PM
1272
April 24, 2014 07:10PM
1096
April 24, 2014 07:19PM
1239
April 25, 2014 10:55AM
951
April 25, 2014 11:02PM
1910
April 27, 2014 07:53PM
Re: Adding index kills query
1029
April 27, 2014 08:50PM
1015
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.