Announcement

Announcement Module
Collapse
No announcement yet.

mySQL Config Creator fails to start mySQL

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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 (http://tools.percona.com/) 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

  • #2
    Hey Martin,

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

    /var/run/mysql/mysql-error.log

    Comment


    • #3
      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.

      Comment

      Working...
      X