Naveen,
the size of the mysqld process is only 1.7 GB, and you have plenty of free memory. Swap usage is zero.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
----- Original Message ----- From: ""Naveen C Joshi"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 17, 2004 5:10 AM
Subject: Mysql taking 100% Mem utilisation
------=_NextPart_000_1503_01C4CBC3.341C7D00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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 =3D 3306 socket =3D /var/lib/mysql/mysql.sock [mysqld] datadir =3D /xxx/yyy basedir =3D / port =3D 3306 socket =3D /var/lib/mysql/mysql.sock skip-locking set-variable =3D key_buffer=3D768M set-variable =3D max_allowed_packet=3D1M set-variable =3D table_cache=3D512 set-variable =3D sort_buffer=3D9M set-variable =3D record_buffer=3D3M set-variable =3D thread_cache=3D8 set-variable =3D max_connections=3D150 set-variable =3D thread_concurrency=3D8 set-variable =3D myisam_sort_buffer_size=3D64M set-variable =3D thread_stack=3D256k log-bin server-id =3D 1 binlog-do-db =3D sms110 slave-skip-errors =3D all innodb_data_home_dir =3D /xxx/yyy/ innodb_data_file_path =3D ibdata1:2000M;ibdata2:10M:autoextend innodb_log_group_home_dir =3D /xxx/yyy/ innodb_log_arch_dir =3D /xxx/yyy/ set-variable =3D innodb_buffer_pool_size=3D1500M set-variable =3D innodb_additional_mem_pool_size=3D20M set-variable =3D innodb_log_file_size=3D400M set-variable =3D innodb_log_buffer_size=3D10M innodb_flush_log_at_trx_commit=3D1 set-variable =3D innodb_lock_wait_timeout=3D50 set-variable =3D innodb_file_io_threads=3D4 transaction-isolation =3D READ-COMMITTED innodb_thread_concurrency =3D 4 [mysqldump] quick set-variable =3D max_allowed_packet=3D16M [mysql] no-auto-rehash [isamchk] set-variable =3D key_buffer=3D256M set-variable =3D sort_buffer=3D256M set-variable =3D read_buffer=3D2M set-variable =3D write_buffer=3D2M [myisamchk] set-variable =3D key_buffer=3D256M set-variable =3D sort_buffer=3D256M set-variable =3D read_buffer=3D2M set-variable =3D write_buffer=3D2M [mysqlhotcopy] interactive-timeout
Please advise me where I have to made changes in config file for the = best performence of mysql server.
Regards
Naveen =20
------=_NextPart_000_1503_01C4CBC3.341C7D00--
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
