ENART.XN--W1YW3PUTK.COM
welcome to my space |
HOME  Mass Duplicate Problem Causing MySQL Error & Server Issues |
| Mass Duplicate Problem Causing MySQL Error & Server Issues | | Published by: rose 2010-03-11 |
My VB has started to go down frequently, I contacted my server to see what the problem was, and they said it was due to the massive database size of the vb board. So after hearing that, I decided to start pruning some posts. While doing this I noticed there was a extremely large amount of duplicate posts of the exact same thing. We were using the RSS importer for some time and over time it accumulated way to many posts for my taste. I simply forgot it was still running because I wasn't checking the forums frequently up until they began getting more traffic, and it started causing server issues effecting my main site outside of the vb.
So my question is, would it be ok to alphabetically sort the threads via phpmyadmin, and remove them from there, leaving one with that title? Or would this effect the rest of the site and cause errors?
If there are any other ways to do this that will not be a heavy server strain please let me know. Right now none of the forums will load the threads in order to delete them that way, and the duplicate delete in admin hasn't worked due to the large amount of posts. I left it there doing some thing for hrs then it finally just loaded a white page.
i have never tryed this but i wonder if you could go to admin control>>Maintenance>>Update Counters>>Delete Duplicate Threads
just a suggestion.
edit: ahhhh sorry i see you tryed this already sorry.
No prob. I should have stated that I tried that first so every one knows what I already did. Thanks for the suggestion though.
I'm looking at the db via phpmyadmin and don't really see any reason it would cause problems deleting threads that way. If any one has tried this before please let me know.
I was thinking of deleting them this way, then when the site loads, go to the admin and rebuild every thing. Sound logical?
Any one have any tips?
So my question is, would it be ok to alphabetically sort the threads via phpmyadmin, and remove them from there, leaving one with that title? Or would this effect the rest of the site and cause errors?
I don't think that will work, and it's generally a bad idea to remove data directly from that database with phpMyAdmin anyway.
Please see this thread for help with optimizing your server:
http://www.vbulletin.com/forum/showthread.php?threadid=70117
Then post the requested info in a new thread in that forum.
Also please note that we do this as a courtesy but optimizing servers is not really a part of vBulletin support.
man i really would help you if i could, i cant believe you have no reply yet.
 Pull Down Menu Options
 birthday error |
#If you have any other info about this subject , Please add it free.# | |
|