MySQL And Load Stats

: Hosting Glossary; Disk Space; Hepsia Control Panel; Hosted Domain Names; InnoDB; Integrated Ticketing System; Email Accounts; Memcached; Node.js; Subdomains; Customer Support; Monthly Traffic; Varnish; VPN Traffic; Assisted Website Migration; Weekly Backup; Get Started

If you have an HTML site, it likely uses a very small amount of system resources as it's static, but this is not the case with dynamic database-driven Internet sites that use PHP scripts and offer you way more capabilities. This sort of sites generate load on the web hosting server every time anyone browses them, simply because the 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 well known discussion board, as an illustration, stores all usernames and posts in a database, so some load is produced any time a thread is opened or an end user searches for a specific term. If many people connect to the forum simultaneously, or if each search involves checking a large number of database entries, this may create high load and affect the performance of the site. In this regard, CPU and MySQL load stats can provide you with info about the site’s performance, as you can compare the numbers with your traffic statistics to decide if the site must be optimized or moved to a new sort of website hosting platform that'll be able to bear the high system load in the event that the website is very popular.

MySQL & Load Stats in Shared Hosting

Our system keeps comprehensive information about the system resource usage of every shared hosting account which is set up on our top-notch cloud platform, so if you choose to host your Internet sites with us, you will have full access to this information from the Hepsia Control Panel, which you will 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 could also see what processes generated the load - PHP or Perl scripts, cron jobs, and so forth. The MySQL load statistics section will show you the number of queries to each individual database that you have created inside your shared hosting account, the total queries for the account altogether and the average hourly rate. Comparing these numbers to the site visitor statistics will tell you if your sites perform the way they have to or if they require some optimization, that will improve their performance and the overall website visitor experience.

MySQL & Load Stats in Semi-dedicated Servers

If you have a semi-dedicated server account with us, you will be able to access rather comprehensive CPU and MySQL load stats that'll give you more information about the performance of your websites. Two sections of the Hepsia CP are dedicated to the stats, one for each and every kind. Within the CPU Load section you could see the execution time of your scripts and how much time the web server processed them. You can also see the kinds of processes that were executed. Stats are generated every 6 hours, but if needed, you could also check figures for previous days or months. The MySQL Load section will show you the entire number of database queries each day and each hour, as well as the queries to each individual database you have in your semi-dedicated account. Comparing this data to your traffic statistics shall give you valuable data about how your Internet sites perform and you will determine if you have to take some measures to optimize them.