Tuesday, September 21, 2010

Site Performance Issue Resolve

Warning, there is a lot of geek talk in this post ;)

When it comes to site performance and optimization it becomes a cat and mouse game between the developer and the growing user base. For the last 2 weeks I notice high CPU usage from the database. My first attempt to solve the problem was to enable query caching, increase the size of the temp tables, restarting the service, etc. At first it appeared that page load speed were back to normal, but after another spike in traffic myVidster's servers could not keep up. Last night during peak usage I decided to look at the queries that the database were processing. I notice several update queries in the queue and I wonder why myVidster is executing so many updates, most queries should be selects or inserts. Then I remember that I reorder all the videos in a channel when a new one was added (which requires an update to those videos)! This is not an issues when a user has a few videos, but as myVidster grows user's collections have grown to the 100s and 1000s of videos!

I change the logic so that an update is no longer needed to videos in a channel when a new video is added. Doing this drop the database's CPU usage in half and page load speed was back to normal. One a side note, I notice that users are now trying out our storage upgrade service! For those who do not know what this is, adding storage to your account will allow you to backup your videos to myVidster for safe keep and viewing. More info on our upgrade page.

10 comments:

Mharish said...

Thanks for sharing this post. I really appreciate your efforts and I will be waiting for your next write. packers and movers marathahalli bangalore

JANA GANGA said...

Good Posting...
Personality Development Programs in Chennai

Richard Majece said...

I hope that you understand all the importance of education. Cause it's my real passion and I even know how to make homework fun. You can use this info if you want to.

Expert for hire said...

Experts that wrote this post did a great job, its highly commendable and professional. It would be a great idea to keep sharing more. Your blogging skills are a reliable source of professional information to many people. Meanwhile, when looking for 3D wall murals in Nairobi-Thika, feel free and confident to visit our shop. The products we sell are certified of being quality and durable, and also legal to sell. Make a purchase and see the difference.

Nikki Heysen said...

Students Assignment Help is giving services of Dissertation Writers 24x7 at a good price. The professionals' team offers high-quality work in a short time without any delay.

My Homework Help said...

Do you want to lagging behind in every step of your educational life? If not then start learning computer effectively as it is the most efficient tool for you in your entire life in this digital era. Do not get confused and do not west time only by keeping your eyes on our post. Get your admission successfully in our online tutorial at myhomeworkhelp to experience the efficiency of our My homework help computer science team for an effective learning.

Evelyn W Minnick said...

Performance tuning includes query optimization, SQL client code optimization, database index management, and in another sense, better coordination between developers and DBAs. Need some help with Computer science assignments and don’t know what to do? Are the lessons and tests bothering you with no help to cater you with? Here’s what you can do! Follow us on our Facebook page at 24x7assignmenthelp.com and you will realize how simple it is to get 24x7 Assignment help Computer Science. Are you unable to cope with the extreme academic pressures especially on subjects like computer science? With your best interest in mind, we at our online assignment help company 24x7 assignment help are available to provide the best academic assistance possible. Learn everything starting from the basics of computer software to hardware and prepare well for your exams with computer science homework help.

LennonJohn said...

For all those students who have been looking for updated quality academic services, we universityhomeworkhelp
are here at just a click away! From our team of specialised subject experts to guest lecturers and reputed professors – we provide our students online chat facility and that too free of cost. Also, apart from general students, we extend our services to specially-abled students at similar rates.
With us, your learning of the subject will not just be complete but justified. Our USP rests in minimal costs and submission within a specified time. Trust us – we promise complete satisfaction!

Christian Baker said...

We @ Do My Homework firmly believe that every student has the capacity to understand and represent their subjects in their unique manner. Hence as an academic forum, we simply wish to provide them with knowledge base that they can utilise in the best manner.
DoMyHomework also aim to provide students with a database in a variety of related topics from social sciences to engineering. In future we look forth to state ourselves as a pillar of our student’s success that enables us to work round the clock! As a pioneer in this industry, we provide quality work, minus error and plagiaristic issues!

Assignment Help said...

Those who are searching over internet IT assignment help can contact with us now. We are the best assignment writing service provider in melbourne, Australia. Our Academic assignment writers available 24*7 hours for the students, if you really want to need IT assignment help, Computer science assignment help online at cheapest price and get high distinction grades.