MySQL & Load Stats
What kind of info is available in the MySQL & Load Stats section? How could you take full advantage of it?
Each time a visitor opens your website, the web browser sends a request to the web server, which executes it and gives the desired information as a response. A simple HTML Internet site uses negligible system resources due to the fact that it's static, but database-driven platforms are more demanding and use a lot more processing time. Every single webpage that's served creates 2 kinds of load - CPU load, which depends on the time period the hosting server spends executing a specific script; and MySQL load, that depends on the total number of database queries produced by the script while the end user browses the site. Larger load shall be generated if many people surf a particular site concurrently or if many database calls are made simultaneously. 2 examples are a discussion board with thousands of users or an online store where a client enters a term in a search box and a large number of items are searched. Having thorough data about the load that your site generates can help you optimize the content or see if it is time for you to switch to a more powerful type of website hosting service, if the website is simply getting really popular.
MySQL & Load Stats in Shared Hosting
Our system keeps detailed information about the system resource usage of every shared hosting
account that is set up on our top-notch cloud platform, so if you decide to host your websites with us, you shall have full access to this data from the Hepsia CP, 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 created the load - PHP or Perl scripts, cron jobs, and so on. The MySQL load stats section will show you the number of queries to each specific database that you have created inside your shared hosting account, the total queries for the account overall and the average hourly rate. Comparing these numbers to the site visitor statistics shall tell you if your sites perform the way they ought to or if they require some optimization, that'll improve their efficiency and the overall visitor experience.
MySQL & Load Stats in Semi-dedicated Hosting
If you want to see detailed stats about the load generated by your Internet sites, it won't take more than a couple of mouse clicks to do this. The Hepsia hosting Control Panel, included with all semi-dedicated servers
we offer, has a section focused on the system resource usage and the data there can tell you if your sites function properly and if the load they generate corresponds to the total amount of received visitors. The CPU load statistics include the script execution time and the amount of time it took for the hosting server to process the requests, plus what kinds of processes generated the load. The MySQL stats will show you how frequently every single database was accessed, and also everyday and by the hour stats for the whole account. With both kinds of stats, you'll be able to check the numbers for every one of the past days and months, so you could see how sites perform as the traffic to them rises or once you've applied some update.