Posted on: 03/12/18 11:40pm
By: OMAL
Upgrading a very old version of Geeklog makes structure of tables change drastically on myisam. Should I run some mysql commands for optimizing the database if it has poor performance after upgrading?
Re: Should mysql be optimized when upgrading?
Posted on: 03/13/18 07:25am
By: Laugh
Sure.
Geeklog has some built in optimizations in the Geeklog Database Administration. This includes:
- Converting myisam to innodb
- Optimizing Tables
Re: Should mysql be optimized when upgrading?
Posted on: 03/13/18 08:47am
By: OMAL
Ok.
I tried it at demo site. It seems running just Mysql's OPTIMIZE TABLE Syntax.
Thanks.