Which MySQL settings for 64 GB of memory are the most productive?

Question

MySQL

How to configure mysql for maximum memory usage and zero disk usage? Although the drives are SSD. MyISAM engine. I found all sorts of manuals on Habré with a description of the settings, but there are such tips, like: "for such and such requests, increase such and such a parameter", but how much to increase it is not indicated. Maybe someone has a config file for an example for a machine with a lot of RAM?

Answer 1

Short answer: the most productive are those that are tailored to your task.
Full answer: it is not known what kind of database you have, what kind of load is on it, what is more - reads or writes, how complex queries are. Calculate the required amount of memory by rough estimates, drive the data back and forth, then see how it lives / works, ask mysqltuner for help and, I'm sure everything will work out fine.

Answer 2

Try running mysql-tuning-primer first. He has to show the biggest problems. And go to innodb no matter how many frames you add, but the locks on the table will all slow down.

Answer 3

It's stupid to tune the mscule for memory and not for your load, load the database, look at the statistics, optimize the config, otherwise you will do something stupid.