MySQL & Load Stats
What kind of info is provided in the MySQL & Load Stats section? How could you benefit from it?
If you have an HTML Internet site, most likely it uses a small amount of system resources as it is static, but this is not the case with dynamic database-driven sites that use PHP scripts and provide considerably more capabilities. Such sites generate load on the website hosting server when anyone browses them, since the server requires time to execute the script, to access the database and then to provide the information requested by the visitor's browser. A widely used discussion board, for instance, stores all usernames and posts in a database, so some load is created any time a thread is opened or a user searches for a specific term. If a lot of people connect to the forum at the same time, or if each and every search involves checking thousands of database entries, this may generate high load and affect the functionality of the Internet site. In this regard, CPU and MySQL load statistics can provide data about the site’s functionality, as you can compare the numbers with your traffic statistics to decide if the website has to be optimized or transferred to a new kind of web hosting platform which will be able to bear the high system load in case the website is really popular.
-
MySQL & Load Stats in Website Hosting
Our system keeps detailed info about the system resource usage of each and every
website hosting account that's set up on our top-notch cloud platform, so given that you opt to host your sites with us, you shall have full access to this info through the Hepsia Control Panel, which you'll get with the account. The CPU load statistics include the CPU time and the actual execution time of your scripts, and what amount of system memory they used. You may also see what processes generated the load - PHP or Perl scripts, cron jobs, etc. The MySQL load data section will show you the amount of queries to each individual database which you have created within your shared hosting account, the total queries for the account as a whole and the normal hourly rate. Comparing these numbers to the visitor data will tell you if your websites perform the way they ought to or if they require some optimization, which will improve their performance and the overall website visitor experience.
-
MySQL & Load Stats in Semi-dedicated Servers
Our system creates detailed statistics about the two different kinds of load, so if you acquire a
semi-dedicated server for your sites, you can access the info with a few clicks inside your Hepsia hosting Control Panel. Every type of info is listed in its own section. The CPU Load section can tell you exactly what processes produced the load and how much time it took for the web server to execute each of the requests. Although statistics are generated every six hours, you can see daily and per month stats as well. In the MySQL Load section you shall find a list of all the databases produced inside your semi-dedicated account manually and automatically, what number of queries were sent to each one of them, the total everyday queries for the account in general, as well as the average per hour rate. This information will help you see how well your websites perform and if any of them needs optimization of some type.