adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

Consider using InnoDB instead of MyISAM? #500

New Issue
Closed
opened 2026-10-05 00:01:23 +02:00 by adam · 2 comments
adam commented 2026-10-05 00:01:23 +02:00
Owner
Copy link
Copy source

Hi,

isn't there an ongoing effort or discussion to switch from MyISAM engine to InnoDB? MyISAM is not really supported (considered "still experimental": https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_replicate_myisam) with Galera clustering, and since I've deployed Piwigo into MariaDB cluster, I had to mysqldump the initial DB, "fix" all create table statements from MyISAM to InnoDB and re-import the DB. It seems to work now, but I'm sure some more testing will be needed.

Thank you in advance.
Martin

Hi, isn't there an ongoing effort or discussion to switch from MyISAM engine to InnoDB? MyISAM is not really supported (considered "still experimental": https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_replicate_myisam) with Galera clustering, and since I've deployed Piwigo into MariaDB cluster, I had to mysqldump the initial DB, "fix" all create table statements from MyISAM to InnoDB and re-import the DB. It seems to work now, but I'm sure some more testing will be needed. Thank you in advance. Martin <!-- github-sync-id:183163037 -->
adam closed this issue 2026-10-05 00:01:23 +02:00
adam commented 2026-10-05 00:01:24 +02:00
Author
Owner
Copy link
Copy source

Hi @martinstefany

MyISAM has 2 advantages over InnoDB: performances on reads (what Piwigo does nearly all the time) and full-text search (used for quick search). InnoDB has full-text search only starting with MySQL 5.6.

Just to give an idea on how MySQL 5.6 is deployed : current Debian 8 (the stable version) is only MySQL 5.5!

So for now I would say it's still early to switch to InnoDB :-/

Hi @martinstefany MyISAM has 2 advantages over InnoDB: performances on reads (what Piwigo does nearly all the time) and full-text search (used for quick search). InnoDB has full-text search only starting with MySQL 5.6. Just to give an idea on how MySQL 5.6 is deployed : current Debian 8 (the stable version) is only MySQL 5.5! So for now I would say it's still early to switch to InnoDB :-/ <!-- github-comment-id:254148164 -->
adam commented 2026-10-05 00:01:25 +02:00
Author
Owner
Copy link
Copy source

I close this issue, but it doesn't mean Piwigo won't make the move in the future. It's just "too early".

I close this issue, but it doesn't mean Piwigo won't make the move in the future. It's just "too early". <!-- github-comment-id:258458566 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#500