MySQL & Load Stats
What kind of info is accessible in the MySQL & Load Stats section? How could you take full advantage of it?
Whenever a visitor opens your Internet site, the Internet browser sends a request to the hosting server, which executes it and gives the desired data as a response. A simple HTML Internet site uses minimal resources due to the fact that it is static, but database-driven platforms are more demanding and use more processing time. Every webpage which is served produces 2 forms of load - CPU load, that depends on the time period the web server spends executing a particular script; and MySQL load, which depends on the amount of database queries generated by the script while the customer browses the website. Bigger load shall be produced if a whole lot of people look through a particular website all at once or if many database calls are made concurrently. Two good examples are a discussion board with thousands of users or an online store where a client enters a term within a search box and thousands of items are searched. Having in depth statistics about the load that your website generates will allow you to boost the content or see if it's the perfect time to switch to a more powerful type of hosting service, if the Internet site is simply getting very popular.
MySQL & Load Stats in Shared Hosting
Using the Hepsia CP, which comes with all of our shared hosting packages, you will be able to see really detailed statistics about the system resources which your websites use. One of the sections will give you information regarding the CPU load, including how much processing time the server spent, the length of time it took for your scripts to be executed and exactly how much memory they used. Stats are routinely generated every 6 hours and you can also see the kinds of processes that generated the most load - PHP, Perl, etc. MySQL load statistics are listed in a separate section in which you can see all the queries on a per hour, daily, etc. basis. You'll be able to go back and compare stats from different months to find out whether some update has transformed the resource usage if the amount of visitors has not changed much. That way, you will see if your site needs to be optimized, that'll lead to a better functionality and an improved user experience.