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.

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

waston said...


Microsoft office.com/setup with your product key. Get started: step 1. Go to office.com/setup - Sign in, 2nd. Enter product key, and 3rd. Install Office 365 or Office 2016. If you are having any Office Setup issue then call us at 24*7 for technical help. we also help with like Excel, PowerPoint, PowerPoint, Word, OneNote,

office.com/setup

norton.com/setup said...

I really happy found this website eventually. Really informative and inoperative, Thanks for the post and effort! Please keep sharing more such blog.

norton.com/setup

norton.com/setup

mcafee.com/activate

kaspersky activation code

free pogo games

roadrunner email

aol mail

Factocert said...

Thanks for the sharing this informative and interesting post with us, I really admire your post as its it's really very helpful for my research.
regards,
factocert
iso certification in iraq
iso certification in jordan
iso certification in lebanon
iso certification in oman
iso certification in saudi arabia

factocert1 said...

Such a focal article. Boggling to research this article.I should need to thank you for the endeavors you had made for trim this staggering article.
regards
iso certification in saudi arabia
iso certification in oman
iso certification in philippines

ryans said...

You can check out the live train information from this site

richardburke said...

Good article and knowledge for me! I found a lot of information here! Thank you for sharing with us! I will be sharing this on my essay writing service website page for sure. Thanks for the great work.

Noida Escorts said...

call girls in Noida
Russian Escorts in Noida
Noida Bhabhi

Unknown said...

Harley Quinn Jacket gives you a pleasure of getting something special for yourself or your love ones, will be a great gift to anyone with quality standard

Sophia Thomas said...

This is a great article and great read for me. It's my first visit to your blog, and I have found it so useful and informative especially this article.

online assignment help cheap
Assignment Help

webroot-activate said...

Activate webroot on your devices now.

https://webroot-activate.com/geek-squad-webroot-download-with-key/
https://webroot-activate.com/geeksquad-webroot-download/
https://webroot-activate.com/how-to-install-webroot-from-cd/
https://webroot-activate.com/install-webroot-on-new-computer/
https://webroot-activate.com/install-webroot-without-cd/
https://webroot-activate.com/protection-with-webroot/

geek squad webroot download with key
geeksquad webroot download
how to install webroot from cd
install webroot on new computer
install webroot without cd
Protection with webroot

Isa Bella said...

McAfee antivirus offers complete assurance to their clients for verifying their information against malware. At the point when the clients download any document from the Internet, at that point the main thing McAfee do is that it examines the record before it begins downloading on their framework.

When the clients download McAfee on their framework, at that point they don't need to stress over the security of their own information. McAfee antivirus likewise obstructs the sites which are bad for the client' computer and don't let the client' to visit those sorts of locales.

mcafee.com/activate | mcafee.com/activate | mcafee.com/activate | mcafee.com/activate

Isa Bella said...

McAfee provides real-time security against all new and old threats that lurk in the digital world. Sometimes, users see that whenever they open a browser, they get McAfee subscription has expired error. If you are getting this error, then here is what you need to do.
Antivirus locates and terminates threats to your system. It also provides protection when you are browsing through the internet. The market is filled with numerous antivirus software that claims to offer total protection to your PC. There are over thousands of antivirus available on the market. Significant companies provide antivirus for you to install, but the best among the group is MacAfee antivirus.

mcafee.com/activate | mcafee.com/activate | mcafee.com/activate

georgethomas said...

GoAssignmentHelp is very useful for the students who are doing their masters and want to submit the document to take their degree. We are providing the

best assignment service to everyone. Just contact us at +61-0283206023 for the best quality services. All subjects and types of assignments available.
eviews assignment help | psychology assignment help | corporate finance assignment help | business law assignment help

Puremelda said...

The agency knows how tedious and overwhelming crafting Custom Research Paper Services can be for learners and Deliberate all your tasks to writers at the Online Research Paper Writing Services and Legitimate Custom Research Paper Writing Services.

johnrobertson said...

I am really interested in this article. This article really helps me to increase my knowledge. So thanks for sharing such an awesome article.
outlook support phone number

Microsoft tech support

And one more thing you may also get here the Outlook FAQs queries that people also like to ask.
Is there a phone number for Outlook support?
How do I contact Microsoft tech support?

alexhydra11 said...

Excellent post keep sharing post like this. informative post keep posting like this.
mcafee.com/activate The McAfee Internet protection suite and antivirus software are the products designed by McAfee for helping to secure home, business or school systems. You will need an identification key for the entire McAfee products brought online or from the retail store.Upgrade your protection to the next level.

office.com/setup Office Setup your Microsoft Office version. Sign in at office.com/setup, and download the setup. After installation, enter the 25 characters alphanumeric product key for activation

trendmicrobestbuy said...

Trend micro best buy is one of the best security software provided by best buy to its customers.

https://trendmicrobestbuy.com/trend-micro-best-buy-download/
https://trendmicrobestbuy.com/trend-micro-login/
https://trendmicrobestbuy.com/www-trendmicro-com-best-buy-downloads/

trend micro best buy download
trend micro login
www trendmicro com best buy downloads

installvipre said...

Vipre antivirus secures your computer against unwanted cyber threats available online.


https://installvipre.org
https://installvipre.org/i-need-to-install-vipre
https://installvipre.org/install-vipre-with-key-code
https://installvipre.org/reinstall-vipre-with-product-key
https://installvipre.org/vipre-antivirus-hsn-install-download

install vipre antivirus
i need to install vipre
install vipre with key code
reinstall vipre with product key
vipre antivirus hsn install
download

Edward Lewis said...

Very informative post, your post unique. Thanks for sharing.
central.bitdefender.com
central.bitdefender.com
trendmicro.com/activation
trendmicro.com/activation
avast.com/activate

installavg said...

Install avg on your device and protect your device from cyber threats

install avg