Not the answer you need?
Register and ask your own question!

mySQL Config Creator fails to start mySQL

rastarrrastarr EntrantInactive User Role Beginner
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 (http://tools.percona.com/) version REL5-20120208
# Configuration name noinnodb generated for [email protected] 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

Comments

  • eroomydnaeroomydna MySQL Addict Current User Role Beginner
    Hey Martin,

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

    /var/run/mysql/mysql-error.log
  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.