Jump to content

Splitting posts table + mysql-proxy

Featured Replies

Posted

How hard is it to split the posts table and manage queries with mysql-proxy?

Has this been done before? :huh:

..and why would you want to do this?

..and why would you want to do this?



posts table is TOO big at this point (if we don't prune heavily every couple weeks, we hit 2 million rows very quickly).

Also- we're suffering from error-500s (using lighttpd fastcgi) etc. etc.

But mainly: splitting the posts table might help us a great deal - maybe even splitting it into more than just two smaller tables.

Ouch...Quite honestly, I agree. Now I've never had a forum get as big as RSC, but I really can see where it would cause a problem. I don't know if this is possible or not, but if it's not, it should be. If it is, I really want to see how it's done.


By the way, sorry. I contribute to some of those posts as well. :unsure:

What would this entail on our end? Wouldn't you handle this primarily in MySQL?

  • 10 months later...

Now that partitioning is in mySQL 5.1 - how do you recommend I partition the posts table using mySQL 5.1 ?

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.