Luis Manson Posted January 26, 2016 Share Posted January 26, 2016 The table core_session can be moved into memory as in ipb3 times? Link to comment Share on other sites More sharing options...
TSP Posted January 26, 2016 Share Posted January 26, 2016 I've done it. Link to comment Share on other sites More sharing options...
AutoItScript Posted January 26, 2016 Share 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. Link to comment Share on other sites More sharing options...
Luis Manson Posted January 26, 2016 Author Share 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 Link to comment Share on other sites More sharing options...
RevengeFNF Posted January 26, 2016 Share 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. Link to comment Share on other sites More sharing options...
Luis Manson Posted January 26, 2016 Author Share 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 Link to comment Share on other sites More sharing options...
RevengeFNF Posted January 26, 2016 Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.