MySQL & Load Stats
What type of info is available in the MySQL & Load Stats section? How do you make use of it?
If you have an HTML site, it likely uses a really small amount of resources simply because it is static, but that isn't so with dynamic database-driven websites that use PHP scripts and provide you with a lot more functions. This kind of websites create load on the website hosting server every time somebody browses them, as the hosting server needs time to execute the script, to access the database and then to provide the info requested by the visitor's Internet browser. A well-known discussion board, as an illustration, stores all usernames and posts within a database, so some load is generated each time a thread is opened or a user searches for a particular term. If many people connect to the forum simultaneously, or if every single search involves checking thousands of database entries, this can produce high load and affect the performance of the Internet site. In this regard, CPU and MySQL load stats can provide you with info about the site’s overall performance, as you can compare the numbers with your traffic statistics to decide if the site should be optimized or transferred to another type of web hosting platform that will be able to bear the high system load in the event that the Internet site is really popular.
-
MySQL & Load Stats in Web Hosting
If you host your websites within a
web hosting account with our company, you shall have access to comprehensive CPU and MySQL data that will enable you to monitor their functionality. You are able to see the data with a couple of mouse clicks in your Hepsia Control Panel. The CPU Load section will reveal to you the total time the web server spent on your scripts and the amount of memory was required, as well as the time it took for the scripts to be executed. The daily view is the standard one, but you are able to also see the stats from the preceding months. The MySQL Load section give you more info about the total amount of queries to each and every database that you have created inside the account. Once again, you can see per month, day-to-day and per hour data, which will give you info that's different from the traffic or the number of visitors that you get. This way, you can see if the Internet sites require some optimization.
-
MySQL & Load Stats in Semi-dedicated Servers
Our system produces detailed statistics about both different kinds of load, so if you acquire a
semi-dedicated server for your Internet sites, you can access the information with just a few clicks inside your Hepsia hosting CP. Every type of data is listed within its own section. The CPU Load section will tell you exactly what processes generated the load and the length of time it took for the web server to execute all the requests. Though statistics are generated every six hours, you can see daily and monthly statistics as well. In the MySQL Load section you'll find a list of all the databases produced inside your semi-dedicated account manually and automatically, how many queries were sent to every one of them, the total everyday queries for the account overall, along with the average per hour rate. This info shall help you see how well your websites perform and if any of them needs optimization of some sort.