MySQL & Load Stats
What kind of data is accessible in the MySQL & Load Stats section? How do you take full advantage of it?
If you have an HTML site, it likely uses a very small amount of system resources due to the fact that it is static, but this isn't the situation with dynamic database-driven Internet sites that use PHP scripts and provide considerably more features. This sort of sites create load on the hosting server when someone browses them, simply because the web server requires time to execute the script, to access the database and then to provide the info requested by the visitor's Internet browser. A well-known discussion board, for instance, stores all usernames and posts within a database, so some load is generated every single time a thread is opened or a user looks for a given name. If many people connect to the forum all at once, or if every search involves checking tens of thousands of database entries, this may produce high load and affect the performance of the Internet site. In this regard, CPU and MySQL load data can provide you with info about the site’s overall performance, as you can compare the numbers with your traffic stats to decide if the website needs to be optimized or transferred to a new sort of web hosting platform that will be able to bear the high system load if the Internet site is really popular.
-
MySQL & Load Stats in Cloud Web Hosting
Our system keeps comprehensive information about the system resource usage of each and every
cloud web hosting account which is created on our top-notch cloud platform, so if you choose to host your Internet sites with our company, you'll have full access to this info through the Hepsia Control Panel, which you'll get with the account. The CPU load data include the CPU time and the actual execution time of your scripts, plus what amount of system memory they used. You may also see what processes generated the load - PHP or Perl scripts, cron jobs, etcetera. The MySQL load statistics section will show you the number of queries to each individual database you have created in your shared hosting account, the total queries for the account altogether and the normal hourly rate. Comparing these statistics to the website visitor data shall tell you if your Internet sites perform the way they need to or if they need some optimization, that'll improve their performance and the overall site visitor experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
As our system keeps thorough statistics for the load that each
semi-dedicated server account generates, you shall be aware of how your websites perform at any time. After you log in to the Hepsia Control Panel, supplied with each account, you can check out the section dedicated to the system load. In it, you can easily see the processing time our system spent on your scripts, the length of time it took for the scripts to be actually executed and what types of processes generated the load - cron jobs, PHP pages, Perl scripts, etc. Additionally you can see the total number of queries to every single database inside your semi-dedicated account, the total everyday figures for the account altogether, and also the average hourly rate. With both the CPU and the MySQL load statistics, you could always go back to past days or months and assess the performance of your sites after some update or after a considerable rise in the number of your visitors.