MySQL & Load Stats
What sort of info is available in the MySQL & Load Stats section? How can you take advantage of it?
The CPU load depends upon the time a server spends executing a script each time a visitor opens a page on a given script-driven website. Static HTML websites use hardly any CPU time, but this isn't the situation with the far more advanced and functional scripts, which use a database and display dynamic content. The more customers open this type of a website, the more load will be produced on the hosting server and if the database is big, the MySQL server will be loaded as well. A good example of what could cause high load is an Internet store with tens of thousands of products. If it's popular, lots of people shall be visiting it simultaneously and if they seek out items, the entire database containing all of the products will also be constantly accessed by the script, which will result in high load. In this light, having CPU and MySQL load statistics will provide you with an idea of how the website is doing, if it has to be optimized or if you just need a more potent web hosting solution - if the site is very popular and the current setup can't handle the load.
-
MySQL & Load Stats in Shared Website Hosting
Our system keeps detailed info about the system resource usage of each and every
shared website hosting account that's created on our top-notch cloud platform, so given that you decide to host your websites with us, you'll have full access to this data through the Hepsia Control Panel, which you'll get with the account. The CPU load statistics include the CPU time and the actual execution time of your scripts, plus the amount of system memory they used. You can also see what processes generated the load - PHP or Perl scripts, cron jobs, etc. The MySQL load statistics section will show you the amount of queries to each particular database that you have created inside your shared hosting account, the total queries for the account as a whole and the average hourly rate. Comparing these statistics to the visitor statistics shall tell you if your websites perform the way they ought to or if they require some optimization, which will improve their functionality and the overall site visitor experience.
-
MySQL & Load Stats in Semi-dedicated Servers
If you have a
semi-dedicated server account with our company, you'll be able to access really comprehensive CPU and MySQL load data that'll give you addiitional information about the general performance of your websites. 2 sections of the Hepsia Control Panel are dedicated to the stats, one for each and every type. Inside the CPU Load section you are able to see the execution time of your scripts and the amount of time the hosting server processed them. Additionally you can see the different types of processes which were executed. Stats are generated every six hours, but if needed, you can also check stats for previous days or months. The MySQL Load section shall show you the whole amount of database queries each day and per hour, plus the queries to each individual database which you have inside your semi-dedicated account. Comparing this info to your traffic stats shall give you useful info about how your websites perform and you shall see if you have to take some measures to optimize them.