MySQL
 MySQL |
|
MySQL (: [maɪ ˌɛskjuːˈɛl]; . ) [4] (). MySQL Oracle Corporation, Sun Microsystems, . GNU General Public License . , .
MySQL . WAMP, AppServ, LAMP , XAMPP. MySQL , , , MySQL .
MySQL : MyISAM, , InnoDB, . , MySQL EXAMPLE, . GPL-, MySQL .
26 2008 Sun Microsystems MySQL AB 1 .[5]
27 2010 Oracle Corporation Sun Microsystems MySQL .[6]
MySQL , Drizzle (.), OurDelta, Percona Server, MariaDB. Sun MySQL AB Oracle.
|
|
[] MySQL
MySQL mSQL : , ISAM . SQL-, API- mSQL. «MySQL» . : , My, My, , [7][8].
MySQL «Sakila». « ». «Sakila» Open Source- Ambrose Twebaze.
[]
MySQL . MySQL GPL. GPL, - MySQL, GPL. , . , .
[]
MySQL : AIX, BSDi, FreeBSD, HP-UX, Linux, Mac OS X, NetBSD, OpenBSD, OS/2 Warp, SGI IRIX, Solaris, SunOS, SCO OpenServer, SCO UnixWare, Tru64, Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP, Windows Server 2003, WinCE, Windows Vista Windows 7. MySQL OpenVMS. , , MySQL.
[]
MySQL API Delphi, C, C++, , Java, , Perl, PHP, Python, Ruby, Smalltalk, Tcl, .NET, ODBC ODBC- MyODBC.
[]
- MySQL 23 1995 .
- Windows (Windows 95 NT) 8 1998.
- 3.23: - 2000, 2001.
- 4.0: 2002, 2003.
- 4.1: 2004, 2004.
- 5.0: 2005, 2005.
- 5.1: 2005, 2008.
- 5.4: 2009, .
- 5.5: 2010.
- 5.6: (5.6.4 m8 10 2012).
[] MySQL 4.0
, 4.0 , . :
[] MySQL 4.1
- .
- ;
- - , ;
- Microsoft Windows Linux;
- OpenSSL -;
- - , ;
- (UTF-8 UCS2);
- GIS, ;
- .
[] MySQL 5.0
MySQL 5.0 24 2005 , , MySQL . MySQL SQL, , SQL. MySQL 5.0 :
[] MySQL 5.1
MySQL 5.1 SQL:2003. MySQL 5.1 [9][10].
- , , . , , .
- , SQL2003.
- (. row-based replication), (, , ) . sql-, MySQL (. mixed replication).
- . , crontab.
- XML, XPath.
- . -, general_log slow_log. mysqlslap .
- mysql_upgrade, , .
- MySQL Cluster , MySQL 5.1 NDBCLUSTER.
- MySQL Cluster, , , , .
- libmysqld, MySQL 5.0.
- API , , (, ), .
- plug-in.
- Maria ( MyISAM).
[] Maria
Maria ( 5.2.x - Aria) MySQL . Maria MyISAM, .
Maria [11].
- LOCK TABLES. .
- , CREATE/DROP/RENAME/TRUNCATE. , .
- MyISAM, «rows-in-block», , .
- : , .
- 8 ( MyISAM 1), , .
[] MySQL 5.5
MySQL 5.5 MySQL 5.4 , , :
- InnoDB.
- (semi-synchronous) , InnoDB Google.
- . , * (partitioning). RANGE, LIST «partition pruning».
- JOIN .
- .
- Google InnoDB CPU .
[] MySQL 6.0
MySQL 6.0 -. 5.2, 6.0. , MySQL 6.0 , 5.5 5.6.
6.0 Falcon, InnoDB Innobase, Oracle. 2010 Sun Microsystems Oracle, Falcon .
[]
[]
MySQL 3.22: 4
MySQL 3.23+: 8 (263 )
. MyISAM . NTFS 32 . InnoDB , . 64 .
[]
4.1 MySQL . Windows-1251, SQL- :
SET character_set_client='cp1251'; SET character_set_results='cp1251'; SET character_set_connection='cp1251';
:
SET NAMES 'cp1251'
character_set_client , character_set_results , character_set_connection , , .
SET NAMES 'utf8'
[]
- MySQL 5.5.25 Release notes
- MySQL 5.6.5 Release notes
- [1]Oracle Provides Early Access to MySQL 5.6 New Features,MySQL Forums :: Announcements, Oracle MySQL 5.6
- 1.3.1. What is MySQL? (.). MySQL 5.5 Reference Manual. Oracle Corporation. 23 2011. 24 2010.
- MySQL :: Observations by Kaj Arnö @Sun (.)
- Oracle Sun (.)
- MySQL. = MySQL. Administrator's Guide. .: «», 2005. . 624. ISBN 5-8459-0805-1
- MySQL (.)
- MySQL 5.1
- MySQL 5.1
- Maria opennet.ru
[] .
[]
[]
- . . MySQL: = MySQL Database Usage & Administration. .: «», 2011. 368 . ISBN 978-5-459-00264-5
- , , . PHP MySQL. , 2- = PHP 6 and MySQL 6 Bible. .: «», 2010. 912 . ISBN 978-5-8459-1640-2
- , . MySQL 5: = Beginning MySQL. .: «», 2007. 880 . ISBN 978-5-8459-1167-4
- , . MySQL . .: «-», 2008. . 952. ISBN 978-5-9775-0066-1
- . MySQL, 3- = MySQL, 3ed. .: «», 2006. 1168 . ISBN 5-8459-1119-2
- , . MySQL 5. . .: «-», 2006. . 1024. ISBN 5-94157-928-4
- , . MySQL 5. .: «-», 2006. . 560. ISBN 5-94157-754-0
| MySQL | |
|---|---|
| MySQL · MySQL Enterprise · MySQL Cluster | |
| MySQL Workbench · phpMyAdmin · HeidiSQL · Navicat | |
| MyISAM · Falcon · InnoDB · XtraDB · MySQL Federated · MySQL Archive · Maria · Aria | |
| Drizzle · MariaDB · Percona Server | |
| () | |
|---|---|
| - | |
| - | |
| SQL | |
|---|---|
