Last post 4 min ago

Posts last week 141

Average response time last week 4 hours 42 min

All time posts 67801

All time tickets 10476

All time avg. posts per day 21

All time avg response time 3 hours 53 min last_week_start: 2024-04-14 00:00:00 last_week_end: 2024-04-20 23:59:59 last_week_raw_avg_resp: 16950.2000 last_week_raw_avg_resp_to_time: 4 hours 42 min

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.

#7743 – High number of 404 logs crashing the site

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.

Friday, 30 April 2021 21:15 UTC

Donnie

Hello,

Our site kept going down with mySQL errors. When we looked at the server, we noticed that this query was what was taking down the site.

SELECT `oldurl`, `newurl`, `id`, `rank`, `dateadd`, soundex(`oldurl`) AS soundex_value FROM `sh404sef_urls`

Upon further inspection of the table, we noticed that it has 800,000+ records.

Why is the software generating so many records? It's causing sh404 queries to run slow, the website loading performance slow, and sometimes makes sh404 makes sh404 busy.

Monday, 03 May 2021 09:22 UTC

wb_weeblr

Upon further inspection of the table, we noticed that it has 800,000+ records.

That is totally fine and not excessive at all. This table contains both valid URLs and 404s requests.

Why is the software generating so many records?

sh404SEF does not generate any single records. It only records those generated by Joomla and your site.

It's causing sh404 queries to run slow, the website loading performance slow

sh404SEF runs very fast, even with multiple times the number of records you have in the urls table.

SELECT `oldurl`, `newurl`, `id`, `rank`, `dateadd`, soundex(`oldurl`) AS soundex_value FROM `sh404sef_urls`

This query is a very special one, that does not happen on normal pages. It happens on 404s. When a 404 happens, the "Similar URLs" plugin search the database for similar URLs and offers them to your visitors faced with a 404 to try keep them on the site.

Now this request is very heavy because it does not just search for exact matches but also for words that sound similar. If your server cannot cope with this workoad, then best is to simply disable the "Similar URL" plugin. You'll likely have to change also the text of your 404 error page (under "Error page" in sh404SEF configuration) to your preferred message.

Best regards

Yannick Gaultier

weeblr.com / @weeblr

Thursday, 03 June 2021 05:34 UTC

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

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.