Last post 1 hour 22 min ago

Posts last week 89

Average response time last week 30 min

All time posts 67739

All time tickets 10468

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.

#2648 – huge database table - sh404sef url_src

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.

Thursday, 25 August 2016 18:32 UTC

yorai85

hello dear support team,

i'm runing into a problem where my site's backups keep getting larger & larger, to the point of 4.5GB - unproportional to the site's content.

when checking the backup files we located 1 of your (sh404SEF) DB tables - named url_src. this table gorws to the extent of 5GB.
can you pleas explain the meaning of this table and how to make it's size tollerable. does it relate to any conifguration in sh404SEF that i can change?

thank you

yorai ronen

Thursday, 25 August 2016 19:03 UTC

wb_weeblr

Hi

This is because you have enabled a debugging feature, and record a lot of details about each URL, each time they are displayed. This is a debug-only feature and should not be enabled on love site. That's why there's a big orange warning on your dashboard for instance.

Read the corresponding documentation page for disabling it.

There is no button to delete that data directly, as this is a debugging feature. You can manually empty the db table using PHPMyAdmin for instance or a similar tool. Don't delete the table, just empty it.

Rgds

Thursday, 25 August 2016 23:53 UTC

yorai85

thank you very much for the fast response.

that fixed the issue.

i was unawer this was only debugging features.

thanks again

yorai

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.