サイボウズã¯ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ™ãƒ¼ã‚¹ã®ã‚°ãƒ«ãƒ¼ãƒ—ウェアやæ¥å‹™æ”¹å–„サービスを軸ã«ã€ç¤¾ä¼šã®ãƒãƒ¼ãƒ ワークå‘上を支æ´ã—ã¦ã„ã¾ã™ã€‚
CyDN - MySQL 㧠BLOB を扱ã†ãŸã‚ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ "BLOB Streaming Engine"
サイボウズã¯ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ™ãƒ¼ã‚¹ã®ã‚°ãƒ«ãƒ¼ãƒ—ウェアやæ¥å‹™æ”¹å–„サービスを軸ã«ã€ç¤¾ä¼šã®ãƒãƒ¼ãƒ ワークå‘上を支æ´ã—ã¦ã„ã¾ã™ã€‚
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
Database Optimization for Rails Apps
Database Optimization for Rails Apps 20th Nov 2007 by Gwyn Morfey Summary Use STRAIGHT_JOIN if MySQL is doing something silly MySQL Datetimes are not slow MyISAM is much, much faster than InnoDB Consider MySQL partitioning; it's not hard Watch out for background optimisation and query caching Log everything you do, and why The reporting application I'm working on does a date-range select against a
1
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
https://labs.cybozu.co.jp/blog/kazuho/archives/2008/02/triton-embed-primary-key.php
{{#tags}}- {{label}}
{{/tags}}