The innodb_buffer_pool_size is the size in bytes of the memory buffer InnoDB uses to cache data and indexes of its tables.
In this calculator, max_connections is estimated as 100 connections per GB of available memory. However, the actual optimal value depends on your specific workload and server configuration.
Reserving memory for the OS ensures that the system has enough resources to run smoothly, preventing potential slowdowns or crashes due to memory exhaustion.
No, these are general recommendations. The optimal settings can vary greatly depending on your specific use case, workload, and hardware. It's always best to monitor your system's performance and adjust accordingly.