MySQL & Load Stats
What type of info is available in the MySQL & Load Stats section? How can you take full advantage of it?
Whenever a visitor opens your site, the browser sends a request to the web server, which executes it and provides the necessary information as a response. A basic HTML Internet site uses minimal system resources because it is static, but database-driven platforms are more demanding and use more processing time. Every single page which is served creates two sorts of load - CPU load, which depends on the time the web server spends executing a specific script; and MySQL load, that depends on the amount of database queries produced by the script while the client browses the site. Larger load shall be produced if many people browse a certain website at the same time or if a lot of database calls are made concurrently. 2 illustrations are a discussion board with a large number of users or an online store where a visitor enters a term inside a search box and thousands of items are searched. Having thorough statistics about the load your site generates can help you boost the content or see if it's time for you to switch to a more powerful type of web hosting service, if the site is simply getting extremely popular.
-
MySQL & Load Stats in Web Hosting
Using the Hepsia CP, which comes with all of our
web hosting offers, you'll be able to see very detailed stats concerning the system resources which your sites use. One of the sections will give you info on the CPU load, including how much processing time the web server spent, the span of time it took for your scripts to be executed and what amount of memory they used. Statistics are routinely created every 6 hours and you could also see the types of processes that generated the most load - PHP, Perl, etc. MySQL load data are listed inside a different section in which you are able to see all the queries on a per hour, everyday, etcetera. basis. You can go back and compare statistics from different months to find out whether some update has changed the resource usage if the number of visitors has not changed much. This way, you can determine if your Internet site needs to be optimized, which will give you a better general performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you have a
semi-dedicated server account with us, you shall be able to access very detailed CPU and MySQL load statistics that will give you additional information about the functionality of your Internet sites. 2 sections of the Hepsia Control Panel are committed to the stats, one for each type. Inside the CPU Load section you could see the execution time of your scripts and the amount of time the web server processed them. You can also see the different kinds of processes which were executed. Statistics are generated every 6 hours, but if required, you could 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 data to your traffic stats will give you useful info about how your websites perform and you will determine if you need to take some measures to optimize them.