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.

40 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.

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.
office.com/setup

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. |
mcafee.com/activate

TAMILSTATUS said...

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

Unknown said...

Is your printer facing many technical issues? No need to worry. Hp customer support is there to help you sort out your problems. The only thing you have to do is to call our HP Support Phone Number where experts will solve all your technical issues related to your printer and try to clear it in the best way possible within the given time. Hp experts are a group of professionals who deals in all kind of technical issues directly related to the printer. To grab this service, you have to call on our HP Support Phone Number or you can go through our website for further information.
HP Suport
HP Printer Support

Unknown said...

Is your printer facing many technical issues? No need to worry. Hp customer support is there to help you sort out your problems. The only thing you have to do is to call our HP Support Phone Number where experts will solve all your technical issues related to your printer and try to clear it in the best way possible within the given time. Hp experts are a group of professionals who deals in all kind of technical issues directly related to the printer. To grab this service, you have to call on our HP Support Phone Number or you can go through our website for further information.
HP Suport
HP Printer Support

studentsassignmenthelp said...

Our team is ready to help you and keeps working for the students to give the best service every day. At studentsassignmenthelp.com students can easily get best service 24X7. so stop searching else. Students who study in the physic subject and keeps demanding for finish physic homework they can quickly get physics homework help from the students' assignment help experts.

Daniel said...

I resembled your article, however, I favored Top Celebs Jackets online store since this store gives me all items in retailer cost and item quality is incredible all items are agreeable and sleek. NCR Coat

kiara Jess said...

I feel it interesting; your post gave me a new perspective! I have read many other articles about the same topic. Get Assignment Help Birmingham in uk.

smith warner said...

mcafee.com/activate - Follow the steps to activate mcafee, download and install at www.mcafee.com/activate. Find 25-digit alphanumeric product key on registered email or backside of the retail card to mcafee activate.

norton.com/setup - Follow the steps to set up Norton, download and install at www.norton.com/setup. Find 25-digit alphanumeric product key on registered email or backside of the retail card to activate norton setup.

office.com/setup - Enter Key office setup, after purchasing MS Office from visit www.office.com/setup, sign in to your Microsoft account then enter product key for Office Install.

Daveheller said...

Such wonderful information
I think I’m your biggest fan and I really appreciate your effort, thanks for sharing valuable information keep posting a great job…!!! I found this kind of valuable information in the outlook support

Gclub45 said...
This comment has been removed by the author.
หมูอวกาศ said...

คาสิโนออนไลน์ที่น่าเชื่อถือและมีความเป็นมืออาชีพที่สุดในตอนนี้
โปรโมชั่นGclub ของทางทีมงานตอนนี้แจกฟรีโบนัส 50%
เพียงแค่คุณสมัคร สล็อตออนไลน์ กับทางทีมงานของเราเพียงเท่านั้น
ร่วมมาเป็นส่วนหนึ่งกับเว็บไซต์คาสิโนออนไลน์ของเราได้เลยค่ะ
สมัครสล็อตออนไลน์ >>> Goldenslot
สนใจร่วมสนุกกับ คาสิโนออนไลน์ คลิ๊กได้เลย
มีทั้งคาสิโนออนไลน์ หวยออนไลน์ ฟุตบอลออนไลน์ สล็อตออนไลน์ และอื่นๆอีกมากมาย

Unknown said...

Thanks For share such a nice platform for know our horror scope. If any one want to resolve their problems talk to astrologer for free.

James Boond said...

Thanks for sharing this amazing blog . I appreciate for this performance .

www.office.com/setup

www.mcafee.com/activate

www.mcafee.com/activate

www.norton.com/setup

hookstefan said...

This assignment help online gives 24 hours of accessibility to students. Through this, the students can whenever look for assistance from online administrations. They begin making them assignment which is completely interesting and genuine.
Assignment Help UK
Do My Assignment UK

Suhana Williams said...

Assignment Help Online Online brings to you a comprehensive solution with an assurance of peerless writing style, implemented in every paper. Our online assignment experts ensure students receive needed assistance to fulfill their desired academic goals.

latest news said...

Nice post. Check out the Trend news around the world. Trend news on Education, Health, Travels, Business, Technology and Travel.

siru dell said...

If you are looking for "how to do my math homework", Tophomeworkhelper provides the best homework answers to all your queries whether It is Chemistry Homework help, English Homework help and Algebra Homework Help. You will get all the solutions related to your queries.

Robert Smith said...

Nice post but I was wondering if you could write a litte more on this subject? I’d be very thankful if you could elaborate a little bit further. Appreciate it...
Academic Writing Service

Office com Setup said...

Nice Post!
As we all know, Microsoft Office is among the greatest productivity applications available in market at this time, Followed by a number of other applications with fantastic chances. However, Office can do wonders in a lot of ways. To a lot of people in the world. Working on PC/MAC is something that they do daily basis, yet this computer work ought to be accomplished easily and quick. This isn't so simple without softwares. And for companies and other workplaces, Productivity softwares have accepted the floor to find work done over the time limitation or even quicker than the given time.
Setup And Install Your Office Product With Activation Key.
office com setup

Suhana Williams said...

Homework Help of Assignmenthelp.us is here to provide all the solutions of all the problems related to homework. If you have a question in your mind how to “do my homework”? You can go with assignmenthelp.us whether you are searching for Math homework help, Statistics homework help or physics homework help.