http://www.mysqlkorea.co.kr
Çѱ۸Ŵº¾ó 5.0 , Çѱ۸Ŵº¾ó 5.1 , MySQL 5.1 HA , »ç¿ëÀڸŴº¾ó
Advanced Knowle...  
¿£Áö´Ï¾î ³ëÆ®  
ºí·Î±×Á¸  
±Û·Î¹ú MySQL  
MySQL 5.5 GA  
MySQL 5.6 Developer  
ÃֽűÛ
foreign key ¼³Á¤¡¦
ÀÎÅØ½º Ãß°¡ µî¿¡¡¦
mysql master - s¡¦
´Ù´ë´Ù °ü°è¿¡¼­ ¡¦
mysql myÆÄÀϰú ¡¦
 
MySQL5.5 Added Features(Ãß°¡µÈ ±â´É)
±Û¾´ÀÌ : royster   ³¯Â¥ : 11-10-21 09:12   Á¶È¸¼ö : 8942

Added Features(Ãß°¡µÈ ±â´É)

´ÙÀ½°ú °°Àº ±â´ÉµéÀÌ MySQL5.5¿¡ Ãß°¡µÇ¾ú½À´Ï´Ù:
  • MySQL5.5¿¡¼­´Â ¸ÖƼ ÄÚ¾î ½Ã½ºÅÛ¿¡¼­ È®À强À» ³ôÀ̱â À§ÇØ SMP ½Ã½ºÅÛ¿¡¼­ ¼º´ÉÀÌ Çâ»óµÇ¾ú½À´Ï´Ù.
    º¯°æ »çÇ×Àº InnoDB Locking ¹× ¸Þ¸ð¸® °ü¸®¿¡ ¿µÇâÀ» ¹ÌĨ´Ï´Ù. See Section 1.5.1, ¡°Scalability Improvements¡±.
  • I/O¸¦ º¸´Ù È¿°úÀûÀ¸·Î »ç¿ëÇÒ ¼öÀÖ°Ô InnoDB I/O¸¦ subsystem¿¡¼­ º¯°æ °¡´ÉÇÕ´Ï´Ù. See Section 1.5.2, ¡°InnoDB I/O Subsystem Changes¡±.
  • Solaris ±â¹ÝÀÇ MySQL ¼­¹öÀÇ ¼º´ÉÀÌ Çâ»óµÇ¾ú½À´Ï´Ù. . See Section 1.5.3, ¡°Enhanced Solaris Support¡±.
  • execution ¹× performance information ±â´ÉÀÌ Ãß°¡µÇ¾ú½À´Ï´Ù. show engine INNODB status Ãâ·Â¿¡¼­ »õ·Î¿î »óÅ º¯¼ö¸¦ Æ÷ÇÔÇÏ¿© ±â´ÉÀÌ È®ÀåµÇ¾ú½À´Ï´Ù. See Section 1.5.4, ¡°Diagnostic and Monitoring Capabilities¡±.
  • default storage engineÀÌ InnoDB·Î º¯°æµÇ¾ú½À´Ï´Ù. See Section 13.6.1, ¡°InnoDB as the Default MySQL Storage Engine¡±.
  • semisynchronous replication¿¡ ´ëÇÑ interfac Áö¿ø: 'Æ®·£Àè¼Ç(transaction) commitÀ» ¿Ï·áÇÑ ½ÃÁ¡¿¡¼­ slave¿¡µµ ¹ÙÀ̳ʸ® ·Î±×°¡ ¹Ý¿µ µÈ °ÍÀ» Master°¡ ÀÎÁõÇÕ´Ï´Ù.' Áï À̰ÍÀ» ÀÎÁõÇÏ´Â ±â´ÉÀÌ Ãß°¡µÇ¾ú½À´Ï´Ù.. Semisynchronous replicationÀº plug-in ÇüÅ·ΠÁö¿øÇÕ´Ï´Ù. See Section 17.3.8, ¡°Semisynchronous Replication¡±
  • SQL standard SIGNAL °ú RESIGNAL ±¸¹®À» Áö¿øÇÕ´Ï´Ù. See Section 12.7.8, ¡°SIGNAL and RESIGNAL¡±.
  • Performance Schema Áö¿ø, Low level¿¡¼­ MySQL ¼­¹ö¸¦ ¸ð´ÏÅ͸µÇϱâÀ§ÇÑ ±â´É Áö¿ø . See Chapter 21, MySQL Performance Schema.
  • Unicode character set Ãß°¡: utf16, utf32, and utf8mb4 µîÀÇ À¯´ÏÄڵ尡 Ãß°¡µÇ¾ú½À´Ï´Ù. See Section 9.1.10, ¡°Unicode Support¡±.
  • »õ·Î¿î LOAD XML ±¸¹®ÀÌ Ãß°¡µÇ¾ú½À´Ï´Ù.
  • µÎ°¡Áö »õ·Î¿î ŸÀÔÀÇ user-defined partitioning Áö¿ø: RANGE COLUMNS partitioningÀº RANGE partitioningÀÇ È®Àå ±â´ÉÀÔ´Ï´Ù. LIST COLUMNS partitioninÀº LIST partitioningÀÇ È®Àå ±â´ÉÀÔ´Ï´Ù. ÀÌ·¯ÇÑ È®ÀåµÈ °¢ MySQLÀÇ partitioningÀº µÎ °¡Áö Çâ»óµÈ ±â´ÉÀ» Á¦°øÇÕ´Ï´Ù.
    1. range , list ÆÄƼ¼Å´×(partitioning)¿¡¼­ DATE, DATETIME ¶Ç´Â string values(CHAR or VARCHAR) Data TypeÀ¸·Î Á¤ÀÇÇÒ¼ö ÀÖ½À´Ï´Ù.
      ¿©·¯ºÐÀº °¢°¢ RANGE COLUMNS ¶Ç´Â LIST COLUMNSÀÇ ÆÄƼ¼Ç Å×ÀÌºí¿¡ multiple column values(º¹ÇÕ Ä÷³ values)¸¦ Á¤ÀÇÇÒ¼öµµ ÀÖ½À´Ï´Ù. ±×¸®°í ÃÖ´ë 16 Ä÷³À» ÂüÁ¶ÇÒ ¼ö ÀÖ½À´Ï´Ù.
    2. ¿©·¯ºÐÀº ÀÌ·¸°Ô ÆÄƼ¼Ç Å×À̺í(partitioning table) Çü½ÄÀ» »ç¿ëÇÏ¿© ÁúÀǸ¦ ÃÖÀûÈ­ ½Ãų¼ö ÀÖ½À´Ï´Ù.(conditions that use multiple comparisons between (different) column values and constants, such as a = 10 AND b > 5 or a < "2005-11-25" AND b = 10 AND c = 50)
    º¸´Ù ¸¹Àº Á¤º¸´Â , see Section 18.2.1, ¡°RANGE Partitioning¡±, and Section 18.2.2, ¡°LIST Partitioning¡±.
  • ALTER TABLE ... TRUNCATE PARTITION ±¸¹®À» »ç¿ëÇÏ¿© ÆÄƼ¼Ç Å×À̺í(partitioned table)ÀÇ Çϳª ÀÌ»óÀÇ ÆÄƼ¼Ç¿¡¼­ ¸ðµç rowÀ» »èÁ¦ÇÒ ¼ö ÀÖ½À´Ï´Ù. Delete¹®À¸·Î Å×À̺íÀÇ ±¸Á¶¿¡ ¿µÇâÀ»ÁÖÁö ¾Ê°í row¸¦ »èÁ¦ÇÒ¼ö ÀÖ½À´Ï´Ù.
  • Key caches´Â ÇöÀç CACHE INDEX ¹× LOAD INDEX INTO CACHE ±¸¹®À» »ç¿ëÇÏ¿© ºÐÇÒµÈ MyISAM Å×ÀÌºí¿¡ À妽º(index)¸¦ Áö¿øÇÕ´Ï´Ù.
  • MySQLÀÇ µÎ °¡Áö »õ·Î¿î ÀÎÁõ±â´ÉÀº pluggable authentication(Ç÷¯±× ÀÎÁõ) ¹× proxy users(ÇÁ·Ï½Ã »ç¿ëÀÚ) ÀÔ´Ï´Ù. see Section 5.5.6, ¡°Pluggable Authentication¡±, and Section 5.5.7, ¡°Proxy Users¡±.
  • TO_SECONDS() ÇÔ¼ö°¡ Ãß°¡µÇ¾ú½À´Ï´Ù. ÀÌ ÇÔ¼ö´Â 0³â ÀÌÈÄ·Î ÃÊ ´ÜÀ§ÀÇ ¼ýÀÚ¸¦ date ¶Ç´Â datetime Çü½ÄÀ¸·Î º¯È¯ÇÕ´Ï´Ù. ¿©·¯ºÐÀº ÆÄƼ¼Ç Ç¥Çö½Ä¿¡¼­ À̱â´ÉÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
  • MySQL releases ÀÌÁ¦ GNU´Â autotoolsº¸´Ù´Â CMake¸¦ »ç¿ëÇÕ´Ï´Ù. µû¶ó¼­ MySQL source(¼Ò½º) ¼³Ä¡¸¦ À§ÇÑ ¼³¸íÀº CMake¸¦ »ç¿ëÇÏ¿© MySQLÀ» ¼³Ä¡ÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÏ¿´½À´Ï´Ù. See Section 2.9, ¡°Installing MySQL from Source¡±.
    ¼³Ä¡¹æ¹ý(build process)´Â Windows¸¦ Æ÷ÇÔÇÑ ¸ðµç Ç÷§Æû¿¡ ±âÁ¸°ú À¯»çÇÕ´Ï´Ù.

Removed Features (»èÁ¦µÈ ±â´É)

¾Æ·¡ constructs´ÂMySQL 5.5¿¡¼­ »èÁ¦µÇ¾ú½À´Ï´Ù.
  • The log_bin_trust_routine_creators system variable (use log_bin_trust_function_creators).
  • The myisam_max_extra_sort_file_size system variable.
  • The record_buffer system variable (use read_buffer_size).
  • The sql_log_update system variable.
  • The table_type system variable (use storage_engine).
  • The FRAC_SECOND modifier for the TIMESTAMPADD() function.
  • The TYPE table option to specify the storage engine for CREATE TABLE or ALTER TABLE (use ENGINE).
  • The SHOW TABLE TYPES SQL statement (use SHOW ENGINES).
  • The SHOW INNODB STATUS and SHOW MUTEX STATUS SQL statements (use SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX).
  • The SHOW PLUGIN SQL statement (use SHOW PLUGINS).
  • The LOAD TABLE ... FROM MASTER and LOAD DATA FROM MASTER SQL statements (use mysqldump or mysqlhotcopy to dump tables and mysql to reload dump files).
  • The BACKUP TABLE and RESTORE TABLE SQL statements (use mysqldump or mysqlhotcopy to dump tables and mysql to reload dump files).
  • TIMESTAMP(N) data type: The ability to specify a display width of N (use without N).
  • The --default-character-set and --default-collation server options (use --character-set-server and --collation-server).
  • The --delay-key-write-for-all-tables server option (use --delay-key-write=ALL).
  • The --enable-locking and --skip-locking server options (use --external-locking and --skip-external-locking).
  • The --log-bin-trust-routine-creators server option (use --log-bin-trust-function-creators).
  • The --log-long-format server option.
  • The --log-update server option.
  • The --master-xxx server options to set replication parameters (use the CHANGE MASTER TO statement instead): --master-host, --master-user, --master-password, --master-port, --master-connect-retry, --master-ssl, --master-ssl-ca, --master-ssl-capath, --master-ssl-cert, --master-ssl-cipher, --master-ssl-key.
  • The --safe-show-database server option.
  • The --skip-symlink and --use-symbolic-links server options (use --skip-symbolic-links and --symbolic-links).
  • The --sql-bin-update-same server option.
  • The --warnings server option (use --log-warnings).
  • The --no-named-commands option for mysql (use --skip-named-commands
  • The --no-pager option for mysql (use --skip-pager).
  • The --no-tee option for mysql (use --skip-tee).
  • The --position option for mysqlbinlog (use --start-position).
  • The --all option for mysqldump (use --create-options).
  • The --first-slave option for mysqldump (use --lock-all-tables).
  • The --config-file option for mysqld_multi (use --defaults-extra-file).
  • The --set-variable=var_name=value and -O var_name=value general-purpose options for setting program variables (use --var_name=value).
  • The --with-pstack option for configure and the --enable-pstack option for mysqld.
ÀÌÀü±Û MySQL 5.5 ÆÄƼ¼Ç ±â´É °³¼±»çÇ× ÀÚ¼¼È÷ ¾Ë¾Æº¸±â 
´ÙÀ½±Û MySQL5.5.x Storage Engines 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.