MySQL & Load Stats
What kind of info is accessible in the MySQL & Load Stats section? How do you take full advantage of it?
If you have an HTML Internet site, most likely it uses a really small amount of resources simply because it's static, but this is not so with dynamic database-driven Internet sites that use PHP scripts and provide considerably more capabilities. This kind of websites produce load on the hosting server every time someone browses them, as the web server requires time to execute the script, to access the database and then to provide the data requested by the visitor's Internet browser. A well-known discussion board, as an illustration, stores all usernames and posts in a database, so some load is produced every single time a thread is opened or a user searches for a given phrase. If lots of people access the forum simultaneously, or if every search involves checking tens of thousands of database entries, this can produce high load and affect the functionality of the Internet site. In this regard, CPU and MySQL load data can provide you with info about the site’s efficiency, as you can compare the numbers with your traffic stats to determine if the site has to be optimized or transferred to a different sort of web hosting platform that will be able to bear the high system load in case the site is very popular.
MySQL & Load Stats in Hosting
If you host your Internet sites inside a hosting account with us, you will have access to comprehensive CPU and MySQL data that will allow you to monitor their performance. You can see the statistics with a couple of clicks in your Hepsia Control Panel. The CPU Load section can tell you the total time the web server spent on your scripts and how much memory was needed, plus the time it took for the scripts to be executed. The everyday view is the standard one, but you may also see the data from the past months. The MySQL Load section offer you more info about the total amount of queries to every database that you have set up in the account. Once again, you are able to see monthly, daily and per hour stats, which will give you info that's different from the traffic or the number of visitors that you get. In this way, you can determine if the websites require some optimization.