Quote:
Originally Posted by boneless
id say natnet, since the topic starter said he asked for root, and once given the host didnt want to support the box anymore. natnet got the same policy in place ;)
|
We go to great lengths to tune customer servers based on what the server is doing. In fact, as part of our continuing education program, our Director of Programming Services just gave a great class last week to all the System Administrators on identifying database bottlenecks and the importance of keys and indexes, as well as how to determine what tables need them and how to add them. There's tons of poor programming out there with things like bad "join" queries, etc. He showed us one example where a poorly formatted query took over 31 seconds to complete. After adding some keys, it dropped to 0.01 seconds - Nice!
Other examples include moving websites to nginx or lighttpd if we think that will work better, upgrading Mysql versions to take advantage of newer functionality such as partitioning in the newer versions of Mysql, converting older Myisam tables to Innodb (where applicable) as well as working with the many caching and accelerator programs available.
We never recommend upgrades or additional hardware without exhausting every tuning effort and in fact, I routinely talk customers out of adding additional servers or upgrades
-- Bill