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.


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.

Online Assignment Services said...

This is the first time i am reading article here,very helpful and knowledgeable.The points are very deeply clarify in it.A very important message given in it. Write My Assignment

Complete My Assignment said...

It is good to read such a valuable information and thanks for sharing it. I am hoping the same best work from you in the future as well. Problem Faced By Students

Assignment Help said...

That is indeed a wonderful piece of information and of great help. If you want to get assistance in your academics then you can avail our assignment help services at Complete My Assignment with affordable prices.

RajMohan said...

Hello there. I found your web site by the use of Google at the same time as searching for a comparable subject, your site came up. It seems great. I have bookmarked it in my google bookmarks to come back then.

Telugu Status
Telugu Whatsapp Video Status
WhatsApp Video Status in Telugu
Telugu Status Video
Telugu Status Video Songs Download
Telugu Status Video Songs Download
Malayalam Status Video Songs Download

rickypauls said...

I have been using this Assignment Help services for a long time. The team is highly supportive and understands my necessities. They prepare my assignments regardless of subjects in an organized and maintained manner. If anyone is having trouble with their university projects, I recommend them to use this service.

Online Assignment help said...

we offer best online assignment help services in USA. Allassignmenthelp is number 1 online assignment help in US, Australia and UK.

online assignment help
assignment help online

ashleyleio123 said...

Excellent blog. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking.

john martin said...

office.com/setup is a product ofoffice setup. Get Support if you face problem to activate office.com/setup or mcafee.com/activate install Microsoft Office product. Install with Product Key. mcafee.com/activate
norton.com/setup is one of the best Security Antivirus product can completely Call qui protect your digital life online. You can securely surf the Internet with the To activate your with product key you can visit norton.com/setup. |


Hi there, I found your blog by way of Google whilst searching for a related subject, your web site came up, it appears good. I have bookmarked it in my google bookmarks. Hi there, just changed into alert to your blog thru Google, and found that it is really informative. I am going to be careful for brussels. I will be grateful should you continue this in future. Lots of people will likely be benefited from your writing. Cheers!

Vastu in Dubai and UAE
Vastu Consultant in Dubai and UAE
Vastu Shastra Consultant in Dubai and UAE
Best Vastu Consultant in Dubai and UAE
Vastu Shastra Training in Dubai and UAE
Indian Vastu Training tamil status videos for whatsapp
Whatsapp Tamil DP Status Quotes and Images
Vastu Consulation in Dubai and UAE
Vastu Remedies in Dubai and UAE
Vastu Tips For Homes
Vastu Tips For Office and Buildings
Vastu Training Programs and Workshops in Dubai and UAE

برق یار said...

به خاطر داشته باشید که آسانسور قیمت آسانسور ، بازسازی آسانسور و شرکت آسانسور نیز مسائل قابل ملاحظه‌ای است.نگهداری قطعات آسانسور ، شغل نصب آسانسور است. سیستم تهویه مطبوع به خاطر داشته باشید که تهویه مطبوع سامسونگ و شرکت تهویه مطبوع نیز بهترین سیستم تهویه مطبوع و تهویه مطبوع ساختمان می باشد. برق یار برای خدمات برق برای عیب یابی ، تعمیر ، نگهداری یا نصب ، سرویس تاسیسات و کامپیوتر است.

Anonymous said...

Wow!! It's a really great experience shearing with us. I like your post, it's a really interesting.Career Predictions by Date of Birth

john smith said...

Great post, Thank you for sharing this amazing post, I really appreciate your work.

norton.com/setup | office.com/setup | mcafee.com/activate