How to set "performance_schema on" in mysql?

mysql mysql-workbench sqlyog
Vikrant More picture Vikrant More · Mar 26, 2015 · Viewed 13.7k times · Source

I want to turn performance_schema ON in mysql to collect statistics.

How can I achieve this?

Answer

sjas picture sjas · Mar 26, 2015

The following guide is linux-specific, but should easily be adaptable to windows.

You have to check if the mysql server version you use, is compiled with support for it:

mysqld --verbose --help | grep performance-schema

If you can read something there, you are good to go.

Enable it on server startup by putting into /etc/mysql/my.cnf

[mysqld]
performance_schema

Afterwards do a service mysqld restart (redhat) (or service mysql restart on debian/ubuntu) to restart the mysql server.

On how to use the performance schema engine and its output, see the manual:
https://dev.mysql.com/doc/refman/5.5/en/performance-schema-quick-start.html

Related questions

How to run script from within Mysql workbench?

I have a SQL script to distribute to others to run from a MySQL IDE, not from a MySQL command prompt. I want the user to load the script into a window of workbench (or another IDE like sqlyog) and …

Read More
How to use to_char function functionality in MySQL

I have a table tine_by_day and I know how to use TO_CHAR function in oracle, but how to get same output if I use in MySQL? Is there any conversion function in MySQL for TO_CHAR()? I …

Read More
MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More