MySQL & Load Stats
What type of data is available in the MySQL & Load Stats section? How can you make use of it?
If you have an HTML site, in all probability it uses a very small amount of resources as it's static, but this isn't so with dynamic database-driven Internet sites that use PHP scripts and provide much more capabilities. This sort of Internet sites create load on the web hosting server anytime somebody browses them, since the hosting server needs time to execute the script, to access the database and then to supply the content requested by the visitor's web browser. A widely used discussion board, for example, stores all usernames and posts inside a database, so some load is generated every single time a thread is opened or an end user looks for a certain term. If a lot of people access the forum all at once, or if every search involves checking hundreds of thousands of database entries, this can produce high load and affect the functionality of the website. In this regard, CPU and MySQL load data can provide you with data about the site’s efficiency, as you can compare the numbers with your traffic data and see if the Internet site has to be optimized or migrated to a different type of web hosting platform that will be able to bear the high system load in case the Internet site is extremely popular.
MySQL & Load Stats in Web Hosting
Our system keeps comprehensive info about the system resource usage of every web hosting account that's set up on our top-notch cloud platform, so if you choose to host your sites with our company, you shall have full access to this info through the Hepsia Control Panel, which you shall get with the account. The CPU load data include the CPU time and the actual execution time of your scripts, plus what amount of system memory they used. You may also see what processes created the load - PHP or Perl scripts, cron jobs, etcetera. The MySQL load stats section will show you the amount of queries to each specific database you have created in your shared hosting account, the total queries for the account altogether and the normal hourly rate. Comparing these numbers to the website visitor data will tell you if your websites perform the way they ought to or if they need some optimization, that'll improve their overall performance and the overall website visitor experience.