MySQL & Load Stats
What type of information is available in the MySQL & Load Stats section? How can you take full advantage of it?
Every time a visitor opens your website, the Internet browser sends a request to the web server, which executes it and provides the required data as a response. A simple HTML Internet site uses minimum system resources because it is static, but database-driven platforms are more demanding and use a lot more processing time. Each and every webpage that is served generates 2 forms of load - CPU load, which depends on the time period the web server spends executing a particular script; and MySQL load, that depends on the amount of database queries generated by the script while the customer browses the site. Bigger load shall be created if a considerable amount of people browse a particular Internet site at the same time or if loads of database calls are made at the same time. Two examples are a discussion board with thousands of users or an online store where a client enters a term inside a search box and thousands of items are searched. Having thorough stats about the load which your website generates will help you optimize the content or see if it is time for you to switch to a more powerful type of hosting service, if the website is simply getting extremely popular.
MySQL & Load Stats in Cloud Hosting
Using the Hepsia CP, included with all our cloud hosting
packages, you'll be able to see incredibly comprehensive data regarding the system resources that your Internet sites use. One of the sections will give you information regarding the CPU load, like the amount of processing time the server spent, the length of time it took for your scripts to be executed and how much memory they used. Stats are automatically created every 6 hours and you may also see the different types of processes that produced the most load - PHP, Perl, and so forth. MySQL load stats are listed within a separate section where you could 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 determine if some update has changed the resource usage if the amount of site visitors has not changed much. That way, you will see if your site needs to be optimized, which will result in a better performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Hosting
Due to the fact that our system keeps comprehensive stats for the load which every semi-dedicated server
account generates, you shall be aware of how your websites perform at any time. When you log in to the Hepsia CP, supplied with every account, you should check out the section committed to the system load. There, you are able to see the processing time our system spent on your scripts, how much time it took for the scripts to be actually executed and what types of processes generated the load - cron jobs, PHP pages, Perl scripts, etcetera. You can also see the number of queries to every database in your semi-dedicated account, the total day-to-day statistics for the account overall, and also the average hourly rate. With both the CPU and the MySQL load stats, you may always go back to past days or months and evaluate the functionality of your Internet sites after some update or after a significant increase in the number of your visitors.