sessions table into memory

[Luis Manson]

The table core_session can be moved into memory as in ipb3 times?

[TSP]

I've done it.

[AutoItScript]

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]

@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]

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]

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]

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.