-- ::  [Note] Plugin 'FEDERATED' is disabled.

-- ::  [Note] InnoDB: Using atomics to ref count buffer pool pages

-- ::  [Note] InnoDB: The InnoDB memory heap is disabled

-- ::  [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

-- ::  [Note] InnoDB: Memory barrier is not used

-- ::  [Note] InnoDB: Compressed tables use zlib 1.2.

-- ::  [Note] InnoDB: Using CPU crc32 instructions

-- ::  [Note] InnoDB: Initializing buffer pool, size = 128.0M

InnoDB: mmap( bytes) failed; errno

-- ::  [ERROR] InnoDB: Cannot allocate memory for the buffer pool

-- ::  [ERROR] Plugin 'InnoDB' init function returned error.

-- ::  [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

-- ::  [ERROR] Unknown/unsupported storage engine: InnoDB

-- ::  [ERROR] Aborting

-- ::  [Note] Binlog end

-- ::  [Note] Shutting down plugin 'partition'

-- ::  [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

-- ::  [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

-- ::  [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

-- ::  [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

-- ::  [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

-- ::  [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

-- ::  [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

-- ::  [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

-- ::  [Note] Shutting down plugin 'INNODB_SYS_TABLES'

-- ::  [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

-- ::  [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

-- ::  [Note] Shutting down plugin 'INNODB_FT_CONFIG'

-- ::  [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

-- ::  [Note] Shutting down plugin 'INNODB_FT_DELETED'

-- ::  [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

-- ::  [Note] Shutting down plugin 'INNODB_METRICS'

-- ::  [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

-- ::  [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

-- ::  [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

-- ::  [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

-- ::  [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

-- ::  [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

-- ::  [Note] Shutting down plugin 'INNODB_CMPMEM'

-- ::  [Note] Shutting down plugin 'INNODB_CMP_RESET'

-- ::  [Note] Shutting down plugin 'INNODB_CMP'

-- ::  [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

-- ::  [Note] Shutting down plugin 'INNODB_LOCKS'

-- ::  [Note] Shutting down plugin 'INNODB_TRX'

-- ::  [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

-- ::  [Note] Shutting down plugin 'ARCHIVE'

-- ::  [Note] Shutting down plugin 'BLACKHOLE'

-- ::  [Note] Shutting down plugin 'MyISAM'

-- ::  [Note] Shutting down plugin 'MRG_MYISAM'

-- ::  [Note] Shutting down plugin 'CSV'

-- ::  [Note] Shutting down plugin 'MEMORY'

-- ::  [Note] Shutting down plugin 'sha256_password'

-- ::  [Note] Shutting down plugin 'mysql_old_password'

-- ::  [Note] Shutting down plugin 'mysql_native_password'

-- ::  [Note] Shutting down plugin 'binlog'

-- ::  [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

mysql 启动到底需要多少内存？

官网是这什么回答的：

How MySQL Uses Memory？

MySQL allocates buffers and caches to improve performance of database operations. The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately512MB of RAM. You can improve MySQL performance by increasing the values of certain cache and buffer-related system variables. You can also modify the default configuration to run MySQL on systems with limited memory.

于是，那么有什么办法可以小内存启动 mysql 吗？

vim /etc/my.cnf

performance_schema_max_table_instances=

table_definition_cache=

table_open_cache=

主要是innodb日志大小不对造成的

innodb_buffer_pool_size=512M

innodb_log_file_size=128M

把以上几个参数调大点，然后把ibdata1，ib_logfile0，ib_logfile1这三个文件删除后，再重启服务就好了。

如果还是不行，在my.ini文件里还需要加入tmpdir="usr/tmp"这样的路径，因为innodb还需要一个临时的文件缓存区。

问题描述：

非正常关闭mysql，同时更改了my.cnf 导致启动时不支持innodb，出现如下错误：

[ERROR] Plugin ‘InnoDB’ init function returned error.

[ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.

[ERROR] Unknown/unsupported table type: InnoDB

[ERROR] Aborting

解决办法：

删除log文件和data的初始化文件  

重新运行mysql_install_db

再启动

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| binlog             |

| log                |

| mysql              |

| performance_schema |

| test               |

| zabbix             |

+--------------------+

 rows in set (0.00 sec)

mysql> use zabbix;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

+----------------------------+

| Tables_in_zabbix           |

+----------------------------+

| acknowledges               |

| actions                    |

| alerts                     |

| application_discovery      |

| application_prototype      |

| application_template       |

| applications               |

| auditlog                   |

| auditlog_details           |

| autoreg_host               |

| conditions                 |

| config                     |

| corr_condition             |

| corr_condition_group       |

| corr_condition_tag         |

| corr_condition_tagpair     |

| corr_condition_tagvalue    |

| corr_operation             |

| correlation                |

| dbversion                  |

| dchecks                    |

| dhosts                     |

| drules                     |

| dservices                  |

| escalations                |

| event_recovery             |

| event_tag                  |

| events                     |

| expressions                |

| functions                  |

| globalmacro                |

| globalvars                 |

| graph_discovery            |

| graph_theme                |

| graphs                     |

| graphs_items               |

| group_discovery            |

| group_prototype            |

| groups                     |

| history                    |

| history_log                |

| history_str                |

| history_text               |

| history_uint               |

| host_discovery             |

| host_inventory             |

| hostmacro                  |

| hosts                      |

| hosts_groups               |

| hosts_templates            |

| housekeeper                |

| httpstep                   |

| httpstepitem               |

| httptest                   |

| httptestitem               |

| icon_map                   |

| icon_mapping               |

| ids                        |

| images                     |

| interface                  |

| interface_discovery        |

| item_application_prototype |

| item_condition             |

| item_discovery             |

| items                      |

| items_applications         |

| maintenances               |

| maintenances_groups        |

| maintenances_hosts         |

| maintenances_windows       |

| mappings                   |

| media                      |

| media_type                 |

| opcommand                  |

| opcommand_grp              |

| opcommand_hst              |

| opconditions               |

| operations                 |

| opgroup                    |

| opinventory                |

| opmessage                  |

| opmessage_grp              |

| opmessage_usr              |

| optemplate                 |

| problem                    |

| problem_tag                |

| profiles                   |

| proxy_autoreg_host         |

| proxy_dhistory             |

| proxy_history              |

| regexps                    |

| rights                     |

| screen_user                |

| screen_usrgrp              |

| screens                    |

| screens_items              |

| scripts                    |

| service_alarms             |

| services                   |

| services_links             |

| services_times             |

| sessions                   |

| slides                     |

| slideshow_user             |

| slideshow_usrgrp           |

| slideshows                 |

| sysmap_element_url         |

| sysmap_url                 |

| sysmap_user                |

| sysmap_usrgrp              |

| sysmaps                    |

| sysmaps_elements           |

| sysmaps_link_triggers      |

| sysmaps_links              |

| task                       |

| task_close_problem         |

| timeperiods                |

| trends                     |

| trends_uint                |

| trigger_depends            |

| trigger_discovery          |

| trigger_tag                |

| triggers                   |

| users                      |

| users_groups               |

| usrgrp                     |

| valuemaps                  |

+----------------------------+

 rows in set (0.00 sec)

mysql> desc valuemaps;

ERROR  (42S02): Table 'zabbix.valuemaps' doesn't exist

mysql> desc usrgrp;

ERROR  (42S02): Table 'zabbix.usrgrp' doesn't exist

mysql> select * from users;

ERROR  (42S02): Table 'zabbix.users' doesn't exist

mysql> select user();

+----------------+

| user()         |

+----------------+

| root@localhost |

+----------------+

 row in set (0.00 sec)

mysql> 

-- ::  [Warning] InnoDB: Cannot open table zabbix/dbversion from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

-- ::  [Warning] InnoDB: Cannot open table zabbix/dbversion from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

-- ::  [Warning] InnoDB: Cannot open table zabbix/dbversion from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

-- ::  [Warning] InnoDB: Cannot open table mysql/innodb_index_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

-- ::  [Warning] InnoDB: Cannot open table mysql/innodb_table_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

-- ::  [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

-- ::  [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

-- ::  [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

-- ::  [Warning] InnoDB: Cannot open table zabbix/dbversion from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

-- ::  [Warning] InnoDB: Cannot open table zabbix/dbversion from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.