very poor db performance
Installation and Configuration
https://www.dreadlockssite.com/phpinfo.php
dont seemy.cnf in there
i used your guide as a start long ago then tweaked from there
my.cnf
[mysqld]
bind-address = 127.0.0.1
skip_name_resolve
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
key-buffer-size = 1024M
myisam-recover = FORCE,BACKUP
max_allowed_packet = 128M
wait_timeout = 300
max-connect-errors = 1000000
table_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
datadir = /var/lib/mysql/
tmp-table-size = 128M
max-heap-table-size = 128M
query_cache_size = 128M
query_cache_limit = 2M
query_cache_type = 0
join_buffer_size = 4M
max-connections = 160
thread-cache-size = 160
open-files-limit = 65535
table-definition-cache = 8096
table-open-cache = 8096
optimizer_search_depth = 1
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 2G
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 10G
innodb_buffer_pool_instances = 10
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
mysqltuner.pl recomendations
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
Control warning line(s) into /var/log/mysqld.log file
Control error line(s) into /var/log/mysqld.log file
Run OPTIMIZE TABLE to defragment tables for better performance
OPTIMIZE TABLE greentec_jam.jr_jrcore_cache; -- can free 1180 MB
Total freed space after theses OPTIMIZE TABLE : 1180 Mb
Restrict Host for user@% to user@SpecificDNSorIp
MySQL started within last 24 hours - recommendations may be inaccurate
Increasing the query_cache size over 128M may reduce performance
Variables to adjust:
query_cache_type (=0)
query_cache_size (> 128M) [see warning above]
innodb_log_file_size should be equals to 1/4 of buffer pool size (=2G) if possible.
note that i already set these in my.cnf but they dont seem to be taking
