Innodb variables

[ankur02018]

Hi,

I have installed MySQL 5.0.51 on Linux 32 bit plateform all tables are using innodb engine

I want to set all innodb related variables for better performance

what is forumula to set innodb_buffer_pool_size and other related innodb variable

I have set Max_connection to 100

[vgatto]

There’s no easy answer to this question. It’s best to educate yourself. Obviously the MySQL manual is a good source of information. Here are a few links that might help you out as well:

http://www.bigdbahead.com/?p=115

http://www.mysqlperformanceblog.com/2007/11/03/choosing-inno db_buffer_pool_size/

[ankur02018]

Thanks Dear cool: