MySQL & Load Stats
What type of information is accessible in the MySQL & Load Stats section? How can you benefit from it?
Each time a visitor opens your Internet site, the browser sends a request to the hosting server, which in turn executes it and gives the required data as a response. A standard HTML website uses very little resources due to the fact that it is static, but database-driven platforms are more requiring and use much more processing time. Each webpage that is served produces 2 forms of load - CPU load, that depends on the time the hosting server spends executing a particular script; and MySQL load, which depends on the number of database queries produced by the script while the customer browses the site. Bigger load will be generated if loads of people browse a certain Internet site simultaneously or if loads of database calls are made concurrently. Two examples are a discussion board with tens of thousands of users or an online store in which a visitor enters a term inside a search box and thousands of items are searched. Having detailed stats about the load that your site generates can help you improve the content or see if it is time to switch to a more powerful kind of hosting service, if the Internet site is simply getting quite popular.
-
MySQL & Load Stats in Cloud Website Hosting
Our system keeps detailed information about the system resource usage of every
cloud website hosting account that is created on our top-notch cloud platform, so in case you decide to host your websites with our company, you shall have full access to this info from the Hepsia Control Panel, which you will get with the account. The CPU load statistics include the CPU time and the actual execution time of your scripts, along with the amount of system memory they used. You may see what processes generated the load - PHP or Perl scripts, cron jobs, etc. The MySQL load statistics section will show you the total amount queries to each specific database which you have created in your shared hosting account, the total queries for the account in general and the average hourly rate. Comparing these figures to the 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 Servers
If you want to see detailed stats for the load generated by your Internet sites, it won't take more than a few clicks to do that. The Hepsia hosting CP, which comes with all
semi-dedicated servers we offer, has a section devoted to the system resource usage and the information there will tell you if your sites function properly and if the load they produce corresponds to the amount of received visitors. The CPU load data include the script execution time and the amount of time it took for the web server to process the requests, and also what types of processes produced the load. The MySQL data shall show you the number of times every database was accessed, as well as daily and per hour statistics for the whole account. With both types of statistics, you can check the numbers for each of the past days and months, so you could see how the sites perform as the traffic to them increases or after you have applied some update.