> Date: Sat, 6 Sep 2014 14:26:22 +0530
> Subject: Query on some MySQL-internals
> From: ajaygargn...@gmail.com
> To: mysql@lists.mysql.com
>
> Hi all.
>
>
> We are facing a very strange scenario.
>
> We have two mysql-instances running on the same machine, and they had
> been running functionally fine since about 6 years or so (catering to
> millions of records per day).
>
> However, since last few days, we were experiencing some elongated
> slowness on both the instances.
> So, we decided to "OPTIMIZE TABLE slow_table" on both the instances.
>
> We first ran the command on one instance.
> That speeded up things massively (select count(*) that was earlier
> taking 45 minutes was now running in less than 3 minutes).
>
>
> We then ran the command on the second instance. However, that seemed
> to have no effect.
> We ran the command again (on the same instance); again it had no effect.
>
>
>
> What could be the reason of this strange behavior?
> Both the instances run under fairly the same loadMG>How do you extract the
> metrics to determine what the second instance is handling the same load as
> first instance?
MG>vmstat?MG>iostat?
MG>SHOW GLOBAL STATUS ?
> and both instances
> are mounted on the same partition (obviously, all the directories are
> different).
>
>
> Hoping for some light on this strange issue.
>
>
>
> Thanks and Regards,
> Ajay
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
