Geek Answers Handbook

Starting MySQL.Manager pid file ends without updating fi error

I get the following error when mysql starts ... can someone help:

] # service mysql start Starting the MySQL.Manager pid file ends without updating fi [FAILED] The following file is my.cnf ...

** file my.cnf *****

[tudes]
data_directory = / var / lib / mysql
socket = / var / lib / mysql / mysql.sock
user = mysql

table_cache = 2048
innodb_buffer_pool_size = 2G
innodb_file_per_table
innodb_log_buffer_size = 8M
innodb_log_file_size = 128M
innodb_additional_mem_pool_size = 4M
innodb_table_locks = 0
by default, the storage engine = the InnoDB
join_buffer_size = 2M
query_cache_size = 512M
query_cache_limit = 2M
sort_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 4M
key_buffer = 512M
key_buffer_size = 256M
max_allowed_packet = 16M
max_connections = 250
long_query_time = 5
log_slow_queries = ekb-qa-app-02-slow.log
innodb_autoinc_lock_mode = 2

[mysqld_safe]
=///mysqld.log
PID =////mysqld.pid

+5
13

... . ( ) , . df -h , . , , ( :)).

+9

:

  • mysqld , .
  • mysqld , .
+4

mysqld_safe , . , , .

+2

mysql. root. mysql: mysql, .

+2

/etc/init.d/mysql [d] script , , . " [FAILED]" " [OK]", script, .

, , :

Manager of pid-file quit wi[FAILED]dating file

, mysqld :

/usr/sbin/mysqld: File 'MASTER/master15-bin.index' not found (Errcode: 2)

, /var/lib/mysql . , MASTER SLAVE /etc/my.cnf, . - MASTER.

, .

, " pid-file quit" . , , (1) , , , (2) , mysqld_safe.

+1

sudo mysql .

$ sudo /etc/rc.d/init.d/mysql start

: MySQL. , MySQL , :

$ mysqladmin -u root -pjoomla1 ping

mysqld

+1

, my.cnf, , ( )

0

mysql (,/var/lib/mysql), , . () . , , fsck . , (lsof/var/lib/mysql | awk '{print $1}' | sort | uniq -c | awk '{print $2}'), umount fscking .

0

my.cnf, .

innodb_log_file_size , mysql, , , - :

Starting MySQL.The server quit without updating PID file ([FAILED]mysql/<insert pid file here>).

, , , , :

140709 22:47:30 mysqld_safe mysqld from pid file /var/lib/mysql/<pid filename>.pid ended
140709 22:47:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140709 22:47:31 [Warning] Using unique option prefix thread_cache instead of thread_cache_size is deprecated and will be removed...
140709 22:47:31 [Note] Plugin 'FEDERATED' is disabled.
140709 22:47:31 InnoDB: The InnoDB memory heap is disabled
140709 22:47:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140709 22:47:31 InnoDB: Compressed tables use zlib 1.2.3
140709 22:47:31 InnoDB: Using Linux native AIO
140709 22:47:31 InnoDB: Initializing buffer pool, size = 512.0M
140709 22:47:31 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!
140709 22:47:31 [ERROR] Plugin 'InnoDB' init function returned error.
140709 22:47:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140709 22:47:31 [ERROR] Unknown/unsupported storage engine: InnoDB
140709 22:47:31 [ERROR] Aborting

140709 22:47:31 [Note] /usr/sbin/mysqld: Shutdown complete

140709 22:47:31 mysqld_safe mysqld from pid file /var/lib/mysql/<pid filename>.pid ended

, pid "pid filename".

, innodb_log_file_size , - , , mysql, , .

0

. , DEFAULTS [mysqld] my.cnf/.ini sort_buffer_size read_buffer_size read_rnd_buffer_size join_buffer_size () . 16M read_rnd_buffer_size, DEFAULT 256K?

0

I think it will fix query_cache hash

-1
source

You did not indicate which system you are using here. For CentOS, Fedora, and Red Hat Enterprise Linux, use the mysqld service instead of mysql

    sudo /etc/init.d/mysqld start
-1
source

I believe the problem may be related to the variable "performance_schema" found in your my.cnf file. This variable should be commented out. Give it a try.

-2
source

More articles:


All Articles