Welcome to Geeklog, Anonymous Sunday, July 20 2025 @ 12:25 am EDT
Geeklog Forums
Should mysql be optimized when upgrading?
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?
30
21
Quote
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
Geeklog has some built in optimizations in the Geeklog Database Administration. This includes:
- Converting myisam to innodb
- Optimizing Tables
23
16
Quote
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.
I tried it at demo site. It seems running just Mysql's OPTIMIZE TABLE Syntax.
Thanks.
27
17
Quote
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