mysql鍚姩閿欒锛孴he server quit without updating PID file (/usr/local/mysql/var/VM_157_231_centos.pid)

涔熶笉鐭ラ亾涓轰粈涔堢獊鐒跺氨鐧讳笉浜嗕簡锛宮ysql鎯抽噸鍚篃涓嶈锛屽彧濂界敤鐐规棩蹇楃湅鐪嬩簡銆傛壘鍒my.cnf
鐒跺悗鍦ㄦ渶鍚庝竴娈靛姞鍙log_error = /var/log/mysql/error.log
鍦/var/log搴曚笅鍒涘缓涓涓媘ysql杩欎釜鐩綍锛岀劧鍚庡啀娆¢噸鍚紝鐒跺悗鏌ョ湅涓涓嬫姤閿欒褰曘


180125 10:10:28 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var 2 2018-01-25 10:10:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server optio n (see documentation for more details). 3 2018-01-25 10:10:29 30338 [Note] Plugin 'FEDERATED' is disabled. 4 2018-01-25 10:10:29 7fef32867720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future re leases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 5 2018-01-25 10:10:29 30338 [Note] InnoDB: Using atomics to ref count buffer pool pages 6 2018-01-25 10:10:29 30338 [Note] InnoDB: The InnoDB memory heap is disabled 7 2018-01-25 10:10:29 30338 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 8 2018-01-25 10:10:29 30338 [Note] InnoDB: Memory barrier is not used 9 2018-01-25 10:10:29 30338 [Note] InnoDB: Compressed tables use zlib 1.2.3 10 2018-01-25 10:10:29 30338 [Note] InnoDB: Using CPU crc32 instructions 11 2018-01-25 10:10:29 30338 [Note] InnoDB: Initializing buffer pool, size = 244.0M 12 InnoDB: mmap(261849088 bytes) failed; errno 12 13 2018-01-25 10:10:29 30338 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 14 2018-01-25 10:10:29 30338 [ERROR] Plugin 'InnoDB' init function returned error. 15 2018-01-25 10:10:29 30338 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 16 2018-01-25 10:10:29 30338 [ERROR] Unknown/unsupported storage engine: InnoDB 17 2018-01-25 10:10:29 30338 [ERROR] Aborting 18 19 2018-01-25 10:10:29 30338 [Note] Binlog end 20 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'partition' 21 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 22 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 23 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 24 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 25 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 26 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 27 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 28 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 29 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 30 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 31 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 32 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 33 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 34 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 35 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_FT_DELETED' 36 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 37 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_METRICS' 38 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 39 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 40 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 41 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 42 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 43 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 44 2018-01-25 10:10:29 30338 [Note] Shutting down plugin 'INNODB_CMPMEM'

鏍规嵁鎴戜笉鎴愬櫒鐨勮嫳璇垽鏂紝浼拌鏄痬ysql瑕佸崰鐢ㄥ唴瀛橈紝浣嗘槸鐗╃悊鍐呭瓨涓嶅浠涔堢殑锛屽洖鍒癿y.cnf锛屾妸innodb_buffer_pool_size濉皬涓鐐癸紝閲嶅惎锛孫JBK浜

All posts

Other pages

鍙戣〃鍥炲

鎮ㄧ殑鐢靛瓙閭鍦板潃涓嶄細琚叕寮銆 蹇呭~椤瑰凡鐢*鏍囨敞