Welcome to Geeklog Saturday, October 20 2018 @ 08:30 pm EDT

Geeklog Forums

Should mysql be optimized when upgrading?


Status: offline

OMAL

Forum User
Chatty
Registered: 06/12/17
Posts: 59
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?

Status: offline

Laugh

Site Admin
Admin
Registered: 27/09/05
Posts: 1308
Sure.

Geeklog has some built in optimizations in the Geeklog Database Administration. This includes:

- Converting myisam to innodb
- Optimizing Tables
One of the Geeklog Core Developers.

Status: offline

OMAL

Forum User
Chatty
Registered: 06/12/17
Posts: 59
Ok.
I tried it at demo site. It seems running just Mysql's OPTIMIZE TABLE Syntax.
Thanks.

All times are EDT. The time is now 08:30 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content