Percona5.6.10 get error ERROR! The server quit without updating PID file

  • Filter
  • Time
  • Show
Clear All
new posts

  • Percona5.6.10 get error ERROR! The server quit without updating PID file

    hey i have meet the same problem,and i install percona5.6.10 via compile(i download Percona-Server-5.6.10-alpha60.2.tar.gz),when i finished install, all is well,but after a short time when i use /etc/init.d/mysqld restart i get error like "The server quit without updating PID file "
    so i reinstall the percona,and when i complete ,the mysql service is normal and is running,but sfter about 1 0r 2 hours, when i check,the service status is not running and get error like "mysql is not running and lock file………",even if i remove /etc/my.cnf,the service is not starting,and weather my percona package is correct?and below is the parameter of compile for percona
    tar -zxv -f mysql-5.6.13.tar.gz
    cd mysql-5.6.13/
    cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
    -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
    -DDEFAULT_COLLATION=utf8_general_ci \
    male install
    /usr/local/mysql/scripts/mysql_install_db \
    --basedir=/usr/local/mysql \
    --datadir=/var/mysql/data \

    and below if my /etc/my.cnf

    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M

    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin

    # These are commonly set, remove the # and set as required.
    basedir = /usr/local/mysql
    datadir = /var/mysql/data
    port = 3306
    server_id = 1
    socket = /tmp/mysql.sock
    sort_buffer_size = 1M
    join_buffer_size = 1M
    query_cache_size = 50M
    query_cache_limit = 2M
    query_cache_min_res_unit = 2k
    thread_stack = 192K
    tmp_table_size = 246M
    max_heap_table_size = 50M
    key_buffer_size = 256M
    read_buffer_size = 1M
    read_rnd_buffer_size = 10M
    bulk_insert_buffer_size = 10M
    slow_query_log = 1
    log-error = /var/mysql/mysql_error.log
    slow_query_log_file = /var/mysq/query_slow.log
    long_query_time = 2
    log-queries-not-using-indexes = ON

    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M


  • #2
    What does the error log say? (/var/mysql/mysql_error.log)


    • #3
      thank you dear,i have fixed it and i have another problem and confused ,when i install mysql and i see only a thread running when i use top command or use lsof -i:3306,but when i install percona ,i have found some mysql thread are running,why?