Monitoring your mysql and mariadb database on mobile where ever you are.

Mysql and Mariadb monitoring application for Traffic, Queries per second, Reads/Writes per second and more. You can monitor and access your database using pangdata.com cloud web service on mobile, tablet and Laptop anywhere.

Screen shot

Realtime monitoring

Realtime monitoring on Mobile

Getting Started

Sign up for Pangdata.com

Before you begin, you need an Pangdata.com account. Please visit http://pangdata.com and create an account and retrieve your user key in user profile.

Minimum requirements

To run the application you will need Java 1.5+.

Installation

Very easy to install ^^.

Step 1

Windows

Download a Pang Data mysql/mariadb monitoring application file and unzip it.

Linux

wget https://github.com/pang-apps/pang-apps-monitor-mysqlmariadb/releases/download/1.0.4/pang-apps-monitor-mysqlmariadb.tar
tar -xvf pang-apps-monitor-mysqlmariadb.tar

Step 2: Configure pang.properties file

cd pang-apps-monitor-mysqlmariadb/conf

Confgiure your account and user key in pang.properties.

pang.username=your username in pangdata.com
pang.userkey=your user key in pangdata.com

Confgiure database connection properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost
jdbc.username=username
jdbc.password=password

Declare your status variable.

#If MySQL is frequently accessing the first row of a table index, it suggests that it is performing a sequential scan of the entire index. This indicates that the corresponding table is not properly indexed.
status.Handler_read_first = false
#If this variable is high, it suggests that MySQL's memory buffer is incorrectly configured for the amount of writes the server is currently performing.
status.Innodb_buffer_pool_wait_free = false
#It provides real-time information on how many clients are currently connected to the server. This can help in traffic analysis or in deciding the best time for a server re-start.
status.Threads_connected = true
#This value provides a benchmark to help you decide the maximum number of connections your server should support. It can also help in traffic analysis.
status.Max_used_connections = true
status.Cpu_time = true
status.Queries = true
status.Memory_used = false
status.Innodb_deadlocks = false
# Performing filesystem reads for database indexes slows query performance. If this variable is high, it indicates that MySQL's key cache is overloaded and should be reconfigured.
status.Key_reads = false
#A high value indicates that many queries are not being optimally executed. A necessary next step would be to examine the slow query log and identify these slow queries for optimization.
status.Slow_queries = false
#A high value indicates that many queries are not being optimally executed. A necessary next step would be to examine the slow query log and identify these slow queries for optimization.
status.Select_full_join = false

######################################################################
#Below fields are not STATUS's variables. These fields are generated by calculation.
status.queries_per_second = true
#Unit: kb
status.traffic_in = true
#Unit: kb
status.traffic_out = true
#Unit: %
status.buffer_usage = true
#Innodb writes per second
status.writes_per_second = true
#Innodb reads per second
status.reads_per_second = true

Note: User key can be found in your profile of Pangdata.com

Step 3: Run

Windows

pang-apps-monitor-mysqlmariadb/pang.bat

Linux

pang-apps-monitor-mysqlmariadb/pang.sh

Step 4: Access your devices

Register your device in Pangdata.com

Login your account. See main dashborad and you can find unregistered device. Register the unregistered device.

Step 5: You are happy to play with your data

Wow!! all done. Enjoy and play with your device and your data.