Last post 7 min ago

Posts last week 141

Average response time last week 4 hours 42 min

All time posts 67794

All time tickets 10475

All time avg. posts per day 21

Helpdesk is open from Monday through Friday CET

Please create an (free) account to post any question in the support area.

Please check the development versions area. Look at the changelog, maybe your specific problem has been resolved already!

All tickets are private and they cannot be viewed by anyone. We have made public only a few tickets that we found helpful, after removing private information from them.

#3009 – database size

Posted in ‘sh404SEF’

This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Monday, 28 November 2016 08:50 UTC

ifootpath

Hi

The sh404sef_urls_src is now 2.9gb

I do not have record on = see screen grab

What can I do to reduce the size of the database?

Many thanks

Richard

Monday, 28 November 2016 08:59 UTC

wb_weeblr

Hi

This would happen when "Source URL recording is left enabled for too long. It's a debug feature that records a lot of data and should not only be enabled for short period of time.

You can:

- Purge URLs from the sh404SEF control panel -> that has negative consequences such has creating 404s for users until URLs have been created again, and loosing all "Main URL" selection you may have done in case of duplicates URLs. Not advised

- Empty that db tables using PHPMyadmin or your hosting company control panel. Do not delete that table, just empty it.

Rgds

Monday, 28 November 2016 09:02 UTC

ifootpath

Thank you for the quick reply - I will empty the db tables as you suggest. (I will back-up first)

Thanks

Monday, 28 November 2016 09:04 UTC

wb_weeblr

I will empty the db tables

OK, just to be sure, empty only the sh404sef_urls_src table, not any other table (you put an s to "tables"!)

Rgds

Monday, 28 November 2016 09:20 UTC

ifootpath

Yes - will do thanks for that.

R

Monday, 28 November 2016 13:06 UTC

ifootpath

Looks like to worked well - thank you for your help

R

Monday, 28 November 2016 13:39 UTC

wb_weeblr

Hi

Glad to hear that! Closing this ticket now, feel free to open a new one as needed. If you do so, please mention this ticket number in the new one.

If you created any superadmin account for us, be sure to delete or block it now to avoid unnecessary risk in the future.

Be sure to also check out wbAMP, our new Accelerated Mobiles pages plugin for Joomla - the next big thing is SEO, direct from Google themselves!

Rgds

This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.