j25_redirect_links table is HUGE!
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.
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.
-
- Joomla! Apprentice
- Posts: 31
- Joined: Tue May 11, 2010 2:31 am
j25_redirect_links table is HUGE!
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
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
-
- Joomla! Apprentice
- Posts: 31
- Joined: Tue May 11, 2010 2:31 am
Re: j25_redirect_links table is HUGE!
Wow, no one has a clue huh?
-
- Joomla! Apprentice
- Posts: 31
- Joined: Tue May 11, 2010 2:31 am
Re: j25_redirect_links table is HUGE!
I am going to try again and bump this. Anyone have ANY ideas please?
- sudo-web
- Joomla! Ace
- Posts: 1325
- Joined: Fri Jan 22, 2016 7:10 pm
- Location: Vienna - Austria
- Contact:
Re: j25_redirect_links table is HUGE!
Do you need the Joomla! Redirect function? If not just disable the plugin.
Visit me on my Webdesign Webpage: https://www.posit.at
-
- Joomla! Apprentice
- Posts: 31
- Joined: Tue May 11, 2010 2:31 am
Re: j25_redirect_links table is HUGE!
Thanks sudo-web! I appreciate it. I suppose I could then clear that table in the database?
- fcoulter
- Joomla! Ace
- Posts: 1685
- Joined: Thu Sep 13, 2007 11:39 am
- Location: UK
- Contact:
Re: j25_redirect_links table is HUGE!
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"
http://www.fionacoulter.com/blog my personal website
Security Forum moderator :: VEL team member
"Wearing my tin foil hat with pride"
- sudo-web
- Joomla! Ace
- Posts: 1325
- Joined: Fri Jan 22, 2016 7:10 pm
- Location: Vienna - Austria
- Contact:
Re: j25_redirect_links table is HUGE!
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
- fcoulter
- Joomla! Ace
- Posts: 1685
- Joined: Thu Sep 13, 2007 11:39 am
- Location: UK
- Contact:
Re: j25_redirect_links table is HUGE!
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.
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"
http://www.fionacoulter.com/blog my personal website
Security Forum moderator :: VEL team member
"Wearing my tin foil hat with pride"
-
- Joomla! Apprentice
- Posts: 31
- Joined: Tue May 11, 2010 2:31 am
Re: j25_redirect_links table is HUGE!
Thanks guys! My backup is now 1.5GB! I'll give it a try...
-
- Joomla! Apprentice
- Posts: 31
- Joined: Tue May 11, 2010 2:31 am
Re: j25_redirect_links table is HUGE!
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
- Joomla! Ace
- Posts: 1685
- Joined: Thu Sep 13, 2007 11:39 am
- Location: UK
- Contact:
Re: j25_redirect_links table is HUGE!
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"
http://www.fionacoulter.com/blog my personal website
Security Forum moderator :: VEL team member
"Wearing my tin foil hat with pride"
-
- Joomla! Apprentice
- Posts: 31
- Joined: Tue May 11, 2010 2:31 am
Re: j25_redirect_links table is HUGE!
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
- Joomla! Ace
- Posts: 1685
- Joined: Thu Sep 13, 2007 11:39 am
- Location: UK
- Contact:
Re: j25_redirect_links table is HUGE!
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.
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"
http://www.fionacoulter.com/blog my personal website
Security Forum moderator :: VEL team member
"Wearing my tin foil hat with pride"