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.

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

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

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

Unknown 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!

Evelynminnick01 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

completemyassignment.blogspot.in 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.

TAMILSTATUS 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

Frozen 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

printersupportnumber 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

printersupportnumber 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
สนใจร่วมสนุกกับ คาสิโนออนไลน์ คลิ๊กได้เลย
มีทั้งคาสิโนออนไลน์ หวยออนไลน์ ฟุตบอลออนไลน์ สล็อตออนไลน์ และอื่นๆอีกมากมาย

techsolution 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

mysystem-mechanic 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

Install vipre 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

Install vipre 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

Install vipre said...

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

install avg

Lily Johnsol said...

Really informative blog post.Really looking forward to reading more. Much obliged.
norton.com/setup
norton.com/setup
norton.com/setup
office.com/setup
mcafee.com/activate
mcafee.com/activate

Printer Repair Dubai said...

This is a well informative post thanks for sharing this awesome information so keep sharing knowledgeable things from your ends.

Install vipre said...

Webroot Safe install is the most popular computer security that helps you to protect Windows,Mac and Android devices.

Below mentioned are the services provided by webroot geek squad

Below mentioned are the services provided by webroot geek squad

webroot geeksquad
webroot geeksquad download
webroot install geek squad
webroot.com geek squad download


https://geeksquadwebroot.com/webroot-geeksquad/
https://geeksquadwebroot.com/webroot-geeksquad-download/
https://geeksquadwebroot.com/webroot-install-geek-squad/
https://geeksquadwebroot.com/webroot-com-geek-squad-download/

Antivirus Activate said...

Visiting the site mcafee.com/activate will offer you free McAfee antivirus download with an ease form. Once you obtain this application, you may avail the basic set of virus removal features.

Ojash Yadav said...

In this model, there is a vertical asymptote at x = 3 and a flat asymptote at y = 1. How to Find Vertical Asymptotes The bends approach these asymptotes however never cross them. To locate the vertical asymptote(s) of a sane capacity, essentially set the denominator equivalent to 0 and tackle for x.

ROHIT RAJWANI said...

Vertical asymptotes are vertical lines which correspond to the zeroes of the denominator of a rational function. (They can also arise in other contexts, such as logarithms, but you'll almost certainly first encounter asymptotes in the context of rationals.)

Read : How to Find Vertical Asymptotes.

Isa Bella said...

After Mcafee activates enables using a 25 digit activation code on mcafee.com/activate, you can download, install and activate Mcafee antivirus security. Mcafee has widely used antivirus which provides a protected shield to the users' devices. A huge range of Mcafee products is available on its official website.

mcafee.com/activate | norton.com/setup

Isa Bella said...

You may activate the office setup by simply visiting on office.com/setup. Office is the most used productivity tool of all time. you can either purchase it online or you can go to the retail store for buying your copy.

office.com/setup | norton.com/setup

Isa Bella said...

Hey, I am a content writer, magazine publisher, and technical blogger currently living in San Diego, CA, USA. My interests range from antivirus to McAfee. I work in Quick Setup Activate | Mcafee Activate | Norton Setup | Office Setup

Quick Setup Activate is a company that provides technical support help regarding McAfee Antivirus Software, Norton Antivirus Software, and Office Setup.

office.com/setup | Quick Setup Activate | Chloe Decker

1800customerservicesnumber said...

Get support for every query related to mcafeecomactivate. You can ask For technical support or any concerned query related to McAfee
Product or service , activation , you can also contact wwwmcafeecomactivate or dial +1-888-526-0222 For McAfee Antivirus support.You can find quickest
solutions to the issues online or offline both .Our Customer Support service is 24/7 available to help you.

mcafee.com/activate
www.mcafee.com/activate
Mcafee Antivirus
Mcafee Antivirus Support
Mcafee Antivirus Support Service

remmy said...

McAfee Livesafe spearheaded the idea of a solitary antivirus membership to ensure the entirety of the Windows, Mac OS, Android, and iOS gadgets in a family unit or work space condition. With your Mcafee LiveSafe membership, you could introduce McAfee Total Protection on the entirety of your PCs, and the comparing Windows, Mac OS, Android, and iOS items on your different gadgets. The qualification between the super suite and the all-gadgets suite was clear and explicit.

mcafee.com/activate |
mcafee activate |
mcafee login |
www.mcafee.com/activate |


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

norton.com/setup |
office.com/setup |

Unknown said...

Very Informative Blog. Thanks for sharing with us. Visit at Hotmail Customer Service

Philip seiler said...

Very nice post!!!!! Thanks for Sharing this informative blog. Visit at United Airlines Official Site

Unknown said...

While printing, if the printer stops at the time of feeding pages and a message is displayed on the screen, saying: Paper Jam or HP Printer not responding. Then it is a condition where a paper is stuck in the printer and hence no other paper can be inserted in the printer. To resolve this issue, you have to first look for the jammed paper, and then you have to make sure the carriage can move easily.

Techsupport said...

While setting up a computer, we use a password to protect our data from being accessed by others. It is important to make a strong password also so that it cannot be hacked. It is mandatory to reset your Microsoft account password and it should be changed every 90 days so that it becomes difficult for hackers to log on to our PC or laptop. But in all this, what if you forget your password? You can surely Reset Password Windows 10 by following some steps.

Jatin Sethi said...

happy valentines day

mysystem-mechanic said...

geek squad trend micro download

Barney Stinson said...

Chromium browser provides safe and secure yet convenient browsing environment for its users. If you want to Uninstall Chromium from your device, you have to uninstall it from the control panel and delete all the files after that.

mysystem-mechanic said...


Trendmicro activate for your mac and pc.
When you activate trendmicro antivirus, it protects your device from unwanted threats.

Below mentioned are the services provided by trendmicro activation

https://trendmicro-activate.com/
https://trendmicro-activate.com/activate-trend-micro-internet-security/
https://trendmicro-activate.com/install-trend-micro-activation-code/
https://trendmicro-activate.com/trend-micro-internet-security-activation/
https://trendmicro-activate.com/trendmicro-com-activate/

trend micro activation
activate trend micro internet security
install trend micro activation code
trend micro internet security activation
trendmicro.com/activate

HP Printer Supports said...

Sometimes while using a Laptop the touch screen of the laptop might stop working. If you are also having the same issue with your laptop why wait just visit fix hp laptop touch screen not working.

My Assignment Helper Online said...

If you do not have all the required information available for the coursework topic assigned to you, then writing an assignment certainly would be uneasy for you. Here the importance of online assignment writing service stands out as we have a team of expert assignment writers available for you. You can opt our do my assignment Australia cost-effective service for well-researched content collected by reliable sources.

Best Assignment Writer | Complete My Assignment