#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
[mysqld]
bind-address=127.0.0.1
local-infile=0
log-error=/var/lib/mysql/server1.e3site.com.err
performance_schema = ON
innodb_file_per_table=1
max_allowed_packet=268435456
tmp_table_size=32M
max_heap_table_size=32M
table_open_cache=5000
join_buffer_size=512K
innodb_buffer_pool_size=512M
innodb_log_file_size=64M
query_cache_size=0
query_cache_type=0
query_cache_limit=1M
table_definition_cache=4800
innodb_large_prefix = 1
innodb_file_format = Barracuda
innodb_page_size = 16384
open_files_limit=95000
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
We migrated to this server in February, and so it already had MariaDB 10.3 setup. Really, there doesn't appear to much I can do about that at this point...Please note that downgrades to previous versions are unsupported. After you upgrade your system to a newer version, it may be impossible to switch back.
Also note that since MariaDB is installed, moving to MySQL 8 is considered a downgrade, and therefore not supported.
Please Log in to join the conversation.