January 26, 20169 yr 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.
January 26, 20169 yr Author @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
January 26, 20169 yr 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. Edited January 26, 20169 yr by RevengeFNF
January 26, 20169 yr Author 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
January 26, 20169 yr 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.
Archived
This topic is now archived and is closed to further replies.