Use Nagios to monitor MySQL database in Ossim

Source: Internet
Author: User
Tags ossim

There are a lot of ways to monitor MySQL under Ossim, and today the instructions are monitored under the command line. Usually you run under OSSIM5 to monitor the problem files that are missing libmysqlclient.so.15, but you do not have such problems in Ossim 2.3 and Ossim 3.0 systems.

virtualusmallinone:~#/usr/lib/nagios/plugins/check_mysql-s/var/run/mysqld/mysqld.sock-p PZyAHooqzy

/usr/lib/nagios/plugins/check_mysql:error while loading shared libraries:libmysqlclient.so.15:cannot open shared Object File:no such file or directory

Copy this file and you can use it directly, and let me tell you where to download it.

virtualusmallinone:~# Wget-o/usr/lib/libmysqlclient.so.15 http://files.directadmin.com/services/es_5.0_64/ libmysqlclient.so.15

--2015-09-08 10:14:00--http://files.directadmin.com/services/es_5.0_64/libmysqlclient.so.15

Resolving files.directadmin.com ... 216.144.254.90, 208.167.226.3, 69.162.69.58

Connecting to files.directadmin.com|216.144.254.90|:80 ... Connected.

HTTP request sent, awaiting response ... OK

length:1474856 (1.4M) [Application/octet-stream]

Saving to: '/usr/lib/libmysqlclient.so.15 '


100%[===============================================================>] 1,474,856 195K/s in 9.2s


2015-09-08 10:14:10 (157 kb/s)-'/usr/lib/libmysqlclient.so.15 ' saved [1474856/1474856]

Once the download is complete, execute the command again to see the effect.

virtualusmallinone:~#/usr/lib/nagios/plugins/check_mysql-s/var/run/mysqld/mysqld.sock-p PZyAHooqzy

uptime:253321 threads:16 questions:2688108 Slow queries:6 opens:2551 Flush tables:1 Open tables:549 queries Per second avg:10.611

virtualusmallinone:~#

Okay, now you can write to the CFG configuration file, see the upcoming new book for more examples.

Use Nagios to monitor MySQL database in Ossim

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.