BaDTunes Music Store

1
BaDTunes Music Store

• Brett Stone-Gross
• Dominic Metzger
• CS290F - Scalable Internet Services
• University of California, Santa Barbara December
  14th 2006

2
Website Functionality

• User Functionality
• Users can add ratings for playlists or songs and
  be able to change their own rating
• Search by Artist, Album, Song
• Browse music
• View top rated songs
• View all ratings for particular songs
• Create custom playlists
• Option to purchase a CD consisting of a custom
  playlist
• Embedded Music Player From Rhapsody so that users
  can listen to music
• Share/View other users custom playlists 

3
Website Functionality

• Admin Functionality
• Add/Remove/Edit/List
• Ratings
• Users
• Music
• Orders

4
Website Scaling

• Initial Performance
• Problems with Innodb COUNT queries
• Slow ORDER BY queries
• Optimizations
• Memcached
• Switching from Innodb to MyISAM
• Placing indexes on the right fields

5
Initial Results
6
MySQL getting "Railed"

• Time 061203 35758
• User_at_Host badtunesbadtunes _at_ domU-12-31-
• Query_time 2 Lock_time 0 Rows_sent 1
  Rows_examined 92992
• SELECT count() AS count_all FROM musics
• Time 061203 35804
• User_at_Host badtunesbadtunes _at_ domU-12-31-
• Query_time 2 Lock_time 0 Rows_sent 10
  Rows_examined 93002
• SELECT FROM musics ORDER BY average_rating
  desc LIMIT 0, 10

7
Initial Results
8
MySQL getting "Railed"
9
Putting MySQL on "Rails"

• Switching to MyISAM
• To fix COUNT() for Innodb Tables problem
• Added index to the average_rating field

10
MySQL on Rails!
11
After Improvements
12
After Improvements
13
Questions?

• Contact Information
• bstone_at_cs.ucsb.edu
• metzger_at_cs.ucsb.edu
• Costumer Support
• 1-800 BaDTunes