MySQL & Load Stats
What sort of data is provided in the MySQL & Load Stats section? How do you take advantage of it?
If you have an HTML site, it likely uses a small amount of system resources due to the fact that it is static, but this is not the situation with dynamic database-driven Internet sites that use PHP scripts and offer you far more features. This sort of Internet sites produce load on the website hosting server each time anyone browses them, simply because the web server requires time to execute the script, to access the database and then to deliver the information requested by the visitor's web browser. A well known discussion board, for instance, stores all usernames and posts within a database, so some load is created any time a thread is opened or a user looks for a certain term. If lots of people connect to the forum all at once, or if each search involves checking tens of thousands of database entries, this could generate high load and affect the overall performance of the website. In this regard, CPU and MySQL load statistics can present you with information about the site’s performance, as you can compare the numbers with your traffic stats to decide if the site has to be optimized or transferred to another kind of hosting platform that'll be able to bear the high system load in case the site is extremely popular.
MySQL & Load Stats in Shared Hosting
Our system keeps detailed info about the system resource usage of each and every shared hosting
account that is set up on our top-notch cloud platform, so given that you decide to host your Internet sites with us, you will have full access to this info 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, plus the amount of system memory they used. You may also see what processes generated the load - PHP or Perl scripts, cron jobs, etc. The MySQL load statistics section will show you the total amount queries to each specific database that you've created within your shared hosting account, the total queries for the account overall and the standard hourly rate. Comparing these statistics to the visitor data shall tell you if your Internet sites perform the way they have to or if they need some optimization, that'll improve their efficiency and the overall site visitor experience.
MySQL & Load Stats in Semi-dedicated Hosting
If you have a semi-dedicated server
account with us, you'll be able to access really detailed CPU and MySQL load data that'll give you more info about the general performance of your Internet sites. 2 sections of the Hepsia CP are dedicated to the stats, one for every kind. In the CPU Load section you are able to see the execution time of your scripts and the length of time the web server processed them. You can also 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 will show you the entire amount of database queries each day and on an hourly basis, plus the queries to each individual database that you have in your semi-dedicated account. Comparing this info to your traffic statistics will give you useful data about how your websites perform and you will determine if you have to take some measures to improve them.