pg1989
Reputation: 1010
Is the information in MySQL's performance_schema database stored on disk?
I'm somewhat confused about the actual data in this database. The documentation says the performance_schema database is a combination of temporary tables and views. Does that mean this data is held only in memory, or that it's read from a different place on disk?
Upvotes: 1
Views: 70
Answers (1)
Bill Karwin
Reputation: 562498
https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html says:
- Tables in the performance_schema database are views or temporary tables that use no persistent on-disk storage.
The performance data is held in volatile RAM only. All the information is discarded if you shut down the mysqld process, and data collection will start over when you restart mysqld.
Upvotes: 2
Related Questions
- What does MySQL's performance_schema do and what are the ramifications of disabling it?
- Where does MySQL store data?
- Does MySQL (5.6) always cache the entire result set for a query in memory/on disk?
- MySQL performance_schema not working properly?
- Where are the Drupal performance settings stored in the database?
- mysql performance_schema missing tables
- MySQL metadata (usage and performance statistics)
- Where does the MySQL database store its data?
- Where exactly the table-data stored using MySQL-cluster gets stored?
- Are MySQL databases with a MEMORY storage engine persisted to disk?