Re: Need help for performance tuning with Mysql

[Prabhat Kumar]

Check performance with script :

http://mysqltuner.pl/mysqltuner.pl - Variable tunning
http://hackmysql.com/mysqlidxchk - Unused Index

Thanks,
Prabhat

On Thu, May 24, 2012 at 4:32 PM, Rick James  wrote:

> Thanks.  I got tired of answering the same questions about buffer_pool and
> key_buffer over and over on forums.mysql.com; now I just point people at
> that page.
>
> INT(1) and INT(50) are identical -- and take 4 bytes.  See TINYINT,
> BIGINT, etc.  Also, UNSIGNED is probably wanted in more places than you
> have it.
>
> 555KB is not very big.  But a table scan (as indicated by the EXPLAIN)
> costs something.
>
> select  * -- Is this what you are really fetching?  If not, we
> can discuss a "covering" index.
>from  thold_data
>where  thold_enabled='on' -- 2-valued flag?  Not likely to be useful in
> an index, esp. not by itself
>  AND  data_id = 91633;   -- Probably the best bet.
>
> Recommend:
> INDEX(data_id)  -- or UNIQUE, if it is unique
> INDEX(data_id, thold_enabled)  -- or the opposite order; this probably
> would not be noticeable better.
>
> `notify_default` enum('on','off') default NULL
> Did you really mean to have 3 values (on, off, NULL)?
>
>
>
> > -Original Message-
> > From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com]
>  > Sent: Wednesday, May 23, 2012 7:10 PM
> > To: mysql@lists.mysql.com
> > Subject: Re: Need help for performance tuning with Mysql
> >
> > Rick
> >
> > Thank you for the reply.
> >
> > >1. There are only a few things worth tuning -- see
> > >http://mysql.rjweb.org/doc.php/memory (they don't include the ones you
> > >tried)
> > >
> >
> >   The page is really cool. Its very simple and easy to understand.
> >
> > >2. Instead INDEXes and schema design must be studied.  Please provide:
> > >SHOW CREATE TABLE
> >
> >   | thold_data | CREATE TABLE `thold_data` (
> > `id` int(11) NOT NULL auto_increment,
> > `rra_id` int(11) NOT NULL default '0',
> > `data_id` int(11) NOT NULL default '0',
> > `thold_hi` varchar(100) default NULL,
> > `thold_low` varchar(100) default NULL,
> > `thold_fail_trigger` int(10) unsigned default NULL,
> > `thold_fail_count` int(11) NOT NULL default '0',
> > `thold_alert` int(1) NOT NULL default '0',
> > `thold_enabled` enum('on','off') NOT NULL default 'on',
> > `bl_enabled` enum('on','off') NOT NULL default 'off',
> > `bl_ref_time` int(50) unsigned default NULL,
> > `bl_ref_time_range` int(10) unsigned default NULL,
> > `bl_pct_down` int(10) unsigned default NULL,
> > `bl_pct_up` int(10) unsigned default NULL,
> > `bl_fail_trigger` int(10) unsigned default NULL,
> > `bl_fail_count` int(11) unsigned default NULL,
> > `bl_alert` int(2) NOT NULL default '0',
> > `lastread` varchar(100) default NULL,
> > `oldvalue` varchar(100) NOT NULL default '',
> > `repeat_alert` int(10) unsigned default NULL,
> > `notify_default` enum('on','off') default NULL,
> > `notify_extra` varchar(255) default NULL,
> > `host_id` int(10) default NULL,
> > `syslog_priority` int(2) default '3',
> > `cdef` int(11) NOT NULL default '0',
> > PRIMARY KEY  (`id`),
> > KEY `rra_id` (`rra_id`)
> >   ) ENGINE=MyISAM AUTO_INCREMENT=69641 DEFAULT CHARSET=latin1 |
> >
> > >SHOW TABLE SIZE
> >
> >   You must be mentioning about the "show table status"
> >
> > mysql> show table status where name = "thold_data";
> > +++-++--++-
> > +-+--+---+-
> > ---+-+-
> > +-+---+--+
> > +-+
> > | Name   | Engine | Version | Row_format | Rows | Avg_row_length |
> > Data_length | Max_data_length | Index_length | Data_free |
> > Auto_increment | Create_time | Update_time | Check_time
> > | Collation | Checksum | Create_options | Comment |
> > +++-++--++-
> > +-+--+---+-
> > ---+-+-
> > +-+---+--

RE: Need help for performance tuning with Mysql

[Rick James]

Thanks.  I got tired of answering the same questions about buffer_pool and 
key_buffer over and over on forums.mysql.com; now I just point people at that 
page.

INT(1) and INT(50) are identical -- and take 4 bytes.  See TINYINT, BIGINT, 
etc.  Also, UNSIGNED is probably wanted in more places than you have it.

555KB is not very big.  But a table scan (as indicated by the EXPLAIN) costs 
something.

select  * -- Is this what you are really fetching?  If not, we can 
discuss a "covering" index.
from  thold_data
where  thold_enabled='on' -- 2-valued flag?  Not likely to be useful in an 
index, esp. not by itself
  AND  data_id = 91633;   -- Probably the best bet.

Recommend:
INDEX(data_id)  -- or UNIQUE, if it is unique
INDEX(data_id, thold_enabled)  -- or the opposite order; this probably would 
not be noticeable better.

`notify_default` enum('on','off') default NULL
Did you really mean to have 3 values (on, off, NULL)?



> -Original Message-
> From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com]
> Sent: Wednesday, May 23, 2012 7:10 PM
> To: mysql@lists.mysql.com
> Subject: Re: Need help for performance tuning with Mysql
> 
> Rick
> 
> Thank you for the reply.
> 
> >1. There are only a few things worth tuning -- see
> >http://mysql.rjweb.org/doc.php/memory (they don't include the ones you
> >tried)
> >
> 
>   The page is really cool. Its very simple and easy to understand.
> 
> >2. Instead INDEXes and schema design must be studied.  Please provide:
> >SHOW CREATE TABLE
> 
>   | thold_data | CREATE TABLE `thold_data` (
> `id` int(11) NOT NULL auto_increment,
> `rra_id` int(11) NOT NULL default '0',
> `data_id` int(11) NOT NULL default '0',
> `thold_hi` varchar(100) default NULL,
> `thold_low` varchar(100) default NULL,
> `thold_fail_trigger` int(10) unsigned default NULL,
> `thold_fail_count` int(11) NOT NULL default '0',
> `thold_alert` int(1) NOT NULL default '0',
> `thold_enabled` enum('on','off') NOT NULL default 'on',
> `bl_enabled` enum('on','off') NOT NULL default 'off',
> `bl_ref_time` int(50) unsigned default NULL,
> `bl_ref_time_range` int(10) unsigned default NULL,
> `bl_pct_down` int(10) unsigned default NULL,
> `bl_pct_up` int(10) unsigned default NULL,
> `bl_fail_trigger` int(10) unsigned default NULL,
> `bl_fail_count` int(11) unsigned default NULL,
> `bl_alert` int(2) NOT NULL default '0',
> `lastread` varchar(100) default NULL,
> `oldvalue` varchar(100) NOT NULL default '',
> `repeat_alert` int(10) unsigned default NULL,
> `notify_default` enum('on','off') default NULL,
> `notify_extra` varchar(255) default NULL,
> `host_id` int(10) default NULL,
> `syslog_priority` int(2) default '3',
> `cdef` int(11) NOT NULL default '0',
> PRIMARY KEY  (`id`),
> KEY `rra_id` (`rra_id`)
>   ) ENGINE=MyISAM AUTO_INCREMENT=69641 DEFAULT CHARSET=latin1 |
> 
> >SHOW TABLE SIZE
> 
>   You must be mentioning about the "show table status"
> 
> mysql> show table status where name = "thold_data";
> +++-++--++-
> +-+--+---+-
> ---+-+-
> +-+---+--+
> +-+
> | Name   | Engine | Version | Row_format | Rows | Avg_row_length |
> Data_length | Max_data_length | Index_length | Data_free |
> Auto_increment | Create_time | Update_time | Check_time
> | Collation | Checksum | Create_options | Comment |
> +++-++--++-
> +-+--+---+-
> ---+-+-
> +-+---+--+
> +-+
> | thold_data | MyISAM |  10 | Dynamic| 6161 | 90 |
> 555128 | 281474976710655 |   140288 | 0 |  70258 |
> 2012-05-24 10:41:47 | 2012-05-24 10:47:19 | 2012-05-24
> 10:41:47 | latin1_swedish_ci | NULL || |
> +++-++--++-
> +-+--+---+-
> ---+-+-
> +-+---+--+--

Re: Need help for performance tuning with Mysql

[Yu Watanabe]

Johnny

Thank you for the reply.

>Second, make sure your Innodb buffer pool is allocating as much ram as
>possible. I'd even go as far as adding another 8gb of ram to the
>server. The buffer pool setting is going to give you the best
>performance increase.

  The problem is mainly on MyISAM engine.

>Also, what kind of hard disks do you have the data files on? Raid? No raid?

  The server has no RAID.

Thanks,
Yu

Johnny Withers さんは書きました:
>I don't see any attachments.
>
>First, I would upgrade to 5.5 as 5.0 is very old. The upgrade process
>is painless.
>
>Second, make sure your Innodb buffer pool is allocating as much ram as
>possible. I'd even go as far as adding another 8gb of ram to the
>server. The buffer pool setting is going to give you the best
>performance increase.
>
>Also, what kind of hard disks do you have the data files on? Raid? No raid?
>
>Sent from my iPad
>
>On May 22, 2012, at 9:08 PM, Yu Watanabe  wrote:
>
>> 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

Re: Need help for performance tuning with Mysql

[Yu Watanabe]

Alex

Thank you for the advice.

Probably, we will put index (key) on both columns.

Thanks,
Yu

Alex Schaft さんは書きました:
>On 2012/05/24 07:37, Alex Schaft wrote:
>> You are selecting a record based on the value of data_id and
>> thold_enabled, but don't have an index on either? Add an index for both.
>> If data_id is unique, then you would only need an index on that.
>>
>> Alex
>>
>
>On second thought, an index on thold_enabled won't mean much I think, so
>either leave it off or create an index on data_id plus thold_enabled.
>Someone more knowledgeable may correct me.
>
>Alex
>
>
>-- 
>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

Re: Need help for performance tuning with Mysql

[Alex Schaft]

On 2012/05/24 07:37, Alex Schaft wrote:
> You are selecting a record based on the value of data_id and
> thold_enabled, but don't have an index on either? Add an index for both.
> If data_id is unique, then you would only need an index on that.
>
> Alex
>

On second thought, an index on thold_enabled won't mean much I think, so
either leave it off or create an index on data_id plus thold_enabled.
Someone more knowledgeable may correct me.

Alex


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Need help for performance tuning with Mysql

[Alex Schaft]

On 2012/05/24 04:10, Yu Watanabe wrote:
> 2. Instead INDEXes and schema design must be studied.  Please provide:
> SHOW CREATE TABLE
>   | thold_data | CREATE TABLE `thold_data` (
> `id` int(11) NOT NULL auto_increment,
> `rra_id` int(11) NOT NULL default '0',
> `data_id` int(11) NOT NULL default '0',
> `thold_hi` varchar(100) default NULL,
> `thold_low` varchar(100) default NULL,
> `thold_fail_trigger` int(10) unsigned default NULL,
> `thold_fail_count` int(11) NOT NULL default '0',
> `thold_alert` int(1) NOT NULL default '0',
> `thold_enabled` enum('on','off') NOT NULL default 'on',
> `bl_enabled` enum('on','off') NOT NULL default 'off',
> `bl_ref_time` int(50) unsigned default NULL,
> `bl_ref_time_range` int(10) unsigned default NULL,
> `bl_pct_down` int(10) unsigned default NULL,
> `bl_pct_up` int(10) unsigned default NULL,
> `bl_fail_trigger` int(10) unsigned default NULL,
> `bl_fail_count` int(11) unsigned default NULL,
> `bl_alert` int(2) NOT NULL default '0',
> `lastread` varchar(100) default NULL,
> `oldvalue` varchar(100) NOT NULL default '',
> `repeat_alert` int(10) unsigned default NULL,
> `notify_default` enum('on','off') default NULL,
> `notify_extra` varchar(255) default NULL,
> `host_id` int(10) default NULL,
> `syslog_priority` int(2) default '3',
> `cdef` int(11) NOT NULL default '0',
> PRIMARY KEY  (`id`),
> KEY `rra_id` (`rra_id`)
>   ) ENGINE=MyISAM AUTO_INCREMENT=69641 DEFAULT CHARSET=latin1 |
> EXPLAIN SELECT
>   I have seen the following select query in the slow query log.
>   I also saw update queries as well.
>
> mysql> explain select * from thold_data where thold_enabled='on' AND data_id 
> = 91633;
> ++-++--+---+--+-+--+--+-+
> | id | select_type | table  | type | possible_keys | key  | key_len | ref 
>  | rows | Extra   |
> ++-++--+---+--+-+--+--+-+
> |  1 | SIMPLE  | thold_data | ALL  | NULL  | NULL | NULL| 
> NULL | 6161 | Using where | 
> ++-++--+---+--+-+--+--+-+
> 1 row in set (0.06 sec)
>
> If cache size tuning is not an option ,
> do you think that following action would be an choice to faten the queries 
> little bit more?
You are selecting a record based on the value of data_id and
thold_enabled, but don't have an index on either? Add an index for both.
If data_id is unique, then you would only need an index on that.

Alex

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Need help for performance tuning with Mysql

[Yu Watanabe]

Rick

Thank you for the reply.

>1. There are only a few things worth tuning -- see 
>http://mysql.rjweb.org/doc.php/memory (they don't include the ones you tried)
>

  The page is really cool. Its very simple and easy to understand.

>2. Instead INDEXes and schema design must be studied.  Please provide:
>SHOW CREATE TABLE

  | thold_data | CREATE TABLE `thold_data` (
`id` int(11) NOT NULL auto_increment,
`rra_id` int(11) NOT NULL default '0',
`data_id` int(11) NOT NULL default '0',
`thold_hi` varchar(100) default NULL,
`thold_low` varchar(100) default NULL,
`thold_fail_trigger` int(10) unsigned default NULL,
`thold_fail_count` int(11) NOT NULL default '0',
`thold_alert` int(1) NOT NULL default '0',
`thold_enabled` enum('on','off') NOT NULL default 'on',
`bl_enabled` enum('on','off') NOT NULL default 'off',
`bl_ref_time` int(50) unsigned default NULL,
`bl_ref_time_range` int(10) unsigned default NULL,
`bl_pct_down` int(10) unsigned default NULL,
`bl_pct_up` int(10) unsigned default NULL,
`bl_fail_trigger` int(10) unsigned default NULL,
`bl_fail_count` int(11) unsigned default NULL,
`bl_alert` int(2) NOT NULL default '0',
`lastread` varchar(100) default NULL,
`oldvalue` varchar(100) NOT NULL default '',
`repeat_alert` int(10) unsigned default NULL,
`notify_default` enum('on','off') default NULL,
`notify_extra` varchar(255) default NULL,
`host_id` int(10) default NULL,
`syslog_priority` int(2) default '3',
`cdef` int(11) NOT NULL default '0',
PRIMARY KEY  (`id`),
KEY `rra_id` (`rra_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=69641 DEFAULT CHARSET=latin1 |

>SHOW TABLE SIZE

  You must be mentioning about the "show table status"

mysql> show table status where name = "thold_data";
+++-++--++-+-+--+---++-+-
+-+---+--++-+
| Name   | Engine | Version | Row_format | Rows | Avg_row_length | 
Data_length | Max_data_length | Index_length | Data_free | Auto_increment | 
Create_time | Update_time | Check_time  
| Collation | Checksum | Create_options | Comment |
+++-++--++-+-+--+---++-+-
+-+---+--++-+
| thold_data | MyISAM |  10 | Dynamic| 6161 | 90 |  
555128 | 281474976710655 |   140288 | 0 |  70258 | 
2012-05-24 10:41:47 | 2012-05-24 10:47:19 | 2012-05-24 
10:41:47 | latin1_swedish_ci | NULL || | 
+++-++--++-+-+--+---++-+-
+-+---+--++-+
1 row in set (0.00 sec)

>EXPLAIN SELECT

  I have seen the following select query in the slow query log.
  I also saw update queries as well.

mysql> explain select * from thold_data where thold_enabled='on' AND data_id = 
91633;
++-++--+---+--+-+--+--+-+
| id | select_type | table  | type | possible_keys | key  | key_len | ref  
| rows | Extra   |
++-++--+---+--+-+--+--+-+
|  1 | SIMPLE  | thold_data | ALL  | NULL  | NULL | NULL| NULL 
| 6161 | Using where | 
++-++--+---+--+-+--+--+-+
1 row in set (0.06 sec)

If cache size tuning is not an option ,
do you think that following action would be an choice to faten the queries 
little bit more?

1. depriving the database and setup as an another process. (multiple mysql 
processes)
2. Move the MYD, MYI, frm to ram disk (/dev/shm)

Thanks,
Yu

Rick James さんは書きました:
>100% CPU --> A slow query.  Tuning will not help.  Period.
>
>1. There are only a few things worth tuning -- see 
>http://mysql.rjweb.org/doc.php/memory (they don't include the ones you tried)
>
>2. Instead INDEXes and schema design must be studied.  Please provide:
>SHOW CREATE TABLE
>SHOW TABLE SIZE
>EXPLAIN SELECT ...
> 
>
>> -Original Message-
>> From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com]
>> Sent: Tuesday, May 22, 2012 7:07 PM
>> To

RE: Need help for performance tuning with Mysql

[Rick James]

100% CPU --> A slow query.  Tuning will not help.  Period.

1. There are only a few things worth tuning -- see 
http://mysql.rjweb.org/doc.php/memory (they don't include the ones you tried)

2. Instead INDEXes and schema design must be studied.  Please provide:
SHOW CREATE TABLE
SHOW TABLE SIZE
EXPLAIN SELECT ...
 

> -Original Message-
> From: Yu Watanabe [mailto:yu.watan...@jp.fujitsu.com]
> Sent: Tuesday, May 22, 2012 7:07 PM
> To: mysql@lists.mysql.com
> Subject: Need help for performance tuning with Mysql
> 
> 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

Re: Need help for performance tuning with Mysql

[Ananda Kumar]

Hi,
How much ever tuning you do at my.cnf will not help much, if you do not
tune your sql's.

Your first priority should be tune sql's, which will give you good
performance even with decent memory allocations and other settings

regards
anandkl

On Wed, May 23, 2012 at 3:45 PM, Andrew Moore  wrote:

> Yu,
>
> The upgrade to 5.5 that Jonny advises should NOT your first action. If
> MySQL is mis-configured on 5.0 it will likely be misconfigured on 5.1 and
> 5.5. Test your application thoroughly on the new version before heeding
> that advice. Read the change logs and known bugs. Running the upgrade might
> seem painless but if you have some legacy feature in place then things will
> not work how you may expect them to.
>
> Review your needs and see if a switch to innodb storage engine will give
> you any performance gain. The locking differences alone might make this
> worthwhile. TEST it.
>
> You did not state your data and index size. You will benefit from having
> enough RAM so that your 'working' data set fits to memory. This isn't
> possible/practical for large data but if you have a 5G dataset and 8G
> available memory you might not need to rush out and spend money.
>
> If you're heavily using MyISAM, review and tune the MyISAM related buffers.
> If you are working mostly with InnoDB tune those variables. Measure, change
> measure again. It might be an iterative process but you will learn lots
> along the way.
>
> Good luck.
>
> Andy
>
> On Wed, May 23, 2012 at 5:44 AM, Tsubasa Tanaka 
> wrote:
>
> > Hello, Yu-san,
> > (へろへろな英語で申し訳ないです)
> >
> > Can I think that you already tweaked Index on the tables?
> > if you yet,please create apt indexes.
> >
> > MyISAM caches only Index without data.
> > i take way for decreasing disk seek,
> >  1) create more indexes on the tables,if the tables doesn't update quite
> > often.
> >   including data into index forcibly.
> >   this makes slow for insert and update,and this is dirty idea,i think.
> >(よくSELECTされるカラムをINDEXに含めてしまいます。
> >ただし、SELECT * FROMで呼ばれることが多い場合には使えない上に
> >かなり美しくない策です。。)
> >  2) tune filesystem and disk drive parameter for datadir.
> >   MyISAM table's data caches only in the filesystem cache.
> >   But i regret that i don't have knowledge around filesystem.
> >
> > あまり力になれなくて申し訳ないです。
> >
> > regards,
> >
> >
> > ts. tanaka//
> >
> > 2012/5/23 Yu Watanabe :
> > > 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 :
> > >>> Also following is the free command result.
> > >>>
> > >>> total   used   free sharedbuffers
> > cached
> > >>> Mem:   81623807843676 318704  0  95632
> >  5970892
> > >>> -/+ buffers/cache:17771526385228
> > >>> Swap:  8032492  235608008932
> > >>>
> > >>> 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
> > 
>

Re: Need help for performance tuning with Mysql

[Andrew Moore]

Yu,

The upgrade to 5.5 that Jonny advises should NOT your first action. If
MySQL is mis-configured on 5.0 it will likely be misconfigured on 5.1 and
5.5. Test your application thoroughly on the new version before heeding
that advice. Read the change logs and known bugs. Running the upgrade might
seem painless but if you have some legacy feature in place then things will
not work how you may expect them to.

Review your needs and see if a switch to innodb storage engine will give
you any performance gain. The locking differences alone might make this
worthwhile. TEST it.

You did not state your data and index size. You will benefit from having
enough RAM so that your 'working' data set fits to memory. This isn't
possible/practical for large data but if you have a 5G dataset and 8G
available memory you might not need to rush out and spend money.

If you're heavily using MyISAM, review and tune the MyISAM related buffers.
If you are working mostly with InnoDB tune those variables. Measure, change
measure again. It might be an iterative process but you will learn lots
along the way.

Good luck.

Andy

On Wed, May 23, 2012 at 5:44 AM, Tsubasa Tanaka  wrote:

> Hello, Yu-san,
> (へろへろな英語で申し訳ないです)
>
> Can I think that you already tweaked Index on the tables?
> if you yet,please create apt indexes.
>
> MyISAM caches only Index without data.
> i take way for decreasing disk seek,
>  1) create more indexes on the tables,if the tables doesn't update quite
> often.
>   including data into index forcibly.
>   this makes slow for insert and update,and this is dirty idea,i think.
>(よくSELECTされるカラムをINDEXに含めてしまいます。
>ただし、SELECT * FROMで呼ばれることが多い場合には使えない上に
>かなり美しくない策です。。)
>  2) tune filesystem and disk drive parameter for datadir.
>   MyISAM table's data caches only in the filesystem cache.
>   But i regret that i don't have knowledge around filesystem.
>
> あまり力になれなくて申し訳ないです。
>
> regards,
>
>
> ts. tanaka//
>
> 2012/5/23 Yu Watanabe :
> > 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 :
> >>> Also following is the free command result.
> >>>
> >>> total   used   free sharedbuffers
> cached
> >>> Mem:   81623807843676 318704  0  95632
>  5970892
> >>> -/+ buffers/cache:17771526385228
> >>> Swap:  8032492  235608008932
> >>>
> >>> 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 

Re: Need help for performance tuning with Mysql

[Tsubasa Tanaka]

Hello, Yu-san,
(へろへろな英語で申し訳ないです)

Can I think that you already tweaked Index on the tables?
if you yet,please create apt indexes.

MyISAM caches only Index without data.
i take way for decreasing disk seek,
 1) create more indexes on the tables,if the tables doesn't update quite often.
   including data into index forcibly.
   this makes slow for insert and update,and this is dirty idea,i think.
(よくSELECTされるカラムをINDEXに含めてしまいます。
ただし、SELECT * FROMで呼ばれることが多い場合には使えない上に
かなり美しくない策です。。)
 2) tune filesystem and disk drive parameter for datadir.
   MyISAM table's data caches only in the filesystem cache.
   But i regret that i don't have knowledge around filesystem.

あまり力になれなくて申し訳ないです。

regards,


ts. tanaka//

2012/5/23 Yu Watanabe :
> 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 :
>>> Also following is the free command result.
>>>
>>> total   used   free sharedbuffers cached
>>> Mem:   81623807843676 318704  0  956325970892
>>> -/+ buffers/cache:17771526385228
>>> Swap:  8032492  235608008932
>>>
>>> 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
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Need help for performance tuning with Mysql

[Yu Watanabe]

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 :
>> Also following is the free command result.
>>
>> total   used   free sharedbuffers cached
>> Mem:   81623807843676 318704  0  956325970892
>> -/+ buffers/cache:17771526385228
>> Swap:  8032492  235608008932
>>
>> 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

Re: Need help for performance tuning with Mysql

[Johnny Withers]

I don't see any attachments.

First, I would upgrade to 5.5 as 5.0 is very old. The upgrade process
is painless.

Second, make sure your Innodb buffer pool is allocating as much ram as
possible. I'd even go as far as adding another 8gb of ram to the
server. The buffer pool setting is going to give you the best
performance increase.

Also, what kind of hard disks do you have the data files on? Raid? No raid?

Sent from my iPad

On May 22, 2012, at 9:08 PM, Yu Watanabe  wrote:

> 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

Re: Need help for performance tuning with Mysql

[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 :
> Also following is the free command result.
>
> total   used   free sharedbuffers cached
> Mem:   81623807843676 318704  0  956325970892
> -/+ buffers/cache:17771526385228
> Swap:  8032492  235608008932
>
> 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

Re: Need help for performance tuning with Mysql

[Yu Watanabe]

Also following is the free command result.

 total   used   free sharedbuffers cached
Mem:   81623807843676 318704  0  956325970892
-/+ buffers/cache:17771526385228
Swap:  8032492  235608008932

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

Need help for performance tuning with Mysql

[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