Loading some tables of an innodb databse into memory in mariadb

Question

I have a innoDB database with size of about 40GB.
The text-only tables overall have around 10MB and the rest of the size belong to blobs.
Is it better to load the text-only tables into the memory at startup.
If it is useful how can I do it?
Thanks in Advance

Rick James · Accepted Answer · 2018-10-08 00:39:45Z

2

Putting anything into memory competes with InnoDB's favorite way of caching data -- the innodb_buffer_pool_size.

Bottom line: You might get some improvement. But don't bother going to the extra effort.

answered Oct 8, 2018 at 0:39

Rick James

144k15 gold badges144 silver badges255 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Loading some tables of an innodb databse into memory in mariadb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related