Dear All,
Kindly please make me sure that my configuration are appropriate for monitoring 500 client (specialy about innodb_data_file_path).
Here is my configuration :
Intel processor Core 2 Duo.
Ubuntu 8.04 64 bit
2 GB RAM
40 GB Hardisk
I Installed xampp-linux-1.6.7.tar.gz (PHP 5.2.6, apache 2.2, MYSQL 5)
my.cnf configuration:
# Comment the following if you are using InnoDB tables
# skip-innodb
innodb_data_home_dir = /opt/lampp/var/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/lampp/var/mysql/
innodb_log_arch_dir = /opt/lampp/var/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
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 250M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
Thanks,
NS
Kindly please make me sure that my configuration are appropriate for monitoring 500 client (specialy about innodb_data_file_path).
Here is my configuration :
Intel processor Core 2 Duo.
Ubuntu 8.04 64 bit
2 GB RAM
40 GB Hardisk
I Installed xampp-linux-1.6.7.tar.gz (PHP 5.2.6, apache 2.2, MYSQL 5)
my.cnf configuration:
# Comment the following if you are using InnoDB tables
# skip-innodb
innodb_data_home_dir = /opt/lampp/var/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /opt/lampp/var/mysql/
innodb_log_arch_dir = /opt/lampp/var/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
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 250M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
Thanks,
NS