NTSE Web MySQL (Breezes/ ).. http://wangyuanzju.blog.163.com wangyuan@corp.netease.com
NTSE: Non-Transactional Storage Engine MySQL InnoDB 10 InnoDB +Memcached 5 50% / 2008.6 2010.5 90K C++
Web - UGC Web 2.0-20T - - Memcached - Memcached - IO Memcached 90% - IO - SQL CPU MySQL - / Web
- MySQL+InnoDB - - - - Memcached - - OSCAR MySQL
Web - IO CPU UGC IO CPU à CPU IO - à - 5% à - à
- IO - NTSE - Memcached - 30-40% - 30% - 40% - InnoDB 19 NTSE 0 4 UPDATE - IO -
- - - - - -
ACID vs ACID NTSE - - ACID - - ACID
Blogbench Blog Memcached
NTSE vs InnoDB 10% NTSE InnoDB 7-13 InnoDB+Memcache 3-5
NTSE vs Oracle etc NTSE XtraDB InnoDB Plugin Oracle
MMS MMS Main Memory Storage MMS MMS vs - - MMS MMS - <30% -
MMS UPDATE UPDATE MMS UPDATE - MMS - - -
MMS vs Memcached MMS Memcached Memcached - - UPDATE - - UPDATE UPDATEè - - - + - + MMS - + UPDATE - + - + - + - - - - LRU
MMS 1 MMS - - LOG - IO - - RID PID IO IO - - à IO - à IO - - Smart sleep sleep
MMS 2 MMS - - LRU CLOCK - - 2 LRU+ à LRU - - - - - -
- 0/0xFF - memcmp - 30% - MiniPage 15 MiniPage MiniPage 35% - LZO 40% - 64K - - - CPU
- - - - NTSE - - - - - - - INSERT/DELETE - UPDATE DELETE INSERT - IO
- - / - - RID - RID - - - <10 - UNDO REDO - NTSE REDO
NTSE 2.0à TNT NTSE 2.0 TNT Transactional or Non- Transactional - - - - - - - Index only NTSE
Memcached - - - ACID - - CAS Consistency - Consistency - Eventual Consistency - EC - CAP - 1000 P C - 100 A A C