ǰλ: ҳ > >

Mysql InnoDB ṹ

ʱ:

1. Master Thread*汾Ļ߼֮汾޷ڴ˻һЩϸڵţӦʱ


ҳˢ¡ϲ뻺塢UNDO


ỵ̈


־ˢµ̣¼


ϲ뻺


ˢ100ҳ̣checkpoint


ǰûûлbackground loop


ÿʮ̣


ˢҳ


ϲ뻺


־ˢµ


ɾõundoҳ


?


2. IO Thread


ʹAIO


?


3. Purge Thread


Ѿʹòundoҳ


?


4.


ṹҳҳundoҳ뻺壨insert bufferӦhashϢֵϢ


->


д ޸Ļ -> һƵˢҳ


ع㷨 LRU


?


5. ־壨־ԣ


д -> ̣־ļ


ʱ


Master Threadʱˢ



־ʣռС50%


?


6. checkpoint


ã еҳˢ


ʱ


Master Thread CheckPointÿ/ÿʮٶȶʱˢһ첽û̲߳ᱻ


flush_lru_list checkpointLRUбҪһĿҳʱƳбβҳҳҪcheckpoint


async/sync flush checkpoint־õcase


dirty page too much check pointҳ̫ࣩ


?


7. insert buffer


ڷǾۼΨһл崦


дȻ -> ˢ


?


8. ۼ +


ۼB+ȫ


Ҷӽڵ㲻м¼ȫݣṹkey-value + ʵݱǩ


?


?



ӣ