MySQL & Load Stats
What kind of information is provided in the MySQL & Load Stats section? How can you take advantage of it?
If you have an HTML Internet site, in all probability it uses a small amount of resources simply because it's static, but this isn't the case with dynamic database-driven Internet sites that use PHP scripts and offer much more functions. This type of websites produce load on the web hosting server each time 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 browser. A well-known discussion board, for example, stores all usernames and posts inside a database, so some load is produced each time a thread is opened or an end user looks for a given name. If lots of people access the forum at the same time, or if every single search involves checking thousands of database entries, this may generate high load and affect the overall performance of the website. In this regard, CPU and MySQL load stats can provide you with information about the site’s performance, as you can compare the numbers with your traffic statistics to make a decision if the site has to be optimized or transferred to a different type of hosting platform that will be able to bear the high system load in case the Internet site is very popular.
-
MySQL & Load Stats in Cloud Web Hosting
Our system keeps comprehensive information about the system resource usage of each
cloud web hosting account that is created on our top-notch cloud platform, so given that you opt to host your Internet sites with our company, you will have full access to this information through the Hepsia CP, which you will get with the account. The CPU load statistics include the CPU time and the actual execution time of your scripts, plus how much system memory they used. You may also see what processes generated the load - PHP or Perl scripts, cron jobs, etc. The MySQL load stats section will show you the number of queries to each specific database you have created inside your shared hosting account, the total queries for the account in general and the average hourly rate. Comparing these statistics to the site visitor data shall tell you if your sites perform the way they should or if they need some optimization, that will improve their efficiency and the overall site visitor experience.
-
MySQL & Load Stats in Semi-dedicated Servers
Because our system keeps comprehensive statistics for the load that every
semi-dedicated server account generates, you'll be aware of how your Internet sites perform at any time. As soon as you log in to the Hepsia Control Panel, which comes with every account, you can go to the section committed to the system load. In it, you can easily see the processing time our system spent on your scripts, the time it took for the scripts to be actually executed and what kinds of processes produced the load - cron jobs, PHP pages, Perl scripts, etcetera. Also you can see the total number of queries to each database in your semi-dedicated account, the total daily statistics for the account overall, along with the average hourly rate. With both the CPU and the MySQL load stats, you may always go back to past days or months and assess the general performance of your sites after some update or after a significant boost in the number of your website visitors.