MySQL & Load Stats
The MySQL & Load Stats will quietly gather data while your website is functioning. Discover why it's important to check them out regularly.
If you have an HTML site, it likely uses a very small amount of system resources due to the fact that it is static, but this is not so with dynamic database-driven sites that use PHP scripts and provide far more functions. This kind of websites produce load on the hosting server every time someone browses them, as the server needs time to execute the script, to access the database and then to supply the information requested by the visitor's browser. A widely used discussion board, for instance, stores all usernames and posts within a database, so some load is generated every time a thread is opened or a user searches for a given name. If many people connect to the forum concurrently, or if every single search involves checking tens of thousands of database entries, this may create high load and affect the overall performance of the website. In this regard, CPU and MySQL load statistics can provide you with data about the site’s overall performance, as you can compare the numbers with your traffic statistics to make a decision if the site has to be optimized or moved to a new kind of hosting platform that will be able to bear the high system load if the website is really popular.
MySQL & Load Stats in Cloud Web Hosting
Using the Hepsia CP, bundled with all our cloud web hosting
offers, you shall be able to to see really detailed data about the resources which your websites use. One of the sections will give you information about the CPU load, like how much processing time the web server spent, how much time it took for your scripts to be executed and exactly how much memory they used. Stats are routinely created every 6 hours and you could also see the different kinds of processes that produced the most load - PHP, Perl, and so forth. MySQL load statistics are listed in a separate section in which you are able to see all the queries on a per hour, day-to-day, etcetera. basis. You'll be able to go back and compare statistics from different months to see if some update has altered the resource usage if the amount of site visitors hasn't changed much. In this way, you can see if your site needs to be optimized, that'll 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'll be able to access very comprehensive CPU and MySQL load statistics which will give you additional information about the efficiency of your websites. 2 sections of the Hepsia CP are dedicated to the statistics, one for every type. In the CPU Load section you can see the execution time of your scripts and the length of time the server processed them. You can also see the different types of processes that were executed. Statistics are generated every 6 hours, but if needed, you may also check figures for previous days or months. The MySQL Load section will show you the whole amount of database queries per day and per hour, along with the queries to each individual database you have within your semi-dedicated account. Comparing this information to your traffic stats shall give you valuable data about how your Internet sites perform and you shall see if you must take some measures to improve them.