Differences

This shows you the differences between two versions of the page.

--- mysql:tunning [2010/04/26 15:12]
a
+++ mysql:tunning [2011/01/01 19:16] (current)
a
@@ Line 10: / Line 10: @@
   * **''thread_cache_size''** - set it until show status like ‘threads_created’ quits increasing.
   * **''table_cache_size''** - set until show status like ‘opened_tables’ quits increasing. If you have thousands of tables this might not be possible
+===== How to enable performance_schema in MySQL 5.5 =====
+One of the cool feature of MySQL 5.5 performance schema is not enabled by default to enable it in the my.cnf for linux add variable under mysqld
+   [mysqld]
+   performance_schema
+to check if the performance_schema
+<code>
+mysql> show databases;
++--------------------+
+| Database           |
++--------------------+
+| information_schema |
+| mysql              |
+| performance_schema |
+| test               |
++--------------------+
+rows in set (0.00 sec)
+</code>
 ==== Tune MySQL parameters ====