MySQL & Load Stats
What kind of information is provided in the MySQL & Load Stats section? How can you take advantage of it?
If you have an HTML site, most likely it uses a really small amount of resources because it's static, but this isn't so with dynamic database-driven Internet sites that use PHP scripts and provide you with considerably more functions. This sort of sites produce load on the web hosting server every time somebody browses them, because the hosting server requires time to execute the script, to access the database and then to supply the info requested by the visitor's browser. A popular discussion board, as an illustration, stores all usernames and posts inside a database, so some load is created every time a thread is opened or an end user searches for a given name. If lots of people connect to the forum at the same time, or if every single search involves checking thousands of database entries, this may generate high load and affect the overall performance of the website. In this regard, CPU and MySQL load data can present you with information about the site’s overall performance, as you can compare the numbers with your traffic stats to make a decision if the site has to be optimized or moved to another kind of hosting platform which will be able to bear the high system load if the site is very popular.
MySQL & Load Stats in Web Hosting
If you host your sites inside a web hosting
account with our company, you shall have access to in depth CPU and MySQL statistics that will allow you to keep an eye on their overall performance. You are able to see the stats with a number of mouse clicks in your Hepsia CP. The CPU Load section can tell you the total time the server spent on your scripts and just how much memory was needed, along with the time it took for the scripts to be executed. The daily view is the default one, but you can also see the statistics from the previous months. The MySQL Load section offer additional information about the amount of queries to every database that you have created in the account. Once again, you can easily see monthly, daily and hourly data, that'll give you data that is different from the traffic or the number of visitors you get. In this way, you can see if the websites require some optimization.
MySQL & Load Stats in Semi-dedicated Hosting
If you have a semi-dedicated server
account with our company, you shall be able to access quite comprehensive CPU and MySQL load data that will give you additional information about the functionality of your sites. Two sections of the Hepsia CP are devoted to the stats, one for every type. In the CPU Load section you could see the execution time of your scripts and the length of time the web server processed them. You may also see the types of processes which were executed. Stats are produced every six hours, but if necessary, you may also check stats for previous days or months. The MySQL Load section will show you the total number of database queries each and every day and on an hourly basis, plus the queries to each individual database that you have in your semi-dedicated account. Comparing this data to your traffic statistics will give you valuable data about how your sites perform and you will determine if you must take some measures to optimize them.