问：宝塔环境，mysqld服务经常自动停止，什么原因或如何排查？
数据库日志：
00:33:06 [Warning] IP address '127.0.0.1' could not be resolved: Name or service not known
02:47:42 [Note] Plugin 'FEDERATED' is disabled.
02:47:42 [Note] InnoDB: Using atomics to ref count buffer pool pages
02:47:42 [Note] InnoDB: The InnoDB memory heap is disabled
02:47:42 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
02:47:42 [Note] InnoDB: Memory barrier is not used
02:47:42 [Note] InnoDB: Compressed tables use zlib 1.2.11
02:47:42 [Note] InnoDB: Using Linux native AIO
02:47:42 [Note] InnoDB: Using CPU crc32 instructions
02:47:42 [Note] InnoDB: Initializing buffer pool, size = 256.0M
InnoDB: mmap bytes) failed; errno 12
02:47:42 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
02:47:42 [ERROR] Plugin 'InnoDB' init function returned error.
02:47:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
02:47:42 [ERROR] Unknown/unsupported storage engine: InnoDB
02:47:42 [ERROR] Aborting
02:47:42 [Note] Binlog end
02:47:42 [Note] Shutting down plugin 'partition'
02:47:42 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
02:47:42 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
02:47:42 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
02:47:42 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
02:47:42 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
02:47:42 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
02:47:42 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
02:47:42 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
02:47:42 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
02:47:42 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
02:47:42 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
02:47:42 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
02:47:42 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
02:47:42 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
02:47:42 [Note] Shutting down plugin 'INNODB_FT_DELETED'
02:47:42 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
02:47:42 [Note] Shutting down plugin 'INNODB_METRICS'
02:47:42 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
02:47:42 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
02:47:42 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
02:47:42 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
02:47:42 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
02:47:42 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
02:47:42 [Note] Shutting down plugin 'INNODB_CMPMEM'
02:47:42 [Note] Shutting down plugin 'INNODB_CMP_RESET'
02:47:42 [Note] Shutting down plugin 'INNODB_CMP'
02:47:42 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
02:47:42 [Note] Shutting down plugin 'INNODB_LOCKS'
02:47:42 [Note] Shutting down plugin 'INNODB_TRX'
02:47:42 [Note] Shutting down plugin 'BLACKHOLE'
02:47:42 [Note] Shutting down plugin 'ARCHIVE'
02:47:42 [Note] Shutting down plugin 'MRG_MYISAM'
02:47:42 [Note] Shutting down plugin 'InnoDB'
02:47:42 [Note] Shutting down plugin 'MEMORY'
02:47:42 [Note] Shutting down plugin 'CSV'
02:47:42 [Note] Shutting down plugin 'sha256_password'
02:47:42 [Note] Shutting down plugin 'mysql_old_password'
02:47:42 [Note] Shutting down plugin 'mysql_native_password'
02:47:42 [Note] Shutting down plugin 'binlog'
02:47:42 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
02:50:02 [Note] Plugin 'FEDERATED' is disabled.
02:50:02 [Note] InnoDB: Using atomics to ref count buffer pool pages
02:50:02 [Note] InnoDB: The InnoDB memory heap is disabled
02:50:02 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
02:50:02 [Note] InnoDB: Memory barrier is not used
02:50:02 [Note] InnoDB: Compressed tables use zlib 1.2.11
02:50:02 [Note] InnoDB: Using Linux native AIO
02:50:02 [Note] InnoDB: Using CPU crc32 instructions
02:50:02 [Note] InnoDB: Initializing buffer pool, size = 256.0M
02:50:02 [Note] InnoDB: Completed initialization of buffer pool
02:50:02 [Note] InnoDB: Highest supported file format is Barracuda.
02:50:02 [Note] InnoDB: The log sequence numbers and in ibdata files do not match the log sequence number in the ib_logfiles!
02:50:02 [Note] InnoDB: Database was not shutdown normally!
02:50:02 [Note] InnoDB: Starting crash recovery.
02:50:02 [Note] InnoDB: Reading tablespace information from the .ibd files…
02:50:02 [Note] InnoDB: Restoring possible half-written data pages
02:50:02 [Note] InnoDB: from the doublewrite buffer…
InnoDB: Last MySQL binlog file position 0 , file name mysql-bin.000697
02:50:02 [Note] InnoDB: 128 rollback segment(s) are active.
02:50:02 [Note] InnoDB: Waiting for purge to start
02:50:02 [Note] InnoDB: 5.6.50 started; log sequence number
02:50:02 [Note] Recovering after a crash using mysql-bin
02:50:02 [Note] Starting crash recovery…
02:50:02 [Note] Crash recovery finished.
02:50:02 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
02:50:02 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
02:50:02 [Note] Server hostname (bind-address): '*'; port: 3306
02:50:02 [Note] IPv6 is available.
02:50:02 [Note] – '::' resolves to '::';
02:50:02 [Note] Server socket created on IP: '::'.
02:50:02 [Note] Event Scheduler: Loaded 0 events
02:50:02 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.6.50-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
03:07:44 [Warning] IP address '127.0.0.1' could not be resolved: Name or service not known
07:04:44 [Note] Plugin 'FEDERATED' is disabled.
07:04:44 [Note] InnoDB: Using atomics to ref count buffer pool pages
07:04:44 [Note] InnoDB: The InnoDB memory heap is disabled
07:04:44 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
07:04:44 [Note] InnoDB: Memory barrier is not used
07:04:44 [Note] InnoDB: Compressed tables use zlib 1.2.11
07:04:44 [Note] InnoDB: Using Linux native AIO
07:04:44 [Note] InnoDB: Using CPU crc32 instructions
07:04:44 [Note] InnoDB: Initializing buffer pool, size = 256.0M
InnoDB: mmap bytes) failed; errno 12
07:04:44 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
07:04:44 [ERROR] Plugin 'InnoDB' init function returned error.
07:04:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
07:04:44 [ERROR] Unknown/unsupported storage engine: InnoDB
07:04:44 [ERROR] Aborting
…
…
…
,服务器偶发满载，数据库自动停止
答：您好，
从web控制台查看之前是服务器内存耗尽导致mysql进程被终止；显示是站点程序访问量较大php进程较多占用了较多内存；
从最近站点访问日志来看，站点访问量较大，有大量来自127.0.0.1这个ip对站点www.scmmhb.com的根目录下的/xmlrpc.php这个文件的访问，若该ip不是正常访问，您可以参考http://www.35.com/faq/list.asp?unid=1427 使用安全组屏蔽该ip的访问或者回复工单由我司为您设置屏蔽该ip的访问；非常感谢您长期对我司的支持!
