Re: Monitoring large resultsets
Enable slow_query_log and see what has been stressing your database server
If you are using MySQL 5.1 and onward
SET GLOBAL slow_query_log=ON;
SET GLOBAL long_query_time=2;
If using MySQL 5.0 or earlier
[mysqld]
....
log-slow-queries
long_query_time=2
If you use Percona MySQL, you can enable 'userstat' to understand the server activity better and identify the source of the load.
http://www.percona.com/doc/percona-server/5.5/diagnostics/user_stats.html?id=percona-server:features:userstatv2
Edited 2 time(s). Last edit at 07/11/2012 02:04AM by Aftab Khan.
Subject
Views
Written By
Posted
2065
July 10, 2012 10:26PM
Re: Monitoring large resultsets
1125
July 11, 2012 02:01AM
937
July 12, 2012 12:22AM
905
July 12, 2012 02:19AM
1024
July 12, 2012 03:06AM
957
July 12, 2012 03:37AM
948
July 12, 2012 03:51AM
946
July 12, 2012 04:13AM
930
July 12, 2012 05:35AM
991
July 12, 2012 05:49AM
933
July 12, 2012 06:05AM
1128
July 12, 2012 07:02AM
902
July 12, 2012 04:41PM
942
July 13, 2012 07:50PM
926
July 14, 2012 02:43AM
909
July 12, 2012 08:13AM
907
July 12, 2012 08:55AM
990
July 12, 2012 12:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.