snippetsqlMajor
I dropped MySQL's `performance_schema` database, how can I create it?
Viewed 0 times
canperformance_schemacreatedroppeddatabasemysqlhow
Problem
While fixing a ibdata/log problem, I accidentally dropped my
Those variables appear to be fine to me.
The following question asks the same thing, however the user concludes that they were able to create it by following documentation that I could not find such instructions in.
mysql: deleted performance_schema, is it a problem?
Any thoughts?
performance_schema database, I'd like to create a new one.mysql> SHOW VARIABLES LIKE 'perf%';
+---------------------------------------------------+---------+
| Variable_name | Value |
+---------------------------------------------------+---------+
| performance_schema | ON |
| performance_schema_events_waits_history_long_size | 10000 |
| performance_schema_events_waits_history_size | 10 |
| performance_schema_max_cond_classes | 80 |
| performance_schema_max_cond_instances | 1000 |
| performance_schema_max_file_classes | 50 |
| performance_schema_max_file_handles | 32768 |
| performance_schema_max_file_instances | 10000 |
| performance_schema_max_mutex_classes | 200 |
| performance_schema_max_mutex_instances | 1000000 |
| performance_schema_max_rwlock_classes | 30 |
| performance_schema_max_rwlock_instances | 1000000 |
| performance_schema_max_table_handles | 100000 |
| performance_schema_max_table_instances | 50000 |
| performance_schema_max_thread_classes | 50 |
| performance_schema_max_thread_instances | 1000 |
+---------------------------------------------------+---------+
16 rows in set (0.06 sec)Those variables appear to be fine to me.
The following question asks the same thing, however the user concludes that they were able to create it by following documentation that I could not find such instructions in.
mysql: deleted performance_schema, is it a problem?
Any thoughts?
Solution
Tables in the performance_schema database are a collection of views and temporary tables that do not store data permanently. The mysql_upgrade command will restore the performance_schema database
From the shell
From the shell
mysql_upgrade --user=root --password=passwordCode Snippets
mysql_upgrade --user=root --password=passwordContext
StackExchange Database Administrators Q#56812, answer score: 20
Revisions (0)
No revisions yet.