Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2 ?

updated to answer the 3 questions:

mysql> show variables like 'version%';
+-------------------------+------------------+
| Variable_name           | Value            |
+-------------------------+------------------+
| version                 | 5.1.54-1ubuntu4  |
| version_comment         | (Ubuntu)         |
| version_compile_machine | i686             |
| version_compile_os      | debian-linux-gnu |
+-------------------------+------------------+

mysql> show variables like 'have_innodb';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb   | YES   |
+---------------+-------+

mysql> select * from information_schema.engines where engine='InnoDB';
+--------+---------+------------------------------------------------------------+--------------+------+------------+
| ENGINE | SUPPORT | COMMENT                                                    | TRANSACTIONS | XA   | SAVEPOINTS |
+--------+---------+------------------------------------------------------------+--------------+------+------------+
| InnoDB | YES     | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
+--------+---------+------------------------------------------------------------+--------------+------+------------+
1 row in set (0.00 sec)
share|improve this question
1  
If you change it to 0 or 1, then it starts OK? I'm just wondering if this is unrelated –  gbn Feb 9 '12 at 16:03
    
@golimar I upvoted your comment to check the error log, but it'll be tough for him to run the query if he can't start mysql server. The location of the error log should be in the /etc/mysql/my.cnf (I think that is ubuntu's location...might be /etc/my.cnf) –  Derek Downey Feb 9 '12 at 16:03
    
@gbn Yes, If I comment this option, it works well. –  Bruce Dou Feb 10 '12 at 3:30
    
Please run these queries : 1) show variables like 'version%';, 2) show variables like 'have_innodb';, 3) select * from information_schema.engines where engine='InnoDB';. Display the output of these 3 queries in your question. –  RolandoMySQLDBA Feb 10 '12 at 5:19
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.