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.

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