InnoDB Plugin ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åœ§ç¸®æ©Ÿèƒ½ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
ファイルサイズ㌠1/10 ã«ãªã£ã¦ã‚¢ã‚¯ã‚»ã‚¹é€Ÿåº¦ã‚‚大幅改善ã‹ã€‚実データã§ã“ã‚Œã¯ã™ã”ã„㪠*1。 I’ve tried to convert this table using COMPRESSED row format. This time conversion took 1,5 hours and results were really surprising: Only 5Gb data file (from 60Gb) ~5% I/O load according to iostat (from 99%) ~5% CPU load according to top (from 80-100% mostly waiting for I/O) 0.01 sec average lookup time by primary key (from 1-20 sec before the conve
MySQL ストレージエンジンã¸ã®ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã‚¢ã‚¯ã‚»ã‚¹ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
å‰é … (タイムライン処ç†ã¨ SQL オプティマイザã®å¯èƒ½æ€§ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´) ã®ç¶šã。 一方ã§ã€ã‚¢ãƒ—リケーション開発者ã®ç«‹å ´ã‹ã‚‰è¨€ã†ã¨ã€SQL オプティマイザをãƒãƒ¥ãƒ¼ãƒ³ã™ã‚‹ã¨ã„ã†ã®ã¯è¿‚é ã™ãŽã¦ã‚„ã£ã¦ã‚‰ã‚Œãªã„ã‚ã‘ã§ã€‚ãªã‚‰ã€MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ç›´æŽ¥ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚ˆã†ãªã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’ C++ ã§æ›¸ã‘ã‚Œã°ã€ãã‚ŒãŒä¸€ç•ªé€Ÿã„ã‚“ã˜ã‚ƒãªã„ã®ã¨ã„ã†ã“ã¨ã§ã€ mysql-dev ML ã§è³ªå•ã—ã¦ã¿ãŸã€‚一瞬ã§ç”ãˆãŒè¿”ã£ã¦ããŸã€‚brianaker++ MySQL Lists: internals: Stored Procedures in C++? (and direct access to storage engine API) MySQL Lists: internals: Re: Stored Procedures in C++? (and direct access to
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
処ç†ã‚’実行ä¸ã§ã™
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
http://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/friends_timeline.php
Efficient data transfer through zero copy
{{#tags}}- {{label}}
{{/tags}}