MySQL Load Stats

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

If you have an HTML site, most likely it uses a very small amount of system resources as it's static, but this is not so with dynamic database-driven websites that use PHP scripts and offer you much more features. This kind of Internet sites generate load on the web hosting server every time anyone browses them, because the web server needs time to execute the script, to access the database and then to provide the information requested by the visitor's web browser. A well-known discussion board, as an illustration, stores all usernames and posts inside a database, so some load is created any time a thread is opened or an end user looks for a specific name. If a lot of people access the forum simultaneously, or if every search involves checking hundreds of thousands of database entries, this could create high load and affect the functionality of the site. In this regard, CPU and MySQL load stats can provide you with info about the site’s functionality, as you can compare the numbers with your traffic stats to make a decision if the site must be optimized or transferred to a different sort of hosting platform that will be able to bear the high system load in case the website is really popular.

MySQL & Load Stats in Shared Web Hosting

We generate in depth statistics about the system resource usage of every shared web hosting account, so in the event that you host your sites on our innovative cloud platform, you will be able to check out the stats with only a couple of clicks from your Hepsia Control Panel. The data is available in two different sections. The first one will show you the span of time our system spent serving your sites, the total time it took for your scripts to be executed, how much memory the sites used and what kinds of processes created the load. Stats are created every 6 hours. You'll be able to see daily and monthly statistics too. In the second section you'll discover all the databases that you've created inside the account and for each one of them you'll see the total amount of per hour and day-to-day queries. The info will give you an accurate picture of the performance of your sites, specifically if you compare it to the daily traffic and visitor stats.

MySQL & Load Stats in Semi-dedicated Servers

Our system produces in depth stats about the two kinds of load, so if you acquire a semi-dedicated server for your websites, you can access the info with a few clicks within your Hepsia hosting CP. Each kind of data is listed within its own section. The CPU Load section shall tell you exactly what processes created the load and the amount of time it took for the server to execute each of the requests. Though stats are produced every six hours, you can see day by day and month-to-month statistics also. In the MySQL Load section you'll find a list of all the databases generated within your semi-dedicated account manually and automatically, what number of queries were sent to every one of them, the total daily queries for the account in general, plus the average per hour rate. This data shall help you see how well your sites perform and if each of them needs optimization of some type.