MySQL & Load Stats
What sort of info is available in the MySQL & Load Stats section? How do you take advantage of it?
If you have an HTML website, in all probability it uses a really small amount of resources as it is static, but this isn't the situation with dynamic database-driven sites that use PHP scripts and provide you with much more functions. This kind of Internet sites produce load on the website hosting server anytime somebody browses them, as the hosting server requires time to execute the script, to access the database and then to supply the content requested by the visitor's browser. A well known discussion board, for example, stores all usernames and posts within a database, so some load is generated every time a thread is opened or a user searches for a specific word. If a lot of people access the forum all at once, or if each search involves checking tens of thousands of database entries, this could create high load and affect the performance of the site. In this regard, CPU and MySQL load stats can give you information about the site’s overall performance, as you can compare the numbers with your traffic data to determine if the website should be optimized or moved to a different type of web hosting platform that'll be able to bear the high system load in case the Internet site is very popular.
MySQL & Load Stats in Web Hosting
Our system keeps comprehensive info about the system resource usage of every single web hosting
account that is set up on our top-notch cloud platform, so in case you choose to host your websites with our company, you will have full access to this data via 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, and how much system memory they used. You could also see what processes generated the load - PHP or Perl scripts, cron jobs, etc. The MySQL load stats section will show you the number of queries to each particular database that you have created in your shared hosting account, the total queries for the account in general and the normal hourly rate. Comparing these statistics to the website visitor statistics shall tell you if your websites perform the way they should or if they need some optimization, which will improve their efficiency and the overall website visitor experience.
MySQL & Load Stats in Semi-dedicated Servers
If you have a semi-dedicated server
account with us, you will be able to access very comprehensive CPU and MySQL load data which will give you more information about the functionality of your sites. Two sections of the Hepsia Control Panel are dedicated to the stats, one for every single kind. Within the CPU Load section you can see the execution time of your scripts and the length of time the hosting server processed them. You can also see the different types of processes that were executed. Stats are produced every six hours, but if required, you could also check stats for previous days or months. The MySQL Load section shall show you the total amount of database queries per day and per hour, and also the queries to each individual database you have in your semi-dedicated account. Comparing this information to your traffic stats shall give you useful data about how your Internet sites perform and you will see if you have to take some measures to improve them.