Support

Admin Tools

#39272 Repair and Optimize Tables - Host Error

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

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

Environment Information

Joomla! version
10.12
PHP version
8.0.29
Admin Tools version
n/a

Latest post by tampe125 on Tuesday, 01 August 2023 05:32 CDT

Ulysses

Not certain if Cloudflare has anything to do with it.

But would really love to get our repair and optimize for our database, as its needs some love from your amazing tools.

However, when I run it, it will work for a bit:

https://app.screencast.com/Xvt9cvgYPALWJ

However, its not long before this error pops up,  "A timeout occurred"

https://app.screencast.com/eyUmQmhJ0idgc

https://app.screencast.com/u2BeNcRm8zZPz


I suspect it has something to do with my tables, as I ran a restore kickstart akeeba backup after an issue we had.

Or the fact that the database is big:  12077.00 MB

Here are our current specs from our server, if this helps:
https://app.screencast.com/SePj6MsoznbUU


If it helps, below is our current php settings and you will see plenty of time for execution:
https://app.screencast.com/EOPOa7T80DCzz
changed from 30 to 600..

Yet, we are still receiving this error..


 

tampe125
Akeeba Staff

Hello,

Admin Tool provides some handy tools to perform maintenance operations on your database, however you might end up with a timeout if the tables are very large or you could be blocked by CloudFlare if we page the same URL again again too many times.

First of all I'd suggest you to exclude the backend from CloudFlare, since the traffic load is not so large and you might get errors since the server is serving you a "cached" version of the data.

If you still have troubles, I think you'll have to work directly on the database using your database management tool, since it means that you have very large tables and the PHP execution dies when working on very large tables.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Ulysses

Hi Regarding:

you might end up with a timeout if the tables are very large or you could be blocked by CloudFlare if we page the same URL again again too many times.

Yes, I do have a fairly large database, that could be the reason and will try doing directly via phpmyadmin.  Is there any particular order; such as optimize, then repair, etx etc?

 

'd suggest you to exclude the backend from CloudFlare, since the traffic load is not so large and you might get errors since the server is serving you a "cached" version of the data.

I believe you are talking about doing this within Cloudflare, correct?

https://app.screencast.com/VX4Y3p516M3W7

If so, yes this was completed upon setup.  If something else, please let me know and I will jump on it.

Thanks for your time.

tampe125
Akeeba Staff

Hello,

you can perform the maintenance functions as you wish, there isn't a particular order.

Regarding CloudFlare, that ok, you configured it correctly.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!