Quote:
Originally Posted by LBBV
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 |
i agree you guys go great lengths, like i said in my reply the give out root thing was the only bells that rang in my head and the only company i could remember that had that policy in the past, dunno if it still is like that, was natnet ;) thats all, been with you guys in the past for over a year so i know how the support guys go out of their way to get things resolved.