MySQL & Load Stats
Discover the kind of data is gathered in the MySQL & Load Stats area and how you can benefit from it.
If you have an HTML website, it likely uses a really small amount of resources due to the fact that it is static, but this isn't so with dynamic database-driven websites that use PHP scripts and offer you way more functions. Such websites generate load on the website hosting server each time somebody browses them, due to the fact that the server needs time to execute the script, to access the database and then to deliver the info requested by the visitor's browser. A widely used discussion board, for instance, stores all usernames and posts inside a database, so some load is produced every time a thread is opened or an end user looks for a given name. If many people access the forum concurrently, or if every search involves checking hundreds of thousands of database entries, this could produce high load and affect the functionality of the website. In this regard, CPU and MySQL load stats can give you data about the site’s efficiency, as you can compare the numbers with your traffic statistics and see if the Internet site has to be optimized or transferred to a different sort of hosting platform which will be able to bear the high system load in the event that the Internet site is extremely popular.
MySQL & Load Stats in Website Hosting
Using the Hepsia Control Panel, included with all our website hosting
offers, you shall be able to to see rather detailed statistics concerning the resources which your sites use. One of the sections shall give you details about the CPU load, including the amount of processing time the hosting server spent, the time it took for your scripts to be executed and the amount of memory they used. Stats are automatically generated every 6 hours and you may also see the kinds of processes that generated the most load - PHP, Perl, and so forth. MySQL load stats are listed inside a separate section in which you'll be able to see all the queries on an hourly, day-to-day, and so on. basis. You can go back and compare statistics from different months to find out if some update has transformed the resource usage if the total amount of visitors has not changed much. In this way, you will see if your website needs to be optimized, which will result in a better performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
Our system produces detailed stats about both kinds of load, so if you purchase a semi-dedicated server
for your websites, you can access the data with a few mouse clicks in your Hepsia hosting Control Panel. Every type of info is listed inside its own section. The CPU Load section can tell you exactly what processes generated the load and how much time it took for the web server to execute all the requests. Although statistics are produced every 6 hours, you can see day by day and month-to-month statistics as well. In the MySQL Load section you'll find a list of all the databases generated within your semi-dedicated account manually and automatically, the amount of queries were sent to each one of them, the total day-to-day queries for the account overall, as well as the average per hour rate. This data will help you determine how well your sites perform and if any of them needs optimization of some kind.