Hello, I seem your mysqld doesn't use enough memory.
>>Date Time CPU% RSS VSZ >>2012/5/22 21:00:39 109 294752 540028 if your mysqld uses InnoDB oftenly, edit innodb_buffer_pool_size in you my.cnf. http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size >>table_cache >>thread_cache_size >>tmp_table_size >>max_heap_table_size >> >>but made not much difference. It is solution for only sql's large result,i think. if you doesn't recognize that problem causes large result, you should approach other way,too. regards, ts. tanaka// 2012/5/23 Yu Watanabe <yu.watan...@jp.fujitsu.com>: > 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 > > Thanks, > Yu > > > Yu Watanabe さんは書きました: >>Hello all. >> >>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 >> >>Attached file >># 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, >>http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html >> >>and read "Hiperformance Mysql vol.2" , >>and increased the following values, >> >>table_cache >>thread_cache_size >>tmp_table_size >>max_heap_table_size >> >>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 >> >>*2 SAR >>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. >> >>Best Regards, >>Yu Watanabe >> >>______________________________________________________________________ >> >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe: http://lists.mysql.com/mysql > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
