MySQL & Load Stats
See which kind of info is gathered in the MySQL & Load Stats section and exactly how you'll be able to reap the benefits of it.
Whenever a visitor opens your Internet site, the web browser sends a request to the server, which in turn executes it and gives the required content as a response. A standard HTML website uses minimum system resources because it is static, but database-driven platforms are more demanding and use far more processing time. Every page which is served creates 2 sorts of load - CPU load, which depends on the time the server spends executing a certain script; and MySQL load, that depends on the total number of database queries produced by the script while the end user browses the Internet site. Greater load shall be produced if many people browse a certain site concurrently or if a considerable amount of database calls are made at the same time. Two good examples are a discussion board with a huge number of users or an online store where a customer enters a term in a search box and tens of thousands of items are searched. Having thorough stats about the load your Internet site generates can help you optimize the content or see if it's the perfect time to switch to a more powerful type of web hosting service, if the Internet site is simply getting really popular.
-
MySQL & Load Stats in Shared Hosting
Using the Hepsia CP, included with all our
shared hosting offers, you'll be able to see very detailed data concerning 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 the amount of memory they used. Statistics are routinely provided every 6 hours and you could also see the different kinds of processes that produced the most load - PHP, Perl, etc. MySQL load stats are listed in an individual section where you could see all the queries on a per hour, day-to-day, and so on. basis. You could go back and compare statistics from various months to see if some update has changed the resource usage if the amount of visitors hasn't changed much. In this way, you will see if your site needs to be optimized, which will give you a better 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 detailed CPU and MySQL load statistics that'll give you additional information about the overall performance of your websites. 2 sections of the Hepsia CP are focused on the stats, one for every type. Within the CPU Load section you could see the execution time of your scripts and the amount of time the web server processed them. You can even see the types of processes which were executed. Statistics are generated every 6 hours, but if required, you may also check statistics for previous days or months. The MySQL Load section shall show you the total number of database queries daily and on an hourly basis, and also the queries to each individual database which you have within your semi-dedicated account. Comparing this info to your traffic statistics shall give you useful information about how your Internet sites perform and you shall see if you need to take some measures to boost them.