MySQL & Load Stats
What sort of data 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 simply because it's static, but this isn't the situation with dynamic database-driven Internet sites that use PHP scripts and provide you with much more capabilities. Such websites produce load on the website hosting server every time someone browses them, as the web server needs time to execute the script, to access the database and then to deliver the content requested by the visitor's web browser. A famous discussion board, for instance, stores all usernames and posts in a database, so some load is created any time a thread is opened or an end user searches for a specific phrase. If lots of people access the forum at the same time, or if each and every search involves checking a large number of database entries, this can create high load and affect the functionality of the website. In this regard, CPU and MySQL load statistics can provide you with information about the site’s efficiency, as you can compare the numbers with your traffic stats to make a decision if the site needs to be optimized or moved to a new sort of web hosting platform that'll be able to bear the high system load in the event that the site is extremely popular.
MySQL & Load Stats in Cloud Website Hosting
Our system keeps comprehensive information about the system resource usage of every single cloud website hosting
account that's set up on our top-notch cloud platform, so given that you opt to host your Internet sites with us, you will have full access to this data via the Hepsia CP, which you'll get with the account. The CPU load stats feature the CPU time and the actual execution time of your scripts, along with the amount of system memory they used. You can also see what processes produced the load - PHP or Perl scripts, cron jobs, and so forth. The MySQL load data section will show you the amount of queries to each individual database that you have created within your shared hosting account, the total queries for the account in general and the average hourly rate. Comparing these figures to the visitor data shall tell you if your Internet sites perform the way they need to or if they require some optimization, which will improve their overall performance and the overall visitor experience.
MySQL & Load Stats in Semi-dedicated Servers
If you have a semi-dedicated server
account with our company, you will be able to access rather detailed CPU and MySQL load data which will give you additional information about the general performance of your Internet sites. 2 sections of the Hepsia CP are devoted to the statistics, one for every single type. In the CPU Load section you could see the execution time of your scripts and how much time the hosting server processed them. You can also see the types of processes which were executed. Statistics are created every 6 hours, but if necessary, you may also check figures for previous days or months. The MySQL Load section will show you the total amount of database queries per day and per hour, and also the queries to each individual database that you have inside your semi-dedicated account. Comparing this info to your traffic stats shall give you important information about how your websites perform and you shall see if you have to take some measures to optimize them.