What's the default MySQL my.cnf configuration from default WordPress One-Click app in Linode

I'm on DigitalOcean, and I'm thinking on transferring the site to Linode, but I wanted to know if Linode offers a more configured MySQL for production.

Can anyone share the default my.cnf settings for the WordPress One-Click app in Linode?

Thanks,

1 Reply

The Wordpress One-Click App doesn't make significant changes to the MySQL installation beyond ensuring it installs in a secure manner. The contents of the my.cnf file for the default installation refer to two other directories: /etc/mysql/mariadb.conf.d and /etc/mysql/conf.d, where each directory contains additional configuration files. This is a snippet of the default /etc/mysql/mariadb.conf.d/50-client.cnf file which is referenced in the my.cnf file:

# * Basic Settings
#
user                    = mysql
pid-file                = /run/mysqld/mysqld.pid
socket                  = /run/mysqld/mysqld.sock
#port                   = 3306
basedir                 = /usr
datadir                 = /var/lib/mysql
tmpdir                  = /tmp
lc-messages-dir         = /usr/share/mysql
#skip-external-locking

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1

#
# * Fine Tuning
#
#key_buffer_size        = 16M
#max_allowed_packet     = 16M
#thread_stack           = 192K
#thread_cache_size      = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
#myisam_recover_options = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10

#
# * Query Cache Configuration
#
#query_cache_limit      = 1M
query_cache_size        = 16M

Because you have root access to your Linode, you're able to make changes to any of the configuration files as needed. This would need to be done via the command line after the One-Click App deployment is completed.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct