lundi 2 mars 2015

MySQL InnoDB

Hello,



Just a quick question.



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


Code:



# 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





MySQL InnoDB

Aucun commentaire:

Enregistrer un commentaire