Recently we’ve got critical load on one of our new free web hosting servers that handles millions of hits per day. When I’ve tried to analyze how to get more performance from that servers, I noted that these servers has ICH7 chipsets and Seagate SATA drives with NCQ support… But in closer view I noticed, that NCQ support is not enabled on our servers with ata_piix IDE driver. So, I decided that it would be great to enable NCQ and take a look what will happen with performance (it was obvious, that performance should increase)…
Read the rest of this entry →
I apologize for the lack of posting on my blog. Life has been pretty busy as last month I started a new job as Senior System Administrator in Toronto, On at a leading video hosting community.
I am very excited about this job and look forward to working with a great team that is really passionate about what they are doing.
As time goes by I will be posting more. At the moment, thanks for staying tuned.
Today Peter Zaitsev announced launch of new forums related to MySQL Performance questions. He says:
This forum is created as free alternative to MySQL Consulting Services which we provide. If you would like to get some free help to your performance issues please use forums so everyone else could benefit from our replies. You also should get more opinions on your performance problems from other forum members. There were a lot of unrelated performance questions placed as comments and sent by email and we had to find better way to organize it.
I think that it is a great idea to start such forums ontop of great blog site because many people can find it from Google when looking for some performance related questions or discussions. So, I want to say good luck to peter and will try to participate any discussions in these forums.