1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

MySQL Partitioning

Discussion in 'MySQL' started by retwedia, Jan 8, 2013.

0
  1. #1
    Hello, I am working on a search engine that indexes classified ads from Craigslist and Backpage. The system indexes about 3,000,000 ads a day and each ad stays in the system for 30 days. Once I hit 30 days from release I should always have around 90,000,000 ads in the system. Working with this many ads is very demanding, I think I need to set up partitioning.


    Each ad is inserted into the ads table with a state id, city id, category id and subcategory id. I really wanted to partition my ads table by State but I have no idea how to. I've read some tutorials and can't get anywhere.
     
    retwedia, Jan 8, 2013 IP