Pm2 Mysql

Mysql module for Keymetrics
Alternatives To Pm2 Mysql
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
Tidb34,121681014 hours ago1,289April 07, 20223,983apache-2.0Go
TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at :
4 hours ago1June 08, 20222,998otherClojure
The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
6 hours ago1,753apache-2.0Java
Free universal database tool and SQL client
Prisma31,6754424 hours ago4,993September 24, 20222,899apache-2.0TypeScript
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Typeorm31,3371,9942,1642 days ago650September 20, 20221,958mitTypeScript
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.
Directus21,718504 hours ago55September 22, 2022229otherTypeScript
The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
Shardingsphere18,44685 hours ago7June 04, 2020652apache-2.0Java
Ecosystem to transform any database into a distributed database system, and enhance it with sharding, elastic scaling, encryption features & more
Mindsdb16,305314 hours ago42March 19, 2019621gpl-3.0Python
MindsDB is a Server for Artificial Intelligence Logic. Enabling developers to ship AI powered projects to production in a fast and scalable way.
Vitess16,267665 hours ago397September 01, 2022840apache-2.0Go
Vitess is a database clustering system for horizontal scaling of MySQL.
Dolt14,89924 days ago214May 19, 2022276apache-2.0Go
Dolt – Git for Data
Alternatives To Pm2 Mysql
Select To Compare

Alternative Project Comparisons


PM2 module to monitor a MySQL server with Keymetrics


pm2 install pm2-mysql


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'


  • host (Defaults to localhost) : Set the hostname/ip of your mysql server
  • port (Defaults to 3306): Set the port of your mysql server
  • user (Defaults to root): Set the user of your mysql server
  • password (Defaults to none): 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>


  • pm2 set pm2-mysql:port 3307 (set the mysql port to 3307)
  • pm2 set pm2-mysql:password keppo (use keppo as password for your mysql server)


pm2 uninstall pm2-mysql

Popular Mysql Projects
Popular Database Projects
Popular Data Storage Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.