Luis Manson Posted January 26, 2016 Posted January 26, 2016 The table core_session can be moved into memory as in ipb3 times?
AutoItScript Posted January 26, 2016 Posted January 26, 2016 From what I heard, if you are using innodb then it's better off staying as is, because the memory tables have the same locking issues as myisam tables.
Luis Manson Posted January 26, 2016 Author Posted January 26, 2016 @AutoItScript i was just reading that. i guess memory would release the lock faster than disk, and also reduce some IO , since i see a lot of updates. However i do not have the skill to test my theory
RevengeFNF Posted January 26, 2016 Posted January 26, 2016 3 hours ago, TSP said: I've done it. In IPS4? Session tables have blob fields, so it cannot be moved to memory. Upcoming Mariadb 10.2 will support blob/text columns in memory, but its not out yet.
Luis Manson Posted January 26, 2016 Author Posted January 26, 2016 1 minute ago, RevengeFNF said: In IPS4? Session tables have blob fields, so it cannot be moved to memory. Upcoming Mariadb 10.2 will support bob/text columns in memory, but its not out yet. thanks for the info, however i desisted before further investigation because memory tables do have table-level locks
RevengeFNF Posted January 26, 2016 Posted January 26, 2016 Just now, Luis Manson said: thanks for the info, however i desisted before further investigation because memory tables do have table-level locks Go with Innodb/xtradb and you will be fine.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.