How to clear MySQL query profiles

mysql profiling database-performance
Ray picture Ray · Jan 20, 2014 · Viewed 9.9k times · Source

After turning on profiling in MySQL

  SET profiling=1;

I can run like a query like SELECT NOW(); and see profile results with it's execution time using:

  SHOW PROFILES;

However, I can't figure how to clear out the profile listing. Anyone know the statement to delete old profile data? SET profiling=0; just disables logging of new data and doesn't remove old stats.

Answer

Chris Blackwell picture Chris Blackwell · Sep 10, 2014

To remove previous query profiles set @@profiling_history_size=0. The following snippet clears the profiles, sets the history to its maximum size and enables profiling

SET @@profiling = 0;
SET @@profiling_history_size = 0;
SET @@profiling_history_size = 100; 
SET @@profiling = 1;

Tested on 5.6.17

Related questions

How to profile MySQL

How do I profile a MySQL database. I want to see all the SQL being run against a database. I know you can do this: set profiling=1; Run your slow query (eg SELECT * FROM messages WHERE fromaddress='xxx'; SHOW PROFILES; …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More