MySQL & Load Stats
See which kind of data is gathered in the MySQL & Load Stats section and how it is possible to take full advantage of it.
The CPU load depends upon the amount of time a server spends executing a script each time a visitor opens a page on a certain script-driven Internet site. Static HTML sites use barely any CPU time, but this is not the case with the considerably more complex and functional scripts, that use a database and display dynamic content. The more customers open this kind of an Internet site, the more load will be generated on the server and if the database is large, the MySQL server will be loaded also. A good example of what may cause high load is an online store with tens of thousands of products. If it's popular, plenty of people will be visiting it concurrently and if they seek out items, the entire database which contains all of the products shall also be frequently accessed by the script, resulting in high load. In this light, having CPU and MySQL load statistics will give you an idea of how the Internet site is doing, if it has to be optimized or if you simply just need a more effective web hosting solution - if the website is popular and the established setup cannot handle the load.
MySQL & Load Stats in Shared Website Hosting
If you host your Internet sites inside a shared website hosting
account with us, you will have access to thorough CPU and MySQL stats which will allow you to keep tabs on their overall performance. You could see the statistics with a few clicks in your Hepsia Control Panel. The CPU Load section will show you the total time the hosting server spent on your scripts and how much memory was required, and the time it took for the scripts to be executed. The daily view is the default one, but you'll be able to also see the statistics from the past months. The MySQL Load section will provide you with more info about the amount of queries to each database that you have created in the account. Once again, you can easily see month-to-month, everyday and hourly statistics, that shall give you info 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 will be able to access rather detailed CPU and MySQL load stats which will give you addiitional information about the performance of your sites. 2 sections of the Hepsia Control Panel are dedicated to the stats, one for every type. Within the CPU Load section you are able to see the execution time of your scripts and how much time the server processed them. You may also see the different kinds of processes which were executed. Stats are created every six hours, but if required, you may also check data for previous days or months. The MySQL Load section shall show you the total amount of database queries daily and on an hourly basis, as well as the queries to each individual database that you have in your semi-dedicated account. Comparing this info to your traffic statistics shall give you useful data about how your Internet sites perform and you shall see if you have to take some measures to improve them.