EQEmulator Forums - MySQL/MariaDB optimization?

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)

- - MySQL/MariaDB optimization? (https://www.eqemulator.org/forums/showthread.php?t=42618)

MySQL/MariaDB optimization?

Hello, im experimenting with moving my server from Windows to Ubuntu (18.04) linux.
The server im experimenting with, is running proxmox, and i have setup a lxc container.
Everything seems to work, but i was wondering if any here has fine tuned MySQL/MariaDB ?
I usually use PGTune for PostgreSql.
Container has 8GB ram and 6 VCores (Hope thats enough ?)
Underlaying proxmox server has 16x 10K HDDs in raid 1 + 0

Quote:

Originally Posted by Mythar (Post 263563)

The database configuration does not need to be crazily optimized, some decent memory allocated to a few different buffers and you should be good to go.

Use MariaDB and this should be more than adequate to add on top of the defaults

Code:

query_cache_limit        = 10M

query_cache_size         = 16M

query_cache_type         = 1

query_cache_min_res_unit = 2k

key_buffer               = 16M

key_buffer_size          = 16M

max_allowed_packet       = 16M

thread_stack             = 192K

thread_cache_size        = 8

max_allowed_packet       = 16M

innodb_buffer_pool_size  = 100M

tmp_table_size           = 16M

Thx, i will try it out :)