linux mysql总是自动关闭

Question

大概场景: 用的阿里云的服务器,用的镜像ubuntu系统,新装的系统,mysql隔几天就挂掉一次,重启一下mysql就好了,错误域名访问提示,没有正确连接数据库(大概意思) 当前尝试方法: vim /etc/my.cnf key_buffer_size = 128M 默认的没有这个参数,已添加 mysql的错误日志具体如下 170902 20:48:29 [Note] Plugin 'FEDERATED' is disabled. 170902 20:48:29 InnoDB: The InnoDB memory heap is disabled 170902 20:48:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170902 20:48:29 InnoDB: Compressed tables use zlib 1.2.8 170902 20:48:29 InnoDB: Using Linux native AIO 170902 20:48:30 InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 170902 20:48:30 InnoDB: Completed initialization of buffer pool 170902 20:48:30 InnoDB: Fatal error: cannot allocate memory for the buffer pool 170902 20:48:30 [ERROR] Plugin 'InnoDB' init function returned error. 170902 20:48:30 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 170902 20:48:30 [ERROR] Unknown/unsupported storage engine: InnoDB 170902 20:48:30 [ERROR] Aborting 170902 20:48:30 [Note] /usr/sbin/mysqld: Shutdown complete 应该如何解决 修改记录 20170906: 今天再次sql崩溃了, ps:服务器配置 1 核 512MB的-,-!! 日志: 170906 18:48:57 InnoDB: The InnoDB memory heap is disabled 170906 18:48:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170906 18:48:57 InnoDB: Compressed tables use zlib 1.2.8 170906 18:48:57 InnoDB: Using Linux native AIO 170906 18:48:57 InnoDB: Initializing buffer pool, size = 128.0M 170906 18:48:57 InnoDB: Completed initialization of buffer pool 170906 18:48:57 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 170906 18:48:57 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 170906 18:48:58 InnoDB: Waiting for the background threads to start 170906 18:48:59 InnoDB: 5.5.57 started; log sequence number 7652899 170906 18:48:59 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3310 170906 18:48:59 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 170906 18:48:59 [Note] Server socket created on IP: '127.0.0.1'. 170906 18:48:59 [Note] Event Scheduler: Loaded 0 events 170906 18:48:59 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.57-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3310 (Ubuntu) 170906 18:49:01 [ERROR] /usr/sbin/mysqld: Table './XX/XX' is marked as crashed and should be repaired 170906 18:49:01 [Warning] Checking table: './XX/XX' 170906 18:49:01 [ERROR] /usr/sbin/mysqld: Table './XX/XX' is marked as crashed and should be repaired 170906 18:49:01 [Warning] Checking table: './XX/XX 170906 18:49:01 [ERROR] /usr/sbin/mysqld: Table './XX/XX' is marked as crashed and should be repaired 170906 18:49:01 [Warning] Checking table: './XX/XX' 170906 18:49:01 [ERROR] /usr/sbin/mysqld: Table './XX/XX' is marked as crashed and should be repaired 170906 18:49:01 [Warning] Checking table: './XX/XX' 修改 innodb_buffer_pool_size＝６４Ｍ "解决阿里云内存不足-centos 6.4 linux系统 创建swap虚拟分区"按照这个方法新增swap分区 mysqlcheck -uroot -p --repair --all-databases 卸载AliYunDun进程 wget http://update.aegis.aliyun.com/download/uninstall.sh chmod 755 uninstall.sh ./uninstall.sh ps: /etc/mysql/my.cnf # # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # For explanations see # http://dev.mysql.com/doc/mysql/en/server-system-variables.html # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes # escpecially if they contain "#" chars... # Remember to edit /etc/mysql/debian.cnf when changing the socket location. [client] port = 3000 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] federated innodb_buffer_pool_size = 60MB # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3310 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address = 127.0.0.1 # # * Fine Tuning # key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover-options = BACKUP #max_connections = 100 #table_cache = 64 #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_limit = 1M query_cache_size = 16M # # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. # As of 5.1 you can enable the log at runtime! #general_log_file = /var/log/mysql/mysql.log #general_log = 1 # # Error log - should be very few entries. # log_error = /var/log/mysql/error.log # # Here you can see queries with especially long duration #log_slow_queries = /var/log/mysql/mysql-slow.log #long_query_time = 2 #log-queries-not-using-indexes # # The following can be used as easy to replay backup logs or for replication. # note: if you are setting up a replication slave, see README.Debian about # other settings you may need to change. #server-id = 1 #log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M #binlog_do_db = include_database_name #binlog_ignore_db = include_database_name # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! # # * Security Features # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". # # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M # # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # !includedir /etc/mysql/conf.d/

Answer 1

从日志上看应该是内存不足， 如果你看message日志的话， 应该会发现杀掉mysql的记录，

所以， 如果是内存不足的话， 应该用free看下剩余内存， 然后top或ps来检查下可疑进程。

上个星期， 我出现这个问题后， 发现apache进程又一两百个， 内存使用300%多， 查看apache状态后发现，大多数进程处于写日志的状态， 然后检查配置后， 发现日志目录不存在~， 于是创建目录， 重启apache， 完美解决~

Answer 2

推测题主用的是一核1G内存的阿里云，这样的低配主机经常会遇到mysql挂掉的可能，特别是启动了一段时间后。