MySQL & Load Stats
What kind of data is provided in the MySQL & Load Stats section? How could you make use of it?
If you have an HTML Internet site, it likely uses a very small amount of resources because it's static, but this isn't so with dynamic database-driven Internet sites that use PHP scripts and provide far more functions. This kind of websites create load on the website hosting server each and every time somebody browses them, because the hosting server needs time to execute the script, to access the database and then to deliver the information requested by the visitor's browser. A popular discussion board, for example, stores all usernames and posts within a database, so some load is created every time a thread is opened or a user looks for a particular phrase. If many people connect to the forum all at once, or if every single search involves checking hundreds of thousands of database entries, this can produce high load and affect the performance of the site. In this regard, CPU and MySQL load stats can provide data about the site’s overall performance, as you can compare the numbers with your traffic data and see if the Internet site has to be optimized or moved to a new type of website hosting platform that will be able to bear the high system load in case the Internet site is extremely popular.
MySQL & Load Stats in Website Hosting
Our system keeps comprehensive info about the system resource usage of each website hosting account which is set up on our top-notch cloud platform, so in case you opt to host your sites with us, you'll have full access to this information from the Hepsia Control Panel, which you will get with the account. The CPU load stats feature the CPU time and the actual execution time of your scripts, as well as how much system memory they used. You could also see what processes produced the load - PHP or Perl scripts, cron jobs, and so on. The MySQL load stats section will show you the amount of queries to each particular database which you have created within your shared hosting account, the total queries for the account as a whole and the typical hourly rate. Comparing these numbers to the site visitor data will tell you if your Internet sites perform the way they need to or if they need some optimization, that will improve their efficiency and the overall website visitor experience.