Hola estoy intentando optimizar mysql no tengo casi nada de conocimiento en esto y me arrojo el mysqltuner las siguientes recomendaciones:
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
Control warning line(s) into /var/lib/mysql/ns3849001.ip-217-182-198.eu.err file
Control error line(s) into /var/lib/mysql/ns3849001.ip-217-182-198.eu.err file
Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
Adjust your join queries to always utilize indexes
Set thread_cache_size to 4 as a starting value
Increase table_open_cache gradually to avoid file descriptor limits
Read this before increasing table_open_cache over 64:
http://bit.ly/1mi7c4C
Beware that open_files_limit (10000) variable
should be greater than table_open_cache (2000)
Performance should be activated for better diagnostics
Consider installing Sys schema from
https://github.com/mysql/mysql-sys
Read this before changing innodb_log_file_size and/or innodb_log_files_in_group:
http://bit.ly/2wgkDvS
Variables to adjust:
query_cache_size (=0)
query_cache_type (=0)
query_cache_limit (> 1M, or use smaller result sets)
join_buffer_size (> 256.0K, or always use indexes with joins)
thread_cache_size (start at 4)
table_open_cache (> 2000)
performance_schema = ON enable PFS
innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
innodb_buffer_pool_instances (=1)
A continuacion segun eso que archivo debo modificar y como debo dejarlo , SI hay alguien aqui que me haga el favor de pegarme que debo hacer y donde debo pegar el codigo les agradeceria.