npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2024 – Pkg Stats / Ryan Hefner

pm2-mysql

v1.0.0

Published

Mysql module

Downloads

8

Readme

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 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>

e.g:

  • 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)

Uninstall

pm2 uninstall pm2-mysql