Also following is the free command result.
total used free shared buffers cached
Mem: 8162380 7843676 318704 0 95632 5970892
-/+ buffers/cache: 1777152 6385228
Swap: 8032492 23560 8008932
Yu Watanabe さんは書きました:
>I would like to ask for advice with performance tuning with MySQL.
>Following are some data for my server.
>CPU : Xeon(TM) 2.8GHz (2CPUs - 8core total)
>Memory : 8GB
>OS : RHEL 4.4 x86_64
>MySQL : MySQL 5.0.50sp1-enterprise
># my.cnf.txt : my.cnf information
># mysqlext_20120522131034.log : variable and status information from mysqladmin
>I have 2 database working with high load.
>I wanted to speed up my select and update queries not by
>optimizing the query itself but tuning the my.cnf.
>I have referred to following site,
>and read "Hiperformance Mysql vol.2" ,
>and increased the following values,
>but made not much difference.
>According to the ps and sar result
>*1 PS result
>Date Time CPU% RSS VSZ
>2012/5/22 21:00:39 109 294752 540028
>Average CPU user 25%
> sys 5%
> io 3%
>I assume that MySQL can work more but currently not.
>I am considersing to off load 1 high load database to
>seperate process and make MySQL work in multiple process.
>It would be a great help if people in this forum can give
>us an adivice for the tuning.
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql