MySQL Performance Analyzer is an open source project for MySQL performance monitoring and analysis. This repository includes two sub projects: Java web application project myperf Java web server jetty wrapper
MySQL性能分析器是一个MySQL性能监控和分析的开源项目。它包括两个子项目：Java web应用项目myperf和Java web服务器jetty wrapper。
MySQL Performance Analyzer is a Java Maven project. JDK and Maven 3.0 or later are required to build it.
MySQL性能分析器是一个Java Maven项目。JDK和Maven3.0是构建时必须的。
Although JDK 8 is specified in pom.xml, this project does not use Java 8 specific features, so the user can modify pom.xml files of the two sub projects to use different JDK version. For example, if the build host only has JDK 7, modify the file myperf/pom.xml, change the lines
尽管JDK8在pom.xml中已包含，这个项目用不到Java8的特性，所以用户可以自行修改这两个子项目的pom.xml文件来应用不同的JDK版本。比如，构建主机如果只有JDK7，修改myperf/pom.xml文件，将以下内容：
1.8
1.8
to 更改为
1.7
1.7
The build will create a zip file named as myperfserver-server.zip under directory perfJettyServer/target. To build it, at top level, run
构建时会在perfJettyServer/target目录下生成一个zip文件：myperfserver-server.zip。准备构建，在最顶层，运行命令：
mvn clean package
Installation and Usage Instructions
安装和使用说明
Requirement: Java JDK 8, or the one specified by in pom.xml if changed during build time.
需要的软件：Java JDK8，或者在pom.xml文件中修改的版本。
Unzip myperfserver-server.zip to the desired installation directory. If you intend to install on Windows host, please review two shell scripts and create Windows equivalent.
For a more formal installation, it is recommended to have a MySQL database server to store the metrics. Otherwise, use the built-in derby db. a. Create a database, for example, named as metrics, with the MySQL database server. b. Create a MySQL user (for example, 'metrics'@'my_host' -> here my_host is the machine where you MySQL perf analyzer) with all privileges on above schema. c. The above information will be required when you first login to the analyzer to setup metrics gathering.
Review script start_myperf.sh to see if you need to modify any command line settings. Usually, port number is the only one you need change -j: jettyHome, leave it as it is -p: http port to be used, 9092 by default -w: war (web archive) file, has to be myperf.war -k: working directory, if not specified, it will use ./work -c: url context, default to /myperf, leave it as is.
Modify java command path inside start_myperf.sh, if needed.
如果需要，在文件start_myperf.sh中修改java命令的path目录
Start up: ./start_myperf.sh Check nohup.out and logs directory for any error logs.
开始命令：./start_myperf.sh，注意检查nohup.out文件和日志目录的错误日志
Shutdown: ./stop_myperf.sh
关闭命令：./stop_myperf.sh
First time Login and Setup After startup, point your browser to http://your_host:9092/myperf (or the port number you changed). The initial login user and credential are myperf/change.