MySQL & Load Stats

If you have an HTML Internet site, it likely uses a small amount of resources because it is static, but this is not the situation with dynamic database-driven websites that use PHP scripts and offer way more capabilities. This sort of websites generate 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 supply the info requested by the visitor's Internet browser. A popular discussion board, for example, stores all usernames and posts inside a database, so some load is created each time a thread is opened or an end user searches for a particular term. If a lot of people access the forum all at once, or if every single search involves checking tens of thousands of database entries, this can generate high load and affect the functionality of the site. In this regard, CPU and MySQL load statistics can provide you with data about the site’s functionality, as you can compare the numbers with your traffic statistics to make a decision if the site must be optimized or migrated to another kind of hosting platform which will be able to bear the high system load in the event that the site is really popular.