MySQL FAQs - Revision history

Jakeh at 20:10, 7 March 2014

2014-03-07T20:10:22Z

Jonc at 19:42, 4 June 2013

2013-06-04T19:42:47Z

Jakeh: Created page with "==How do I see all running processes in MySQL?== #Open up a command prompt on your server #Log into MySQL with this command:

mysql -u root -p

#Enter your root MySQL..."

2012-12-12T22:44:23Z

Created page with "==How do I see all running processes in MySQL?== #Open up a command prompt on your server #Log into MySQL with this command: <pre>mysql -u root -p</pre> #Enter your root MySQL..."

New page

==How do I see all running processes in MySQL?==
#Open up a command prompt on your server
#Log into MySQL with this command: <pre>mysql -u root -p</pre>
#Enter your root MySQL password when prompted
#Issue this command: <pre>SHOW FULL PROCESSLIST\G</pre>

MySQL will display a full list of running processes along with the state of the query and the SQL being ran at that time.

[[Category:Databases-MySQL]]

← Older revision		Revision as of 20:10, 7 March 2014
Line 22:		Line 22:
	</pre>		</pre>

		+	==How to Handle Error: ''User does not have access to metadata required to determine stored procedure parameter types.''==
		+	When using stored procedures in MySQL, you may come accross the error ''User does not have access to metadata required to determine stored procedure parameter types.'' In this case, you need to add SELECT permissions for the user trying to run the procedure.

		+	To add the permissions, run the following queries within MySQL on your server (replacing '''USER''' with your MySQL user):
		+	GRANT SELECT ON mysql.proc TO 'USER'@'%';
		+	flush privileges;
		+
		+	Once completed you should no longer receive the error.
		+
		+	__FORCETOC__
	[[Category:Databases-MySQL]]		[[Category:Databases-MySQL]]

← Older revision		Revision as of 19:42, 4 June 2013
Line 6:		Line 6:

	MySQL will display a full list of running processes along with the state of the query and the SQL being ran at that time.		MySQL will display a full list of running processes along with the state of the query and the SQL being ran at that time.
		+
		+	==VPS - How do I log slow queries?==
		+	You can set the this options in the my.cnf/my.ini option files
		+
		+	<pre>
		+	log_slow_queries = 1
		+	slow_query_log_file = <some file name>
		+	</pre>
		+
		+	If your server is above 5.1.6 you can set the slow query log in the runtime itself. For which you have to execute these queries (as root).
		+
		+	<pre>
		+	set global log_slow_queries = 1;
		+	set global slow_query_log_file = <some file name>;
		+	</pre>
		+

	[[Category:Databases-MySQL]]		[[Category:Databases-MySQL]]