MySQL & Load Stats
What sort of data is provided in the MySQL & Load Stats section? How could you take advantage of it?
Whenever a visitor opens your site, the browser sends a request to the hosting server, which in turn executes it and provides the required content as a response. A standard HTML website uses minimal resources due to the fact that it is static, but database-driven platforms are more requiring and use a lot more processing time. Every webpage that's served creates two forms of load - CPU load, that depends on the length of time the hosting server spends executing a specific script; and MySQL load, that depends on the number of database queries generated by the script while the end user browses the site. Greater load shall be produced if many people look through a particular website at the same time or if loads of database calls are made concurrently. Two good examples are a discussion board with a large number of users or an online store in which a visitor enters a term within a search box and a large number of items are searched. Having detailed stats about the load that your site generates can help you boost the content or see if it is time to switch to a more powerful kind of website hosting service, if the site is simply getting extremely popular.
MySQL & Load Stats in Shared Website Hosting
If you host your sites within a shared website hosting
account with our company, you shall have access to comprehensive CPU and MySQL statistics that will allow you to keep track of their operation. You can easily see the statistics with a number of mouse clicks inside your Hepsia Control Panel. The CPU Load section will reveal to you the total time period the server spent on your scripts and the amount of memory was needed, and the time it took for the scripts to be executed. The daily view is the standard one, but you'll be able to also see the data from the past months. The MySQL Load section give you additional information about the number of queries to every database that you have created in the account. Once again, you are able to see monthly, everyday and hourly data, that will give you information that's different from the traffic or the number of visitors which you get. Thus, you can identify if the sites require some optimization.
MySQL & Load Stats in Semi-dedicated Hosting
If you have a semi-dedicated server
account with our company, you'll be able to access very comprehensive CPU and MySQL load stats which will give you more info about the functionality of your Internet sites. Two sections of the Hepsia Control Panel are focused on the statistics, one for every single kind. In the CPU Load section you could see the execution time of your scripts and how much time the hosting server processed them. You can also see the types of processes that were executed. Stats are produced every six hours, but if necessary, you could also check figures for previous days or months. The MySQL Load section will show you the entire amount of database queries each day and per hour, along with the queries to each individual database you have in your semi-dedicated account. Comparing this info to your traffic statistics will give you valuable data about how your websites perform and you shall see if you have to take some measures to boost them.