Innodb variables


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

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: db_buffer_pool_size/

Thanks Dear cool: