j25_redirect_links table is HUGE!

[dougevans]

Hello All,

I have inherited a Joomla 2.5 website with a HUGE database - over 1GB. I know that this site was upgraded from a 1.5 site and the largest table is the j25_redirect_links which is a whopping 559mb! It appears to be adding on every day. Can anyone give me some direction on how to stop the madness or if I can remove the data? Not sure if this is helpful but it is using sh404SEF component but nothing else out of the ordinary.

Thanks for ANY help,
Doug

[dougevans]

Wow, no one has a clue huh?

[dougevans]

I am going to try again and bump this. Anyone have ANY ideas please?

[sudo-web]

Do you need the Joomla! Redirect function? If not just disable the plugin.

[dougevans]

Thanks sudo-web! I appreciate it. I suppose I could then clear that table in the database?

[fcoulter]

Yes I would just drop every entry in that table, through PHPMyAdmin or similar.

[sudo-web]

As far as I remember there should be no conflict in deleting all entries in the table. I would suggest making a backup in PhpMyAdmin first.

[fcoulter]

I have deleted all the entries in the past and not had any problems on my site. The redirect plugin when it was introduced was a major nuisance, it was enabled by default and just clogged up the database. It works better now, although I find you can still end up with a lot of entries, I periodically clear all the unpublished entries through PHPMyAdmin, it is a lot easier than trying to delete them all through the Joomla admin. I wish there was a way through the Joomla admin to just purge all the unpublished entries in one go.

As you say, make a backup first.

[dougevans]

Thanks guys! My backup is now 1.5GB! I'll give it a try...

[dougevans]

I have deleted all the contents from the redirect_links table but the database is still the same size? I have also done a test and deleted the complete table but the database remains the same size? How can that be? The table's content said it was over 800mb before I deleted it, now it says 45kb. Does anyone have any clue as to why the database is remaining the same size please?

[fcoulter]

It sounds like the information about the size is being cached.

[dougevans]

Thank you for the response! Does this mean the size is not real? When I transfer the backup to another drive it remains the same size.

[fcoulter]

Actually it may be an issue with mysql, I found this: http://stackoverflow.com/questions/1270 ... from-table

It sounds like there is not an easy fix. You might try making a new working database, by exporting the sql to a download file, then create a new empty database, re-import the sql. When it is imported successfully then switch the Joomla site configuration to use the shiny new database. I have not actually had a problem on this scale myself though, so I can only offer it as a suggestion.