j25_redirect_links table is HUGE!

Discussion regarding Joomla! 2.5 Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
dougevans
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Tue May 11, 2010 2:31 am

j25_redirect_links table is HUGE!

Postby dougevans » Wed Dec 16, 2015 8:23 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Tue May 11, 2010 2:31 am

Re: j25_redirect_links table is HUGE!

Postby dougevans » Thu Dec 17, 2015 11:57 pm

Wow, no one has a clue huh?

dougevans
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Tue May 11, 2010 2:31 am

Re: j25_redirect_links table is HUGE!

Postby dougevans » Wed Mar 02, 2016 10:34 pm

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

User avatar
sudo-web
Joomla! Ace
Joomla! Ace
Posts: 1326
Joined: Fri Jan 22, 2016 7:10 pm
Location: Vienna - Austria
Contact:

Re: j25_redirect_links table is HUGE!

Postby sudo-web » Wed Mar 02, 2016 11:48 pm

Do you need the Joomla! Redirect function? If not just disable the plugin.
Visit me on my Webdesign Webpage: https://www.posit.at

dougevans
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Tue May 11, 2010 2:31 am

Re: j25_redirect_links table is HUGE!

Postby dougevans » Thu Mar 03, 2016 2:44 am

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

User avatar
fcoulter
Joomla! Ace
Joomla! Ace
Posts: 1540
Joined: Thu Sep 13, 2007 11:39 am
Location: UK
Contact:

Re: j25_redirect_links table is HUGE!

Postby fcoulter » Thu Mar 03, 2016 10:46 am

Yes I would just drop every entry in that table, through PHPMyAdmin or similar.
http://www.spiralscripts.co.uk for Joomla! extensions
http://www.fionacoulter.com/blog my personal website
Security Forum moderator
VEL team member
"Wearing my tin foil hat with pride"

User avatar
sudo-web
Joomla! Ace
Joomla! Ace
Posts: 1326
Joined: Fri Jan 22, 2016 7:10 pm
Location: Vienna - Austria
Contact:

Re: j25_redirect_links table is HUGE!

Postby sudo-web » Thu Mar 03, 2016 10:58 am

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.
Visit me on my Webdesign Webpage: https://www.posit.at

User avatar
fcoulter
Joomla! Ace
Joomla! Ace
Posts: 1540
Joined: Thu Sep 13, 2007 11:39 am
Location: UK
Contact:

Re: j25_redirect_links table is HUGE!

Postby fcoulter » Thu Mar 03, 2016 11:09 am

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.
http://www.spiralscripts.co.uk for Joomla! extensions
http://www.fionacoulter.com/blog my personal website
Security Forum moderator
VEL team member
"Wearing my tin foil hat with pride"

dougevans
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Tue May 11, 2010 2:31 am

Re: j25_redirect_links table is HUGE!

Postby dougevans » Thu Mar 03, 2016 3:26 pm

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

dougevans
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Tue May 11, 2010 2:31 am

Re: j25_redirect_links table is HUGE!

Postby dougevans » Thu Apr 14, 2016 5:29 pm

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?

User avatar
fcoulter
Joomla! Ace
Joomla! Ace
Posts: 1540
Joined: Thu Sep 13, 2007 11:39 am
Location: UK
Contact:

Re: j25_redirect_links table is HUGE!

Postby fcoulter » Fri Apr 15, 2016 4:17 pm

It sounds like the information about the size is being cached.
http://www.spiralscripts.co.uk for Joomla! extensions
http://www.fionacoulter.com/blog my personal website
Security Forum moderator
VEL team member
"Wearing my tin foil hat with pride"

dougevans
Joomla! Apprentice
Joomla! Apprentice
Posts: 31
Joined: Tue May 11, 2010 2:31 am

Re: j25_redirect_links table is HUGE!

Postby dougevans » Fri Apr 15, 2016 6:12 pm

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.

User avatar
fcoulter
Joomla! Ace
Joomla! Ace
Posts: 1540
Joined: Thu Sep 13, 2007 11:39 am
Location: UK
Contact:

Re: j25_redirect_links table is HUGE!

Postby fcoulter » Mon Apr 18, 2016 4:12 pm

Actually it may be an issue with mysql, I found this: http://stackoverflow.com/questions/1270944/mysql-innodb-not-releasing-disk-space-after-deleting-data-rows-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.
http://www.spiralscripts.co.uk for Joomla! extensions
http://www.fionacoulter.com/blog my personal website
Security Forum moderator
VEL team member
"Wearing my tin foil hat with pride"


Return to “Performance - Joomla! 2.5”

Who is online

Users browsing this forum: No registered users and 5 guests