Hello Tsubasa. Thank you for the reply. (返信ありがとうございます。)
Our high loaded DB are both INNODB and MyISAM. Espicially , on MyISAM. I will consider the tuning of innodb_buffer_pool_size as well. Do you know the tips for how to tune the disk access for MyISAM? Thanks, Yu Tsubasa Tanaka さんは書きました: >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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql