MySQL & Load Stats
What type of information is provided in the MySQL & Load Stats section? How do you take advantage of it?
If you have an HTML website, most likely it uses a small amount of resources as it is static, but this is not the case with dynamic database-driven websites that use PHP scripts and provide considerably more features. This type of Internet sites produce load on the web hosting server anytime anyone browses them, due to the fact that the hosting server needs time to execute the script, to access the database and then to provide the content requested by the visitor's web browser. A well-known discussion board, for example, stores all usernames and posts inside a database, so some load is produced each time a thread is opened or a user searches for a certain term. If a lot of people connect to the forum simultaneously, or if each and every search involves checking a large number of database entries, this may produce high load and affect the overall performance of the website. In this regard, CPU and MySQL load stats can provide you with data about the site’s efficiency, as you can compare the numbers with your traffic statistics to decide if the site needs to be optimized or moved to a different type of website hosting platform which will be able to bear the high system load if the site is very popular.
MySQL & Load Stats in Cloud Hosting
Our system keeps comprehensive information about the system resource usage of each cloud hosting
account that's created on our top-notch cloud platform, so in case you decide to host your websites with our company, you will have full access to this info through the Hepsia CP, which you shall get with the account. The CPU load stats feature the CPU time and the actual execution time of your scripts, as well as what amount of system memory they used. You could also see what processes created the load - PHP or Perl scripts, cron jobs, and so forth. The MySQL load statistics section will show you the total amount queries to each specific database that you've created inside your shared hosting account, the total queries for the account overall and the average hourly rate. Comparing these figures to the website visitor data shall tell you if your sites perform the way they need to or if they require some optimization, that'll 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 us, you will be able to access really detailed CPU and MySQL load stats that will give you more info about the overall performance of your Internet sites. Two sections of the Hepsia Control Panel are dedicated to the stats, one for each and every kind. Inside the CPU Load section you are able to see the execution time of your scripts and the amount of time the web server processed them. You may also see the kinds of processes that were executed. Statistics are created every six hours, but if required, you may also check statistics for previous days or months. The MySQL Load section shall show you the total amount of database queries each day and each hour, and also the queries to each individual database you have in your semi-dedicated account. Comparing this info to your traffic stats will give you important data about how your sites perform and you shall see if you have to take some measures to boost them.