From Drizzle Wiki

Contents 1 Installation 2 Objects Removed 3 Operators Removed 4 Procedures Removed 5 Keywords Removed 6 Information Schema Changes 7 Commands Removed 8 Alternatives to Removed Commands 8.1 SHOW ENGINES

[edit] Installation

• There is no Windows version. Drizzle runs under any Unix system (currently tested on Linux, Mac OS X, and Solaris only).
• There is no 'scripts/mysql_install_db' or related command.
• There is no 'mysql' or related default system database.
• There is no UNIX socket, the only protocol is TCP/IP.
• drizzled defaults to the port 4427. This is an Officially Assigned Port
• There is no timezone support. Use UTC.
• The MERGE storage engine has been removed.
• The FEDERATED storage engine has been removed.
• The BLACKHOLE storage engine is not installed by default. You may install it by using ./configure --with-plugins=blackhole
• The default storage engine is InnoDB.

[edit] Objects Removed

• There is no 'mysql' database.
• There is no 'test' database.
• There is no MEDIUM datatype. Use INT.
• There are no TINYBLOB, MEDIUMBLOB and LONGBLOB datatypes. Use BLOB.
• There are no TINYTEXT, MEDIUMTEXT and LONGTEXT datatypes. Use TEXT.
• There are no spatial data types GEOMETRY, POINT, LINESTRING & POLYGON (go use Postgres).
• No YEAR field type.
• There are no FULLTEXT indexes for the MyISAM storage engine (the only engine FULLTEXT was supported in). Look at either Lucene or Sphinx.
• No "dual" table.
• No Views.
• No Stored Procedures.
• No Triggers.
• No Prepared statements.
• No partitions.
• No event scheduler.

[edit] Operators Removed

• BIT: &&,>>,<<,~,^,|,&

[edit] Procedures Removed

• Removed crypt()

[edit] Keywords Removed

CIPHER, CLIENT, CODE, CONTRIBUTORS, CPU, DEFINER, DES_KEY_FILE, ENGINES, EVERY, IO, IPC, ISSUER, BIT_AND, BIT_XOR, BIT_OR

[edit] Information Schema Changes

Removed references to event fields information, {user, schema, table, column, table constraints, paramaters} privileges fields info

[edit] Commands Removed

• Most SHOW commands.
• drizzleadmin options

* create database

* debug

* drop database

* extended-status

* flush-hosts

* flush-logs

* flush-status

* flush-tables

* flush-threads

* flush-privileges

* kill

* password

* old-password

* processlist

* reload

* refresh

* status

* start-slave

* stop-slave

* variables

* version

• ALTER TABLE UPGRADE

[edit] Alternatives to Removed Commands

[edit] SHOW ENGINES

drizzle>> SELECT * FROM information_schema.plugins WHERE plugin_type ='STORAGE ENGINE';