суббота, 30 апреля 2011 г.

mysql InnoDB disabled (Unknown)


mysql> SHOW VARIABLES LIKE 'have_innodb';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb | NO |
+---------------+-------+
1 row in set (0.00 sec)



IN /etc/mysql/my.cnf
innodb_buffer_pool_size=1000M # or someone
Restart mysql


mysql> SHOW VARIABLES LIKE 'have_innodb';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb | NO |
+---------------+-------+


mysql stop
Remove /var/lib/mysql/ib_logfile*


mysql start
PROFIT


mysql> SHOW VARIABLES LIKE 'have_innodb';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb | YES |
+---------------+-------+

Комментариев нет:

Отправить комментарий