Recent content by enivid

Kudos to @Sim and @Masetrix! Upgrading to MariaDB 10.6.5 and applying some of the MySQLTuner recommendations did the trick. It improved DB performance and dealt with all the slow queries I had.

I can always upgrade the server - I am just trying to do what I can with software before resorting to that.

No, it has nothing to do with PHP. I was talking about max_statement_time getting exceeded. A dedicated server with HDD.

Because for the backup to finish I already had to set max execution time to 10 minutes. That's not too good for the overall server setup.

More than 10 minutes.

No, it's the third-party service connecting via SSH and doing the job, but the result is probably the same as a cron job doing that.

Yes.

Hello all! Our forum got pretty large and with 160k+ posts it takes quite a long time to backup the database. Is there any guide or tips for improving the database backup speed for XenForo? We are using XF 2.2 with MariaDB 10.1.

That'd be 6 hours of work wasted to get a user to do a one click to select the email thread and one click to delete it. Besides, you will start getting a challenge on every recaptcha after a certain number of requests during a period of time. This isn't comparable to when there is no rate...

@pegasus That's not an issue at all. With captcha, the rate of email requests will be very low.

This scenario is currently impossible because: 1. When requesting a password reset while not being logged in, a captcha is used. 2. When requesting a password while being logged in, the password will only be sent to a confirmed email address.

Currently (XF2.2.2), when a user doesn't have a password set for their account and requests a password via the "Password and security" page, they can send any number of requests without any restrictions. Of course, they can only flood their own email account in such a way, but this also...

I am interested in an add-on that would safely and correctly remove all tags with 0 use count. Is there an existing tool that does this on XF 2.1?

I can also vouch for @fahad ashraf. He created a very reliable custom add-on for me. Normally, I would have some problems with custom add-ons show up after some time. In this case, everything was done on a high-quality, really professional, level. It still works flawlessly.

This still would be a useful feature.