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.watanabe@stripped>:
>> 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
>
>
