MySQL & Load Stats
The MySQL & Load Stats will quietly gather data while your website is working. See why you need to check them out frequently.
If you have an HTML site, in all probability it uses a small amount of system resources as it is static, but that isn't the situation with dynamic database-driven websites that use PHP scripts and provide much more features. This sort of sites create load on the hosting server each time somebody browses them, since the hosting server needs time to execute the script, to access the database and then to deliver the info requested by the visitor's Internet browser. A well known discussion board, as an illustration, stores all usernames and posts in a database, so some load is generated every time a thread is opened or a user looks for a certain phrase. If lots of people connect to the forum concurrently, or if every single search involves checking tens of thousands of database entries, this can generate high load and affect the performance of the Internet site. In this regard, CPU and MySQL load stats can provide you with data about the site’s functionality, as you can compare the numbers with your traffic statistics to determine if the site has to be optimized or moved to a new type of hosting platform that'll be able to bear the high system load in case the Internet site is extremely popular.
-
MySQL & Load Stats in Hosting
Using the Hepsia Control Panel, included with all of our
hosting plans, you'll be able to see very detailed data about the resources your websites use. One of the sections shall give you info on the CPU load, like how much processing time the server spent, the span of time it took for your scripts to be executed and what amount of memory they used. Stats are consistently generated every six hours and you may also see the types of processes that generated the most load - PHP, Perl, and so on. MySQL load data are listed in a separate section where you'll be able to see all the queries on an hourly, daily, and so on. basis. You can go back and compare data from various months to find out whether some update has transformed the resource usage if the amount of site visitors has not changed much. Thus, you will see if your website needs to be optimized, that will give you a better general performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you have a
semi-dedicated server account with us, you'll be able to access quite comprehensive CPU and MySQL load data that'll give you more info about the general performance of your websites. 2 sections of the Hepsia CP are devoted to the statistics, one for every single kind. Inside the CPU Load section you are able to see the execution time of your scripts and the span of time the server processed them. You can even see the different types of processes which were executed. Stats are created every 6 hours, but if needed, you can also check data for previous days or months. The MySQL Load section will show you the entire amount of database queries each and every day and on an hourly basis, along with the queries to each individual database you have within your semi-dedicated account. Comparing this data to your traffic stats will give you useful info about how your websites perform and you will see if you have to take some measures to optimize them.