• Home
  • Get help
  • Ask a question
Last post 3 min ago
Posts last week 69
Average response time last week 48 min
All time posts 43438
All time tickets 6969
All time avg. posts per day 22

Helpdesk is open from Monday through Friday CET

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
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
yorai85
Thursday, 25 August 2016 19:03 UTC
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
 
wb_weeblr
Thursday, 25 August 2016 23:53 UTC
thank you very much for the fast response.

that fixed the issue.

i was unawer this was only debugging features.

thanks again

yorai
yorai85
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.