MySQL & Load Stats
View what type of data is gathered in the MySQL & Load Stats area and how it is possible to reap the benefits of it.
If you have an HTML Internet site, in all probability it uses a really small amount of system resources simply because it's static, but that isn't so with dynamic database-driven Internet sites that use PHP scripts and provide considerably more functions. This sort of websites generate load on the hosting server when somebody browses them, simply because the server needs time to execute the script, to access the database and then to supply the content requested by the visitor's Internet browser. A popular discussion board, for instance, stores all usernames and posts within a database, so some load is generated each time a thread is opened or a user looks for a given phrase. If a lot of people access the forum concurrently, or if each and every search involves checking a large number of database entries, this may create high load and affect the performance of the website. In this regard, CPU and MySQL load statistics can present you with info about the site’s performance, as you can compare the numbers with your traffic data to decide if the site must be optimized or transferred to another sort of website hosting platform that'll be able to bear the high system load if the website is very popular.
-
MySQL & Load Stats in Website Hosting
Using the Hepsia CP, included with all of our
website hosting plans, you will be able to see rather comprehensive statistics concerning the system resources that your Internet sites use. One of the sections will give you information regarding the CPU load, including the amount of processing time the web server spent, the amount of time it took for your scripts to be executed and the 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, etc. MySQL load statistics are listed in an individual section where you can see all the queries on an hourly, everyday, etc. basis. You can go back and compare stats from various months to find out if some update has changed the resource usage if the total amount of visitors hasn't changed much. Thus, you will see if your site needs to be optimized, which will contribute to 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 shall be able to access really comprehensive CPU and MySQL load statistics which will give you addiitional information about the efficiency of your websites. 2 sections of the Hepsia Control Panel are focused on the stats, one for each kind. In the CPU Load section you are able to see the execution time of your scripts and how much time the hosting server processed them. You may also see the different types of processes which were executed. Statistics are generated every six hours, but if required, you may also check figures for previous days or months. The MySQL Load section shall show you the entire number of database queries daily and on an hourly basis, plus the queries to each individual database which you have within your semi-dedicated account. Comparing this data to your traffic stats shall give you valuable info about how your websites perform and you will determine if you have to take some measures to boost them.