个人工具

UbuntuHelp:MyISAMUnderUbuntu

来自Ubuntu中文

跳转至: 导航, 搜索

You must remove skip-innodb from /etc/mysql/my.cnf otherwise the MySQL that currently ships with Hoary will silently downgrade your MyISAM tables to MyISAM. Very confusing!

david@bunta:~ $ mysql --host=***** --user=***** --password=***** test2
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 765 to server version: 4.0.23_Debian-3ubuntu2-log
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql> drop database test2;
Query OK, 0 rows affected (0.02 sec)
 
mysql> create database test2;
Query OK, 1 row affected (0.00 sec)
 
mysql> CREATE TABLE AccountLink (
    ->   active int(10) unsigned NOT NULL default '0',
    ->   inactive int(10) unsigned NOT NULL default '0',
    ->   UNIQUE KEY inactive (inactive)
    -> ) TYPE=MyISAM;
Query OK, 0 rows affected (0.02 sec)
 
mysql>
mysql> Bye
david@bunta:~ $ mysqldump -a -c --host=***** --user=***** --password=***** test2
-- MySQL dump 9.11
--
-- Host: *****    Database: test2
-- ------------------------------------------------------
-- Server version       4.0.23_Debian-3ubuntu2-log
 
--
-- Table structure for table `AccountLink`
--
 
CREATE TABLE `AccountLink` (
  `active` int(10) unsigned NOT NULL default '0',
  `inactive` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `inactive` (`inactive`)
) TYPE=MyISAM;
 
#
# okay it's come out as MyISAM ... I'll fix it!
#
 
david@bunta:~/root/common $ mysql --host=***** --user=***** --password=***** test2
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 769 to server version: 4.0.23_Debian-3ubuntu2-log
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql> ALTER TABLE AccountLink Type = MyISAM;
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
mysql> Bye
david@bunta:~/root/common $ mysqldump --host=***** --user=***** --password=***** test2
-- MySQL dump 9.11
--
-- Host: *****    Database: test2
-- ------------------------------------------------------
-- Server version       4.0.23_Debian-3ubuntu2-log
 
--
-- Table structure for table `AccountLink`
--
 
CREATE TABLE `AccountLink` (
  `active` int(10) unsigned NOT NULL default '0',
   `inactive` int(10) unsigned NOT NULL default '0',
   UNIQUE KEY `inactive` (`inactive`)
) TYPE=MyISAM;
 
--
-- Dumping data for table `AccountLink`
--
 
david@bunta:~/root/common $
 
#
# Nooo... it's still MyISAM!
#.

Other keywords: MySQLMyISAMDialect