MySQL & Load Stats
What sort of data is available in the MySQL & Load Stats section? How can you take full advantage of it?
The CPU load is dependent upon the length of time a server spends executing a script whenever a visitor opens a page on a specific script-driven website. Static HTML sites use barely any CPU time, but this is not the case with the considerably more advanced and functional scripts, that use a database and display dynamic content. The more people open such an Internet site, the more load shall be produced on the web server and if the database is big, the MySQL server will be loaded too. An illustration of what can cause high load is a web-based store with a huge number of products. If it's popular, a lot of people shall be browsing it concurrently and if they look for items, the entire database containing all of the products will also be frequently accessed by the script, which will result in high load. In this light, having CPU and MySQL load data can provide an idea of how the site is doing, if it has to be optimized or if you just need a more powerful web hosting solution - if the website is really popular and the current setup cannot handle the load.
-
MySQL & Load Stats in Hosting
Our system keeps comprehensive info about the system resource usage of each
hosting account that is set up on our top-notch cloud platform, so given that you opt to host your websites with our company, you'll have full access to this information via the Hepsia Control Panel, which you will get with the account. The CPU load stats include the CPU time and the actual execution time of your scripts, and how much system memory they used. You may 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 specific database you have created inside your shared hosting account, the total queries for the account altogether and the standard hourly rate. Comparing these figures to the website visitor data shall tell you if your websites perform the way they need to or if they require some optimization, that will improve their functionality and the overall site visitor experience.
-
MySQL & Load Stats in Semi-dedicated Servers
If you would like to see in depth stats for the load generated by your Internet sites, it will not take more than just a few mouse clicks to do this. The Hepsia hosting Control Panel, supplied with all
semi-dedicated servers we offer, features a section dedicated to the system resource usage and the data there shall tell you if your sites function properly and if the load they create corresponds to the total amount of received site visitors. The CPU load data include the script execution time and how much time it took for the hosting server to process the requests, plus what sorts of processes produced the load. The MySQL data shall show you how frequently each individual database was accessed, plus day-to-day and hourly data for the entire account. With both sorts of stats, you'll be able to check the numbers for every one of the past days and months, so you could see how sites perform as the traffic to them increases or after you have applied some update.