Re: Need help to improve innodb performance
Thanks Rick.
I have you a snapshot from the db at night, when not much action. Will try processlist.
But my big confusion is about these two variables.
innodb_buffer_pool
max_connections
Buffer_pool should be set large. Manuals says even up to 80%. Given that I have 32GB of ram, I want to set it up to 20GB or so.
But max_connections with "1.5G per thread" (as reported by MySQL-tuning.pl script) is what I am confused about.
(1) Should I increase max_connections to the tune of 20,000 or more. Is it inadvisable?
(2) How can I make sure each "thread" does not require 1.5G!
Thanks
Subject
Views
Written By
Posted
6234
March 28, 2009 10:10AM
3114
March 29, 2009 11:00PM
3101
March 30, 2009 10:17PM
2840
March 31, 2009 12:20AM
3572
April 02, 2009 01:22AM
2613
April 02, 2009 01:28AM
2920
April 02, 2009 10:19AM
6776
April 17, 2009 03:50PM
3251
April 17, 2009 10:00PM
Re: Need help to improve innodb performance
3090
April 17, 2009 11:26PM
2779
April 18, 2009 05:58PM
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.