{"id":2248,"date":"2013-07-12T15:16:58","date_gmt":"2013-07-12T07:16:58","guid":{"rendered":"http:\/\/rmohan.com\/?p=2248"},"modified":"2013-07-12T15:17:26","modified_gmt":"2013-07-12T07:17:26","slug":"monitor-mysql-db-in-linux","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=2248","title":{"rendered":"Monitor Mysql DB in linux"},"content":{"rendered":"<div>We can monitor mysql queries and database using an utility called\u00a0MonYog. MONyog is a monitoring and advisory tool for MySQL Community as well as Enterprise versions.MONyog is agent-less, and does not require anything to be installed on the MySQL servers. MONyog helps monitor enterprise database environments.<\/div>\n<p>&nbsp;<\/p>\n<div>MONyog MySQL Monitor and Advisor MySQL DBAs manage more MySQL servers,and tune their MySQL servers.<\/div>\n<p>&nbsp;<\/p>\n<div>To install monyog get the rpm \/ tar.gz package<\/div>\n<p>&nbsp;<\/p>\n<div># rpm -ivh monyog.version.rpm<\/div>\n<div># service monyog start \/ stop<\/div>\n<p>or<\/p>\n<div># tar -xvf monyog.version.tar.gz<\/div>\n<div># cd monyog<\/div>\n<div># cd bin<\/div>\n<div># .\/MoNyog start \/ stop<\/div>\n<div><\/div>\n<div>After installing, MONyog will be started automatically as a daemon\/service. We can immediately start monitoring your MySQL servers by pointing your browser to:<\/div>\n<p>http:\/\/&lt;YOUR_HOST&gt;:5555<\/p>\n<div>After getting the GUI interface perform some more steps to get the desired data&#8217;s\u00a0 into the interface.<\/div>\n<div>You have to set the username and password for the interface.<\/div>\n<div>Name for the new Host that need to add the interface.<\/div>\n<div>Mysql host, mysql host username and password.<\/div>\n<div>Mysql connection interval<\/div>\n<div>Enable query logs, error logs<\/div>\n<p>&nbsp;<\/p>\n<div>Just go through the following screen shoots for more details<\/div>\n<p><a href=\"http:\/\/www.webyog.com\/en\/screenshots.php\">http:\/\/www.webyog.com\/en\/screenshots.php<\/a><\/p>\n<div>To Enable mysql query logs you need to add some lines to your\u00a0my.cnf\u00a0file<b><\/b>\u00a0and restart.<\/div>\n<div><\/div>\n<p>To enable slow Query Log only<br \/>\nlog-slow-queries = \/var\/log\/mysql\/mysql-slow.log<br \/>\nlong_query_time = 1<\/p>\n<p>To enable full Log Query<br \/>\nlog=\/var\/log\/mysqldquery.log<\/p>\n<p>The above will log all queries to the log file.<br \/>\nDon\u2019t forgot to restart mysql service after making changes in my.cnf file.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We can monitor mysql queries and database using an utility called MonYog. MONyog is a monitoring and advisory tool for MySQL Community as well as Enterprise versions.MONyog is agent-less, and does not require anything to be installed on the MySQL servers. MONyog helps monitor enterprise database environments. <\/p>\n<p>&nbsp;<\/p>\n<p> MONyog MySQL Monitor and Advisor MySQL DBAs [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2248"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2248"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2248\/revisions"}],"predecessor-version":[{"id":2250,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2248\/revisions\/2250"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}