MySQL config advice for Centos8 Maria dB

Issues related to applications and software problems and general support
Post Reply
blue77
Posts: 2
Joined: 2020/06/30 20:12:28

MySQL config advice for Centos8 Maria dB

Post by blue77 » 2020/06/30 20:16:07

Hi all.

I am running CentOS 8 with nginx for wordpress. I have run the mysql tuner and below are the general recommendations:

*****General recommendations:
MySQL was started within the last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Dedicate this server to your database for highest performance.
Reduce or eliminate unclosed connections and network issues
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
Consider installing Sys schema from https://github.com/mysql/mysql-sys for MySQL
Consider installing Sys schema from https://github.com/FromDual/mariadb-sys for MariaDB*

Any advice on how to do this, or if they can be ignored?

My server is 2gb 1 core ( $10 on DO )

My current my.cnf in my.cnf.d is below:

[mysqld]

querycachesize = 0
querycachetype = 0
querycachelimit = 4M
tmptablesize = 32M
maxheaptablesize = 32M
threadcachesize = 4
maxconnections = 100
keybuffersize = 16M
maxallowedpacket = 1024M
innodblogfile_size=16M

performance_schema=ON

Any advice would be very welcome.

Thanks in advance

Colin

User avatar
KernelOops
Posts: 350
Joined: 2013/12/18 15:04:03
Location: xfs file system

Re: MySQL config advice for Centos8 Maria dB

Post by KernelOops » 2020/07/01 05:47:34

A bit unrelated to centos, you may need to ask for help from a mariadb forum.

I'll PM you my configuration for mariadb, in case its of any help to you.
--
I love my computer - all my friends live there.
--

blue77
Posts: 2
Joined: 2020/06/30 20:12:28

Re: MySQL config advice for Centos8 Maria dB

Post by blue77 » 2020/07/01 07:58:54

Yes please, that would be great. What size is your vps?

User avatar
KernelOops
Posts: 350
Joined: 2013/12/18 15:04:03
Location: xfs file system

Re: MySQL config advice for Centos8 Maria dB

Post by KernelOops » 2020/07/01 15:19:40

PM sent.

I use various sizes, from simple VMs with as little as 1GB of ram, up to bare metal servers with several TB of memory.

Read the comments in my config template, they are split into 3 different memory sizes.
--
I love my computer - all my friends live there.
--

Post Reply

Return to “CentOS 8 - General Support”