Hi,
I’m very much a newbie when it comes to SysAdmin and command line but I’m trying to get there.
I have a 1G VPS server that I’m trying to really fine tune the mySQL since it’s configured in such a way to consume a max of 1.4G so that’s not good.
The server runs Wordpress blog and forums for the most part.
My current mySQL (which is really default) is:
=============
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
Here follows entries for some specific programs
The MySQL server
[mysqld]
port = 3306
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
log_error = /var/log/mysql/error.log
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
Remove the next comment character if you are not familiar with SQL
safe-updates
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
!includedir /etc/mysql/conf.d/
=============
However, the Config Creator came up with this which produces a Fail To Start error when I go to restart the mySQL server so I’m wondering what is wrong with it:
=============
Generated by Percona Configuration Wizard ([url]MySQL Tools and Management Software to Perform System Tasks by Percona) version REL5-20120208
Configuration name noinnodb generated for martin@cooney.com.au at 2013-09-29 09:30:12
[mysql]
CLIENT
port = 3306
socket = /var/run/mysql/mysql.sock
[mysqld]
GENERAL
user = mysql
default-storage-engine = MyISAM
socket = /var/run/mysql/mysql.sock
pid-file = /var/run/mysql/mysql.pid
MyISAM
key-buffer-size = 256M
myisam-recover = FORCE,BACKUP
SAFETY
max-allowed-packet = 16M
max-connect-errors = 1000000
DATA STORAGE
datadir = /var/run/mysql/
BINARY LOGGING
log-bin = /var/run/mysql/mysql-bin
expire-logs-days = 14
sync-binlog = 1
CACHES AND LIMITS
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 4096
INNODB
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 32M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 8M
LOGGING
log-error = /var/run/mysql/mysql-error.log
log-queries-not-using-indexes = 1
slow-query-log = 1
slow-query-log-file = /var/run/mysql/mysql-slow.log
=============
Any help would be really appreciated
Cheers
Martin