View Single Post
Old 03-31-2005, 07:44 AM   #1
ohcnetwork
Registered User
 
Join Date: Mar 2005
Posts: 19
Default MySQL InnoDB set up

I have been having some problems with my server, and I'm suspecting that the database, MySQL, is causing these problems. Specifically, MySQL configuration file currently does not set any variable for InnoDB. As I check the information on the web, I find that the following is the standard configuration:

[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
set-variable = innodb_buffer_pool_size=70M
set-variable = innodb_additional_mem_pool_size=10M
#
# Set the log file size to about 25% of the buffer pool size
set-variable = innodb_log_file_size=20M
set-variable = innodb_log_buffer_size=8M
#
innodb_flush_log_at_trx_commit=1

(http://dev.mysql.com/doc/mysql/en/in...iguration.html)

How do I know if this is the ideal configuration for my server?
ohcnetwork is offline   Reply With Quote