Grouper Users - Open Discussion List

[Jeff McCullough <>]

Is that special to MySQL or recommended for any DB?

> On Feb 13, 2018, at 1:35 PM, Wessel, Keith 
> <>
>  wrote:
> 
> All,
> 
> Last week at a TIER face-to-face, Shilen told us that we needed to be doing 
> regular runs of table optimizations on our MySQL Grouper tables. This is 
> easy enough to do, but when you try to do an optimization on innodb tables, 
> MySQL informs you that optimize isn't supported and that it's using 
> recreate + analyze.
> 
> I'm pretty sure that innodb is the default storage engine in MySQL 5.7, and 
> I assume that's why the tables Grouper created use that storage engine.
> 
> Are others who are using MySQL using different storage engines for the 
> Grouper tables that support a direct optimize? I suspect we could optimize 
> faster if we were using a storage engine that didn't have to fall back on 
> recreate + analyze.
> 
> Keith
>