Innodb variables

ankur02018 · March 19, 2009, 6:21am

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 · March 19, 2009, 1:32pm

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:

[URL]bigdbahead.com is almost here!

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

ankur02018 · March 19, 2009, 11:38pm

Thanks Dear cool:

Topic		Replies	Views
MySQL Server Configuration innodb_buffer_pool_size and innodb_log_file_size Other MySQL® Questions	0	806	April 22, 2016
InnoDB performance and scalability blog Other MySQL® Questions	1	668	August 14, 2013
innodb_buffer_pool_size possibly not being used? Other MySQL® Questions	2	1577	June 24, 2007
MySQL crashes when InnoDB variables uncommented in my.cnf Other MySQL® Questions	1	490	November 20, 2007
MySQL Database performance issue-urgent help plz Other MySQL® Questions	2	541	December 6, 2010

Innodb variables

Related topics