<div dir="ltr"><div class="gmail_quote"><div dir="ltr">Hello<br><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">I am running mysqltunner on my DB server and show memory error</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">Variables to adjust:<br> *** MySQL's maximum memory usage is dangerously high ***<br> *** Add RAM before increasing MySQL buffer variables ***<br> SET innodb_stats_on_metadata = OFF<br> query_cache_size (=0)<br> query_cache_type (=0)<br> innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.<br></div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">my.cnf:</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">[mysqld]<br>datadir=/var/lib/mysql<br>socket=/var/lib/mysql/mysql.sock<br># Settings user and group are ignored when systemd is used.<br># If you need to run mysqld under a different user or group,<br># customize your systemd unit file for mariadb according to the<br># instructions in <a href="http://fedoraproject.org/wiki/Systemd">http://fedoraproject.org/wiki/Systemd</a><br><br>#skip-locking<br><br>max_connections = 100<br>innodb_file_per_table = ON<br>key_buffeir_size = 1024M<br>max_allowed_packet = 2024M<br>table_cache = 512<br>sort_buffer_size = 32M<br>read_buffer_size = 32M<br>read_rnd_buffer_size = 32M<br>myisam_sort_buffer_size = 2048M<br>thread_cache_size = 64<br>query_cache_type = 1<br>query_cache_size = 2048M<br>expire_logs_days = 1<br><br># Disabling symbolic-links is recommended to prevent assorted security risks<br>symbolic-links=0<br><br>[mysqld_safe]<br>log-error=/var/log/mariadb/mariadb.log<br>pid-file=/var/run/mariadb/mariadb.pid<br><br>#<br># include all files from the config directory<br>#<br>!includedir /etc/my.cnf.d<br><br></div><div style="font-size:12.8px">Can anybody help me please</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">Thanks</div><div><br></div>-- <br><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><div><span style="font-size:12.8px">Best regards,</span></div></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">Yamit Moreno</span></div><div dir="ltr"><br></div><div dir="ltr"><font color="#999999" size="1"><br></font></div></div></div></div></div></div></div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><font color="#999999" size="1">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. <br><br>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.</font><strong style="font-size:small"><font color="#999999" size="1"> </font></strong><br></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
<br>
<font color="gray" size="1"><b>AVISO DE CONFIDENCIALIDAD</b>: 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. <br><br><b>CONFIDENTIALITY NOTICE</b>: 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.<br></font><br>