Pm2 Mysql
| Project Name | Stars | Downloads | Repos Using This | Packages Using This | Most Recent Commit | Total Releases | Latest Release | Open Issues | License | Language |
|---|---|---|---|---|---|---|---|---|---|---|
| Tidb | 34,121 | 68 | 101 | 4 hours ago | 1,289 | April 07, 2022 | 3,983 | apache-2.0 | Go | |
| TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial | ||||||||||
| Metabase | 32,563 | 4 hours ago | 1 | June 08, 2022 | 2,998 | other | Clojure | |||
| The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum: | ||||||||||
| Dbeaver | 32,202 | 6 hours ago | 1,753 | apache-2.0 | Java | |||||
| Free universal database tool and SQL client | ||||||||||
| Prisma | 31,675 |  | 442 | 4 hours ago | 4,993 | September 24, 2022 | 2,899 | apache-2.0 | TypeScript | |
| Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB | ||||||||||
| Typeorm | 31,337 |  | 1,994 | 2,164 | 2 days ago | 650 | September 20, 2022 | 1,958 | mit | TypeScript |
| ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms. | ||||||||||
| Directus | 21,718 |  | 50 | 4 hours ago | 55 | September 22, 2022 | 229 | other | TypeScript | |
| The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database. | ||||||||||
| Shardingsphere | 18,446 | 8 | 5 hours ago | 7 | June 04, 2020 | 652 | apache-2.0 | Java | ||
| Ecosystem to transform any database into a distributed database system, and enhance it with sharding, elastic scaling, encryption features & more | ||||||||||
| Mindsdb | 16,305 |  | 3 | 1 | 4 hours ago | 42 | March 19, 2019 | 621 | gpl-3.0 | Python |
| MindsDB is a Server for Artificial Intelligence Logic. Enabling developers to ship AI powered projects to production in a fast and scalable way. | ||||||||||
| Vitess | 16,267 | 66 | 5 hours ago | 397 | September 01, 2022 | 840 | apache-2.0 | Go | ||
| Vitess is a database clustering system for horizontal scaling of MySQL. | ||||||||||
| Dolt | 14,899 | 2 | 4 days ago | 214 | May 19, 2022 | 276 | apache-2.0 | Go | ||
| Dolt – Git for Data | ||||||||||
Description
PM2 module to monitor a MySQL server with Keymetrics
Install
pm2 install pm2-mysql
Requirements
This module requires a MySQL install (tested against v5.6). Optionally, to monitor the DB disk Read/Write you will need iostat located in the sysstat package.
Slow Queries
To be able to display Slow Queries you first need to activate slow_query_log in MySQL via : Edit /etc/mysql/my.cnf and add : slow_query_log = '1'
and you need to set the log file path to a file your pm2 user has read access to : slow_query_log_file = '/var/log/mysql/slow-queries.log'
General Query Log
To be able to display the last queries, you need to enable the General Query Log via : general_log = '1'
and you need to set the log file path to a file your pm2 user has read access to : general_log_file = '/var/log/mysql/general.log'
Configure
-
host(Defaults tolocalhost) : Set the hostname/ip of your mysql server -
port(Defaults to3306): Set the port of your mysql server -
user(Defaults toroot): Set the user of your mysql server -
password(Defaults tonone): Set the password of your mysql server -
refreshRate(Defaults to 1000): Set the stats refresh rate (in milliseconds) -
dbDiskName(Defaults to "sda"): Sets the name of the disk used by the database (used to fetch io stats) -
slowQueriesLog(Defaults to "/var/log/mysql/slow-queries.log"): log file to fetch slow queries from -
generalLog(Defaults to "/var/log/mysql/general.log"): log file to fetch last queries from -
lastQueriesSize(Defaults to 100): number of lines to fetch from general log for last queries display -
errorLog(Defaults to "/var/log/mysql/error.log"): error log file -
lastErrorsSize(Defaults to 100): number of lines to fetch from error log for last errors display
How to set these values ?
After having installed the module you have to type :
pm2 set pm2-mysql:<key> <value>
e.g:
-
pm2 set pm2-mysql:port 3307(set the mysql port to 3307) -
pm2 set pm2-mysql:password keppo(usekeppoas password for your mysql server)
Uninstall
pm2 uninstall pm2-mysql
