http://www.mysqlkorea.co.kr
ѱ۸Ŵ 5.0 , ѱ۸Ŵ 5.1 , MySQL 5.1 HA , ڸŴ
ѱ۸Ŵ 5.0  
ѱ۸Ŵ 5.1  
MYSQL 5.1 HA  
ڸŴ  
Ŵ  
ֽű
Can't open and l
󸶽
PREPARE
mariadb replicat
sql ġ
 
ڸŴ > Ŵ > ڸŴ
 

1.2.1. MySQL 5.1 ο

 

5.1 Ʒ ɵ Ӱ ߰Ǿ:

  • Partitioning: ̰ ̺ Ģ ̺ κ ýۿ ֵ ϴ ̴. , ̺ ٸ κе ٸ ġ ִ ̺ , ٸ, Ƽǵ ̺ ϳ ̺ ̰ ȴ.
  • Row-based replication: MySQL ø̼ Ģ Ϳ ̺ SQL ɹ ϴ ̴. ̰ statement-based replication̶ θ. MySQL 5.1.5 ĺʹ, ٸ ø̼ ְ Ǿ. ̷ row-based replication̶ θ. Ŀ, SQL ɹ ̺꿡 ϴ ſ, Ͱ ø̼ǿ شϴ ̺ 󸶳 Ǵ Ű ڽ ̳ʸ α׿ ̺Ʈ ϰ ȴ. MySQL 5.1.8 ĺʹ, ° ɼ ְ ȴ: mixed. ɹ- ø̼ (statement-based replication) Ʈ ϰ, Ư - ø̼ (row-based replication) ȯѴ.
  • Plugin API: MySQL 5.1 ä پ ۳Ʈ ε/ε ְԲ ִ ÷ API ߰Ͽ.
  • Event scheduler: MySQL ̺Ʈ ٿ Ǵ ׽ũ (task) ϴ ̴.
  • Server log tables: MySQL 5.1 , Ϲ α׿ ο α Ʈ α Ͽ Ͽ. 5.1 ĺʹ, ̷ α׵鿡 α ϰ Ǿ. , α Ʈ α Ͽ ϰų Ǵ mysql ͺ̽ ִ general_log slow_log ̺ ְ Ǿ.
  • The Instance Manager (IM) ΰ ɵ ԵǾ ִ: SHOW instance_name LOG FILES α Ʈ ϸ, SHOW instance_name LOG {ERROR | SLOW | GENERAL} size α κ ϰ, ׸ SET instance_name.option_name=option_value ؼ ɼ ϰ Ͽ Ѵ.
  • Upgrade program: mysql_upgrade α׷ (MySQL 5.1.7 ĺ ) ϰ ִ MySQL ̺ ׷̵ϰ ϴ ؼ ʿ ؾ κп ؼ ġ ϰ ȴ.
  • Replication between MySQL Clusters Ǹ, MySQLŬͿ -Ŭ ͺ̽ ø̼ǵ Ѵ.
  • MySQL Cluster Disk Data: MySQL 5.1.6 , NDBCluster ޸𸮿 Ͽ, MySQL 5.1.6 ĺʹ, Ŭ (ε ) ũ ְ Ǿ. ̸ ؼ, MySQLŬ͸ ڿ ִ ýۿ ų ְ Ǿ.
  • MySQL Cluster ADD INDEX DROP INDEX: NDB ϴ ̺ ε ߰ ſ .
  • MySQL Cluster : ŬͿ ߻ߴ ̱ ü 5.1 ذϿ.
  • tablespaces : mysqldump ƿƼ ̺̽ ɼ ȴ. -Y Ǵ --all-tablespaces ɼ ϸ Ȱȭ ų ִ.
  • INFORMATION_SCHEMA : MySQL 5.1 ڽ Ÿ ͺ̽ ؼ Ѵ. ̷ ͺ̽ ο ̺ Եȴ: FILES, EVENTS, PARTITIONS, PROCESSLIST, ENGINES, ׸ PLUGINS.
  • XML functions: ExtractValue() Լ ־ Xpath İ ġ Ǵ XML ׸Ʈ Ѵ. UpdateXML() Լ ڰ Xpath ؼ XML ׸Ʈ κ XML ׸Ʈ (ڰ ) üϰ, XML Ѵ.

Load emulator: mysqlslap α׷ MySQL Ŭ̾Ʈ ε带 ķƮؼ ܰ ð Ʈϱ ȵ ̴. ̰ ġ Ŭ̾Ʈ ó Ѵ.

1.2.1. MySQL 5. 1 ο
MySQL Korea Ʈ ()̺ Ƿ 縦 մϴ.
2010-2011 ssebiz All Rights Reserved.