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ÆÄÀϰú ¡¦
 
[Âü°í] InnoDB Architecture
±Û¾´ÀÌ : taeguni   ³¯Â¥ : 11-10-05 10:41   Á¶È¸¼ö : 8503

InnoDB Architecture

¸ñÂ÷

InnoDBÀÇ ¸ñÇ¥

  • OLTP ÁöÇà
  • °í¼º´É, ¾ÈÁ¤¼º, È®À强
  • µ¥ÀÌÅÍ º¸È£
  • À̽ļº

InnoDBÀÇ ÁÖ¿ä ±â´É Ư¼º

  • Full transaction Áö¿ø
  • Row-level locking
  • MVCC
  • Crash º¹±¸
  • È¿À²ÀûÀÎ IO °ü¸®

InnoDB Architecture

InnoDB Architecture
¡â
Server
¡ä
¡â
Applications
¡ä
Handler API Embedded InnoDB API
Transaction
Mini-transaction Cursor/Row Lock
B-tree
Page
Buffer
File Space Manager
IO

InnoDBÀÇ ÆÄÀÏ Çü½Ä(Disk Format)

ÀÌÀü±Û 7.2.5. Other Optimization Tips 
´ÙÀ½±Û MySQL 5.6ÀÇ »õ·Î¿î ±â´É 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.