MySQL InnoDB

[Hexweb]

Hello,

Just a quick question.

On one of my servers i have in the /etc/my.cnf the following values

# Uncomment the following if you are using InnoDB tables#innodb_data_home_dir = /var/lib/mysql
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 1G #256M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 64M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

Does it matter that the rest is commented out?
The first sentence is saying "# Uncomment the following if you are using InnoDB tables"
But i never had this on since i changed the my.cnf file from standard to large

And if i remove the comments, what will happen to the existing tables?

Thanks

 

[zEitEr]

Hello Marc,

Empty lines in the file are ignored as well as comments. Whether or not you remove lines beginning with "#" it should not break anything.

More readings: http://dev.mysql.com/doc/refman/5.5/en/option-files.html