Following the release of MySQL 0.1-beta, myperf allows you to display MySQL performance data online in real time and regularly refresh the data. Recently, two other functions are added: regularly collect MySQL database performance data and store (snapshot) because the original intention is mainly to consider multiple MySQL servers, the data will be stored in a centralized MySQLServ
Following the release of MySQL 0.1-beta, myperf allows you to display MySQL performance data online in real time and regularly refresh the data. Recently, two other functions are added: regularly collect MySQL database performance data and store (snapshot) because the original intention is mainly to consider multiple MySQL servers, the data will be stored in a centralized MySQL Serv
Following the release of MySQL 0.1-beta, myperf allows you to display MySQL performance data online in real time and regularly refresh the data. Recently, two other functions are added:
- Regularly collect and store MySQL database performance data (snapshot) because the original intention is mainly to consider multiple MySQL servers, the data will be centrally stored in a centralized MySQL Server and not saved to itself. Of course, this function may be added in the future.
- Currently, only plain text reports can be generated based on snapshot of performance data and report records generated to text files. Only reports of two adjacent snapshots can be generated. Currently, you cannot manually select a report between two snapshots.
In addition to adding these two features, an optional configuration file is also added on the basis of the original. The main purpose is to reduce the input content in the command line. After all, some parameters are repeatedly input. Of course, if you do not like the configuration file method, choose not to use the configuration file and directly enter all the parameters in the command line. Because Performance Schema is now added to MySQL 5.5, the new version also adds collection of Performance Schema data, such as Event wait and File IO, however, at present, the analysis on this write data is still relatively weak, and we hope to strengthen it in the future. The source Code, configuration file, and Schema structure file used to store snapshot data are all stored on Google Code. You can use the SVN tool to co it anonymously. You are also welcome to download the trial. Now, the basic functions I have imagined have been almost completed, and my code is rough. If you are interested in further improvement, welcome Gmail to sky000 and maintain and improve this tool together.
Original article address: the snapshot and report functions are added to myperf. Thank you for sharing them with me.