After service mysqld start, automatic shutdown the service for a few hours or so, basic didn't have any database operations, is opened up, and then after a few hours to shutdown, the site may not be able to use, how to return a responsibility? Ali cloud on the same 1 gb of memory will not be in the ECS, and mysql5.7.20 I haven't online platform is still in development, 1 gb of memory is enough... Whether the BCC need what configuration to ensure the stable running mysql5.7.20? .
The entire server installed PHP7, mysql, VSFTPD these a few simple things.
System: CentOS 6.8/x86_64 (64 - bit) nuclear 1 g
The log is as follows:
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Mysqld service shutdown logs:
The 2017-12-18 T19:47:03. 503012 z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Do use - explicit_defaults_for_timestamp server option (see documentation for more details).
The 2017-12-18 T19:47:03. 543807 z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO SQL modes should be 2 with strict mode. They will be merged with strict mode in a future release.
The 2017-12-18 T19:47:03. 745187 z 0 [Note]/usr/sbin/mysqld (mysqld 5.7.20) starting as the process of 6777...
The 2017-12-18 T19:47:04. 595175 z 0 [Note] InnoDB: PUNCH HOLE support available
The 2017-12-18 T19:47:04. 595234 z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
The 2017-12-18 T19:47:04. 595245 z 0 [Note] InnoDB: Uses the event mutexes
The 2017-12-18 T19:47:04. 595253 z 0 [Note] InnoDB: GCC builtin __sync_synchronize () is 2 for the memory barrier
The 2017-12-18 T19:47:04. 595260 z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
The 2017-12-18 T19:47:04. 595267 z 0 [Note] InnoDB: Using Linux native AIO
The 2017-12-18 T19:47:04. 622159 z 0 [Note] InnoDB: Number of pools: 1
The 2017-12-18 T19:47:04. 743115 z 0 [Note] InnoDB: Using CPU crc32 instructions
The 2017-12-18 T19:47:04. 986152 z 0 [Note] InnoDB: Initializing buffer pool, the total size=128 m, the instances=1, the chunk size=128 m
The 2017-12-18 T19:47:05. 029165 z 0 [ERROR] InnoDB: mmap (137428992 bytes) failed; Errno 12
The 2017-12-18 T19:47:05. 029221 z 0 [ERROR] InnoDB: always the allocate memory for the buffer pool
The 2017-12-18 T19:47:05. 029230 z 0 [ERROR] InnoDB: Plugin initialization aborted with ERROR Generic ERROR
The 2017-12-18 T19:47:05. 029239 z 0 [ERROR] Plugin 'InnoDB init function returned ERROR.
The 2017-12-18 T19:47:05. 029260 z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
The 2017-12-18 T19:47:05. 029267 z 0 [ERROR] Failed to initialize the plugins.
The 2017-12-18 T19:47:05. 029271 z 0 [ERROR] Aborting
The 2017-12-18 T19:47:05. 055405 z 0 [Note] Binlog end
The 2017-12-18 T19:47:05. 124469 z 0 [Note]/usr/sbin/mysqld: Shutdown complete
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Here is my my. Conf: (basic is the default. My conf, new I have commented out useless)
# For advice on how to change Settings both please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[mysqld]
#
# # Remove leading and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of the total RAM for dedicated server, the else 10%.
# innodb_buffer_pool_size=128 m
#
# # Remove leading to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# # Remove leading to set the options mainly useful for reporting the servers.
# The server defaults are faster - for The transactions and fast SELECTs.
# Adjust sizes as men, experiment to find the optimal values.
# join_buffer_size=128 m
# sort_buffer_size=2 m
# read_rnd_buffer_size=2 m
Datadir=/var/lib/mysql
Socket=/var/lib/mysql/mysql. The sock
# Disabling -- - the links is it to prevent assorted security risks
-- - the links=0
The log - error=/var/log/mysqld. Log
Pid - file=/var/run/mysqld/mysqld. Pid
The bind - address=0.0.0.0
Disable - partition - engine - check=1
Sql_mode=STRICT_TRANS_TABLES NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION
# performance_schema=OFF
# reducing mysql memory footprint
# performance_schema_max_table_instances=200
# table_definition_cache=200
# table_open_cache=128
# to find execute slowest SQL statement
# the log - missile - the queries=the queries - missile. The log
Performance_schema_instrument='memory %=counted'
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Fill a mysqld start log: (I just start service)
The 2017-12-19 T01:44:06. 774497 z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Do use - explicit_defaults_for_timestamp server option (see documentation for more details).
The 2017-12-19 T01:44:06. 774569 z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO SQL modes should be 2 with strict mode. They will be merged with strict mode in a future release.
The 2017-12-19 T01:44:06. 776537 z 0 [Note]/usr/sbin/mysqld (mysqld 5.7.20) starting as the process of 8175...
The 2017-12-19 T01:44:06. 799576 z 0 [Note] InnoDB: PUNCH HOLE support available
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
