[B! mysql] maisenakajimaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

maisenakajima id:maisenakajima

mysqlã«é–¢ã™ã‚‹maisenakajimaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (24)

${{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}}

MySQLã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£å›³è§£è¬›åº§
7. ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã‚ˆã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã®ä¾‹ ha_tina::store_lock ha_tina::external_lock ha_tina::info ha_tina::rnd_init ha_tina::extra - ENUM HA_EXTRA_CACHE Cache record in HA_rrnd() ha_tina::rnd_next ha_tina::rnd_next ha_tina::rnd_next ha_tina::rnd_next ha_tina::rnd_next ha_tina::rnd_next ha_tina::rnd_next ha_tina::rnd_next ha_tina::rnd_next ha_tina::extra - ENUM HA_EXTRA_NO_CACHE End caching of records (def) ha_t
maisenakajima 2016/07/30
mysql

ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£

SlideShare

Database

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ORDER BYã§ã€å˜ç´”ãªæ˜‡é †é™é †ã€Œä»¥å¤–ã€ã§ä¸¦ã¹ã‚‹ï¼ - ãªã‹ã‚‰ãªLife
ã„ã‚„ãƒ¼ã€çŸ¥ã‚‰ãªã„ã£ã¦æ€–ã„ãã€‚ ãªã‚“ã ã“ã®ã‚ãƒ¢ã„SQLã¯ã€ã£ã¦æ€ã£ã¦ã—ã¾ã£ãŸã‘ã©ã€èª¿ã¹ã¦ã„ã‚‹ã‚¦ãƒã«ã€ã“ã‚Œã¡ã‚ƒã‚“ã¨SQLæ§‹æ–‡ã«å‰‡ã£ã¦ã‚‹ï¼ã“ã¡ã‚‰ãŒé–“é•ã£ã¦ãŸï¼ã£ã¦äº‹ãŒã‚ã‹ã£ã¦ã„ãã¾ã—ãŸã€‚ ã‚ãˆã¦ã€çŸ¥ã‚‰ãªã‹ã£ãŸæ‰€ã‹ã‚‰å‹¢ã„ã§æ›¸ã„ã¦ã„ãŸã®ã‚’ã€ãã®ã¾ã¾ã«ã—ã¦ã¿ã¾ã—ãŸã€‚ ã‚ãƒ¢ã„SQLã‚³ãƒ¼ãƒ‰ã‚’å¶ç„¶è¦‹ã¤ã‘ãŸ SQLã«ãŠã‘ã‚‹ORDER BYã£ã¦ã€ãã®å¾Œã«ã‚«ãƒ©ãƒ ï¼ˆãŠã‚ˆã³ãã®ã‚¨ã‚¤ãƒªã‚¢ã‚¹ï¼‰ã‚’ä¸¦ã¹ã¦ã‚½ãƒ¼ãƒˆé †ã¨ã—ã¦ä½¿ç”¨ã™ã‚‹ã‚ã‘ã§ã™ãŒã€MySQLæ¡ˆä»¶ã®ãŠä»•äº‹ã®ä¸ã§å¶ç„¶ã“ã‚“ãªã‚‚ã®ã‚’è¦‹ã¤ã‘ã¦ã€çµµã«æã„ãŸã‚ˆã†ãªäºŒåº¦è¦‹ãƒªã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã—ã¾ã—ãŸã€‚ SELECT * FROM tbl ORDER BY id = 23; -- (1) SELECT * FROM tbl ORDER BY FIELD( id, 23, 234, 543, 23 ); -- (2)ã“ã†ã—ãŸã€ã€ŒORDER BYã«ã€ã‚ãŸã‹ã‚‚WHEREå¥ã§çµžã‚Šè¾¼ã‚€æ¡ä»¶æŒ‡å®šã®ã‚ˆã†ãªä½¿
maisenakajima 2016/07/30
mysql

SQL

database

sort
ãƒªãƒ³ã‚¯
JDBC Metadata, MySQL and Oracle Recipes PDF Download Free | 1590596374
JDBC 4.0 and Oracle JDeveloper for J2EE Development A J2EE developer's guide to using Oracle JDeveloper's integrated database features to build data-driven applications This book is a practical reference guide to using Oracle JDeveloper IDE and JDBC 4.0 to develop J2EE data-driven applications. The book is suitable for Java/J2EE and Oracle JDeveloper beginners. If you are a J2EE developer and want
maisenakajima 2015/09/05
JDBC Metadata, MySQL, and Oracle Recipes is the only book that focuses on metadata or annotation-based code recipes for JDBC API for use with Oracle and MySQL.

free

ebook

PDF

Java

programming

mysql

Oracle

database
ãƒªãƒ³ã‚¯
SQLã®è¦³ç‚¹ã‹ã‚‰ã€ŒOracle Databaseã€ã€ŒPostgreSQLã€ ã€ŒMySQLã€ã®ç‰¹å¾´ã‚’æ•´ç†ã—ã‚ˆã†ï¼
EnterpriseZineï¼ˆã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¸ãƒ³ï¼‰ç·¨é›†éƒ¨ã§ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“ã®æ–¹ã€…å‘ã‘ã«ã€EnterpriseZine Dayã€Security Online Dayã€DataTechã¨ã„ã†ã€3ã¤ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œç·¨é›†éƒ¨ç‹¬è‡ªã®åˆ‡ã‚Šå£ã§ã€æ¥ç•Œãƒˆãƒ¬ãƒ³ãƒ‰ã‚„æœ€æ–°äº‹ä¾‹ã‚’ç¶²ç¾…ã€‚æœ€æ–°ã®å‹•å‘ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹å ´ã¨ã—ã¦ã€å¥½è©•ã‚’å¾—ã¦ã„ã¾ã™ã€‚
maisenakajima 2014/10/04
postgresql

mysql

Oracle

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

SQL

database

DB
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ - SH2ã®æ—¥è¨˜
JPOUG> SET EVENTS 20140907 | Japan Oracle User Group (JPOUG)ã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚IIJã•ã¾ã®ã‚»ãƒŸãƒŠãƒ«ãƒ¼ãƒ ã¯çª“ã‹ã‚‰ã®çœºã‚ãŒã™ã°ã‚‰ã—ã„ã§ã™ãã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸIIJã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ŒMySQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ã€ã¨é¡Œã—ã¦ãƒã‚¯ã‚¹ãƒˆã‚ãƒ¼ãƒãƒƒã‚¯ãªã©ã®èª¬æ˜Žã‚’ã—ã¾ã—ãŸã€‚ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã¨ã€èª¿æŸ»ã®ãŸã‚ã«ä½œæˆã—ãŸãƒ„ãƒ¼ãƒ«ã‚’å…¬é–‹ã—ã¾ã™ã€‚ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ (PDF) Lock Inspector 1.0 ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã‹ã‚‰ãƒªãƒ³ã‚¯ã—ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä¸€è¦§ã§ã™ã€‚ MySQL Lists: mysql: Re: InnoDB's inner workings + checkpoints éŽåŽ»è¨˜äº‹ã®è¨‚æ£ @kami
maisenakajima 2014/09/14
mysql

lock

ãƒãƒƒã‚¯
ãƒªãƒ³ã‚¯
Whereç‹™ã„ã®ã‚ãƒ¼ã€order byç‹™ã„ã®ã‚ãƒ¼
11. I'm yoku0825 â— ã¨ã‚ã‚‹ä¼æ¥ã®DBA â— ã‚ªãƒ©ã‚¯ã‚Œãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ â— ãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ã‚‹ â— å®¶ã«å¸°ã‚‹ã¨ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ â— é¦¬é¹¿ã ã‹ã‚‰ã‹ã‚ã„ã„ã‚ã‘ã˜ã‚ƒãªãã¦ã€ã‹ã‚ã„ã„ ã‚¤ãƒ«ã‚«ãŒãŸã¾ãŸã¾ãƒã‚«ã ã£ãŸ 12. ã¯ã˜ã‚ã« â— ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ã¯ MySQLã®ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ ãƒ™ãƒ¼ã‚¹(worldãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹)ã‹ã‚‰ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ ã‚¹ã‚’å…¨ã¦å–ã£æ‰•ã£ãŸã‚‚ã®ã§ã™ â— http://dev.mysql.com/doc/index-other.html â— ã‚³ãƒ¼ãƒ‰ã¯githubã«ä¸Šã’ã¦ã‚ã‚Šã¾ã™ â— https://github.com/yoku0825/yapc_2014 â— ã™ã”ãâ€¦ã‚¦ãƒ³ã‚³ãƒ¼ãƒ‰ã§ã™â€¦ 13. ã¯ã˜ã‚ã« â— åŽŸå‰‡ã€MySQLã¯1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¤ãåŒæ™‚ã«1 ã¤ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã—ã‹ä½¿ã„ã¾ã›ã‚“ â— Index mergeã¨ã‹ã‚ã‚‹ã‘ã©ã‚¢ãƒ¬ã¯ä¾‹å¤–ã ã—ç‹™ã£ã¦ ã‚„ã£ã¦ã‚‚é€Ÿããªã‚‹
maisenakajima 2014/08/29
mysql

ãƒ†ãƒ¼ãƒ–ãƒ«

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

Slideshare
ãƒªãƒ³ã‚¯
ãã‚“ãªãƒˆãƒ©ãƒ³ã‚µã‚™ã‚¯ã‚·ãƒ§ãƒ³ãƒžãƒãƒ¼ã‚·ã‚™ãƒ£ã¦ã‚™å¤§ä¸ˆå¤«ã‹ï¼Ÿ
10. XAãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®SQLï¼ˆMySQLã®å ´åˆï¼‰ mysql> XA START 'xatest'; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO account VALUES(1, 'takezoe'); Query OK, 1 row affected (0.04 sec) mysql> XA END 'xatest'; Query OK, 0 rows affected (0.00 sec) mysql> XA PREPARE 'xatest'; Query OK, 0 rows affected (0.00 sec) mysql> XA COMMIT 'xatest'; Query OK, 0 rows affected (0.00 sec)
maisenakajima 2014/06/01
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³

mysql

DB

Java

Slideshare

slide

slides
ãƒªãƒ³ã‚¯
CentOSã§MySQL5.5ã„ã‚Œã¦ãƒžãƒ«ãƒãƒžã‚¹ã‚¿ãƒ¼ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³çµ„ã‚€ã¾ã§ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
maisenakajima 2014/05/17
CentOS

mysql

Linux
ãƒªãƒ³ã‚¯
MySQLã§å‡¦ç†ã«é•·æ™‚é–“ã‹ã‹ã£ã¦ã„ã‚‹è¤‡æ•°ã‚¯ã‚¨ãƒªã‚’ã¾ã¨ã‚ã¦æ®ºã™æ–¹æ³• | Basicinc Enjoy Hacking!
ã‚ã¾ã‚Šã«ã‚‚å‡¦ç†ã«æ™‚é–“ãŒã‹ã‹ã‚‹ã‚ˆã†ãªSQLã‚’å®Ÿè¡Œã—ã¦ã—ã¾ã„ã€MySQLãŒã†ã‚“ã¨ã‚‚ã™ã‚“ã¨ã‚‚è¨€ã‚ãªããªã£ã¦ã—ã¾ã†ã‚ˆã†ãªçŠ¶æ³ã€ã‚ˆãã‚ã‚Šã¾ã™ã‚ˆãã€‚ã£ã¦ã„ã†ã‹ã€ã¾ããã‚“ãªçŠ¶æ³ã‚ã£ã¦ã¯ãªã‚‰ãªã„ã‚“ã§ã™ãŒã€æ™‚ãŸã¾ã‚ã‚Šã¾ã™ã€‚ãã‚“ãªæ™‚ã€å•é¡Œã¨ãªã£ã¦ã„ã‚‹ã‚¯ã‚¨ãƒªã®å‡¦ç†ã‚’æ¢ã‚ãŸã„ã‚ã‘ã§ã™ã€‚ ç‰¹å®šã®ã‚¯ã‚¨ãƒªã‚’æ¢ã‚ã‚‹æ–¹æ³• MySQLã§å®Ÿè¡Œä¸ã®ã‚¯ã‚¨ãƒªä¸€è¦§ã‚’è¦‹ã¦ã€SQLã‚’å¼·åˆ¶çµ‚äº†ã™ã‚‹æ–¹æ³• ã“ã¡ã‚‰ã‚’è¦‹ã¦ã‚‚ã‚‰ãˆã‚Œã°ã‚„ã‚Šæ–¹ã¯åˆ†ã‹ã‚Šã¾ã™ã€‚å˜ç´”ã«MySQLã«å…¥ã£ã¦ã€show processlist;ã§å•é¡Œã®ã‚ã‚‹ã‚¯ã‚¨ãƒªã‚’ç™ºè¦‹ã—ã€ãƒ—ãƒã‚»ã‚¹IDã‚’ kill ã™ã‚‹ã ã‘ã€‚ã¨ã¦ã‚‚ç°¡å˜ã€‚ è¤‡æ•°ã®ã‚¯ã‚¨ãƒªã‚’ä¸€æ‹¬ã§æ¢ã‚ã‚‹æ–¹æ³• ä»Šå›žã¯å•é¡Œã®ã‚ã‚‹ã‚¯ã‚¨ãƒªãŒ100å€‹ã‚ã£ãŸã‚‰ã©ã†ã™ã‚‹â€¦ï¼Ÿçš„ãªã®ã‚’è§£æ±ºã™ã‚‹ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã™ã€‚ã¾ãã€å•é¡Œã‚ã‚‹ã‚¯ã‚¨ãƒª100å€‹ã‚ã‚‹çŠ¶æ³ã¯ã€ã‚¢ãƒ—ãƒªçš„ã«å•é¡Œã‚ã‚‹ã‚“ã˜ã‚ƒãï¼Ÿã£ã¦ã„ã†ãƒ¬ãƒ™ãƒ«ã§ã™ãŒã€‚ 1å€‹ãšã¤ãƒ—ãƒã‚»ã‚¹IDã‚’ã‚³ãƒ”ãƒšã—ã¦â€¦ãªã‚“ã¦ã‚„ã£ã¦ã‚‰ã‚Œãªã„ã§ã™
maisenakajima 2014/04/17
show processlist;ã§å•é¡Œã®ã‚ã‚‹ã‚¯ã‚¨ãƒªã‚’ç™ºè¦‹ã—ã€ãƒ—ãƒã‚»ã‚¹IDã‚’ kill ã™ã‚‹ã€‚

mysql

SQL

command
ãƒªãƒ³ã‚¯
ORDER BYç‹™ã„ã®ã‚ãƒ¼ãŒä½•æ•…é€Ÿã„ã‹ - æ™‚è¨ˆã‚’å£Šã›
ã©ã®æœ€é©åŒ–ãŒåŠ¹ãã‚“ã‚„â€¦ã¨ã‚°ã‚°ã£ãŸã€‚ ä»¥å‰ã‚‚èª¿ã¹ãŸæ°—ãŒã—ãŸãŒæ€ã„ã ã›ãšã€ã²ãŸã™ã‚‰ã‚°ã‚°ã‚‹ç¾½ç›®ã«ãªã£ãŸã®ã§ã€ åçœã—ã¦ãƒ–ãƒã‚°ã«æ®‹ã™ã€‚ãµã¤ãƒ¼ã«mysqlã®documentã«æ›¸ã„ã¦ã‚ã£ãŸã€‚ http://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html If you use LIMIT row_count with ORDER BY, MySQL ends the sorting as soon as it has found the first row_count rows of the sorted result, rather than sorting the entire result. If ordering is done by using an index, this is very fast. ãƒãƒ¼ã‚¸ãƒ§ãƒ³å¤ã„ã‘ã©æ—¥æœ¬èªžã®ã»
maisenakajima 2014/03/26
mysql

database

DB

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
2. ï¼¼ã“ã‚“ã«ã¡ã¯ï¼ â— â— â— â— ã¨ã‚ã‚‹ä¼æ¥ã®ï¼¤ï¼¢ï¼¡ â— ã‚ªãƒ©ã‚¯ã‚Œãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ â— ãƒžã‚¤ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ã‚‹ ãã®æ£ä½“ã¯ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ æ—¥æœ¬ MySQL ãƒ¦ãƒ¼ã‚¶ä¼š (MyNA) ã®ã™ã¹ã‚Šæ‹…å½“ #mysql_jp ã§ãƒ„ãƒƒã‚³ãƒŸã‚’ã„ãŸã ã‘ã‚‹ã¨å¹¸ã„
maisenakajima 2014/03/03
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

DB

SQL
ãƒªãƒ³ã‚¯
MySQLite: SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’èªã¿æ›¸ãã™ã‚‹MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³
maisenakajima 2014/02/24
sqlite

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

db

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
MySQLã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®4ã¤ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’è©¦ã™ - FAT47ã®åº•è¾ºã‚¤ãƒ³ãƒ•ãƒ©è°äº‹éŒ²
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ã¯ 1ã¤ã®ä½œæ¥å˜ä½ã¨ã—ã¦æ‰±ã‚ã‚Œã‚‹SQLã‚¯ã‚¨ãƒªã®é›†ã¾ã‚Šã§ã™ã€‚ è¤‡æ•°ã®UPDATEã‚„INSERTã‚’ã²ã¨ã¤ã®é›†ã¾ã‚Šã¨ã—ã¦ã€ ãã‚Œã‚‰ã®ã‚¯ã‚¨ãƒªãŒã™ã¹ã¦é©ç”¨ã§ããŸå ´åˆã®ã¿ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«åæ˜ ã—ã¾ã™ã€‚ ã²ã¨ã¤ã§ã‚‚é©ç”¨ã«å¤±æ•—ã—ãŸã‚¯ã‚¨ãƒªãŒã‚ã£ãŸå ´åˆã¯ã€ãã®ã¾ã¨ã¾ã‚Šã™ã¹ã¦ã®ã‚¯ã‚¨ãƒªã®çµæžœã¯åæ˜ ã—ã¾ã›ã‚“ã€‚ ACIDç‰¹æ€§ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã«æ±‚ã‚ã‚‰ã‚Œã‚‹4ã¤ã®ç‰¹æ€§ã§ã™ã€‚ åŽŸåæ€§ (Atomicity) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã‚‹æ‰‹é †ãŒã€Œã™ã¹ã¦å®Ÿè¡Œã•ã‚Œã‚‹ã‹ã€ã€Œã™ã¹ã¦ã•ã‚Œãªã„ã‹ã€ã®ã©ã¡ã‚‰ã‹ã«ãªã‚‹æ€§è³ªã€‚ ä¸€è²«æ€§ (Consistency) ã©ã‚“ãªçŠ¶æ³ã§ã‚‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‰å¾Œã§ãƒ‡ãƒ¼ã‚¿ã®æ•´åˆæ€§ãŒçŸ›ç›¾ãªãä¿ãŸã‚Œã‚‹æ€§è³ªã€‚ åˆ†é›¢æ€§ (Isolation) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å®Ÿè¡Œä¸ã¯ã€å‡¦ç†é€”ä¸ã®ãƒ‡ãƒ¼ã‚¿ã¯å¤–éƒ¨ã‹ã‚‰éš è”½ã•ã‚Œã¦ä»–ã®å‡¦ç†ã«å½±éŸ¿ã‚’ä¸Žãˆãªã„æ€§è³ªã€‚ æ°¸ç¶šæ€§ (Durability) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒå®Œäº†ã—ãŸã‚‰ã€ã‚·ã‚¹
maisenakajima 2014/02/15
database

DB

mysql

ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³

SQL
ãƒªãƒ³ã‚¯
MySQLã‚’ä½¿ã£ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒçŸ¥ã‚‹ã¹ãMySQLã®å†…éƒ¨æ§‹é€ ã¨ã¯ï¼Ÿ | Yakst
MySQLã‚’ä½¿ã£ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒçŸ¥ã‚‹ã¹ãMySQLã®å†…éƒ¨æ§‹é€ ã«ã¤ã„ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ä¼šç¤¾PalominoDBã‚’çµŒå–¶ã™ã‚‹Laine Campbellæ°ã«ã‚ˆã‚‹å›žç”ã€‚MySQLã‚’çŸ¥ã‚‹ãŸã‚ã«ã¯ä½•ã‚’ãƒã‚¤ãƒ³ãƒˆã«å¦ç¿’ã™ã‚Œã°ã‚ˆã„ã®ã‹ãŒã‚ˆãã‚ã‹ã‚‹ã€DBAã‚„é–‹ç™ºè€…ã«ã¨ã£ã¦ã‚‚å½¹ç«‹ã¤å†…å®¹ã€‚ 1. ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã€æ°¸ç¶šæ€§ã€ãƒãƒƒã‚¯æ©Ÿæ§‹ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã®æŒ¯ã‚‹èˆžã„ã‚„åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã¨ã„ã£ãŸã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®åŸºç¤Žã¨ãªã‚‹å‹•ãã«ã¤ã„ã¦ã®ç†è§£ãªã—ã«ã€MySQLè‡ªä½“ã‚„ãƒ¢ãƒ‡ãƒ«ãƒ‡ãƒ¼ã‚¿ã®ã‚³ãƒ¼ãƒ‰ã‚’ã„ã˜ã‚‹ã¹ãã§ãªã„ã€‚ãã‚Œã«åŠ ãˆã¦ã€InnoDBã®ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã•ã‚ŒãŸãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚„ã€MyISAMã®å…¨æ–‡æ¤œç´¢ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã‚ˆã†ãªã‚³ã‚¢è¦ç´ ã‚‚ã€æ¥µã‚ã¦é‡è¦ãªæƒ…å ±ã ã€‚ 2. ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆ ç‰¹ã«ä»¥ä¸‹ã®ã‚ˆã†ãªç‚¹ã«ã¤ã„ã¦ã€‚ ã‚«ãƒãƒªãƒ³ã‚°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ é€£çµã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸã‚½ãƒ¼ãƒˆ
maisenakajima 2013/12/18
mysql

ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

db

database

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
conma.me
This domain may be for sale!
maisenakajima 2013/12/14
mysql

DB

ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—

kage

migration
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã®ãƒ‰ãƒ¡ã‚¤ãƒ³è¨è¨ˆã«ã¤ã„ã¦ã®è°è«–
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’å®Ÿè·µã™ã‚‹ã«ã¯ã€ãƒ‰ãƒ¡ã‚¤ãƒ³ï¼ˆâ‰’ãƒ‡ãƒ¼ã‚¿åž‹ï¼‰ã‚’å¦‚ä½•ã«æ£ã—ãè¨è¨ˆã™ã‚‹ã‹ã¨ã„ã†ã“ã¨ãŒæ¥µã‚ã¦é‡è¦ã«ãªã‚‹ã€‚ã—ã‹ã—ãªãŒã‚‰ã€ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚’ã©ã†è¨è¨ˆã™ã¹ãã‹ã¨ã„ã†è°è«–ã¯ã‚ã¾ã‚Šã•ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ€ã†ã€‚ãã®çµæžœã€ãƒ‰ãƒ¡ã‚¤ãƒ³ã«ã¤ã„ã¦ã®ç†è§£ã¯ã‚ã¾ã‚Šé€²ã¾ãšã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã«å¤±æ•—ã—ã¦ã„ã‚‹ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒå¤šã„ã‚ˆã†ã«æ€ã‚ã‚Œã‚‹ã€‚ ã¨ã„ã†ã‚ã‘ã§ä»Šæ—¥ã®ãƒ†ãƒ¼ãƒžã¯ãƒ‰ãƒ¡ã‚¤ãƒ³ã§ã‚ã‚‹ã€‚ é›†åˆã‚’å®šç¾©ã™ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã¯ä½•ã‹ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’å®Ÿè·µã™ã‚‹ã«ã¯ã¾ãšãã®ç‚¹ã‹ã‚‰ç†è§£ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿åž‹ã¯ãƒ‰ãƒ¡ã‚¤ãƒ³ã¨å‘¼ã°ã‚Œã‚‹ã€‚ãƒ‰ãƒ¡ã‚¤ãƒ³ã¨ã¯ã€ãã®å±žæ€§ï¼ˆâ‰’ã‚«ãƒ©ãƒ ï¼‰ã«å…¥ã‚‹ã¹ãå€¤ã¯ã©ã†ã„ã£ãŸã‚‚ã®ã‹ã‚’é›†åˆã¨ã—ã¦å®šç¾©ã—ãŸã‚‚ã®ã ã€‚è¨€ã„æ›ãˆã‚‹ã¨ã€å±žæ€§å€¤ã¨ã¯ã‚ã‚‹é›†åˆã®è¦ç´ ã®ä¸€ã¤ã§ã‚ã‚‹ã¨è¨€ãˆã‚‹ã€‚å¾“ã£ã¦ã€ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚’è¨è¨ˆã™ã‚‹éš›ã«ã¯ã€SQLã§è¨€ã†ã¨ã“ã‚ã®ãƒ‡ãƒ¼ã‚¿åž‹ã€ã¤ã¾ã‚ŠINTã‚„CHARã¨ã„ã£ãŸã‚‚ã®ã ã‘ã§ãªãã€ãã®
maisenakajima 2013/12/09
ãƒ‡ãƒ¼ã‚¿

è¨è¨ˆ

database

MySQL

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

SQL

ãƒ‰ãƒ¡ã‚¤ãƒ³
ãƒªãƒ³ã‚¯
Java-Only |Â Mapping java enum type to MySQL enum type with hibernate
maisenakajima 2013/12/07
MySql database came's with an enum datatype that although is quite proprietery it can be easily mapped to a java enumeration type in hibernate.

Java

mysql

database
ãƒªãƒ³ã‚¯
MySQLã§MyISAMã‹ã‚‰InnoDBã«ä¹—ã‚Šæ›ãˆã‚‹éš›ã«çŸ¥ã‚‰ãªã„ã¨ãƒãƒžã‚‹ã€æ€–ã„è©± - Y-Ken Studio
photo by byte MySQLã¨ã„ãˆã°ã€å··ã§ã¯InnoDBã°ã‹ã‚Šæ³¨ç›®ã•ã‚Œã€MyISAMã®åœ°ä¸‹ã‚¢ã‚¤ãƒ‰ãƒ«åŒ–ãŒã«ã‚ã‹ã«èªžã‚‰ã‚Œã‚‹ä»Šæ—¥ã“ã®é ƒã€çš†æ§˜ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ã€‚ ã¾ã‚ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’å¤‰æ›ã™ã‚‹ã ã‘ã§æ¸ˆã‚€ãªã‚‰ã€ç°¡å˜ãªã®ã§ã™ã€‚ -- legacy_my_tableã‚’InnoDBã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«å¤‰æ›ã™ã‚‹ ALTER TABLE legacy_my_table ENGINE=InnoDB; ã‚ˆã—çµ‚ã‚ã£ãŸï¼ã•ã‚ãƒ©ãƒ³ãƒã‚¿ã‚¤ãƒ ã ï¼ ãƒ»ãƒ»ãƒ»ã¨ç‰‡ä»˜ã‘ã¦ã—ã¦ã—ã¾ã†ã¨ã€æ‚²åŠ‡ãŒèµ·ã“ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚(>o<;) ãã‚Œã§ã¯æœ¬æ—¥ã€MyISAMã‹ã‚‰InnoDBã¸ç§»è¡Œã™ã‚‹ãªã‚‰çŸ¥ã£ã¦ãŠããŸã„æ„å¤–ãªè½ã¨ã—ç©´ã¨Tipsã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ AUTO INCREMENTã®æŒ™å‹•ãŒé•ã†è½ã¨ã—ç©´ ä»¥ä¸‹ã«è©²å½“ã™ã‚‹ã‚¯ã‚¨ãƒªã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹å ´åˆã«ã¯ã€æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚ç§ã¯ãƒãƒžã‚Šã¾ã—ãŸã€‚ INSERT IGNORE INTO
maisenakajima 2013/12/07
mysql

innodb

database

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

myisam

ç§»è¡Œ

é–‹ç™º
ãƒªãƒ³ã‚¯
InnoDBã®ãƒãƒƒã‚¯ã®ç¯„å›²ã¨ãƒã‚¯ã‚¹ãƒˆã‚ãƒ¼ãƒãƒƒã‚¯ã®è©± - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ã“ã®è¨˜äº‹ã¯MySQL Casual Advent Calendar 2013 3æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ã¯ã˜ã‚ã« ä»¥å‰ã«SELECT ... FOR UPDATEã¨ãƒãƒƒã‚¯ã®æŒ™å‹• - walf443's blogã®è¨˜äº‹ã«Twitterã§å°‘ã—è¨€åŠã—ãŸã‚“ã§ã™ãŒã€ãã‚Œã®è£œè¶³ã¨ã„ã†ã‹ã€InnoDBã®ãƒãƒƒã‚¯ã®ç¯„å›²ã«ã¤ã„ã¦åƒ•ã¯ã“ã†ç†è§£ã—ã¦ã„ã¾ã™ã‚ˆã¨ã„ã†è©±ã§ã™ã€‚ MySQLã¨ã„ãˆã°ã€InnoDBã‚’ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚µãƒ¼ãƒã¨ã—ã¦ä½¿ã†ãŸã‚ã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã§ã‚ã‚Šã€SQLã¯InnoDBã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã®DSLã¨ã„ã£ã¦ã‚‚éŽè¨€ã§ã¯ãªã„ã§ã—ã‚‡ã†ã€‚ InnoDBã®ãƒãƒƒã‚¯ã¨ã¯ã¤ã¾ã‚‹ã¨ã“ã‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¡Œã®ãƒãƒƒã‚¯ãªã®ã§ã€InnoDBã®ãƒãƒƒã‚¯ã®ç¯„å›²ã‚’ç†è§£ã™ã‚‹ãŸã‚ã«InnoDBã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦å°‘ã—å‰ç½®ãã—ã¦ãŠãã¾ã™(ã ã„ã¶ç«¯æŠ˜ã£ãŸã‘ã©é•·ããªã£ãŸâ€¦)ã€‚ ã‚¯ãƒ©ã‚¹ã‚¿ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã‚»ã‚«ãƒ³ãƒ€ãƒªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã™ã§ã«InnoDBã®ã‚¤ãƒ³
maisenakajima 2013/12/05
innodb

DB

mysql

lock
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆå¾¹åº•æŒ‡å—
DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®æŠ€è¡“å‹‰å¼·ä¼šï¼ˆç¬¬3å›žï¼‰ã§ä½¿ç”¨ã—ãŸè³‡æ–™ã§ã™ã€‚ä¸»ã«ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã¨æ£è¦åŒ–ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ã¾ã™ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã®é™ç•Œã«ã¤ã„ã¦æ£ã—ãèªè˜ã—ã¦ã“ãã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’ç†è§£ã—ãŸã¨è¨€ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚
maisenakajima 2013/11/30
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB

è¨è¨ˆ

database

mysql

Slideshare
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸