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

emosei id:emosei

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

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

Embulkã‚’æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã§ä½¿ã£ãŸè©± - ä»Šæ—¥ã‚‚ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
èƒŒæ™¯ è‡ªåˆ†ã¯SIerã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹ã€‚ ã„ã‚ã„ã‚ãªãŠå®¢æ§˜ã®ã€ã„ã‚ã„ã‚ãªæ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã¨æ ¼é—˜ã™ã‚‹ã®ãŒãŠä»•äº‹ã§ã‚ã‚‹ã€‚ ã¾ãŸã€ä»Šã¯embulk-input-jdbcã¨ã‹embulk-output-jdbcã®ã‚³ãƒŸãƒƒã‚¿ã‚‚ã‚„ã£ã¦ã„ã‚‹ã€‚ æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã¨RDBã¨ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ« æ¥å‹™ã‚·ã‚¹ãƒ†ãƒ ã§ã¯ã€ãŸã„ã¦ã„RDBã‚’ä½¿ã£ã¦ã„ã‚‹ã€‚ ãã—ã¦ã€ã‚µãƒ¼ãƒé–“ã§ãƒ‡ãƒ¼ã‚¿ã‚’é€£æºã™ã‚‹ãŸã‚ã«ã€RDBã‹ã‚‰ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã—ãŸã‚Šã€ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’RDBã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒçµæ§‹ã‚ã‚‹ã€‚ ãã‚“ãªã¨ãã©ã†ã™ã‚‹ã‹ã¨è¨€ã†ã¨ã€RDBä»˜å±žã®ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ã“ã¨ãŒå¤šã„ã€‚ ä¾‹ãˆã°ã€Oracleã¸ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ã‚ã‚Œã°SQL*Loaderã€MySQLã¸ã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ã‚ã‚Œã°mysqlimportã€ã¨ã„ã†ã‚ˆã†ã«ã€‚ RDBä»˜å±žã®ãƒ„ãƒ¼ãƒ«ã®å•é¡Œç‚¹ ã„ã‚ã„ã‚ãªãŠå®¢æ§˜ãŒã„ã¦ã€ã„ã‚ã„ã‚ãªã‚·ã‚¹ãƒ†ãƒ ãŒã‚ã‚‹ã®ã§ã€RDBã‚‚ã„ã‚ã„ã‚ã§ã‚ã‚‹ã€‚ ã¡ãªã¿ã«ã€ã†ã¡ã®ä¼šç¤¾ã§
emosei 2016/08/15
embulk

mysql

sql

oss
ãƒªãƒ³ã‚¯
MySQL InnoDBã ã‘ã§å…¨æ–‡æ¤œç´¢ - SH2ã®æ—¥è¨˜
å®Ÿé¨“ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ äºˆç¿’ã—ã¦ã¿ã‚‹ ã€Œè»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ã¨ã„ã†ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã§æ¤œç´¢ã—ã¦ã€ã—ã°ã‚‰ãå‹‰å¼·ã—ã¦ã¿ã¾ã™ã€‚ è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - Wikipedia mixi Engineersâ€™ Blog Â» è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®Ÿè£…ã—ã‚ˆã† ASCII.jpï¼šæ‚Ÿç©ºã€ç§˜å‰£ã€Œè»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ã‚’æ‰‹ã«å…¥ã‚Œã‚‹ ï½œGoogleã¯ãªãœçš„ç¢ºã«æŽ¢ã›ã‚‹ã®ã‹ï¼Ÿ [ã‚’] è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã‚ˆã‚‹æ¤œç´¢ã‚·ã‚¹ãƒ†ãƒ ã‚’ä½œã£ã¦ã¿ã‚ˆã†ï¼ è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§å¦ã¶æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã®ä¸èº«ã‚¢ãƒ—ãƒª - ç¡çœ ä¸è¶³ï¼Ÿï¼ ã†ãƒ¼ã‚“ãªã‚‹ã»ã©ã€‚åˆ†ã‹ã£ãŸã‚ˆã†ãªåˆ†ã‹ã‚‰ãªã„ã‚ˆã†ãªã€‚ ä½œã£ã¦ã¿ã‚‹ ã¨ã‚Šã‚ãˆãšã€Twitter4Jã‚’ä½¿ã£ã¦ã“ã‚“ãªãƒ‡ãƒ¼ã‚¿ã‚’ç”¨æ„ã—ã¾ã—ãŸã€‚ã¡ãªã¿ã«äººé¸ã¯æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLerã®Twitterã‚¢ã‚«ã‚¦ãƒ³ãƒˆã¾ã¨ã‚ã€‚ã‚’å‚è€ƒã«ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ 5707049458,2009-11-14 20:28:34,sakaik,@hbstudy
emosei 2009/12/06
ç½®æ›ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹

mysql

db
ãƒªãƒ³ã‚¯
MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—é‹ç”¨(mysqlhotcopy) - Fedoraã§è‡ªå®…ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰
MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è‡ªå‹•ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œãªã†ã€‚ ã“ã“ã§ã¯ã€MySQLå…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚µãƒ¼ãƒãƒ¼å†…ã®åˆ¥ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã¸ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã€‚ [root@fedora ~]# vi mysql-backup.shã€€â†ã€€MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚¹ã‚¯ãƒªãƒ—ãƒˆä½œæˆ #!/bin/bash PATH=/usr/local/sbin:/usr/bin:/bin # ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å…ˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒª BACKDIR=/backup/mysql # MySQLrootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ ROOTPASS=Mysqlrootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ # ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å…ˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªå†ä½œæˆ rm -rf $BACKDIR mkdir -p $BACKDIR # ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åå–å¾— DBLIST=`ls -p /var/lib/mysql | grep / | tr -d /` # ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— for dbname
emosei 2009/03/15
mysql

backup
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
emosei 2009/02/23
mysql

db

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
rhapsodic cherry - CentOS 5ã§Postfix+PostfixAdmin+MySQLç’°å¢ƒã‚’ä½œã‚‹
â– [CentOS] CentOS 5ã§Postfix+PostfixAdmin+MySQLç’°å¢ƒã‚’ä½œã‚‹ ä»Šå›žã¯Debianã§ã¯ãªãã‚ã¾ã‚Šæ…£ã‚Œã¦ã„ãªã„CentOSã§è©¦ã—ã¦ã¿ãŸã“ã¨ã®è¦šãˆæ›¸ãã§ã™ã€‚æ…£ã‚Œã¦ãªã„ç’°å¢ƒã£ã¦ã¤ã‚‰ã„ãã€‚æœ€å°ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ï¼ˆã®ã¯ãšï¼‰çŠ¶æ…‹ã‹ã‚‰è¡Œã£ã¦ã¿ã¾ã™ã€‚æ‰‹é †ã¯ã“ã‚“ãªæ„Ÿã˜ã§ã—ã‚‡ã†ã‹ã€‚ Postfixã®Buildã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« LAMPç’°å¢ƒã¨PostfixAdminã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Postfixã®ä»®æƒ³ã‚µã‚¤ãƒˆã«é–¢ã™ã‚‹è¨å®š Courier-IMAPã€Courier authentication libraryã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« SMTP-AUTHã®è¨å®š å‹•ä½œç¢ºèª 1. Postfixã®Buildã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« yumã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹Postfixã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨é€£æºã§ãã‚‹ã‚ˆã†ã«ã¯ã•ã‚Œã¦ã„ã¾ã›ã‚“ã€‚ä»Šå›žã®æ§‹æˆã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«MySQLã‚’ä½¿ã£ã¦Postfixã¯ã“ã‚Œã‚’åˆ©ç”¨ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™
emosei 2009/01/03
ã“ã‚Œã§ã§ããŸã€‚

centos

postfix

mysql
ãƒªãƒ³ã‚¯
ã€Œå®Ÿç¾ã—ãŸã„ã“ã¨ã‚’è¨ˆç®—æ©Ÿã®å•é¡Œã«ç½®ãæ›ãˆã‚‹ã“ã¨ãŒã€ŽæŠ€è¡“åŠ›ã€ã€ã€ä¼Šè—¤CTOãŒâ€œã¯ã¦ãªæµâ€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®æ¥µæ„ã‚’èªžã‚‹
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
emosei 2008/11/20
å¤§è¦æ¨¡

ã¯ã¦ãª

linux

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ãƒ¡ãƒ¢ãƒª

mysql

sql
ãƒªãƒ³ã‚¯
ã€Œã¯ã¦ãªæµå¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã€ã‚’è¦‹ã¦ããŸ - ã‚‚ãŽã‚ƒã‚ã
KOF2008ï¼šé–¢è¥¿ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹2008ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã«æ¥ã¦ã„ã¾ã™ã€‚ ã¯ã¦ãªã®ä¼Šè—¤ã•ã‚“ã®è¬›æ¼”ãŒã‚ã£ãŸã®ã§ã€è¬›æ¼”ãƒ¡ãƒ¢ã‚’å…¬é–‹ã€‚ ï¼ƒãƒœã‚¯ãŒãƒ¡ãƒ¢ã—ãŸå†…å®¹ã§ã‚ã£ã¦ã€100%è¨€ã£ãŸã¨ãŠã‚Šã«æ›¸ã„ã¦ã‚ã‚‹ã‚ã‘ã˜ã‚ƒãªã„ã®ã§ã€å‚è€ƒã¨ã—ã¦ã”è¦§ãã ã•ã„ã€‚ (ç¶šã) ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ OSã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ MySQLã®é‹ç”¨ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™º ãƒ‡ãƒ¼ã‚¿ã®ä¾‹ ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã®ãƒ‡ãƒ¼ã‚¿é‡ï¼šäº”åƒä¸‡ä»¶ãã‚‰ã„ã®ãƒ‡ãƒ¼ã‚¿é‡ ã“ã®ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ä½•ç™¾ä¸‡äººãŒã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ãã‚‹çŠ¶æ³ã§ã©ã†ã„ã†ä½œã‚Šã«ã™ã‚‹ã‹ ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 1073ä¸‡ã‚¨ãƒ³ãƒˆãƒªãƒ¼ 3134ä¸‡ã‚¨ãƒ³ãƒˆãƒªãƒ¼ 4143ä¸‡ã‚¿ã‚° ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚º ã‚¨ãƒ³ãƒˆãƒªãƒ¼2.5GB ä½•ã®å·¥å¤«ã‚‚ãªãæ™®é€šã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã¨...200ç§’å¾…ã£ã¦ã‚‚çµæžœãŒå¸°ã£ã¦ã“ãªã„ å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã®é›£ã—ã„ã¨ã“ã‚ é–‹ç™ºã‚µãƒ¼ãƒã§é–‹ç™ºè€…ãŒä½œã£ã¦ã„ã‚‹æ™‚ã¯å¿«é©ã«å‹•ã„ã¦ã„ã¦ã‚‚ã€å¤šæ•°ã®äººé–“ãŒã‚¢ã‚¯
emosei 2008/11/11
ã“ã‚Œã¯ã„ã„ã

ã¯ã¦ãª

mysql

åˆ†æ•£
ãƒªãƒ³ã‚¯
MySQLãŒä¸é©å½“ãªãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿”ã™å•é¡Œã€‚ - ä¸–ç•Œç·šèˆªè·¡è”µ
Active Recordã‹ã‚‰ å¤‰ãªãƒ¬ã‚³ãƒ¼ãƒ‰ãŒè¿”ã£ã¦ãã‚‹ ã®ã¯ã€Active Recordã®å•é¡Œã‹ã¨æ€ã£ãŸã‚‰MySQLã®å•é¡Œã ã£ãŸã€‚Active Recordã‚ˆã€ç–‘ã£ã¦æ¸ˆã¾ãªã‹ã£ãŸã€‚ Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 to server version: 5.0.18-Debian_8bpo1-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> describe users; +-------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key
emosei 2008/07/04
yugui

mysql

ä¸å½“ãªå€¤ï¼Ÿ
ãƒªãƒ³ã‚¯
æŠ€è¡“ãƒ¡ãƒ¢
æŠ€è¡“ãƒ¡ãƒ¢
emosei 2008/02/07
mysql
ãƒªãƒ³ã‚¯
MySQL ã® AUTO_INCREMENT ã®å€¤ã‚’ãƒªã‚»ãƒƒãƒˆã™ã‚‹
MySQL ã® AUTO_INCREMENT ã®å€¤ã‚’ãƒªã‚»ãƒƒãƒˆã™ã‚‹ 2003-03-12-4: [MySQL] ALTER TABLE table_name AUTO_INCREMENT=max_id_number
emosei 2008/02/07
mysql

auto_increment
ãƒªãƒ³ã‚¯
ï¼»MySQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬36å›ž æ–‡å—åŒ–ã‘ã®ãƒ¡ã‚«ãƒ‹ã‚ºãƒ
æ–‡å—ã‚³ãƒ¼ãƒ‰ã®å¤šæ§˜åŒ–ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‚„ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ-ã‚µãƒ¼ãƒãƒ¼ãªã©ã®åˆ†æ•£ç’°å¢ƒã®æ™®åŠã«ã‚ˆã£ã¦ï¼Œæ–‡å—åŒ–ã‘ãƒˆãƒ©ãƒ–ãƒ«ã®é »åº¦ãŒé£›èºçš„ã«æ‹¡å¤§ã—ãŸã€‚ç‰¹ã« Webã‚·ã‚¹ãƒ†ãƒ ã§ã¯ï¼ŒWebãƒ–ãƒ©ã‚¦ã‚¶ã¨Webã‚µãƒ¼ãƒãƒ¼ï¼Œãƒ—ãƒã‚°ãƒ©ãƒ (ã‚¹ã‚¯ãƒªãƒ—ãƒˆ)è¨€èªžï¼Œãã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨æ–‡å—åŒ–ã‘ãŒç™ºç”Ÿã™ã‚‹è¦å› ãŒæ•°å¤šãå˜åœ¨ã™ã‚‹ã€‚ Webã‚µãƒ¼ãƒãƒ¼å´ã®æ–‡å—åŒ–ã‘ã¯ï¼Œä»–ã®ã‚³ãƒ©ãƒ ã«ãŠä»»ã›ã™ã‚‹ã“ã¨ã¨ã—ã¦ï¼Œä»Šå›žã¯MySQLã®æ–‡å—åŒ–ã‘ã«é–¢ã—ã¦è§£èª¬ã™ã‚‹ã€‚ æ–‡å—åŒ–ã‘ã®ä»•çµ„ã¿ æ–‡å—åŒ–ã‘ã¯é–‹ç™ºè€…ã«ã¨ã£ã¦æ‚©ã¿ã®ç¨®ã§ã‚ã‚‹ã€‚ã—ã‹ã—ï¼Œæ–‡å—åŒ–ã‘ã®ä»•çµ„ã¿ã‚’å°‘ã—ã§ã‚‚çŸ¥ã£ã¦ã„ã‚Œã°ï¼Œæ„å¤–ã¨ç°¡å˜ã«è§£æ±ºã§ãã‚‹ã‚‚ã®ã ã€‚ã“ã®ã‚³ãƒ©ãƒ ã§ï¼Œãœã²ãã®çŸ¥è˜ã‚’å¦ã‚“ã§ã»ã—ã„ã€‚ MySQL 4.1ã®å¤‰æ›´ç‚¹ ã•ã¦ï¼ŒMySQLã«ãŠã„ã¦ã¯ï¼Œãƒãƒ¼ã‚¸ãƒ§ãƒ³4.1ã®ãƒªãƒªãƒ¼ã‚¹ã‚’å¢ƒã«æ–‡å—åŒ–ã‘ãŒèµ·ãã‚‹ã“ã¨ãŒéžå¸¸ã«å¤šããªã£ãŸã€‚ã§ã¯ï¼Œãƒãƒ¼ã‚¸ãƒ§ãƒ³4.1ã¯ï¼Œãã‚Œä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ä½•ãŒå¤‰ã‚ã£ãŸã®ã ã‚ã†ã‹ã€‚ãã“ã«æ–‡å—åŒ–ã‘ã‚’è§£æ±ºã™ã‚‹ãƒ’ãƒ³ãƒˆ
emosei 2007/12/17
mysql

æ–‡å—åŒ–ã‘
ãƒªãƒ³ã‚¯
http://oss.timedia.co.jp/show/MySQL%E6%97%A5%E6%9C%AC%E8%AA%9E%E3%81%AE%E6%97%85/SET%E6%96%87%E3%81%AB%E3%82%88%E3%82%8B%E3%82%AD%E3%83%A3%E3%83%A9%E3%82%AF%E3%82%BF%E3%82%BB%E3%83%83%E3%83%88%E3%81%AE%E5%A4%89%E6%9B%B4
emosei 2007/10/31
mysql

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
emosei 2007/10/31
mysql

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
Ground-SunLight
â€” y2sunlight ,Since 2019-10-02 Ground Sunlight ã¯ã€ŒWindowsã§ä½œã‚‹ - PHPãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®é–‹ç™ºç’°å¢ƒã€ã‚’ãƒ†ãƒ¼ãƒžã«ã—ãŸã‚µã‚¤ãƒˆã§ã™ã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹å…¨ã¦ã®äººé”ã«ç¥ç¦ã‚’ï¼
emosei 2007/10/31
mysql

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] All About
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° MySQLã¯ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚’ä½¿ç”¨ã—ã€é€šå¸¸ã®å®Ÿè¡Œæ™‚ã®ãƒ¡ãƒ¢ãƒªæ¶ˆè²»ã‚’å°ã•ãã—ã¦ã„ã¾ã™ãŒã€ãƒ¡ãƒ¢ãƒªã‚’å¤šãå‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå‘ä¸Šã—ã¾ã™ã€‚ mysqld ã‚µãƒ¼ãƒã§ä½¿ç”¨ã•ã‚Œã‚‹ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã¯æ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã§ç¢ºèªã§ãã¾ã™ã€‚ innodb_force_recovery 0 interactive_timeout 28800 join_buffer_size 131072 key_buffer_size 8388572 long_query_time 10 lower_case_table_names TRUE max_allowed_packet 1048576 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 100 max_connect_err
emosei 2007/10/10
mysql

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