Recent changes Random page
GAMING
Technology
 
Gaming
Entertainment
Science Fiction
Biggest wikis
Hobbies
Music
See more...

MySQL Differences

From Drizzle Wiki

Jump to: navigation, search
 

Contents

[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';
Rate this article:
Share this article: