MariaDB Server Setup Step 1: Memory Configuration
Setting up a MariaDB server to reliably host a database, running stable and making good use of resources, involves more than just installing the software. The first step is to configure resource allocation so that the server is getting the benefit of all available RAM without oversubscribing (which will lead to the OOM reaper killing the server at the worst possible times, when it's heavily loaded.) As the MariaDB server runs, it does not check to see what system resources are available, or limit the amount of memory the process uses, except indirectly as a function of the sum of some default & configured values. The default configuration values are conservative and fit comfortably in at least 4G available RAM. If you have a smaller instance, it can easily OOM. If your instance is larger, you're leaving significant performance on the table. It is very important to keep in mind tha...