MySQL & Load Stats
What sort of information is accessible in the MySQL & Load Stats section? How could you take advantage of it?
If you have an HTML site, most likely it uses a small amount of resources because it's static, but this is not the situation with dynamic database-driven websites that use PHP scripts and provide you with far more features. This type of sites create load on the hosting server anytime someone browses them, simply because the web server needs time to execute the script, to access the database and then to provide the info requested by the visitor's browser. A popular discussion board, for instance, stores all usernames and posts inside a database, so some load is produced every time a thread is opened or a user searches for a certain name. If many people access the forum at the same time, or if each and every search involves checking thousands of database entries, this may create high load and affect the efficiency of the site. In this regard, CPU and MySQL load data can present you with info about the site’s functionality, as you can compare the numbers with your traffic statistics to determine if the website needs to be optimized or moved to a new kind of website hosting platform which will be able to bear the high system load in case the Internet site is really popular.
-
MySQL & Load Stats in Shared Web Hosting
Our system keeps detailed info about the system resource usage of each and every
shared web hosting account that's set up on our top-notch cloud platform, so given that you decide to host your sites with us, you shall have full access to this information through the Hepsia Control Panel, which you shall get with the account. The CPU load stats feature the CPU time and the actual execution time of your scripts, plus what amount of system memory they used. You may see what processes produced the load - PHP or Perl scripts, cron jobs, etcetera. The MySQL load stats section will show you the total amount queries to each individual database you have created in your shared hosting account, the total queries for the account overall and the normal hourly rate. Comparing these figures to the visitor data shall tell you if your sites perform the way they ought to or if they require some optimization, that will improve their overall performance and the overall website visitor experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
As our system keeps detailed stats for the load which every
semi-dedicated server account produces, you'll be aware of how your Internet sites perform at any time. After you log in to the Hepsia Control Panel, supplied with each account, you can check out the section committed to the system load. In it, you can easily see the processing time our system spent on your scripts, the time it took for the scripts to be actually executed and what sorts of processes produced the load - cron jobs, PHP pages, Perl scripts, and so on. Also you can see the number of queries to each database in your semi-dedicated account, the total everyday statistics for the account altogether, plus the average hourly rate. With both the CPU and the MySQL load data, you can always go back to past days or months and compare the performance of your sites after some update or after a sizeable boost in the number of your site visitors.