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"" <naveen_joshi@stripped>
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--
>
