[opencms-dev] MariaDB optimization error

Yamit David Moreno Socha yamit.moreno at uptc.edu.co
Fri Mar 13 18:03:22 CET 2020


Hello

I am running mysqltunner on my DB server and show memory error

Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    SET innodb_stats_on_metadata = OFF
    query_cache_size (=0)
    query_cache_type (=0)
    innodb_log_file_size should be (=16M) if possible, so InnoDB total log
files size equals to 25% of buffer pool size.

my.cnf:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

#skip-locking

max_connections         = 100
innodb_file_per_table   = ON
key_buffeir_size        = 1024M
max_allowed_packet      = 2024M
table_cache             = 512
sort_buffer_size        = 32M
read_buffer_size        = 32M
read_rnd_buffer_size    = 32M
myisam_sort_buffer_size = 2048M
thread_cache_size       = 64
query_cache_type        = 1
query_cache_size        = 2048M
expire_logs_days        = 1

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

Can anybody help me please


Thanks

-- 
Best regards,

Yamit Moreno


AVISO DE CONFIDENCIALIDAD: Este mensaje y sus adjuntos se dirigen
exclusivamente a su destinatario, puede contener información
privilegiada o confidencial y es para uso exclusivo de la persona o
entidad de destino. Si no es usted. el destinatario indicado, queda
notificado de que la lectura, utilización, divulgación y/o copia sin
autorización puede estar prohibida en virtud de la legislación
vigente. Si ha recibido este mensaje por error, le rogamos que nos lo
comunique inmediatamente por esta misma vía y proceda a su dest!
rucción.

CONFIDENTIALITY NOTICE: The information contained in this transmission
is privileged and confidential information intended only for the use
of the individual or entity named above. If the reader of this message
is not the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this transmission in error,
do not read it. Please immediately reply to the sender that you have
received this communication in error and then delete it.

-- 
*AVISO DE CONFIDENCIALIDAD*: Este mensaje y sus adjuntos se dirigen 
exclusivamente a su destinatario, puede contener información privilegiada o 
confidencial y es para uso exclusivo de la persona o entidad de destino. Si 
no es usted. el destinatario indicado, queda notificado de que la lectura, 
utilización, divulgación y/o copia sin autorización puede estar prohibida 
en virtud de la legislación vigente. Si ha recibido este mensaje por error, 
le rogamos que nos lo comunique inmediatamente por esta misma vía y proceda 
a su destrucción. 

*CONFIDENTIALITY NOTICE*: The information contained in 
this transmission is privileged and confidential information intended only 
for the use of the individual or entity named above. If the reader of this 
message is not the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication is strictly 
prohibited. If you have received this transmission in error, do not read 
it. Please immediately reply to the sender that you have received this 
communication in error and then delete it.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20200313/6724ac3c/attachment.htm>


More information about the opencms-dev mailing list