Wednesday, August 12, 2009

Performance Issues Resolved

Recently i notice that page loading were getting slower and slower (up to 5 seconds for a page to load during peak hours). When checking the server logs I did not notice any high CPU usage. When coming back from lunch today, I realize that I have done zero optimization to my database. Database optimization is not a big deal when your are only dealing with a couple hundred rows of data, but when you get into the thousands you start to see a degrade in performance.

I have done some simple optimization to the myVidster's mySQL tables. Simple stuff like adding indexs and running the OPTIMIZE command on the tables. I also setup a nightly cron job to optimize my index files for video searching (Zend Lucene).

The final result was page load times and search gain a 2x to 3x boost! Hopefully the performance issues did not cause me to lose any users.

56 comments:

Mharish said...

Excellent and decent post. I found this much informative. I'm impressed by the details that you have on this web site. Thank you for this post. - packers and movers marathahalli

JANA GANGA said...

Life Coach in Chennai

Anonymous said...


Blue waffles
Blue waffles disease
Blue waffles pictures
How do you get blue waffles
Blue waffles symptoms, causes, prevention

Oliver Maurice said...

You definitely need to read this article about yahoo messenger spy applications to get all the news about the subject and spy applications in general

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

برق یار said...

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

meldaresearchusa said...

Our research paper service writers have been 14 years experience in the field where they have assisted thousands of returning clients in attaining high scores.

Madoo said...

This is really an amazing and thank you so much for sharing

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

Puremelda said...

We understand that students in Australia encounter different challenges in completing their Best Custom Essay Writing Service. We offer Best Online Paper Writing Service to students regardless of their specialty, discipline or educational level.

Linda said...

great article, I was very impressed about it, wish you would have stayed next share
cool math games fireboy and watergirl

webnovel said...

I feel sorry for not knowing this sooner, thank you for sharing with us!

Geek squad said...

I found this is very interesting and good. Finally, I resolved the issue very fast and good way. If you face any issue related to any electronic devices then visit our website Geek Squad Support

Legitimate Custom Research Paper Services said...

The backbone of Term Paper Writing Services company is its writers and ours are the choicest in the industry to ensure that clients acquire the Best Term Paper Services and that will make you collect a high-quality Custom Term Paper Writing Help.

Intuit said...

Great article. Intuit provides you various accounting software for small businesses and offers on-premises accounting applications and cloud-based services also. In case of any help to buy any software for your business then visit intuit customer service.

Ryan Weston said...

Very good write-up. I certainly love this website. Thanks! iMessage on PC

Best Packers and Movers in Delhi | Best Packers and Movers in India said...

Your blog is awesome, all contents are really unique. thanks for sharing with us.Looking for some help from Packers And Movers in Dwarka, for shift your home or office then contact Zodiac Packers Movers.

jack miller said...

DMG files are like ISO file.DMG files are Mac-specific files and are not for use in windows. You are not able to run this file on Windows due to the Operating system compatibility issues. And, more than that you cannot open directly DMG file. In windows, you can use FreeViewer DMG Tool viewer to view different files of DMG on the windows platform. For more information, visit dmg file opener windows 7.

Unknown said...


نقل عفش من الدمام الى مكة نقل عفش من الدمام الى مكة
نقل عفش من الرياض الى الدمام نقل عفش من الرياض الى الدمام

نقل عفش من الرياض الى جدة نقل عفش من الرياض الى جدة

arianapham said...

Thank you for sharing this information. Love your blog posts. Please keep updating. You can also visit our website to play blog post y8 game full of fun.

Oliver john said...

promo codes for roblox it is the great experience for you in gaming.

peter said...

the information which you shared in your article is quite impressive and it helps while developing. keep sharing such kind of article with us. mcafee.com/activate

Twin said...

keep sharing this type of information if you are facing any kind of issue while using norton setup then you can simply visit our website our technical assistant assist you the same we are 24*7 available for our users.

peter said...


if you are looking for antivirus then we suggest you download Mcafee activate for total protection. if you had a premium version of mcafee.com/activate
and face any kind of technical error then you can visit our website.

mcafee free trial said...

Mcafee security is an antivirus that is most commonly used, it is the most popular and the best antivirus, it is an antivirus that has been used since the first appearance of the virus. McAfee offers a full range of security products such as antivirus, firewall and anti-spyware programs that provide us protection against viruses, threats and malware

file said...
This comment has been removed by the author.
open acsm file said...

I love to read this information.
thanks

pdf file said...

I appreciate your efforts, keep sharing with us

mary Brown said...

Great Article
android based projects

Java Training in Chennai

FInal Year Project Centers in Chennai

Java Training in Chennai

projects for cse

sam smith said...

Quickbooks desktop 2019 provides accounting software to the users where you can connect with quickbooks software from any where with just an internet connection at quickbooks online.if you have any query you can contact with us our support team available 24*7.https://thestandarddaily.com/quickbooks-pro/.

sam smith said...

Quickbooks provides accounting software to the users by which you can resolve your accounting related query data then you can contact with quickbooks support team our contact number is QuickBooks support phone number.

lucy jhonson said...

I am really very happy to visit your blog. Now I am found what I actually want. I check your blog every day and try to learn something from your blog.
Please keep it up to date like this. Thanks for sharing.
McAfee is the ultimate cybersecurity software range that keeps your devices protected round the clock. Although set up for any application is a time consuming and complicated process. However,
McAfee Activate activate setup is much simpler and convenient than expected.

Technical Support said...

I appreciate your efforts, keep sharing with us

Visit: WWW.WEBROOT.COM/SAFE

Technical Support said...

The Trend Micro antivirus auto update feature gives you the freedom to use your computer without any hesitation. Trend micro browser extension on the other hand immediately prevents you from visiting unwanted and malicious websites.

Visit: www.trendmicro.com.au/downloadme

safeactivation said...

AOL Desktop Gold is that the easy to use, all-in-one desktop you recognize and love with mail, browsing, search, content and now includes: Premium security measures to assist prevent your AOL account from being compromised and hacked.
aol desktop gold download

safeactivation said...

If you've got scanned your computer and verified it for malware and viruses, and located nothing, then it'll be safe to show off your Antivirus and Firewall for a short time until you discover what's wrong together with your software.
Aol Desktop Gold Download

safeactivation said...


Fantastic blog post.Much thanks again. Great.
www.malwarebytes.com/install

safeactivation said...

Norton users can protect their data and private information from etiquette, also because the features are excellent in it.
www.norton.com/setup

safeactivation said...

very nice, Thanks for sharing the most important information I am so glad to visit this blog.
www.malwarebytes.com/install

safeactivation said...

The users can update Webroot Internet Security where the requirement of computer gives complete protection, repair for the outdated version of Webroot Antivirus Software.
www.webroot.com/safe

safeactivation said...


Thanks for posting such an interesting post. I truly like it so much.
www.trendmicro.com/bestbuypc

Eleveck said...

Great article odin download for samsung . Thanks

ross taylor said...

While working on QuickBooks accounting software user can face some errors which obstructs users from working smoothly. On of them error a you can solve is QuickBooks Error 15241.

Security Software said...

Thanks for posting such an interesting post. I truly like it so much.
www.trendmicro.com/bestbuypc

Security Software said...

this is very nice blog
my.kaspersky.com

Anonymous said...

I think this performance issue applies for everything, even application like Quickbooks if you are using along with many more applications, every application tend to work and function slowly, I usually use Quickbooks Tool Hub if something happens to my Quickbooks application.

sam hatter said...

Open your gadget's application store and track down the "Prime Video" application.
Presently click on download and introduce the application in your gadget.
Open the "Prime Video" application and snap on "Register on the Amazon site".
Go to amazon.com/mytv on an internet browser of your gadget.
Enter your activation code.
Enjoy Prime Video.

Sumona Tiger said...

Webroot SecureAnywhere antivirus offers you online sacurity with the world's most remarkable cloud security arrangement. It examines fundamentally quicker contrasted with its rivals. It is upheld on every one of the essential stages like Linux, Windows, Mac, and Android gadgets. To get the subtleties to download, introduce and actuate your gadget, visit www.webroot.com/safe.

Cmissy said...

This is informative, if you are a student looking for Nursing Case Study Help Online get intouch

primevideo.com/mytv code said...

An AOL mail service that is free, an AOL login is an email service that is web-based. So you can access a free AOL email, all that is needed is a mobile device or a computer with a web browser program such as Mozilla Firefox, Internet Explorer, or Google Chrome, and an internet connection.

aol login
aol mail login
aol mail login problems

youmagine said...

If you desire to increase your know-how simply keep visiting this site and be updated with the newest news posted here.

사설토토
온라인카지노사이트
파워볼사이트
바카라

chilterntraveller said...

Greetings! This is my first visit to your blog! We are a group of volunteers and starting a new initiative in a community in the same niche. Your blog provided us beneficial information to work on.


토토사이트
카지노사이트
파워볼
바카라사이트

longisland said...

I seriously love your blog.. Excellent colors & theme. Did you build this website yourself? Please reply back as I’m planning to create my own website and would like to find out where you got this from or exactly what the theme is called.

스포츠토토
온라인카지노
파워볼게임
온라인바카라

Packers and Movers Bangalore said...

Packers and Movers Bangalore - Reliable and Verified Household Shifting Service Providers Give Reasonable ###Packers and Movers Charges. Cheap and Best Office Relocation Compare Quotation for Assurance for Local and Domestic House Shifting and Get estimates today to save upto 20%, ***Read Customer Reviews - @ Packers And Movers Bangalore

Couponsva said...

This is Couponsva, a professional blogger I enjoy writing on multiple callings with a firm grip on specialty include digital marketing, affiliate marketing, entertainment, and e-commerce blogs.

Packers And Movers Gurgaon said...

Really impressive post. I read it whole and going to share it with my social circules. I enjoyed your article and planning to rewrite it on my own blog Packers And Movers Gurgaon

Packers And Movers Delhi said...

Get Shifting/Relocation Quotation from ###Packers and Movers Delhi. Packers and Movers Delhi 100% Affordable and Reliable ***Household Shifting Services. Compare Transportation Charges and Save Time, Verified and Trusted Packers and Movers in Delhi, Cheap and Safe Local, Domestic House Shifting @ Packers And Movers Delhi