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

wkbyshnbtk id:wkbyshnbtk

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

${{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 ã§ SELECT ã®ã¨ãã«ãƒ¦ãƒ¼ã‚¶ãƒ¼å¤‰æ•°ã‚’ä»£å…¥ã—ã¦ä½¿ã†
çŸ¥ã‚‰ãªã‹ã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ mysql> SELECT @foo := UNIX_TIMESTAMP(), FROM_UNIXTIME(@foo) +--------------------------+---------------------+ | @foo := UNIX_TIMESTAMP() | FROM_UNIXTIME(@foo) | +--------------------------+---------------------+ | 1331202141 | 2012-03-08 19:22:21 | +--------------------------+---------------------+ @variable := expr ã§å¤‰æ•°ã«ä»£å…¥ã—ã€ãã‚Œã‚’ãã®å ´ã§ä½¿ã†ã“ã¨ãŒã§ãã‚‹ã€‚ã„ã¾ã¾ã§ã¯ SET @variable = expr ã—ã¦ã‹ã‚‰ã—ã‹ä½¿ãˆãªã„ã®ã‹ãªãƒ¼ã¨æ€ã£ã¦
wkbyshnbtk 2012/03/10
mysql
ãƒªãƒ³ã‚¯
http://mysql-casual.org/2011/08/mysql-casual-talks-vol2-1.html
wkbyshnbtk 2011/08/15
mysql

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
ä»Šé¢¨ã®UIã€‚Ajaxã‚’ä½¿ã£ãŸPHPãƒ™ãƒ¼ã‚¹ã®MySQLç®¡ç†ã‚·ã‚¹ãƒ†ãƒ Â·MyWebSql MOONGIFT
MyWebSqlã¯Ajaxã‚’å¤šç”¨ã—ãŸä»Šé¢¨ã®UIã‚’ä½¿ã£ãŸMySQLç®¡ç†ãƒ„ãƒ¼ãƒ«ã€‚ MyWebSqlã¯PHPè£½ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚PHPã¨è¨€ãˆã°MySQLã€ãã®äºŒã¤ã®çµ„ã¿åˆã‚ã›ã‹ã‚‰ç”Ÿã¿å‡ºã•ã‚ŒãŸphpMyAdminã€‚LAMPã‚¹ã‚¿ãƒƒã‚¯ãªã‚“ã¦è¨€è‘‰ãŒç”Ÿã¿å‡ºã•ã‚ŒãŸã®ã«phpMyAdminã®å„ªç§€ã•ãŒã‚ã£ãŸã“ã¨ã¯å¦å®šã§ããªã„ã€‚ãã‚Œãã‚‰ã„èª°ã—ã‚‚ãŒä½¿ã£ã¦ã„ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ ãƒ‡ãƒ¼ã‚¿ä¸€è¦§ ã ãŒé•·ã„å¹´æœˆã®ã†ã¡ã«UIã¯å¤ã„ã‚‚ã®ã«ãªã‚Šã€ã¡ã‚‡ã£ã¨æ™‚ä»£ãŒå¤‰ã‚ã£ã¦ãã¦ã„ã‚‹ã‹ã¨ã„ã†æ°—ãŒã—ãªãã‚‚ãªã„ã€‚ãã“ã§ä»Šã®Webã«åˆã‚ã›ãŸMySQLç®¡ç†ãƒ„ãƒ¼ãƒ«ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ãã‚ŒãŒMyWebSqlã ã€‚ MyWebSqlã¯Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é¢¨ã®ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«åŠ ãˆã¦ã€UIã®ãƒ‡ã‚¶ã‚¤ãƒ³ã‚‚ãƒãƒƒãƒ—ã§æ˜Žã‚‹ã„é…è‰²ã«ãªã£ã¦ã„ã¦ä½¿ã„å‹æ‰‹ãŒè‰¯ã„ã€‚å·¦å´ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸€è¦§ã€å³å´ã§ãƒ‡ãƒ¼ã‚¿ã®ç·¨é›†ã‚’è¡Œã†ã‚¹ã‚¿ã‚¤ãƒ«ã¯phpMyAdminã¨åŒã˜ã ã€‚ã•ã‚‰ã«ä¸‹ã«ã¯SQ
wkbyshnbtk 2011/07/31
ã“ã‚Œã¯è‰¯ã•ãã†ã§ã™ãã€‚

mysql

php
ãƒªãƒ³ã‚¯
725640â€™s gists
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
wkbyshnbtk 2010/12/19
riywo: Perlã§SQLã«ã‚³ãƒ¡ãƒ³ãƒˆã§ã‚½ãƒ¼ã‚¹ä¸Šã®å®Ÿè¡Œä½ç½®ã‚’è¿½åŠ ã™ã‚‹æ–¹æ³• https://gist.github.com/725640

perl

mysql
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
wkbyshnbtk 2010/11/24
mysql

tips

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
utf8_general_ci ã¨ utf8_unicode_ci ã®é•ã„ - Ceekz Logs (Move to y.ceek.jp)
ä»¥å‰ã¾ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ MySQL ã‚’åˆ©ç”¨ã—ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ã¨ãã¯ã€æ–‡å—ã‚³ãƒ¼ãƒ‰ã¨ã—ã¦ EUC-JP ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã—ãŸã€‚æœ€è¿‘ã¯ã€å›½éš›åŒ–ã¨ã®å…¼ãåˆã„ãªã©ã‹ã‚‰ UTF-8 ã‚’åˆ©ç”¨ã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ MySQL ã§ UTF-8 ã‚’æ‰±ã†å ´åˆã€ç…§ä¼šé †åºã¨ã—ã¦ utf8_bin ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã—ãŸï¼ˆä½•ã‚‚è€ƒãˆãšã«ï¼‰ã€‚ utf8_bin ã®å ´åˆã€éƒ¨åˆ†ä¸€è‡´æŽ¢ç´¢ LIKE ãªã©ã®ä½¿ç”¨æ™‚ã«è‹±å—ã®å¤§æ–‡å—å°æ–‡å—ãŒåŒºåˆ¥ã•ã‚Œã¦ã—ã¾ã†ã€‚å¤§æ–‡å—å°æ–‡å—ã‚’åŒºåˆ¥ã•ã‚Œãªã„ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã«ã¯ã€ç…§ä¼šé †åºã¨ã—ã¦ utf8_general_ci ã‚’ä½¿ç”¨ã™ã‚Œã°ã‚ˆã„ã®ã§ã™ãŒã€ä»–ã«ã‚‚ utf8_unicode_ci ãŒã‚ã‚‹ã“ã¨ã«æ°—ãŒã¤ãã¾ã—ãŸã€‚ utf8_general_ci ã¨ utf8_unicode_ci ã§ã¯ã€ã©ã“ãŒé•ã†ã®ã ã‚ã†ï¼Ÿ utf8_general_ci also is satisfactory for both
wkbyshnbtk 2010/11/24
mysql

unicode
ãƒªãƒ³ã‚¯
MySQLã§ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ã®ãªã„ALTER TABLEã®æ¤œè¨Ž - SH2ã®æ—¥è¨˜
MySQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚«ãƒ©ãƒ è¿½åŠ ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†ç·¨æˆãªã©ã‚’è¡Œã†ã¨ã€ãã®é–“ãƒ†ãƒ¼ãƒ–ãƒ«ã«å…±æœ‰ãƒãƒƒã‚¯ãŒã‹ã‹ã£ã¦ã—ã¾ã„ã¾ã™ã€‚ãã®ãŸã‚ã“ã‚Œã‚‰ã®ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å‡¦ç†ã¯ã€é€šå¸¸åˆ©ç”¨è€…ã®å°‘ãªã„æ·±å¤œæ—©æœå¸¯ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¢ã‚ã¦å®Ÿæ–½ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚æœ¬æ—¥ã¯ãã‚Œã‚’ç„¡åœæ¢ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®ã¾ã¾ã§ã§ããªã„ã‹ã¨ã„ã†è©±é¡Œã§ã™ã€‚ åŸºæœ¬çš„ãªã‚¢ã‚¤ãƒ‡ã‚¢ ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å¯¾è±¡ã®å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã€ä½œæ¥ç”¨ã®ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Šã¾ã™ ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€ã‚«ãƒ©ãƒ è¿½åŠ ãªã©ã®å¤‰æ›´ã‚’åŠ ãˆã¾ã™ ãã®é–“ã€å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦è¡Œã‚ã‚Œã‚‹æ›´æ–°å‡¦ç†ã«ã¤ã„ã¦å·®åˆ†ã‚’è¨˜éŒ²ã—ã¦ãŠãã¾ã™ ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã®å¤‰æ›´ãŒçµ‚ã‚ã£ãŸã‚‰ã€è¨˜éŒ²ã—ã¦ãŠã„ãŸå·®åˆ†ãƒ‡ãƒ¼ã‚¿ã‚’ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã«åæ˜ ã—ã¾ã™ å·®åˆ†ãƒ‡ãƒ¼ã‚¿ã®åæ˜ ãŒçµ‚ã‚ã£ãŸã‚‰ã€å…ƒãƒ†ãƒ¼ãƒ–ãƒ«ã¨ä»®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å…¥ã‚Œæ›¿ãˆã¾ã™ ã“ã‚Œã¨ä¼¼ãŸã‚ˆã†ãªã“ã¨ã‚’è€ƒãˆãŸæ–¹ã¯çµæ§‹ã„ã‚‰ã£ã—ã‚ƒã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãŸã ã€è¨€ã†ã¯æ˜“ã—ã€è¡Œã†ã¯é›£ã—ã§ã™ã€‚æ•´åˆæ€§ãŒãã¡ã‚“ã¨å–ã‚Œã‚‹ã‹ã©ã†
wkbyshnbtk 2010/07/07
mysql

maintenance
ãƒªãƒ³ã‚¯
MySQLã®ãŠã¾ã¨ã‚INSERTã¯ã©ã‚Œãã‚‰ã„é€Ÿã„ã‹ - bonar note
MySQLã§å¤§é‡ã®INSERTå‡¦ç†ç‰ã‚’ã™ã‚‹å ´åˆã€VALUES ã§é•·ã„ã‚¯ã‚¨ãƒªã‚’ä½œã£ã¦ä¸€æ°—ã«çªã£è¾¼ã‚€ã¨ã‹ãªã‚Šé«˜é€Ÿã«ãªã‚‹ã“ã¨ã¯ã‚ˆãçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ä½•ã¨ãªã10å€ãã‚‰ã„ã£ã¦ã„ã†ä½“æ„Ÿã ã£ãŸã®ã§ã™ãŒã€è¨ˆã£ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ä»¥ä¸‹ã¨åŒã˜ã‚¹ã‚ãƒ¼ãƒžã®ãƒ†ãƒ¼ãƒ–ãƒ« foo1, foo2 foo3 ã‚’ç”¨æ„ã—ã¾ã™ã€‚ CREATE TABLE `foo1` ( `field1` int(10) unsigned NOT NULL DEFAULT '0', `field2` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`field1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ãƒ†ã‚¹ãƒˆç’°å¢ƒã¯ä»¥ä¸‹ã®ã‚ˆã†ãªæ„Ÿã˜ã§ã™ã€‚ Server version: 5.1.44 MySQL Community Server (GPL) 2.13 GHz
wkbyshnbtk 2010/03/31
mysql

Benchmark
ãƒªãƒ³ã‚¯
YappoLogs: ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã—ãŸMySQLã®ãŠã¾ã¨ã‚INSERTã¯ã©ã‚Œãã‚‰ã„é€Ÿã„ã‹
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã—ãŸMySQLã®ãŠã¾ã¨ã‚INSERTã¯ã©ã‚Œãã‚‰ã„é€Ÿã„ã‹ å…ƒãƒã‚¿ã¯MySQL ã®ãŠã¾ã¨ã‚INSERTã¯ã©ã‚Œãã‚‰ã„é€Ÿã„ã‹ - bonar noteã§ã™ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã§ã¾ã¨ã‚ã¦Insertã—ã¦ã‹ã‚‰commitã—ãŸã»ã†ãŒé€Ÿããªã‚‹ã®ã§ã€å…ƒãƒã‚¿ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ã¦è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ ç’°å¢ƒã¯ macports ã§å…¥ã‚ŒãŸ mysql 5.1.44 ã§ã™ã€‚ ã¾ãnormalã‹ã‚‰bulk(100)ãã‚‰ã„ã®å·®ã¯å‡ºã¦ãªãã¦ã‚‚ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ä½¿ã£ã¦ã¾ã¨ã‚ã¦ã‚³ãƒŸãƒƒãƒˆã—ã¦ã‚‚å¤šå°‘é€Ÿããªã£ã¨ã‚Šã¾ã™ãã€‚ normal ã¨ txn ã®å·®ã‚ˆã‚Šã‚‚ bulk(100) ã¨ bulk(100)_txn ã®å·®ãŒå°ã•ã„ã®ã¯ã€ bulk insert ã§æœ€åˆã‹ã‚‰åŠ¹çŽ‡çš„ã«ãªã£ã¦ã‚‹ã¶ã‚“å·®ãŒå°‘ãªããªã£ã¦ã‚‹ã¨ã„ã†æ„Ÿã˜ã§ã—ã‚‡ã†ã‹ã€‚ ã‚³ãƒ¼ãƒ‰ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ Posted by Yappo at 2010å¹´03æœˆ09æ—¥
wkbyshnbtk 2010/03/31
mysql

Benchmark
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
wkbyshnbtk 2009/02/19
mysql
ãƒªãƒ³ã‚¯
mysql_enable_utf8 => 1 ã§ DBIC::UTF8Columns è¦ã‚‰ãªããªã‚‹ã£ã½ã„ - åƒ•ãƒˆäº‘ãƒ•äº‹ï¼ ã¯ã¦ãªå‡ºå¼µç‰ˆ
è¿½è¨˜ã§ã™ ã‚³ãƒ¡ãƒ³ãƒˆã¨ãƒ–ã‚¯ãƒžã§ä»Šã®ã¨ã“ã‚ experimental ã¨æ›¸ã„ã¦ã‚ã‚‹ã‚ˆï¼ ã¨æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚æ°—ã¥ã„ã¦ãªã‹ã£ãŸã§ã™ã€‚id:nihen ã•ã‚“ã€ã‚³ãƒ¡ãƒ³ãƒˆãã‚ŒãŸäººã€ã‚ã‚ŠãŒã¨ã†ã€‚ This option is experimental and may change in future versions. Catalyst::Wiki ã‚‚ã“ã‚Œæ›¸ã„ãŸæ–¹ãŒè‰¯ã•ãã†ã§ã™ãã€‚æ›¸ã‘ã‚‹ã®ã‹ãªã€‚ ãã‚Œã«ã—ã¦ã‚‚ã€DBD å´ã§ã§ãã‚‹ã¨è‰¯ã„ã«è¶Šã—ãŸã“ã¨ãªã„ã®ã§ã€æ—©ãç¢ºå®šã—ã¦æ¬²ã—ã„ã§ã™ãï¼ è¿½è¨˜2 ã‚ãƒ¼ã€ã§ã‚‚ã“ã‚Œã€4.00ã‹ã‚‰ãšã£ã¨ã“ã®ã¾ã¾ã ã€‚ã‹ã‚Œã“ã‚Œ2å¹´ãã‚‰ã„ experimental ãªã‚“ã§ã™ãŒw Catalyst::Wiki ã«æ›¸ã„ã¦æ¥ã¡ã‚ƒã£ãŸã‘ã©w ã“ã“ã‹ã‚‰å…ƒã®å†…å®¹ lyokato ã•ã‚“çµŒç”±ã§ woremacx ã•ã‚“ã«æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸ Using Unicode - Catalyst::Wiki ã«æ›¸ã„
wkbyshnbtk 2009/02/05
DBIx-Class

perl

mysql
ãƒªãƒ³ã‚¯
KLab
ã”æŒ‡å®šã®ãƒšãƒ¼ã‚¸ãŒè¦‹ã¤ã‹ã‚Šã¾ã›ã‚“ã§ã—ãŸ URLã®å¤‰æ›´ã€ã‚‚ã—ãã¯ãƒšãƒ¼ã‚¸ãŒå‰Šé™¤ã•ã‚ŒãŸå¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ãŠæ‰‹æ•°ã§ã™ãŒã€ä»¥ä¸‹ã®ãƒªãƒ³ã‚¯ã‹ã‚‰ç›®çš„ã®ãƒšãƒ¼ã‚¸ã‚’ãŠæŽ¢ã—ãã ã•ã„ã€‚
wkbyshnbtk 2009/02/05
ã‚ã¨ã§èªã‚€

ã‚ã¨ã§è©¦ã™

mysql
ãƒªãƒ³ã‚¯
cicindela2 - Google Code
Code Archive Skip to content Google About Google Privacy Terms
wkbyshnbtk 2008/12/24
perl

mysql

recommend

ã„ã¤ã‹
ãƒªãƒ³ã‚¯
Yet Another Hackadelic - AES_ENCRYPT, AES_DECRYPTå¯èƒ½ãªæš—å·ã‚’Perlã§è¡Œã†
ã¯ã˜ã‚ã« MySQLã®é–¢æ•°ã«AES_ENCRYPT, AES_DECRYPTã£ã¦ã®ãŒã‚ã‚Šã¾ã™ã€‚ AES_ENCRYPT, AES_DECRYPT Rijndaelã‚’128bitã®keylengthã§ECBã§æš—å·åŒ–ã™ã‚‹é–¢æ•°ã§ã™ã€‚ AES_ENCRYPT mysql> SELECT HEX(AES_ENCRYPT('hogehoge', 'abcdeabcdeabcdea')) AS encrypted; +----------------------------------+ | encrypted | +----------------------------------+ | 2BF77B6863989EAD599D86650A046586 | +----------------------------------+ AES_DECRYPT mysql> SELECT AES_DECRY
wkbyshnbtk 2008/11/28
perl

æš—å·åŒ–

mysql
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
wkbyshnbtk 2008/11/24
movabletype

mysql

server
ãƒªãƒ³ã‚¯
EUC-JPã§æ›¸ãè¾¼ã‚€ã¨MySQLã§æ–‡å—åŒ–ã‘ã™ã‚‹ï¼Ÿï¼ æ—¥æ›œãƒ—ãƒã‚°ãƒ©ãƒžã®ãã‚žã‚äº‹
wkbyshnbtk 2008/07/23
kanji-code

mysql

perl
ãƒªãƒ³ã‚¯
mysql ã‚’é«˜é€ŸåŒ–ã—ãŸã„ã¨ãã«èªã‚€ãƒ¡ãƒ¢ (TechKnowledge)
çµ¦æ–™ã®æŒ¯è¾¼å£åº§ã¨ã—ã¦ä¸‰äº•ä½å‹éŠ€è¡Œã«å£åº§ã‚’æŒã£ã¦ã„ã¾ã™ã€‚è‡ªå‹•æ”¯æ‰•ã„ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½¿ç”¨ã—ã¦å…‰ç†±è²»ç‰ã®å…¬å…±æ–™é‡‘ã®æ”¯æ‰•ã„ã‚’ã—ã¦ã„ã¾ã™ãŒã€å…ˆæ—¥ãã‚Œã‚‰ã®å†…ã®ä¸€ã¤ã‚’å¤±å¿µã—ã¦ãŸã“ã¨ã«æ°—ã¥ãã¾ã—ãŸã€‚å£åº§ã‚’ç¢ºèªã—ãŸæ™‚ã«ã¯ã™ã§ã«å¼•ãè½ã¨ã—ãŒå®Œäº†ã—ã¦ã„ãŸãŸã‚ã€æ‰‹å…ƒã®è³‡é‡‘ãŒå¿ƒç´°ããªã£ãŸçŠ¶æ…‹ã§æ•°æ—¥ã‚’éŽã”ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸‰äº•ä½å‹éŠ€è¡Œã§å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒå¯èƒ½ã§ã‚ã‚Œã°ã€æ˜¯éžåˆ©ç”¨ã—ãŸã„ã®ã§ã™ãŒã€‚ é‹ãŒè‰¯ã‘ã‚Œã°ã€ä¸‰äº•ä½å‹éŠ€è¡Œã®å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã¯å¯èƒ½ ä¸‰äº•ä½å‹éŠ€è¡Œã®ç‰¹å¾´ã¯ã¾ãšã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ä¼šç¤¾ã¨ã®é€£æºã—ãŸã‚µãƒ¼ãƒ“ã‚¹ãŒé…åŠ›çš„ãªã“ã¨ãŒã‚ã’ã‚‰ã‚Œã¾ã™ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã§ã¯éŠ€è¡Œã‚«ãƒ¼ãƒ‰ãƒãƒ¼ãƒ³ã§ã™ã‹ã‚‰ã€ä½•ã‚ˆã‚Šå®‰ã„é‡‘åˆ©ãŒå¤§ãã„åˆ©ç‚¹ã«ãªã‚Šã¾ã™ã€‚æ¦‚ãéŠ€è¡Œç³»ã®å¯©æŸ»ã«å¿…è¦ãªæ™‚é–“ã¯é•·ããªã‚‹ã‚ˆã†ã§ã™ãŒã€ä¸‰äº•ä½å‹éŠ€è¡Œã§ã¯ã‚«ãƒ¼ãƒ‰ç™ºè¡ŒãŒå½“æ—¥ã«è¡Œãªã£ã¦ãã‚Œã¾ã™ã€‚ ä¸‰äº•ä½å‹éŠ€è¡Œã¯å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒã§ãã‚‹ã‹ã¨è¨€ã†ã¨å¾®å¦™ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚ç”³è¾¼ã‹ã‚‰å¯©æŸ»çµæžœã®é€£çµ¡ã¾ã§ã¯ã€åœŸæ—¥
wkbyshnbtk 2006/11/28
mysql

performance

database

tips
ãƒªãƒ³ã‚¯
ã“ã“ã‚®ã‚³ï¼: MySQL4.1ä»¥é™ã§ã®ç©ºé–“æƒ…å ±ã®æ‰±ã„æ–¹
Posted by nene2001 at 01:25 / Tag(Edit): mysql spatial / 2 Comments: Post / View / 1 TrackBack / Google Maps Web2.0ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ§ãƒƒãƒ—ã§è¬›æ¼”ã™ã‚‹ã®ã«ã€ãŸã ã§ã•ãˆä¸€äººã ã‘ç´ äººã§ã¾ã¨ã‚‚ãªè¬›æ¼”ã§ãã‚‹ã‹ä¸å®‰ãªã®ã«ã€å‹‰å¼·ã›ãšã«ä»Šã®çŸ¥è˜ã ã‘ã§ã¯ã„ã‹ã‚“ã ã‚ã†ã¨ã„ã†ã“ã¨ã§ã€ä»Šã¾ã§ã»ã£ãŸã‚‰ã‹ã—ã¦ããŸMySQL4.1ä»¥é™ã®ç©ºé–“æƒ…å ±åˆ©ç”¨æ³•ã‚’å‹‰å¼·ã€‚ ã¨ã„ã£ã¦ã‚‚ã€ã“ã¡ã‚‰ã«4.1ã®æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚ã‚‹ã®ã§å…¨ç„¶è‹¦åŠ´ãªã—ã ãŒã€‚ ãŸã å‹•ä½œç¢ºèªã¯5.1ã§ã‚„ã£ã¦ã„ã‚‹ã®ã§ã€è‹±èªžç‰ˆ5.1ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã¨ã®ç…§ã‚‰ã—åˆã‚ã›ã¯ã‚„ã£ã¦ã¾ã™ã‘ã©ã€‚ä¸€å¿œã€‚ PostGISã¨ã®æ¯”è¼ƒã§æ›¸ãã¨ã€PostGISã®å ´åˆã€PostgreSQL æœ¬ä½“ã¨ã¯åˆ¥ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã‚ã‚‹ã›ã„ã‹ã€ä½ç½®æƒ…å ±ã‚«ãƒ©ãƒ ã®ã¤ã„ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã„ã£ãºã‚“ã«ã¯ã§ããªã„ã€‚ ä¾‹ãˆ
wkbyshnbtk 2006/11/14
mysql

gis
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MySQL ã®è² è·åˆ†æ•£ã« LVS + keepalived ã‚’ä½¿ã†
ã‚ã¨ã§æ›¸ãã€ã¨è¨€ã£ãŸæ‰‹å‰ãªã®ã§æ›¸ãã¨ã—ã¾ã™ã€‚ DSASã®ä¸ã®äººãŒã™ã”ã„å‹¢ã„ã§ LVS ã®è©±ã‚’æ›¸ã„ã¦ãã‚Œã¦ã¾ã™ã€‚ã“ã®è¾ºã€‚LVS ã‚’ä½¿ã†ã¨ Linux ã¨ç®±ã§ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãŒä½œã‚Œã¡ã‚ƒã„ã¾ã™ã€‚æ™®é€šã«è²·ã£ãŸã‚‰æ•°ç™¾ä¸‡ã¨ã‹ã—ã¡ã‚ƒã†ã‚„ã¤ã€‚ DSAS ã®ä¸ã®ã²ã¨ã«æ„Ÿè¬ã—ã¤ã¤ã€ã„ã„æ©Ÿä¼šãªã®ã§ã‚„ã£ã¦ã¿ã‚ˆã†! ã¨æ€ã£ã¦ã„ã‚ã„ã‚è©¦ã—ã¦æ˜¨æ—¥ã‚ãŸã‚Šã‹ã‚‰ã¯ã¦ãªã®ä¸ã§ã‚‚ LVS + keepalived ã§å‹•ã‹ã—ã¯ã˜ã‚ã¦ã¾ã™ã€‚ã„ã¾ã®ã¨ã“ã‚å•é¡Œãªã—ã€‚ ãã®ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã‚’ã©ã“ã«ä½¿ã£ã¦ã‚‹ã‹ã§ã™ãŒã€æ™®é€šãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã¨ã„ã†ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‹ã‚‰ã®å…¥ã‚Šå£ã®ã¨ã“ã‚ã«ç½®ã„ã¦ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£ã«ä½¿ã†ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒã‚ã‚Šã¾ã™ã€‚ãŒã€ä»Šå›žã¯ã¯ã¦ãªã§ã¯ MySQL ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã®æ‰‹å‰ã«ç½®ãã¨ã„ã†å½¹å‰²ã§ã¨ã‚Šã‚ãˆãšä½¿ã„ã¯ã˜ã‚ã¾ã—ãŸã€‚ +-----------+ +-----------+ | mod_perl | | mod_perl | +----
wkbyshnbtk 2006/11/09
mysql

network

performance

server

database
ãƒªãƒ³ã‚¯
1