The secure CMS.

Welcome to Geeklog, Anonymous Sunday, July 20 2025 @ 12:25 am EDT

Geeklog Forums

Should mysql be optimized when upgrading?

 New Topic  Post Reply
 03/12/18 11:40pm (Read 2,534 times)  
Status: offline
Forum User
Regular Poster
Registered: 12/06/17
Posts: 107
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?
 Quote
 03/13/18 07:25am  
Status: offline
Site Admin
Admin
Registered: 09/27/05
Posts: 1475
Sure.

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

- Converting myisam to innodb
- Optimizing Tables
 Quote
 03/13/18 08:47am  
Status: offline
Forum User
Regular Poster
Registered: 12/06/17
Posts: 107
Ok.
I tried it at demo site. It seems running just Mysql's OPTIMIZE TABLE Syntax.
Thanks.
 Quote
 New Topic  Post Reply
All times are EDT. The time is now 12:25 am.
  • 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