MySQL & Load Stats
View the type of information is gathered in the MySQL & Load Stats area and exactly how you are able to make the most of it.
If you have an HTML Internet site, it probably uses a very small amount of resources because it's static, but that isn't so with dynamic database-driven sites that use PHP scripts and provide a lot more capabilities. Such sites produce load on the website hosting server every time anyone browses them, as the hosting server needs time to execute the script, to access the database and then to supply the info requested by the visitor's web browser. A widely used discussion board, for instance, stores all usernames and posts within a database, so some load is produced every time a thread is opened or a user searches for a given word. If lots of people access the forum concurrently, or if every single search involves checking hundreds of thousands of database entries, this could produce high load and affect the functionality of the Internet site. In this regard, CPU and MySQL load statistics can provide info about the site’s functionality, as you can compare the numbers with your traffic statistics and see if the site needs to be optimized or moved to a new sort of hosting platform that'll be able to bear the high system load if the website is very popular.
-
MySQL & Load Stats in Shared Hosting
Our system keeps comprehensive information about the system resource usage of every
shared hosting account which is set up on our top-notch cloud platform, so if you decide to host your Internet sites with us, you shall have full access to this info through the Hepsia Control Panel, which you will 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 may see what processes created the load - PHP or Perl scripts, cron jobs, and so forth. The MySQL load data section will show you the number of queries to each individual database that you've created within your shared hosting account, the total queries for the account altogether and the average hourly rate. Comparing these statistics to the visitor data shall tell you if your websites perform the way they have to or if they require some optimization, which will improve their efficiency and the overall website visitor experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you have a
semi-dedicated server account with our company, you shall be able to access rather comprehensive CPU and MySQL load stats which will give you more info about the performance of your websites. 2 sections of the Hepsia CP are devoted to the statistics, one for each type. In the CPU Load section you are able to see the execution time of your scripts and how much time the web server processed them. You can even see the kinds of processes which were executed. Stats are created every 6 hours, but if necessary, you can also check statistics for previous days or months. The MySQL Load section will show you the whole number of database queries each day and each hour, along with the queries to each individual database you have inside your semi-dedicated account. Comparing this data to your traffic statistics will give you valuable data about how your Internet sites perform and you will see if you need to take some measures to improve them.