WordPress Munin Plugin

vim /etc/munin/plugin-conf.d/wordpress_stats

[wordpress*]
env.DB_HOST localhost
env.DB_NAME database01
env.DB_USER user01
env.DB_PASSWORD XYZ!123
env.DB_PREFIX wp_

vim /etc/munin/plugins/wordpress_stats

#!/bin/sh
 
if [ "$1" = "config" ]; then
    echo 'graph_title Wordpress average'
    echo 'graph_category Wordpress'
    echo 'graph_order posts comments pingbacks users'
    echo 'graph_vlabel Wordpress'
    echo 'graph_info Some Statistics of Wordpress'
    echo 'posts.label Posts'
    echo 'posts.draw LINE3'
    echo 'drafts.label Drafts'
    echo 'comments.label Comments'
    echo 'pingbacks.label Pingbacks'
    echo 'users.label Users'
    exit 0
fi
 
POSTS=0
DRAFTS=0
COMMENTS=0
PINGBACKS=0
USERS=0
 
POSTS=`mysql -h$DB_HOST  -p$DB_PASSWORD -u$DB_USER -D $DB_NAME  --column-names=0 -s --execute="SELECT COUNT(*) FROM ${DB_PREFIX}posts WHERE post_status = 'publish' AND post_password = '' AND post_type = 'post';"`
 
DRAFTS=`mysql -h$DB_HOST  -p$DB_PASSWORD -u$DB_USER -D $DB_NAME  --column-names=0 -s --execute="SELECT COUNT(*) FROM ${DB_PREFIX}posts WHERE post_status = 'draft' AND post_password = '' AND post_type = 'post';"`
 
COMMENTS=`mysql -h$DB_HOST -p$DB_PASSWORD -u$DB_USER -D $DB_NAME  --column-names=0 -s --execute="SELECT COUNT(*) FROM ${DB_PREFIX}comments WHERE comment_approved = '1' AND comment_type = '';"`
 
PINGBACKS=`mysql -h$DB_HOST -p$DB_PASSWORD -u$DB_USER -D $DB_NAME  --column-names=0 -s --execute="SELECT COUNT(*) FROM ${DB_PREFIX}comments WHERE comment_approved = '1' AND comment_type = 'pingback';"`
 
USERS=`mysql -h$DB_HOST -p$DB_PASSWORD -u$DB_USER -D $DB_NAME  --column-names=0 -s --execute="SELECT COUNT(*) FROM ${DB_PREFIX}users ;"`
 
# Output
echo "posts.value $POSTS"
echo "drafts.value $DRAFTS"
echo "comments.value $COMMENTS"
echo "pingbacks.value $PINGBACKS"
echo "users.value $USERS"