What Is Cpu Throttling? How To Troubleshoot?-00-4510

By Author: expertscolumn
Total Articles: 4351
Comment this article

CPU Throttling is the process of cutting on the CPU resources provided by their hosting providers so that everyone on the server could get equal access to CPU resources. While there is minimum need of throttling CPU on dedicated servers, it is usually experienced by users who uses shared hosting environment where large number of sites are being hosted at any given time.

Throttling is a mechanism that keeps your server performing even under high CPU requests. Instead of getting your account temporarily suspended by your shared hosting provider, time latency is being induced that makes your site load slowly for the amount of time your site has been throttled by the shared hosting providers.

Though hosting providers developed this mechanism to savegaurd their users against the threat of temporary account suspending, but CPU Throttling is a big overhead for the users especially those who are not much aware of programming and development. Presently very few companies are using this mechanism, but the notable ones are Hostmonster and Bluehost, both owned by the same person. This CPU Throttling technology has been the ...
... work of brains at hostmonster and blueshost and you will soon see this mechanism being implemented by other shared hosting providers as well.

How can you troubleshoot this CPU Throttling?

You can access your logs which can help you determine which of your queries or scripts are unoptimized. Inside your "mysql_slow_queries" folder, you will see a list of files that you can open which will show you which queries are executing slowly. Login into your cPanel. Look for the section called "Files" and click the icon called "File Manager". Start in the "Home Directory", choose Show Hidden Files, and then click Go. Once in the File Manager, look on the right side for a folder called "tmp" and navigate into that folder. Once inside the Tmp folder, you should see a folder called "mysql_slow_queries". Navigate inside that folder.

You should now look for the files with recent dates and right-click on one of those files and choose "Code Edit". In the new window that comes up, you will see the log details. Look for the logs where the Query_time is over 2 seconds. Queries that take over 2 seconds to execute usually need to be re factored.

These logs are generated to help you troubleshoot your database programming queries that are not optimized. Once you have found the query and database causing the problem, you can then optimize the query or queries by re-writing the query, creating an appropriate Database Index, repairing any damaged databases, etc. If you are not familiar with database programming, you may need to seek help from your web developer/programmer.

It is strongly recommended to backup the database before working with them.

This troubleshooting is ideal if you are experiencing CPU Throttling on Bluehost or Hostmonster hosting.

About the Author:

This is just a basic guide. To know the causes and complete troubleshooting visit http://expertscolumn.com/content/what-cpu-throttling-causes-troubleshooting-guide complete guide at Expertscolumn which gets you http://expertscolumn.com.