Announcement

Announcement Module
Collapse
No announcement yet.

percona mysql not starting

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

  • percona mysql not starting

    Hi, I have a problems with my mysql server, after creating a conf with percona tools the server is not starting.

    can you please help me

    this is the error i get.

    121106 12:03:07 [Note] Plugin 'FEDERATED' is disabled./usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist121106 12:03:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.121106 12:03:07 InnoDB: The InnoDB memory heap is disabled121106 12:03:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins121106 12:03:07 InnoDB: Compressed tables use zlib 1.2.3121106 12:03:07 InnoDB: Using Linux native AIO121106 12:03:07 InnoDB: Initializing buffer pool, size = 6.0G121106 12:03:08 InnoDB: Completed initialization of buffer pool121106 12:03:08 InnoDB: highest supported file format is Barracuda.121106 12:03:08 InnoDB: Waiting for the background threads to start121106 12:03:09 Percona XtraDB (http://www.percona.com) 1.1.8-rel29.1 started; log sequence number 1597945121106 12:03:09 [Note] Recovering after a crash using /var/lib/mysql/data/mysql-bin121106 12:03:09 [Note] Starting crash recovery...121106 12:03:09 [Note] Crash recovery finished.121106 12:03:10 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306121106 12:03:10 [Note] - '0.0.0.0' resolves to '0.0.0.0';121106 12:03:10 [Note] Server socket created on IP: '0.0.0.0'.121106 12:03:10 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist121106 12:03:10 mysqld_safe mysqld from pid file /var/lib/mysql/data//monitoring.pid ended



    root@monitoring RC=130 /var/lib/mysql/data # rpm -qa | grep -i perconaPercona-Server-client-55-5.5.28-rel29.1.335.rhel6.x86_64Percona-Server-shared-compat-5.5.28-rel29.1.335.rhel6.x86_64Percona-Server-devel-55-5.5.28-rel29.1.335.rhel6.x86_64percona-release-0.0-1.x86_64Percona-Server-shared-55-5.5.28-rel29.1.335.rhel6.x86_64Percona-Server-server-55-5.5.28-rel29.1.335.rhel6.x86_64



    # Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208# Configuration name server-6 generated for vukomir@os-ux.com at 2012-11-06 10:48:10[mysql]# CLIENT #port = 3306socket = /var/lib/mysql/data/mysql.sock[mysqld]# GENERAL ##user = mysqldefault-storage-engine = InnoDBsocket = /var/lib/mysql/data/mysql.sockpid_file = /var/lib/mysql/data/mysql.pid# MyISAM #key_buffer_size = 32Mmyisam_recover = FORCE,BACKUP# SAFETY #max_allowed_packet = 16Mmax_connect_errors = 1000000skip_name_resolvesql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_S UBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL _GROUP_BYsysdate_is_now = 1innodb = FORCEinnodb_strict_mode = 1# DATA STORAGE #datadir = /var/lib/mysql/data/# BINARY LOGGING #log_bin = /var/lib/mysql/data/mysql-binexpire_logs_days = 14sync_binlog = 1# CACHES AND LIMITS #tmp_table_size = 32Mmax_heap_table_size = 32Mquery_cache_type = 0query_cache_size = 0max_connections = 500thread_cache_size = 50open_files_limit = 65535table_definition_cache = 4096table_open_cache = 4096# INNODB #innodb_flush_method = O_DIRECTinnodb_log_files_in_group = 2innodb_log_file_size = 256Minnodb_flush_log_at_trx_commit = 1innodb_file_per_table = 1innodb_buffer_pool_size = 6G# LOGGING #log_error = /var/lib/mysql/data/mysql-error.loglog_queries_not_using_indexes = 1slow_query_log = 1slow_query_log_file = /var/lib/mysql/data/mysql-slow.log



    Thanks.

  • #2
    mysql_install_db and mysql_upgrade does not help ?

    Comment


    • #3
      Thanks Pavel,

      mysql_install_db solved my problem.

      Comment

      Working...
      X