添加skip-innodb后MySQL启动失败

在小内存的VPS上,童鞋们(包括我)一般都爱做下所谓的“优化”,其中针对MySQL的优化中,有这样三个参数:

skip-innodb / skip-bdb / skip-locking

特别是第一个参数,据说打开后很省内存,所以我在安装完MySQL之后就在my.cnf中填上了这三个参数,但很不幸,在随后的service mysqld restart中,数据库启动失败。这还得了?!于是乎着急毛慌地请教Google去了,不过可悲的是在国内互联网“天下文章一大抄”的现状下,找个准确的、经过个人实践的答案相当不容易,我的问题最终也没解决。

后来想到去看看我的MySQL版本,一看是5.1.54,而且同时在my.cnf中发现一个skip-external-locking参数,在请教过Google后得知:skip-external-locking就是新版本的skip-locking,skip-locking是早几辈子的事了,而且在新版本的MySQL中,已经废除了skip-bdb这个参数!到这基本上问题就解开了,既然skip-locking都改了,那skip-innodb没准儿也改了!最终在MySQLd的文档中找到了这样一句话:

If InnoDB hasn’t been built, the option –skip-innodb isn’t available.  We prefix with ‘loose’ to allow the option to be used at all times. (详情点这里

这就明白了,skip-innodb已经改成loose-skip-innodb了,我还傻乎乎地硬把几年前的老黄历往里塞,真是不假思索的照搬照抄啊,羞愧羞愧!!

 

37 thoughts on “添加skip-innodb后MySQL启动失败

  1. Pingback: 随便 » 安装wordpress总结

  2. Pingback: LAMP一键安装包-XAMPP | 留点后路

  3. If you dont want to use InnoDB tables you can.add the skip-innodb option to your MySQL option file…..Two important disk-based resources managed by the InnoDB storage.engine are its tablespace data files and its log files…..If you specify no InnoDB configuration options MySQL 4.0 and.above creates an auto-extending 10MB data file named ibdata1 and.two 5MB log files named ib logfile0 and ib logfile1 in the MySQL data directory.. In MySQL 4.0.0 and 4.0.1 the data file is 64MB and not auto-extending. .In MySQL 3.23 InnoDB will not start if you provide no configuration.options…..Note To get good performance you should explicitly provide.InnoDB parameters as discussed in the following examples. See the description for innodb buffer pool awe mem mb in.section …..How to tune other mysqld server parameters?.The following values are typical and suit most users ….. mysqld .skip-external-locking.set-variable max connections 200.set-variable read buffer size 1M.set-variable sort buffer size 1M. . Set key buffer to 5 – 50 of your RAM depending on how much. you use MyISAM tables but keep key buffer size InnoDB. buffer pool size 80 of your RAM.set-variable key buffer size ……..

  4. If you dont want to use InnoDB tables you can.add the skip-innodb option to your MySQL option file…..Two important disk-based resources managed by the InnoDB storage.engine are its tablespace data files and its log files…..If you specify no InnoDB configuration options MySQL 4.0 and.above creates an auto-extending 10MB data file named ibdata1 and.two 5MB log files named ib logfile0 and ib logfile1 in the MySQL data directory.. In MySQL 4.0.0 and 4.0.1 the data file is 64MB and not auto-extending. .In MySQL 3.23 InnoDB will not start if you provide no configuration.options…..Note To get good performance you should explicitly provide.InnoDB parameters as discussed in the following examples. See the description for innodb buffer pool awe mem mb in.section …..How to tune other mysqld server parameters?.The following values are typical and suit most users ….. mysqld .skip-external-locking.set-variable max connections 200.set-variable read buffer size 1M.set-variable sort buffer size 1M. . Set key buffer to 5 – 50 of your RAM depending on how much. you use MyISAM tables but keep key buffer size InnoDB. buffer pool size 80 of your RAM.set-variable key buffer size ……..

  5. If you dont want to use InnoDB tables you can.add the skip-innodb option to your MySQL option file…..Two important disk-based resources managed by the InnoDB storage.engine are its tablespace data files and its log files…..If you specify no InnoDB configuration options MySQL 4.0 and.above creates an auto-extending 10MB data file named ibdata1 and.two 5MB log files named ib logfile0 and ib logfile1 in the MySQL data directory.. In MySQL 4.0.0 and 4.0.1 the data file is 64MB and not auto-extending. .In MySQL 3.23 InnoDB will not start if you provide no configuration.options…..Note To get good performance you should explicitly provide.InnoDB parameters as discussed in the following examples. See the description for innodb buffer pool awe mem mb in.section …..How to tune other mysqld server parameters?.The following values are typical and suit most users ….. mysqld .skip-external-locking.set-variable max connections 200.set-variable read buffer size 1M.set-variable sort buffer size 1M. . Set key buffer to 5 – 50 of your RAM depending on how much. you use MyISAM tables but keep key buffer size InnoDB. buffer pool size 80 of your RAM.set-variable key buffer size ……..

  6. If you dont want to use InnoDB tables you can.add the skip-innodb option to your MySQL option file…..Two important disk-based resources managed by the InnoDB storage.engine are its tablespace data files and its log files…..If you specify no InnoDB configuration options MySQL 4.0 and.above creates an auto-extending 10MB data file named ibdata1 and.two 5MB log files named ib logfile0 and ib logfile1 in the MySQL data directory.. In MySQL 4.0.0 and 4.0.1 the data file is 64MB and not auto-extending. .In MySQL 3.23 InnoDB will not start if you provide no configuration.options…..Note To get good performance you should explicitly provide.InnoDB parameters as discussed in the following examples. See the description for innodb buffer pool awe mem mb in.section …..How to tune other mysqld server parameters?.The following values are typical and suit most users ….. mysqld .skip-external-locking.set-variable max connections 200.set-variable read buffer size 1M.set-variable sort buffer size 1M. . Set key buffer to 5 – 50 of your RAM depending on how much. you use MyISAM tables but keep key buffer size InnoDB. buffer pool size 80 of your RAM.set-variable key buffer size ……..

  7. If you dont want to use InnoDB tables you can.add the skip-innodb option to your MySQL option file…..Two important disk-based resources managed by the InnoDB storage.engine are its tablespace data files and its log files…..If you specify no InnoDB configuration options MySQL 4.0 and.above creates an auto-extending 10MB data file named ibdata1 and.two 5MB log files named ib logfile0 and ib logfile1 in the MySQL data directory.. In MySQL 4.0.0 and 4.0.1 the data file is 64MB and not auto-extending. .In MySQL 3.23 InnoDB will not start if you provide no configuration.options…..Note To get good performance you should explicitly provide.InnoDB parameters as discussed in the following examples. See the description for innodb buffer pool awe mem mb in.section …..How to tune other mysqld server parameters?.The following values are typical and suit most users ….. mysqld .skip-external-locking.set-variable max connections 200.set-variable read buffer size 1M.set-variable sort buffer size 1M. . Set key buffer to 5 – 50 of your RAM depending on how much. you use MyISAM tables but keep key buffer size InnoDB. buffer pool size 80 of your RAM.set-variable key buffer size ……..

Leave a Reply

Your email address will not be published. Required fields are marked *