Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted September 29, 200717 yr How hard is it to split the posts table and manage queries with mysql-proxy? Has this been done before? :huh:
September 29, 200717 yr ..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.
September 29, 200717 yr 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:
August 21, 200816 yr 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.