Support

Admin Tools

#17226 Optimize database

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
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by on Saturday, 28 September 2013 18:00 CDT

Monday, 26 August 2013 15:15 CDT

pixelstext
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes *
Joomla! version: (2.5.14)
PHP version: (5.3.17)
MySQL version: (5.527)
Host: (Easyhosting, Netherlands)
Admin Tools version: (2.5.6)

Description of my issue:

I want to optimize the database through Admin Tools Pro.
After choosing "repair and optimize" I get a popup with a progress bar. It fills to about 50% and then I get a white screen (in popup). I tried several times; each time with same result.

I guess I do get a message that database is optimized/repaired yes or no....?!


* I have read this >
Repair & Optimise Tables will run the repair and optimisation process on all of your site's tables. If the process hangs for a long time after the first time you use it, run it again. The usual problem is that the Joomla! sessions table is so bloated that PHP times out waiting for your database server to optimise this table.
> I'm the only user, how to clean up session table?


Thanks for your help Nicholas

Monday, 26 August 2013 15:53 CDT

nicholas
You seem to have a very big table that takes a very long time to repair. Please contact your host and ask them to manually run a repair & optimise on your MySQL tables.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Tuesday, 27 August 2013 14:54 CDT

pixelstext
Hi Nicholas,

Indeed the site has about 1200 articles and a lot of extensions.

I did a repair & optimize on tables through DirectAdmin.
In about 50% of the tables it gives a result: Table does not support optimize, doing recreate + analyze instead. The other 50% gives: OK.

Still ask the host for another repair & optimize?!

Thanks,
Wim


Wednesday, 28 August 2013 01:46 CDT

nicholas
If you retry using Admin Tools does it still get stuck?

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 28 August 2013 07:19 CDT

pixelstext
Just tried, same error, stops now already before 50% in progress bar.

Wednesday, 28 August 2013 10:56 CDT

nicholas
It seems that the problem is with all the tables which MySQL says cannot be optimised. You will not be able to use that feature on your database.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 28 August 2013 10:57 CDT

nicholas
I forgot to clarify: you do not need that feature if your database tables' engine is one that doesn't support repairing and optimising the tables, so there's no loss there.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 28 August 2013 13:46 CDT

pixelstext
I understand.
After complaining about slow saving/loading in backend of my site, my host did suggest to optimize the tables.
Meanwhile performance increased a lot after change setting of JCE editor.

Thanks for your answer.

Thursday, 29 August 2013 15:49 CDT

nicholas
You're welcome, Wim!

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Saturday, 28 September 2013 18:00 CDT

System Task
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.
Edited by on 2013-09-28 18:00 CDT

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!