MySQL & Load Stats
What type of data is provided in the MySQL & Load Stats section? How can you benefit from it?
If you have an HTML Internet site, it probably uses a small amount of system resources simply because it's static, but this is not the case with dynamic database-driven Internet sites that use PHP scripts and provide you with much more functions. This sort of Internet sites create load on the website hosting server each time somebody browses them, since the web server requires time to execute the script, to access the database and then to deliver the info requested by the visitor's web browser. A widely used discussion board, for example, stores all usernames and posts within a database, so some load is created any time a thread is opened or an end user searches for a specific name. If many people connect to the forum at the same time, or if each search involves checking thousands of database entries, this could generate high load and affect the performance of the website. In this regard, CPU and MySQL load stats can present you with data about the site’s overall performance, as you can compare the numbers with your traffic statistics to make a decision if the Internet site needs to be optimized or migrated to another type of hosting platform which will be able to bear the high system load if the Internet site is really popular.
MySQL & Load Stats in Semi-dedicated Servers
As our system keeps detailed stats for the load which each semi-dedicated server account produces, you will be aware of how your websites perform at any time. As soon as you log in to the Hepsia Control Panel, which comes with each and every account, you should check out the section dedicated to the system load. There, you can see the processing time our system spent on your scripts, the amount of time it took for the scripts to be actually executed and what kinds of processes created the load - cron jobs, PHP pages, Perl scripts, etcetera. Additionally you can see the total number of queries to each database in your semi-dedicated account, the total everyday statistics for the account in general, as well as the average hourly rate. With both the CPU and the MySQL load stats, you could always go back to past days or months and review the overall performance of your Internet sites after some update or after a substantial rise in the number of your site visitors.