FUDforum: FUDforum Installation Issues

Home » FUDforum » FUDforum Installation Issues » Migration Problem

Show: Today's Messages :: Polls :: Message Navigator

Re: Migration Problem [message #187570 is a reply to message #187569]

Mon, 10 September 2018 20:59

art

Messages: 35
Registered: June 2009

Karma:

Member

I regularly run the consistency check. Pretty much after everything I do to the tables.

Ever since I discovered the fud28_read duplicates, I've begun to manually delete them. In fact, I've even made a little PHP script that queries to find fud28_read table duplicates and deletes them. I run it in a cron job that fires each minute. That's one of the ugliest jury-rigs I've ever done, but it does keep the forum looking clean even though it's not. Laughing

As for the fud28_index size, I've done indexdb.php which drops the tables fud28_search, fud28_index and fud28_title_index before it starts gobbling them back up. I can see the table size go to zero, and I can see the disk space change using "df -k." I run it from the CLI using "nohup" and I monitor it with "tail -f" and I also watch "df -k" to see when the database is growing too large. I stop the reindexing process after it has done anywhere from 5000 to 15000 messages because space prohibits me from going any further. And then I do the consistency check. That lets users have access to the forum and it provides some of the data to FUDforum search engine.

I'm pretty much letting it limp along like that while I try to find the right solutions to the problems. Right now, I feel like I'm trying to solder SMD chips with the only tools in my bag being a sledgehammer and a blowtorch.

Report message to a moderator

[Message index]

		Migration Problem By: art on Mon, 10 September 2018 17:13
		Re: Migration Problem By: naudefj on Mon, 10 September 2018 20:03
		Re: Migration Problem By: art on Mon, 10 September 2018 20:59
		Re: Migration Problem By: art on Tue, 11 September 2018 22:37
		Re: Migration Problem By: art on Thu, 13 September 2018 15:34
		Re: Migration Problem By: art on Thu, 13 September 2018 21:18
		Re: Migration Problem By: art on Thu, 13 September 2018 22:51
		Re: Migration Problem By: art on Thu, 13 September 2018 22:57
		Re: Migration Problem By: art on Fri, 14 September 2018 00:28
		Re: Migration Problem By: art on Fri, 14 September 2018 15:42
		Re: Migration Problem By: art on Fri, 14 September 2018 19:40
		Re: Migration Problem By: art on Fri, 14 September 2018 20:30
		Re: Migration Problem By: art on Fri, 14 September 2018 22:49
		Re: Migration Problem By: GaryM on Fri, 14 September 2018 23:45
		Re: Migration Problem By: art on Fri, 14 September 2018 23:47
		Re: Migration Problem By: art on Sat, 15 September 2018 16:53
		Re: Migration Problem By: naudefj on Sat, 15 September 2018 17:34
		Re: Migration Problem By: art on Sun, 16 September 2018 00:14
		Re: Migration Problem By: GaryM on Mon, 17 September 2018 23:32

Previous Topic:	upgrade from 3.07 to 3.09 fails
Next Topic:	Failing to change forum to RTL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 08:53:21 GMT 2025

Total time taken to generate the page: 0.05062 seconds