Hi,
I have installed MySQL-4.0.5-0 version on my RH Linux-7.1 box. I am using the
innodb database with tables (.frm, .MYD & .MYI ). My system's memory is around
3 GB ( 3798748K ). But I am facing problem of memory utilization. The "top"
output is as below ;
Mem: 3798748K av, 2378268K used, 1420480K free, 0K shrd, 7964K buff
Swap: 2096220K av, 0K used, 2096220K free 509892K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
990 mysql 20 0 1756M 1.7G 2060 R 21.0 47.3 135:53 mysqld
883 mysql 20 0 1756M 1.7G 2060 R 20.9 47.3 136:15 mysqld
879 mysql 20 0 1756M 1.7G 2060 R 20.6 47.3 135:49 mysqld
902 mysql 14 0 1756M 1.7G 2060 R 20.3 47.3 136:18 mysqld
22803 root 17 0 1088 1088 840 R 13.3 0.0 0:11 top
866 mysql 9 0 1756M 1.7G 2060 S 2.4 47.3 1:33 mysqld
897 mysql 9 0 1756M 1.7G 2060 S 1.7 47.3 1:32 mysqld
898 mysql 9 0 1756M 1.7G 2060 S 1.3 47.3 1:32 mysqld
877 mysql 9 0 1756M 1.7G 2060 S 0.7 47.3 0:35 mysqld
901 mysql 9 0 1756M 1.7G 2060 S 0.4 47.3 0:35 mysqld
900 mysql 9 0 1756M 1.7G 2060 S 0.2 47.3 0:36 mysqld
875 mysql 9 0 1756M 1.7G 2060 S 0.1 47.3 0:34 mysqld
1 root 8 0 544 544 472 S 0.0 0.0 0:04 init
My configuration (my.cnf) file of mysql server is as below :
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
datadir = /xxx/yyy
basedir = /
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = key_buffer=768M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=9M
set-variable = record_buffer=3M
set-variable = thread_cache=8
set-variable = max_connections=150
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_stack=256k
log-bin
server-id = 1
binlog-do-db = sms110
slave-skip-errors = all
innodb_data_home_dir = /xxx/yyy/
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /xxx/yyy/
innodb_log_arch_dir = /xxx/yyy/
set-variable = innodb_buffer_pool_size=1500M
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_log_file_size=400M
set-variable = innodb_log_buffer_size=10M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_lock_wait_timeout=50
set-variable = innodb_file_io_threads=4
transaction-isolation = READ-COMMITTED
innodb_thread_concurrency = 4
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
Please advise me where I have to made changes in config file for the best
performence of mysql server.
Regards
Naveen
