1. https://blog.csdn.net/weixin_34417635/article/details/94753970
    2. https://blog.csdn.net/weixin_54028135/article/details/123706044
    3. http://t.zoukankan.com/xuefy-p-11009143.html 中文环境配置
    4. https://zhuanlan.zhihu.com/p/35064593 监控用户登录数量实现

    image.png

    1. mysql监控

    https://blog.csdn.net/weixin_35838394/article/details/113210708

    1. i just to let you know im all set:
    3. mysql --user=root mysql
    4. CREATE USER ''zabbix'@'localhost';@'localhost' IDENTIFIED BY 'pass';
    5. GRANT SELECT ON *.* TO 'zabbix'@'localhost';
    7. I then change the daemon config to:
    9. UserParameter=mysql.ping,mysqladmin -uzabbix -pmoon2010 ping|grep alive|wc -l
    10. UserParameter=mysql.uptime,mysqladmin -uzabbix -pmoon2010 status|cut -f2 -d":"|cut -f1 -d"T"
    11. UserParameter=mysql.threads,mysqladmin -uzabbix -pmoon2010 status|cut -f3 -d":"|cut -f1 -d"Q"
    12. UserParameter=mysql.questions,mysqladmin -uzabbix -pmoon2010 status|cut -f4 -d":"|cut -f1 -d"S"
    13. UserParameter=mysql.slowqueries,mysqladmin -uzabbix -pmoon2010 status|cut -f5 -d":"|cut -f1 -d"O"
    14. UserParameter=mysql.qps,mysqladmin -uzabbix -pmoon2010 status|cut -f9 -d":"
    15. UserParameter=mysql.version,mysql -V