{"id":13791,"date":"2010-09-04T19:45:28","date_gmt":"2010-09-04T14:15:28","guid":{"rendered":"https:\/\/www.amitbhawani.com\/blog\/?p=13791"},"modified":"2010-09-04T19:46:08","modified_gmt":"2010-09-04T14:16:08","slug":"monitor-sql-queries","status":"publish","type":"post","link":"https:\/\/www.amitbhawani.com\/blog\/monitor-sql-queries\/","title":{"rendered":"Monitor SQL Queries with Real Time Server Charts"},"content":{"rendered":"

\"Database<\/a>Once your website traffic increases one of the biggest concern would be the server load<\/a> because if the hosting servers are down you would be loosing a lot of revenue and visitors. Hence you will have to always Monitor the SQL database and make sure that the queries are controlled because if your blog or website has some plugins or scripts installed which uses multiple queries then its better to disable those.<\/p>\n

In this article we will be suggesting you a Desktop based software which would connect to your database and then monitor the same along with Real Time charts which can help you in finding out the current load and take measures on time. To get started download a copy of this software to your computer from here<\/a>, and unzip the zip file contents.<\/p>\n

Once you have extracted the files you will have to –<\/p>\n

    \n
  1. Configure the servers parameters:<\/strong> edit the file config\/servers.xml adding the data related to the servers you want to monitor.<\/li>\n
  2. Configure the charts:<\/strong> edit the file config\/charts.xml to set the charts you want the program to plot.<\/li>\n<\/ol>\n

    Under the Config folder you will find the files servers.xml and chart.xml, open them in Notepad and edit the details under the \\server\\ section.<\/p>\n

    \t<server>
    \n\t\t<id>1<\/id> \t\t\t\t\t<!– A server id. Must be unique –>
    \n\t\t<name>Instance1<\/name>\t\t\t<!– The server name. It is used to identify the instance in the program. –>
    \n\t\t<host>localhost<\/host>\t\t\t<!– The host to connect to the server. –>
    \n\t\t<port>3306<\/port>\t\t\t\t<!– The port the server is listening. –>
    \n\t\t<username>user<\/username>\t\t<!– The username to connect. –>
    \n\t\t<password>password<\/password>\t<!– The password to connect. –>
    \n\t<\/server><\/p><\/blockquote>\n

    You can easily get these details at the Cpanel or your Blogs Wp-config file and enter the same details in these two files and save the same. Here are more screenshots on the charts which will be giving you more idea on the software.<\/p>\n

    \"SQL<\/a><\/p>\n

    \"SQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    Once your website traffic increases one of the biggest concern would be the server load because if the hosting servers are down you would be loosing a lot of revenue and visitors. Hence you will have to always Monitor the SQL database and make sure that the queries are controlled because if your blog or […]<\/p>\n","protected":false},"author":1,"featured_media":19798,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1329],"tags":[],"class_list":["post-13791","post","type-post","status-publish","format-standard","has-post-thumbnail","category-software","entry"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/Database-Management-150x150.jpg?fit=150%2C150&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":14301,"url":"https:\/\/www.amitbhawani.com\/blog\/reduce-cpu-server-load-blogs-removing-related-posts-plugin\/","url_meta":{"origin":13791,"position":0},"title":"Reduce CPU Server Load for Blogs by Removing Related Posts Plugin","author":"Amit Bhawani","date":"September 20, 2010","format":false,"excerpt":"We have been using a few useful WordPress plugins on our blogs from the past years and have always been on high server load issues because of which we had to move from shared hosting to dedicated and then move the blogs onto different services like Dedicated, VPS with backups\u2026","rel":"","context":"In "Wordpress Guide"","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"CPU Server Load Usage","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/CPU-Server-Load-Usage.png?fit=697%2C288&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/CPU-Server-Load-Usage.png?fit=697%2C288&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/CPU-Server-Load-Usage.png?fit=697%2C288&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":417,"url":"https:\/\/www.amitbhawani.com\/blog\/tips-to-reduce-wordpress-high-server-usage-problems\/","url_meta":{"origin":13791,"position":1},"title":"Tips to Reduce WordPress High Server Usage Problems","author":"Amit Bhawani","date":"April 14, 2008","format":false,"excerpt":"Many bloggers keep complaining that their blogs were suspended by web hosting companies because of heavy server usage and they plan to change the CMS thinking there would be problems in the CMS but the main problem is in the plugins which are you running. The best suggestion for high\u2026","rel":"","context":"In "Wordpress Guide"","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/high-server-load-wordpress.jpg?fit=376%2C376&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":22000,"url":"https:\/\/www.amitbhawani.com\/blog\/optimizing-wordpress-cpu-consumption\/","url_meta":{"origin":13791,"position":2},"title":"Optimizing WordPress for Less CPU Consumption","author":"Amit Bhawani","date":"April 6, 2011","format":false,"excerpt":"WordPress is the CMS which is used by millions of users every single day and by default many of these users have issues with their web hosting service providers who keep complaining about the high server resource sage and then suspend the blogs for the same reason. You can signup\u2026","rel":"","context":"In "Wordpress Guide"","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"Optimize WordPress","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2011\/04\/Optimize-WordPress.jpg?fit=500%2C500&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":14016,"url":"https:\/\/www.amitbhawani.com\/blog\/fix-disqus-problem-duplicate-comments\/","url_meta":{"origin":13791,"position":3},"title":"Fix Disqus Problem – Duplicate Comments after Export & Import","author":"Amit Bhawani","date":"September 9, 2010","format":false,"excerpt":"The Disqus commenting system is quite good in terms of offering your Blog visitors with a better and easier way to post comments but there are some drawbacks of the same too. One of the biggest one is lack of support from a company which is growing huge and not\u2026","rel":"","context":"In "Wordpress Guide"","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"DisQus WordPress Duplicate Comments","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/09\/DisQus-WordPress-Duplicate-Comments-243x300.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":767,"url":"https:\/\/www.amitbhawani.com\/blog\/root-name-server\/","url_meta":{"origin":13791,"position":4},"title":"What is Root name server","author":"Amit Bhawani","date":"July 28, 2008","format":false,"excerpt":"A DNS server that answers request for DNS root zone is a root name server. It also redirects request for a specific top level domain (TLD) to that TLD, s name server. A local implementation DNS is allowed to have its own private root name servers. The term root name\u2026","rel":"","context":"In "What is Guide"","block_context":{"text":"What is Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/what-is\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6376,"url":"https:\/\/www.amitbhawani.com\/blog\/wordpress-blog-backup-plugins-tools-tutorials\/","url_meta":{"origin":13791,"position":5},"title":"WordPress Blog Backup Plugins Tools & Tutorials","author":"Amit Bhawani","date":"October 12, 2009","format":false,"excerpt":"You have been blogging from a long period and you have been making thousands of dollars from your blog but what about the security of your this money making machine? Iam not taking about any other security but the important content you have written everyday, the thousands of comments you\u2026","rel":"","context":"In "Wordpress Guide"","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/Wordpress-Backup-Tools-Plugins.jpg?fit=500%2C275&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts\/13791","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/comments?post=13791"}],"version-history":[{"count":0,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts\/13791\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/media\/19798"}],"wp:attachment":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/media?parent=13791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/categories?post=13791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/tags?post=13791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}