?
avatar Chacapamac
Chacapamac
1 Feb 2019

Steps to reproduce the issue

Try to optimize database in PHPMyAdmin

Expected result

Just Optimize

Actual result

Message: Table

System information (as much as possible)

PHP 7.2.1 - MYSQL 5.6.38

Additional comments

Collation UTF8B4 Type: InnoDB

Is this normal?

avatar Chacapamac Chacapamac - open - 1 Feb 2019
avatar joomla-cms-bot joomla-cms-bot - change - 1 Feb 2019
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 1 Feb 2019
avatar HLeithner
HLeithner - comment - 1 Feb 2019

The complete message would be nice but anyway thats normal and the table get recreated.

Also this has not much todo with Joomla.

avatar HLeithner HLeithner - change - 1 Feb 2019
Status New Closed
Closed_Date 0000-00-00 00:00:00 2019-02-01 17:33:08
Closed_By HLeithner
avatar HLeithner HLeithner - close - 1 Feb 2019
avatar Chacapamac
Chacapamac - comment - 2 Feb 2019

I just remark this and wonder if it was the same for older version of Joomla, I just test and yes, same with older version of Joomla.

YOU CAN CLOSE THIS!

MORE EXPLANATION HERE...
Likely, you're doing OPTIMIZE on an InnoDB table (table using the InnoDB storage engine, rather than the MyISAM storage engine).

InnoDB doesn't support the OPTIMIZE the way MyISAM does. It does something different. It creates an empty table, and copies all of the rows from the existing table into it, and essentially deletes the old table and renames the new table, and then runs an ANALYZE to gather statistics. That's the closest that InnoDB can get to doing an OPTIMIZE.

The message you are getting is basically MySQL server repeating what the InnoDB storage engine told MySQL server:

Table does not support optimize is the InnoDB storage engine saying...

"I (the InnoDB storage engine) don't do an OPTIMIZE operation like my friend (the MyISAM storage engine) does."

"doing recreate + analyze instead" is the InnoDB storage engine saying...

"I have decided to perform a different set of operations which will achieve an equivalent result."

Add a Comment

Login with GitHub to post a comment