High MySQL load - Revision history

Cocodude at 18:37, 22 April 2013

2013-04-22T18:37:20Z

← Older revision		Revision as of 18:37, 22 April 2013
Line 12:		Line 12:

	A useful program called [http://code.google.com/p/innotop/ innotop] (installed in /root on cPanel servers) can be used to see InnoDB MySQL queries in realtime. You can run this command with the ''-d'' flag to specify how often it should update.		A useful program called [http://code.google.com/p/innotop/ innotop] (installed in /root on cPanel servers) can be used to see InnoDB MySQL queries in realtime. You can run this command with the ''-d'' flag to specify how often it should update.

			==Limiting User Resources==

			With MySQL 5.1 and above (used by default on cPanel servers) it's possible to limit resource usage per server. This might be required if one user is using a lot of resources. To perform this limit:

			# Log into phpMyAdmin on the relevant server
			# Click on ''Users''
			# Click ''Edit Privileges'' on the user
			# Set suitable values in the ''Resource Limits'' box. The most important field is the ''MAX USER_CONNECTIONS'' one, and setting this to ''5'' would usually be suitable.

Cocodude: /* mytop */

2012-10-29T11:34:11Z

mytop

← Older revision		Revision as of 11:34, 29 October 2012
Line 7:		Line 7:
	===mytop===		===mytop===

	mytop will show what MySQL is doing in real time. The most useful mode is accessed by pressing ''Q'' which is the real time query mode. Press ''i'' to hide inactive connections. mytop can be started by running ''mytop -d mysql'' with a ''-s'' flag to specify the refresh delay.		[http://jeremy.zawodny.com/mysql/mytop/ mytop] will show what MySQL is doing in real time. The most useful mode is accessed by pressing ''Q'' which is the real time query mode. Press ''i'' to hide inactive connections. mytop can be started by running ''mytop -d mysql'' with a ''-s'' flag to specify the refresh delay.

	===innotop===		===innotop===

	A useful program called [http://code.google.com/p/innotop/ innotop] (installed in /root on cPanel servers) can be used to see InnoDB MySQL queries in realtime. You can run this command with the ''-d'' flag to specify how often it should update.		A useful program called [http://code.google.com/p/innotop/ innotop] (installed in /root on cPanel servers) can be used to see InnoDB MySQL queries in realtime. You can run this command with the ''-d'' flag to specify how often it should update.

Cocodude: /* innotop */

2012-10-29T11:33:55Z

innotop

← Older revision		Revision as of 11:33, 29 October 2012
Line 11:		Line 11:
	===innotop===		===innotop===

	A useful program called innotop (installed in /root on cPanel servers) can be used to see InnoDB MySQL queries in realtime. You can run this command with the ''-d'' flag to ~~determine~~ how often it should update. T		A useful program called [http://code.google.com/p/innotop/ innotop] (installed in /root on cPanel servers) can be used to see InnoDB MySQL queries in realtime. You can run this command with the ''-d'' flag to specify how often it should update.

Cocodude: Created page with "==Verify that MySQL is causing high load== If you notice high load on a cPanel server, it's worth running ''atop -dl'' to see whether it could be MySQL performing a lot of reads..."

2012-10-29T11:27:37Z

Created page with "==Verify that MySQL is causing high load== If you notice high load on a cPanel server, it's worth running ''atop -dl'' to see whether it could be MySQL performing a lot of reads..."

New page

==Verify that MySQL is causing high load==

If you notice high load on a cPanel server, it's worth running ''atop -dl'' to see whether it could be MySQL performing a lot of reads and writes to the database. If it looks like a likely culprit, then it's worth investigating what user queries are performing.

==Real time MySQL monitoring==

===mytop===

mytop will show what MySQL is doing in real time. The most useful mode is accessed by pressing ''Q'' which is the real time query mode. Press ''i'' to hide inactive connections. mytop can be started by running ''mytop -d mysql'' with a ''-s'' flag to specify the refresh delay.

===innotop===

A useful program called innotop (installed in /root on cPanel servers) can be used to see InnoDB MySQL queries in realtime. You can run this command with the ''-d'' flag to determine how often it should update. T