Opened 7 years ago
Closed 7 years ago
#2049 closed task (fixed)
Upgrade MySQL tables from MyISAM to InnoDB
| Reported by: | robe | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | Website rebranding 2017 |
| Component: | SysAdmin | Keywords: | |
| Cc: |
Description
the staging.www.osgeo.org wordpress was installed using MyISAM which has a number of issues
e.g transaction safety, not supporting multiple cores, not ANSI SQL compliant in enforcing things.
MySQL and Maria planning to get rid of it in some future version.
That said I'd like to convert all the tables to InnoDB and plan to do that this weekend.
I spoke to GetInteractive and they said there was no specific reason they went with MyISAM. Just happened to be the default.
Note:
See TracTickets
for help on using tickets.
Done and documented in https://wiki.osgeo.org/wiki/SAC:betawebsite#Convert_MySQL_Tables_to_InnoDb