Try just 'storage-engine'
----- Original Message -----
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Sent: Wednesday, April 25, 2007 5:26:40 AM (GMT-0500) America/New_York
Subject: default-storage-engine not working?
Hi, we have just upgraded from mysql 4.1 to 5.0 and this far I only have one
problem. I can't get default-storage-engine to work.
I have "default-storage-engine = INNODB" under my [mysqld] in my.cnf which is
loaded by the daemon (tested with password=xxx). I have also tried
default-table-type, default_table_type and default_storage_engine since I found
unofficial posts saying it with underscores.
Please advice, I have spent 1-2 hours without any answer (probably me that
misses something very easy).
I test if it works with this:
--
mysql> create table g (i int); show table status;
Query OK, 0 rows affected (0.06 sec)
+------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length |
Max_data_length | Index_length | Data_free | Auto_increment | Create_time
| Update_time | Check_time | Collation | Checksum |
Create_options | Comment |
+------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| g | MyISAM | 10 | Fixed | 0 | 0 | 0 |
1970324836974591 | 1024 | 0 | NULL | 2007-04-25
11:28:39 | 2007-04-25 11:28:39 | NULL | latin1_swedish_ci | NULL |
| |
+------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
1 row in set (0.00 sec)
--
My mysql.err looks like this:
--
070425 11:19:01 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
070425 11:19:01 [Warning] Aborted connection 3 to db: 'mytest1' user: 'root'
host: 'localhost' (Got timeout reading communication packets)
070425 11:19:03 InnoDB: Starting shutdown...
070425 11:19:05 InnoDB: Shutdown completed; log sequence number 0 74244313
070425 11:19:05 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
070425 11:19:05 mysqld ended
070425 11:19:06 mysqld started
070425 11:19:07 InnoDB: Started; log sequence number 0 74244313
070425 11:19:07 [Warning] 'user' entry '[EMAIL PROTECTED]' ignored in
--skip-name-resolve mode.
070425 11:19:07 [Warning] 'user' entry '@mgdb01' ignored in --skip-name-resolve
mode.
070425 11:19:07 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.0.37-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community
Server (GPL)
--
InnoDB is enabled:
--
mysql> show engines;
+------------+----------+----------------------------------------------------------------+
| Engine | Support | Comment
|
+------------+----------+----------------------------------------------------------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great
performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary
tables |
| InnoDB | YES | Supports transactions, row-level locking, and foreign
keys |
| BerkeleyDB | NO | Supports transactions and page-level locking
|
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it
disappears) |
| EXAMPLE | YES | Example storage engine
|
| ARCHIVE | YES | Archive storage engine
|
| CSV | YES | CSV storage engine
|
| ndbcluster | DISABLED | Clustered, fault-tolerant, memory-based tables
|
| FEDERATED | YES | Federated MySQL storage engine
|
| MRG_MYISAM | YES | Collection of identical MyISAM tables
|
| ISAM | NO | Obsolete storage engine
|
+------------+----------+----------------------------------------------------------------+
12 rows in set (0.00 sec)
--
I am using 5.0.37:
--
mysql> select version();
+------------+
| version() |
+------------+
| 5.0.37-log |
+------------+
1 row in set (0.00 sec)
--
--
Magnus Månsson
Systems administrator
Massive Entertainment
Office: +46-40-6001000
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
