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 website has some plugins or scripts installed which uses multiple queries then its better to disable those.
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, and unzip the zip file contents.
Once you have extracted the files you will have to -
- Configure the servers parameters: edit the file config/servers.xml adding the data related to the servers you want to monitor.
- Configure the charts: edit the file config/charts.xml to set the charts you want the program to plot.
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.
<id>1</id> <!– A server id. Must be unique –>
<name>Instance1</name> <!– The server name. It is used to identify the instance in the program. –>
<host>localhost</host> <!– The host to connect to the server. –>
<port>3306</port> <!– The port the server is listening. –>
<username>user</username> <!– The username to connect. –>
<password>password</password> <!– The password to connect. –>
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.