MySQL & Load Stats
What sort of information is provided in the MySQL & Load Stats section? How can you take advantage of it?
When a visitor opens your Internet site, the web browser sends a request to the server, which in turn executes it and provides the required information as a response. A basic HTML website uses negligible system resources because it's static, but database-driven platforms are more requiring and use more processing time. Each webpage which is served produces 2 types of load - CPU load, which depends on the time the server spends executing a specific script; and MySQL load, which depends on the number of database queries produced by the script while the user browses the Internet site. Greater load shall be produced if a lot of people surf a certain website simultaneously or if a lot of database calls are made all at once. 2 good examples are a discussion board with tens of thousands of users or an online store where a visitor enters a term in a search box and a large number of items are searched. Having in depth stats about the load that your site generates will enable you to optimize the content or see if it's the perfect time to switch to a more powerful kind of website hosting service, if the website is simply getting really popular.
-
MySQL & Load Stats in Shared Website Hosting
Using the Hepsia Control Panel, which comes with all our
shared website hosting packages, you shall be able to to see rather comprehensive stats concerning the system resources which your sites use. One of the sections shall give you information about the CPU load, including the amount of processing time the server spent, how much time it took for your scripts to be executed and exactly how much memory they used. Stats are routinely produced every 6 hours and you may also see the kinds of processes that generated the most load - PHP, Perl, and so on. MySQL load statistics are listed in an individual section where you can see all the queries on an hourly, everyday, and so forth. basis. You'll be able to go back and compare statistics from different months to find out if some update has transformed the resource usage if the total amount of visitors hasn't changed much. This way, you will see if your Internet site needs to be optimized, which will give you a better overall performance and an improved user 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 data that will give you more info about the functionality of your Internet sites. Two sections of the Hepsia Control Panel are committed to the statistics, one for each type. Inside the CPU Load section you are able to see the execution time of your scripts and the amount of time the server processed them. You may also see the types of processes that were executed. Statistics are generated every six hours, but if needed, you may also check stats for previous days or months. The MySQL Load section shall show you the total number of database queries each and every day and per hour, plus the queries to each individual database you have in your semi-dedicated account. Comparing this data to your traffic stats will give you useful info about how your sites perform and you will see if you must take some measures to improve them.