Changes between Version 2 and Version 3 of Ticket #2552, comment 7
- Timestamp:
- 03/18/2020 06:44:54 AM (5 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #2552, comment 7
v2 v3 4 4 5 5 I guess it could potentially be implemented as a [https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html MySQL MEMORY table] which would at least avoid the DB load of querying/writing the post_meta table constantly. 6 edit: As it turns out, [https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html it's probably not a good idea] to use MEMORY tables with replication , as although it can handle the master restarting (and loosing the data is fine), slaves being restarted can cause sync issues. Implemented as it's own table, just on-disk would ultimately be fine I guess.6 edit: As it turns out, [https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html it's probably not a good idea] to use MEMORY tables with replication (like we do on WordPress.org), as although it can handle the primary restarting (and loosing the data is fine), secondaries being restarted can cause sync issues. Implemented as it's own table, just on-disk would ultimately be fine I guess.