[B! database] buty4649ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

buty4649 id:buty4649

databaseã«é–¢ã™ã‚‹buty4649ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Watch Out for Disk I/O Performance Issues when Running EXT4
buty4649 2022/02/21
performance

database

Linux

ext4
ãƒªãƒ³ã‚¯
MySQL 4.0ã§9å¹´å‹•ãç¶šã‘ãŸã‚µãƒ¼ãƒã‚’ ãƒªãƒ—ãƒ¬ã‚¤ã‚¹ã—ã¦ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ãŸè©±
MySQL Casual Talks vol.7 http://mysql-casual.connpass.com/event/9767/Read less
buty4649 2014/12/13
mysql

database

é‹ç”¨
ãƒªãƒ³ã‚¯
PostgreSQL Internals
æœ¬ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¯ã€2014å¹´1æœˆ30ï½ž31æ—¥ã«ç‘æ³¢å¤§å¦ã§é–‹è¬›ã•ã‚ŒãŸã€Œæƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ç‰¹åˆ¥è¬›ç¾©Dã€ã«ãŠã‘ã‚‹è¬›ç¾©ã€ŒInside PostgreSQL Kernelã€ã®å†…å®¹ã‚’å†æ§‹æˆã€åŠ ç†ãƒ»ä¿®æ£ã—ãŸã‚‚ã®ã§ã™ã€‚ ã¯ã˜ã‚ã« æœ¬ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã«ã¤ã„ã¦ æœ¬ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¸ã®ãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã«ã¤ã„ã¦ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£æ¦‚è¦ PostgreSQLã®æ§‹æˆè¦ç´ PostgreSQLã®åŸºæœ¬çš„ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ SQLæ–‡ã®å‡¦ç†ã•ã‚Œã‚‹æµã‚Œ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç®¡ç† ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã«ãŠã‘ã‚‹ACIDç‰¹æ€§ å„ãƒ¬ã‚³ãƒ¼ãƒ‰ã®å¯è¦–æ€§ã®ç®¡ç† Atomicityï¼ˆåŽŸåæ€§ï¼‰ã®å®Ÿè£… Consistencyï¼ˆä¸€è²«æ€§ï¼‰ã®å®Ÿè£… Isolationï¼ˆåˆ†é›¢æ€§ï¼‰ã®å®Ÿè£… ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã®å®šç¾© Durabilityï¼ˆæ°¸ç¶šæ€§ï¼‰ã®å®Ÿè£… ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆ ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ç®¡ç† pg_controlãƒ•ã‚¡ã‚¤ãƒ« OID/XID/TID ã‚·ã‚¹ãƒ†ãƒ ã‚«ã‚¿ãƒã‚° MVCCã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸æ§‹é€ ãƒ†
buty4649 2014/05/11
postgresql

database

SQL
ãƒªãƒ³ã‚¯
InfluxDB ã‚’ã¡ã‚‡ã£ã¨ã•ã‚ã£ã¦ã¿ãŸ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
Influx DBã¨ã¯ http://influx db.org ãƒ¡ãƒˆãƒªã‚¯ã‚¹ã‚„ã‚¤ãƒ™ãƒ³ãƒˆã¨ã„ã£ãŸæ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹ã®ã«é©ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã§ã™ã€‚ ã¡ãªã¿ã« go ã§æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã¡ãªã¿ã« 2013ã®Open Source Rookiesã«é¸ã°ã‚Œã¾ã—ãŸã€‚ Influx DBã®ç‰¹å¾´ RRDã‚„MySQLã«æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹å ´åˆã¨æ¯”è¼ƒã—ã¦ã€Influx DBã®ç‰¹å¾´ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã¯ LevelDB LevelDBã¨ã¯ã€ã‚ãƒ¼ã§ã‚½ãƒ¼ãƒˆã•ã‚ŒãŸçŠ¶æ…‹ã§å¯èƒ½ã•ã‚ŒãŸKVSã§ã™ï¼ˆGoogleè£½ï¼‰ã€‚è©³ã—ãã¯ã“ã®ã¸ã‚“å‚ç…§ã®ã“ã¨ã€‚ http://en.wikipedia.org/wiki/LevelDB https://code.google.com/p/leveldb/ https://speakerdeck.com/smly/influx db-and-leveldb-inside-out å°†æ¥çš„ã«Lev
buty4649 2014/04/08
database

InfluxDB

JSON

leveldb
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5) - SH2ã®æ—¥è¨˜
ã¨ã„ã†ã‚ã‘ã§ã€JPOUG> SET EVENTS 20120721 | Japan Oracle User Groupã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é€šå¸¸ã®å‹‰å¼·ä¼šã¨æ¯”ã¹ã¦ç™ºè¡¨è€…ã¨è´è¬›è€…ã®ä¸€ä½“æ„Ÿã‚’å¢—ã™ãŸã‚ã®å·¥å¤«ãŒãªã•ã‚Œã¦ã„ã¦ã€ã¨ã¦ã‚‚è‰¯ã‹ã£ãŸã¨æ€ã„ã¾ã™ã€‚æœ‰é™ã‚³ãƒ¼ãƒ’ãƒ¼ã‹ã¨æ€ã£ãŸã‚‰ç„¡é™ãƒ“ãƒ¼ãƒ«ã ã£ãŸã®ã‚‚é©šãã§ã™ã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5)ã¨é¡Œã—ã¦éŽåŽ»4å›žåˆ†ã®ã¾ã¨ã‚ã¨è‡ªä½œãƒ„ãƒ¼ãƒ«ã®ç´¹ä»‹ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚JdbcRunnerã¯Oracle Databaseã€MySQLã¨PostgreSQLã®é–“ã§TPC-Bã¨TPC-Cã®æ€§èƒ½æ¯”è¼ƒãŒã§ãã‚‹å”¯ä¸€ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã®ã§ã€ã„ã‚ã„ã‚è©¦ã—ã¦ã¿ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚è©¦ã—ãŸçµæžœ
buty4649 2012/07/23
database

oracle

mysql
ãƒªãƒ³ã‚¯
1