mySQL Config Creator fails to start mySQL

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

Hey Martin,

Please check the error log for further information into the failure of startup;

[COLOR=#252C2F]/var/run/mysql/mysql-error.log

Hi Martin,

It can be any reason so I would also suggest just like eroomydna to share mysql-error.log file with us so we can help you to troubleshoot this issue. Thanks.