We have a local Optiplex PC setup to run our shared MySQL MariaDB database with no way to access it from the outside world. It doesn't have any critical data that needs to be protected.
Basically, no security, encryption or administration needed. What is performance-wise the fastest possible configuration for our setup?
Here's our current config:
[mysqld] max_connections=500 join_buffer_size = 2M tmp_table_size = 24M max_heap_table_size = 24M query_cache_size = 256M key_buffer=256M key_buffer_size = 1332M thread_cache_size = 4 table_cache = 500 table_open_cache = 96 innodb_buffer_pool_size = 27M slow_query_log local-infile=0 skip-name-resolve
I'm running Debian 10 on an Optiplex 780, core2duo E8500 with 4GB RAM. My specs can be found here! https://i.dell.com/sites/doccontent/shared-content/data-sheets/en/Documents/optiplex_780_tech_spec_sheet.pdf