[B! mysql][ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°] yanbowã®ãƒ

yanbow id:yanbow

mysqlã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹yanbowã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{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ã€€InnoDBã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼ˆå¾Œç·¨ï¼‰(EnterpriseZine) - goo ãƒ‹ãƒ¥ãƒ¼ã‚¹
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºç¤Ž ã€€ãã‚Œã§ã¯ã€å…·ä½“çš„ã«InnoDBã§ã©ã“ã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¹ãã‹ã‚’è¦‹ã¦ã„ã“ã†ã€‚ â– ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ« ã€€æœ€ã‚‚åŸºæœ¬ã¨ãªã‚‹ã®ãŒãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã®èª¿æ•´ã ã€‚ãƒ¯ãƒ¼ã‚ãƒ³ã‚°ã‚»ãƒƒãƒˆãŒå…¨ã¦ãƒãƒƒãƒ•ã‚¡ã«åŽã¾ã‚‰ãªã„é™ã‚Šã€ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã¯å¤§ãã‘ã‚Œã°å¤§ãã„ã»ã©è‰¯ã„ã€‚ãã®åˆ†ãƒ‡ã‚£ã‚¹ã‚¯ã‚¢ã‚¯ã‚»ã‚¹ãŒæ¸›ã‚‹ã‹ã‚‰ã ã€‚ãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºãŒå°ã•ã„ã¨ã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒŸã‚¹æ™‚ã«ãƒ‡ã‚£ã‚¹ã‚¯ã‹ã‚‰Readã™ã‚‹ã®ã«æ™‚é–“ãŒã‹ã‹ã‚Šã€I/OãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã†ã€‚äºˆç®—ã®ã‚ã‚‹é™ã‚Šãƒ¡ãƒ¢ãƒªã‚’ç›®ã„ã£ã±ã„æè¼‰ã—ã€ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã«å‰²ã‚Šå½“ã¦ã‚ˆã†ã€‚InnoDBã®ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã¯ã€innodb_buffer_pool_sizeã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§è¨å®šã™ã‚‹ã€‚åˆ©ç”¨å¯èƒ½ãªãƒ¡ãƒ¢ãƒªã¯ã€ä»–ã®å‡¦ç†ã«å¿…è¦ãªåˆ†ã‚’é™¤ã„ãŸã™ã¹ã¦ã‚’InnoDBã®ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã«å‰²ã‚Šå½“ã¦ã‚ˆã†ã€‚ innodb_buffer_pool=32G ã“ã“ã§ä¸€ã¤æ³¨æ„ãŒã‚ã‚‹ã€‚innodb_buffer_pool_sizeã¯ãƒãƒƒãƒ•
yanbow 2018/05/08
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ¡ãƒ¢ãƒª

mysql
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ±‚ã‚ã¦ - ãŠå‰ã®è¡€ã¯ä½•è‰²ã !! 4
çµå±€ã€ã‚ã‹ã£ãŸã“ã¨ã¯ã€ æ¬¡ã®4ã¤ã€‚ index ã‹ã‚‰ å®Ÿä½“ã¸ã®ã‚·ãƒ¼ã‚¯ã¯é…ã„ã€‚ ã™ã¹ã¦ãŒindexå†…ã§å®Œçµã™ã‚‹ã‚¯ã‚¨ãƒªãƒ¼ã¯æ—©ã„ã€‚ limit ã‚’ã¤ã‘ã¦ã‚‚ where ã‚„ order by ã™ã‚‹ã¨æ„å‘³ãŒãªã„ã€‚ indexã‚’å¼µã‚‹ãªã‚‰ Using indexe ã‚’ã‚²ãƒƒãƒˆã§ããªã„ã¨è² ã‘ã‹ãªã€‚ ã§ã¯ã€select ã§å–å¾—ã™ã‚‹å€¤ã™ã¹ã¦ã« index ã‚’å¼µã‚Šã¾ã™ã‹? å ´åˆã«ã‚ˆã£ã¦ã¯å¯èƒ½ã§ã™ãŒã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ–‡å—åˆ—ãªã‚“ã‹ãŒãµã‚“ã ã‚“ã«å«ã¾ã‚Œã¦ã„ã‚‹ã¨é›£ã—ã„ã‚‚ã®ãŒã‚ã‚Šã€ç¾å®Ÿçš„ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ãã“ã§ã“ã‚“ãªæ–¹æ³•ã‚’ææ¡ˆã—ã¾ã™ã€‚2æ®µéšŽã«ã‚ã‘ã¦ã‚¯ã‚¨ãƒªãƒ¼ã‚’æ‰“ã¡ã¾ã™ã€‚ A. task ãƒ†ãƒ¼ãƒ–ãƒ«ã® 2008/6/5 ã€œ 2008/6/18 ã®ãƒ‡ãƒ¼ã‚¿ã‚’é–‹å§‹æ—¥é †ã«ãªã‚‰ã¹ã¦ã€å…ˆé 5ä»¶ã ã‘è¡¨ç¤ºã›ã‚ˆã€‚ select SQL_CALC_FOUND_ROWS * from task where task.task_starttime <= '20
yanbow 2014/10/01
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã®è¤‡åˆINDEX - æ†‚é¬±ãªãƒ—ãƒã‚°ãƒ©ãƒžã®å½¢è€Œä¸Šå¦
MySQL MySQLã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã€‚MySQLã‚’ä½¿ã„ã“ãªã—ã¦ã„ã‚‹äººã«ã¯å¸¸è˜ã®ç¯„ç–‡ã«ã¯ã„ã‚‹çŸ¥è˜ã ã¨æ€ã†ã®ã§ã™ãŒã€ã‹ã¤ã¦ã®ç§ã®ã‚ˆã†ã«ã€çŸ¥ã‚‰ãªã„ã¨ãƒ‰ãƒ„ãƒœã«ã¯ã¾ã‚‹ã®ã§ã€ã“ã“ã«ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ã‚¿ã‚¤ãƒˆãƒ«ã§ã©ã†ã„ã†å†…å®¹ã‹ã€ã‚‚ã—ã‹ã—ãŸã‚‰å¤§ä½“ã€æƒ³åƒãŒã¤ãã‹ãªã¨æ€ã†ã®ã§ã™ãŒã€MySQLã¯1ã¤ã®ã‚¯ã‚¨ãƒªãƒ¼ã§1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã€1ã¤ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã—ã‹æ©Ÿèƒ½ã—ãªã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ˆã†ã™ã‚‹ã«ã€ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€æ™®é€šã«å¤§é‡ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã£ã¦ã‚‚ã‚ã¾ã‚Šæ„å‘³ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ãã“ã§ã€ä»Šå›žã¯ã€æœ€é©ãªè¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã¯ã‚‹ã“ã¨ãŒã§ãã‚‹ã‹è€ƒãˆã¦ã„ã“ã†ã˜ã‚ƒãªã„ã‹ã€ã¨ã„ã†è¶£æ—¨ã§æ›¸ã„ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ã¾ãšã¯åˆ†æžã€‚ãƒ†ã‚¹ãƒˆç’°å¢ƒã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ãªã„SQLã‚’é›†ã‚ã‚‹ã¾ãšã¯ã€/etc/my.cnfã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ä»¥ä¸‹ã®ã‚ˆã†ã«è¨å®šã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ãªã„SQLã‚’ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ã«åãå‡ºã—ã¾ã™ã€‚ slow
yanbow 2014/09/26
sql

mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLTunerã§MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¨ºæ–ã™ã‚‹æ–¹æ³•
https://github.com/rackerhacker/MySQLTuner-perl MySQLTunerã¯MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¨ºæ–ã—ã¦ãã‚Œã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã™ã€‚ åŸºæœ¬çš„ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒ’ãƒ³ãƒˆã‚’ã‚ã‹ã‚Šã‚„ã™ãè¡¨ç¤ºã—ã¦ãã‚Œã¾ã™ã€‚ MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è¨å®šã«ä¸å®‰ãªæ–¹ã‚„ã€ã¯ã˜ã‚ã¦MySQLã‚’ã•ã‚ã‚‹æ–¹ã¯è©¦ã—ã¦ã¿ã‚‹ã¨è‰¯ã„ã§ã—ã‚‡ã†ã€‚ ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯GNU GPLã§ç„¡æ–™ã§ä½¿ãˆã¾ã™ã€‚ æ¤œè¨¼ç’°å¢ƒ CentOS 6.3(64bit) MySQL 5.5.28 MySQL 5.5ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« MySQL 5.5ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ # wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm # wget http://ftp.jaist.ac.jp/pub/Linux/Fedora/epel/6/x86
yanbow 2012/12/21
mysql

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

MySQL
ãƒªãƒ³ã‚¯
WEBã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’å§‹ã‚ã‚‹ - Mandy Code
ã•ã¦ISUCON2ã‚‚è¿‘ã¥ã„ã¦ã„ã‚‹ã“ã¨ã§ã™ã—ã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’é¡Œæã«ä»Šå®Ÿéš›ã«WEBã‚¢ãƒ—ãƒªã‚’ä½œã‚‹ä¸ã§è¡Œãªã£ã¦ã„ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åˆæ©ã«ã¤ã„ã¦æ›¸ã„ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãšã€åƒ•ã¯ã‚‚ã®ã™ã”ãMySQLã«è©³ã—ã„ã‚ã‘ã§ã‚‚ã‚‚ã®ã™ã”ãPerlã‚„PHPã«ç²¾é€šã—ã¦ã„ã‚‹ã‚ã‘ã§ã‚‚ãªã„ã€ã¨ã„ã†å‰æãŒã‚ã‚Šã€è‡ªåˆ†ã§è€ƒãˆãŸã‚Šå°‘ãªã„ãªãŒã‚‰ã‚‚çµŒé¨“ã—ãŸã“ã¨ã‚’ã‚‚ã¨ã«ã—ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’é€²ã‚ã¦ãŠã‚Šã¾ã™ã€‚ ãã®ä¸ã§è¦šæ›¸çš„ã«ã€èª°ã§ã‚‚ã„ã¾ã™ãå‡ºæ¥ã‚‹æ¸¬å®šæ–¹æ³•ãªã©ã‚’æ›¸ã„ã¦ãŠã“ã†ã‹ãªãƒ¼ã¨æ€ã„ã¾ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¯ã‚‚ã®ã™ã”ãå¤§ããåˆ†ã‘ã¦2ç¨®é¡žã‚ã‚Šã¾ã™ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ã‚¤ãƒ³ãƒ•ãƒ©ãƒ¬ã‚¤ãƒ¤ãƒ¼ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ã¾ãšã¯ã“ã®2ã¤ãŒåŠ¹æžœçš„ãªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãªã‚Šã¾ã™ã€‚ ã“ã®ä¸ã§ã‚‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ã»ã†ãŒçµ¶å¤§ãªåŠ¹æžœã‚’ã‚ã’ã‚‹ã“ã¨ãŒå¤šã„ã€ã¨YAPCã§fujiwaraã•ã‚“ãŒãŠã£ã—ã‚ƒã£ã¦ã„ã¾ã—ãŸã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ã§ã¯WEBã‚¢ãƒ—ãƒªã‚±
yanbow 2012/10/26
MySQL

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

ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™º
ãƒªãƒ³ã‚¯
è§£æžã¾ã§10åˆ†ï¼æœ€å¼·ã®MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã€ŒJet Profilerã€ - Lancersé–‹ç™ºãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€keiã§ã™ã€‚ ä»Šå›žã¯ã€MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«å¤§æ´»èºãªã€ŒJet Profilerã€ã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ Jet Profilerã¨ã¯ Jet Profilerã¯ã€MySQLå‘ã‘ã®ã‚¯ã‚¨ãƒªã‚¢ãƒŠãƒ©ã‚¤ã‚¶ã§ã™ã€‚ ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯ã€DBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä¸ã§ã‚‚é‡è¦ãªä½œæ¥ã®1ã¤ã§ã™ãŒã€ Jet Profilerã‚’ä½¿ãˆã°ã€ãã®ä½œæ¥ã‚’GUIã§ç›´æ„Ÿçš„ã«è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ•ãƒªãƒ¼ã‚¦ã‚§ã‚¢ã®å½¢æ…‹ã§æä¾›ã•ã‚Œã¦ãŠã‚Šã€æ©Ÿèƒ½é™å®šç‰ˆã§ã‚ã‚Œã°ç„¡æ–™ã§åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ è³¼å…¥ã™ã‚‹å ´åˆã¯ã€$499ã¨ãªã‚Šã¾ã™ã€‚ è©³ç´°æƒ…å ±ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯å…¬å¼ãƒšãƒ¼ã‚¸ã‹ã‚‰ã©ã†ãžã€‚ http://www.jetprofiler.com/ja/ Jet Profilerã®é…åŠ› ãã®1ã€€å°Žå…¥ã®ã—ã‚„ã™ã• é€šå¸¸ã®Windowãƒžã‚·ãƒ³ã«ã€æ™®é€šã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ„Ÿè¦šã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå¯èƒ½ã§ã™ã€‚ ã‚¤ãƒ³
yanbow 2012/08/25
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã¯ã˜ã‚ã¦ã® MySQL ã§100ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹æ™‚ã«è¡Œã£ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚
MySQL ã®å‹‰å¼·ã‚’ã›ãšã«ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ç‰ã§ SQL ã‚’æ›¸ã‹ãšã« Web ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ã—ã¦ã„ã¾ã—ãŸã€‚ãƒ‡ãƒ¼ã‚¿æ•°ã‚‚2ä¸‡ä»¶ç¨‹åº¦ã§ã—ãŸã®ã§ã€ãã“ã¾ã§å›°ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸãŒã€ä»Šå›ž100ä¸‡å¼±ã®å•†å“ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†æ©Ÿä¼šãŒã§ããŸã®ã§ã€MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„ç™ºè¡Œã™ã‚‹ SQL ã«ã¤ã„ã¦è¦‹ç›´ã™æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ MySQL ã‚’é«˜é€ŸåŒ–ã™ã‚‹ã®ã«è¡Œã£ãŸå¯¾ç–ãªã©å‹‰å¼·ã—ãŸã‚‚ã®ã‚’è‡ªåˆ†ç”¨ã«ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã—ãŸã€‚ æ¡ä»¶å¼ã§æ¯”è¼ƒã™ã‚‹ã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ã¦é«˜é€ŸåŒ– å•†å“ã‚³ãƒ¼ãƒ‰ã§å˜åœ¨ã—ãªã„å•†å“ã‚’è¦‹ã¤ã‘ã¦ã€å•†å“ã‚’DBã«ç™»éŒ²ã™ã‚‹ã¨ã„ã†å‡¦ç†ã‚’è¡Œã£ã¦ã„ã‚‹å ´åˆã€4ä¸‡ä»¶è¶…ãˆãŸã“ã‚ã‹ã‚‰å‡¦ç†ã«2ç§’ä»¥ä¸Šã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã™ã€‚12ä¸‡ä»¶è¶…ãˆãŸé ƒã«ã¯10ç§’ç¨‹åº¦ã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€å•†å“ã‚³ãƒ¼ãƒ‰ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«å¯¾ã—ã¦ã‚«ãƒ©ãƒ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã“ã¨ã§0.2ç§’ã«çŸç¸®ã™ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ MySQL ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«ã‚‚ä»¥ä¸‹ã®ã‚ˆ
yanbow 2011/07/22
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
PHPé–‹ç™ºè€…ã®MySQLã®é–“é•ã„ãƒˆãƒƒãƒ—ï¼‘ï¼:phpspoté–‹ç™ºæ—¥èªŒ
Windowsã‚¢ãƒ—ãƒªã®ãƒ„ãƒªãƒ¼ãƒ“ãƒ¥ãƒ¼ã£ã½ã„UIã‚’WEBä¸Šã§ç°¡å˜å®Ÿè£…ã§ãã‚‹jQueryãƒ—ãƒ©... æ¬¡ã®è¨˜äº‹ â‰«ï¼šã‚·ãƒ³ãƒ—ãƒ«ã•ãŒã„ã„æ„Ÿã˜ã®ï¼‘ï¼•ï¼”ç¨®é¡žã®ã‚¢ã‚¤ã‚³ãƒ³ã‚»ãƒƒãƒˆ Top 10 MySQL Mistakes Made by PHP Developers PHPé–‹ç™ºè€…ã®MySQLã®é–“é•ã„ãƒˆãƒƒãƒ—ï¼‘ï¼ã€‚ æ‰‹æ…£ã‚Œã¦ã„ã‚‹äººã«ã¨ã£ã¦ã¯çŸ¥ã£ã¦ã‚‹ã“ã¨ã‚‚å¤šã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€åˆå¿ƒè€…ãŒå½¹ç«‹ã£ãŸã‚Šã€çŸ¥ã‚‰ãªã„éƒ¨åˆ†ã®ã‚«ãƒãƒ¼ã¨ã—ã¦ãƒ¡ãƒ¢ã¨ã—ã¦æ›¸ã„ã¦ã¿ã¾ã™ MyISAMã‚’ä½¿ã£ã¦ã„ã‚‹ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«MyISAMã ã‘ã©InnoDBã‚’ä½¿ãŠã† ãƒªã‚«ãƒãƒªå¯èƒ½ã§ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ã€å¤–éƒ¨ã‚ãƒ¼åˆ©ç”¨å¯èƒ½ãªInnoDBãŠã™ã™ã‚ è©³ç´°ï¼šOpen database life: MyISAMã¨InnoDBã®ã©ã¡ã‚‰ã‚’ä½¿ã†ã¹ãã‹ PHPã®MySQLé–¢æ•°ã‚’ä½¿ã£ã¦ã„ã‚‹ mysql_* é–¢æ•°ã‚’ä½¿ã‚ãšã€PDOç‰ã§ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸å¤‰æ›´ã«å¯¾å¿œã—ã‚ˆã†
yanbow 2010/11/26
PHP

MySQL

æœ€é©åŒ–

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
1