MySQL Server configuration Variables

15/02/2009

Setting InnoDB variables


[mysqld]
# You can write your other MySQL server options here
# ...
# Data files must be able to hold your data and indexes.
# Make sure that you have enough free disk space.
innodb_data_file_path = ibdata1:10M:autoextend
#
# Set buffer pool size to 50-80% of your computer's memory
innodb_buffer_pool_size=70M
innodb_additional_mem_pool_size=10M
#
# Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=20M
innodb_log_buffer_size=8M
#
innodb_flush_log_at_trx_commit=1

There is 1 comment in this article:

  1. 23/10/2014sex say:

    Hi there, I would like to subscribe for this weblog to take hottest updates, thus where can i do it
    please help out.

Write a comment: