var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
MYSQL Help - innodb_additional_mem_pool_size
How can I set this to be higher in MySQL.
MySQL keeps crashing with the error there is not enough memory I need to increase innodb_additional_mem_pool_size in my.conf
Well there is no variable in my.conf with this.
How do I add it? How much should I make it for MySQL to stop crashing?
In the [mysqld] group, simpy add:
set-variable = innodb_additional_mem_pool_size=XXM
XX, of course, is the size in MB of pool.
You mean the mysqld group in the my.cnf file?
The default is 2MB? Is the setting below correct if I wanted 4MB?
Would is a typical setting for this varaible? Would doubling it be a safe bet. I run a forum with about 300 concurrent users.
set-variable = innodb_additional_mem_pool_size=4
I'd take it a bit higher than that as long as you've got the system RAM. Bump it to around 10MB. If you're running out at 2, an extra-heavy day might break you at 4.
Then I just restart MySQL and the variable should be set? I don't have to change anything elsewhere just add that line to my.cnf?
I have 1 gig of RAM.
Nope, bounce it =) Then login and list your variables to see if it's set.
How do you list your variables?
Yes, restart the server =)