MySQL & Load Stats
Discover which kind of data is gathered in the MySQL & Load Stats section and how you can take advantage of it.
The CPU load is dependent upon the amount of time a web server spends executing a script any time a visitor opens a webpage on a given script-driven Internet site. Static HTML sites use barely any CPU time, but it is not the case with the much more sophisticated and functional scripts, which use a database and display dynamic content. The more people open this kind of a website, the more load will be created on the web server and if the database is large, the MySQL server shall be loaded too. An illustration of what may cause high load is an online store with a huge number of products. If it is popular, lots of people will be browsing it concurrently and if they search for items, the whole database which contains all the products shall also be constantly accessed by the script, resulting in high load. In this light, having CPU and MySQL load statistics can provide an idea of how the Internet site is doing, if it needs to be optimized or if you simply need a more efficient hosting solution - if the website is extremely popular and the current setup cannot deal with the load.
MySQL & Load Stats in Shared Website Hosting
Using the Hepsia Control Panel, which comes with all of our shared website hosting
offers, you shall be able to to see incredibly comprehensive data regarding the resources which your Internet sites use. One of the sections shall give you info on the CPU load, including the amount of processing time the web server spent, the time it took for your scripts to be executed and how much memory they used. Statistics are consistently generated every six hours and you may also see the different types of processes that produced the most load - PHP, Perl, etc. MySQL load statistics are listed in an individual section where you can see all the queries on a per hour, daily, etc. basis. You could go back and compare data from various months to see if some update has transformed the resource usage if the number of visitors has not changed much. In this way, you can determine if your Internet site needs to be optimized, which will result in a better overall performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Hosting
As our system keeps thorough stats for the load that each semi-dedicated server
account produces, you'll be aware of how your sites perform at any time. When you log in to the Hepsia Control Panel, included with each account, you should check out the section dedicated to the system load. There, you will see the processing time our system spent on your scripts, the time it took for the scripts to be actually executed and what types of processes generated the load - cron jobs, PHP pages, Perl scripts, etcetera. You could also see the total number of queries to each database within your semi-dedicated account, the total daily stats for the account altogether, along with the average hourly rate. With both the CPU and the MySQL load statistics, you may always go back to past days or months and evaluate the general performance of your websites after some update or after a substantial boost in the number of your site visitors.