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

katow id:katow

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

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

ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç–ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç– ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã®æ¾æµ¦éš¼äººã•ã‚“ã«ã€8ã¤ã®ã€ŒSQLãŒé‡ãŸããªã‚‹åŽŸå› ã¨ãã®å¯¾ç–ã€ã‚’èžãã¾ã—ãŸã€‚ã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚‹ã‚ˆã†ãªã€Œå•é¡Œã®ã‚ã‚‹SQLã€ã‚’å›žé¿ã™ã‚‹ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã³ã¾ã—ã‚‡ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æ“ä½œã‚„å®šç¾©ã‚’ã™ã‚‹è¨€èªžã€ŒSQLã€ã¯ã€ã©ã®ã‚ˆã†ãªé ˜åŸŸã‚’æ‹…ã†ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã‚‚å¿…ä¿®ç§‘ç›®ã§ã™ã€‚ã—ã‹ã—ã€ãã®ä»•æ§˜ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å„ªã‚ŒãŸSQLã‚’æ›¸ã‘ã‚‹æ–¹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚å•é¡Œã®ã‚ã‚‹SQLã‚’æ›¸ã„ã¦ã—ã¾ã„ã€çŸ¥ã‚‰ã¬é–“ã«ãã‚ŒãŒã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã†äº‹æ…‹ã¯ã‚ˆãç™ºç”Ÿã—ã¾ã™ã€‚ ã§ã¯ã€ã©ã†ã™ã‚Œã°ãã†ã—ãŸäº‹æ…‹ã‚’å›žé¿ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã®ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã¶ãŸã‚ã€ä»Šå›žã¯ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã§ã‚ã‚Šã€è‡ªèº«ã‚‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã‚ã‚‹æ¾æµ¦éš¼äººï¼ˆã¾ã¤ã†ã‚‰ãƒ»ã¯ã‚„ã¨ï¼@dblmktï¼‰ã•ã‚“ã«8ã¤
katow 2017/06/26
SQL

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MySQLã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ï¼šè€ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã®å‚™å¿˜éŒ²ï¼šSo-netãƒ–ãƒã‚°
MySQLã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ« MySQLã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€å®Ÿè¡Œã‚¨ãƒ©ãƒ¼ãƒã‚°ã€ã‚¯ã‚¨ãƒªãƒã‚°ã€ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°åŠã³ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°ã®4ç¨®é¡žã®ãƒã‚°ãŒã‚ã‚Šã¾ã™ã€‚ å®Ÿè¡Œã‚¨ãƒ©ãƒ¼ãƒã‚° å®Ÿè¡Œã‚¨ãƒ©ãƒ¼ãƒã‚°ã¯ã€èµ·å‹•ã€åœæ¢åŠã³å®Ÿè¡Œæ™‚ã®ã‚¨ãƒ©ãƒ¼ãŒMySQLãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«"ãƒ›ã‚¹ãƒˆå.err"ã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«åã§ä¿ç®¡ã•ã‚Œã¾ã™ã€‚ MySQLã§éšœå®³ç™ºç”Ÿæ™‚ã«éšœå®³ç‰¹å®šã®æƒ…å ±ã‚’å¾—ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ãƒ»è¨å®šæ–¹æ³• 1ï¼Žã‚³ãƒžãƒ³ãƒ‰ UNIXã€Linuxã®å ´åˆ $ mysqld_safe --log-error=myerror.log --log-warnings=1 Windowsã®å ´åˆ C\> mysqld-nt --log-error=myerror.log --log-warnings=1 ã‚ªãƒ—ã‚·ãƒ§ãƒ³ ã‚ªãƒ—ã‚·ãƒ§ãƒ³ å†…å®¹ --log-error[=filename] ã‚¨ãƒ©ãƒ¼ãƒã‚°ã®å‡ºåŠ›å…ˆãƒ•ã‚¡ã‚¤ãƒ«åã‚’æŒ‡å®šã—ã¾ã™ã€‚ --log-warnings[
katow 2012/04/07
MySQL
ãƒªãƒ³ã‚¯
MYSQLã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«å‡ºåŠ›è¨å®š - MYSQL
â– MySQLã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ« MySQLã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€å®Ÿè¡Œã‚¨ãƒ©ãƒ¼ãƒã‚°ãƒ»ã‚¯ã‚¨ãƒªãƒã‚°ãƒ»ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ãƒ»ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°ã®4ç¨®é¡žãŒã‚ã‚Šã¾ã™ã€‚ â€» mysql/data/ ã¸æ ¼ç´ã•ã‚Œã‚‹ â€»ã‚³ãƒžãƒ³ãƒ‰ã‹ã‚‰è¨å®šã®å ´åˆã¯Mysqlåœæ¢ã¾ã§æœ‰åŠ¹ã€è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã®å ´åˆã¯è¨å®šå‰Šé™¤ã¾ã§æœ‰åŠ¹ã€‚ â˜†å®Ÿè¡Œã‚¨ãƒ©ãƒ¼ãƒã‚° èµ·å‹•ã€åœæ¢åŠã³å®Ÿè¡Œæ™‚ã®ã‚¨ãƒ©ãƒ¼ãŒMySQLãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ä¿å˜ã•ã‚Œã¾ã™ã€‚ MySQLã§éšœå®³ç™ºç”Ÿæ™‚ã«éšœå®³ç‰¹å®šã®æƒ…å ±ã‚’å¾—ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ãƒ»è¨å®šæ–¹æ³•ï¼ˆã‚³ãƒžãƒ³ãƒ‰ï¼‰ UNIXã€Linuxã®å ´åˆ $ mysqld_safe --log-error=myerror.log -w 1 Windowsã®å ´åˆ C\> mysqld-nt --log-error=myerror.log -w 1 â€» -w [-wlevel]ã€€ï¼ˆãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ 1ï¼‰ level 0ï¼šè¦å‘Šãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã¯è¨˜éŒ²ã•ã‚Œã¾ã›ã‚“ã€‚ level 1ï¼šè¦å‘Šãƒ¡ãƒƒ
katow 2012/04/07
mysql
ãƒªãƒ³ã‚¯
Fatal error: Maximum execution time of 30 seconds exceededã®å¯¾å‡¦æ³• - [PHP + PHP] ãºã‚“ãŸã‚“ info
Fatal error: Maximum execution time of 30 seconds exceededã®å¯¾å‡¦æ³• PHPã§ã¯ç„¡é™ãƒ«ãƒ¼ãƒ—ãªã©ã®å¯¾ç–ã®ãŸã‚ã€PHPå‡¦ç†ã®ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆãŒè¨å®šã•ã‚Œã¦ã„ã¾ã™ã€‚ [å‚è€ƒè¨˜äº‹] ãƒ–ãƒ©ã‚¦ã‚¶ã®ä¸æ¢ãƒœã‚¿ãƒ³ã‚’æŠ¼ã—ãŸã¨ãã«å‡¦ç†ã‚’åœæ¢ã•ã›ã‚‹ ã“ã®ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã¾ã§ã®æ™‚é–“ã¯æ¨™æº–ã§ã¯30ç§’ã¨ãªã£ã¦ã„ã¾ã™ã€‚ PHPã®å‡¦ç†ãŒå®Ÿè¡Œã•ã‚Œã¦ã€30ç§’ä»¥ä¸ŠçµŒéŽã™ã‚‹ã¨æ¬¡ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã€PHPã®å‡¦ç†ã¯åœæ¢ã—ã¾ã™ã€‚ Fatal error: Maximum execution time of 30 seconds exceeded ã“ã®æ™‚é–“ã‚’å¤‰æ›´ã™ã‚‹ã«ã¯ã„ãã¤ã‹ã®æ–¹æ³•ãŒã‚ã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã¯120ç§’ã«å¤‰æ›´ã™ã‚‹å ´åˆã®è¨å®šä¾‹ã§ã™ã€‚ php.ini max_execution_time = 120 httpd.confã‚„.htaccess php_value max_execution
katow 2012/04/07
php

php.ini

Apache

XAMPP

MySQL
ãƒªãƒ³ã‚¯
Ajax+PHP+MySQLãªæŠ•ç¥¨ã‚¦ã‚£ã‚¸ã‚§ãƒƒãƒˆ:phpspoté–‹ç™ºæ—¥èªŒ
Masuga Design å®ŸUnobtrusive AJAX Star Rating Bar This is a rating bar script done with PHP and mySQL that allows users to rate things like can be done on Netflix or Amazon, all web 2.0-like with no page refresh. Ajax+MySQL+PHPãªæŠ•ç¥¨ã‚¦ã‚£ã‚¸ã‚§ãƒƒãƒˆã€‚ æ¬¡ã®ã‚ˆã†ãªWeb2.0é¢¨ã®ãƒ¬ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ãƒãƒ¼ã‚’ç°¡å˜ã«å®Ÿè£…ã§ãã¾ã™ã€‚ å¿…è¦ãªphpãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¤ãƒ³ã‚¯ãƒ«ãƒ¼ãƒ‰ã—ã¦ãŠã‘ã°ã€ãŸã£ãŸä¸€è¡Œã€æ¬¡ã®ã‚ˆã†ã«æ›¸ãã ã‘ã§ãƒ¬ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ãƒãƒ¼ã‚’å®Ÿè£…ã§ãã‚‹ã‚ˆã†ã§ã™ã€‚ ï¼ˆJavaScriptã¨CSSã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚ä½¿ç”¨ã™ã‚‹HTMLå†…ã§ã‚¤ãƒ³ã‚¯ãƒ«ãƒ¼ãƒ‰ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚) <?php rating_bar('2',5)
katow 2011/11/17
PHP

mysql

Ajax

æŠ•ç¥¨

ãƒ¬ãƒ¼ãƒ†ã‚£ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Unknown command '\ãƒ».ã€€(MySQL dump æ–‡å—ã‚³ãƒ¼ãƒ‰) - ãƒ‰ãƒ¼ãƒ‡ã‚‚ã„ã„é©å½“ãªäº‹æ ¸æ—¥è¨˜
dumpã§å…ƒãƒ‡ãƒ¼ã‚¿ã‚’Importã™ã‚‹ã•ã„ã« $ mysql -uroot -ppswrd --default-character-set=sjis database_name < dump.sql å…ƒãƒ‡ãƒ¼ã‚¿ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã«åˆã‚ã›ã¦ã€sjis ã¾ãŸã¯utf8ãªã©ã‚’æŒ‡å®šã™ã‚‹ã€‚ default-character-set=sjis
$Unknown command '\ãƒ».ã€€(MySQL dump æ–‡å—ã‚³ãƒ¼ãƒ‰) - ãƒ‰ãƒ¼ãƒ‡ã‚‚ã„ã„é©å½“ãªäº‹æ ¸æ—¥è¨˜$
katow 2011/04/27
å¤±æ•—ã—ãŸ

mysql

TIPS
ãƒªãƒ³ã‚¯
MySQL Workbench ã®èµ·å‹•æ™‚ã«ã€Œcannot start SSH tunnel managerã€ã£ã¦ã‚¨ãƒ©ãƒ¼ãŒå‡ºã‚‹ - m2
æ¤œç´¢ã™ã‚‹ã¨ã€Œsshtunnel.pyã€ã§ã‚¨ãƒ©ãƒ¼ã«ãªã£ã¦ã‚‹ã¨ã„ã†ã“ã¨ã¯ã‚ã‹ã£ãŸã€‚http://bugs.mysql.com/bug.php?id=52318 ã§ã€sshtunnel.py ã®ã©ã“ã§ã“ã‘ã¦ã‚‹ã‹è¦‹ã¦ã¿ãŸã‚‰ã€ã€Œimport socketã€ã®ã¨ã“ã‚ã ã£ãŸã€‚ ã‚¢ãƒãƒ£ãƒ¼ã€TracLightning ãã€‚TracLightning ã® Python 2.5 ã¨ MySQL Workbench ã® Python 2.6 ã§ã‚³ãƒ³ãƒ•ãƒªã‚¯ãƒˆã—ã¦ã‚‹ã€ã¨ã€‚ ç’°å¢ƒå¤‰æ•°ã‚’è¦‹ã¦ã¿ã‚‹ã€‚ ã€ŒPYTHONHOMEã€ã¨ã€ŒPYTHONPATHã€ãŒæŒ‡å®šã—ã¦ã‚ã‚‹ã€‚ ã€Œset PYTHONPATH=.;.\python;ã€ã—ã¦å®Ÿè¡Œã€‚ ã†ã”ã„ãŸãƒ¼ã€‚ ã‚¹ã‚¿ãƒ¼ãƒˆãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰å‹•ã‹ã™å ´åˆã¯ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ç’°å¢ƒå¤‰æ•°ã§ã€ŒPYTHONPATHã€ã‚’ã€Œ;ã€ã¨ã‹ã«ã—ã¦ãŠã‘ã°å‹•ãã¨æ€ã„ã¾ã™ã€‚
katow 2011/04/27
åŒã˜ã¨ã“ã‚ã§ã²ã£ã‹ã‹ã‚Šã¾ã—ãŸã€‚æ„Ÿè¬ã€‚ï¼ˆè¿½è¨˜ï¼‰ã‚„ã£ã±ã‚ŠTracLightingå´ãŒå†…éƒ¨ã‚¨ãƒ©ãƒ¼ã«ãªã£ãŸã€‚phpMyAdminã§ã‚„ã‚‹ã“ã¨ã«ã—ã¦Workbenchã‚ãã‚‰ã‚ã€‚

mysql

TIPS

Python

Trac Lightning
ãƒªãƒ³ã‚¯
Windowsã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸXAMPPã«Rubyã‚’è¿½åŠ ã—ã¦Railsã‚’ä½¿ã†ã€‚ã¤ã„ã§ã«FastCGIã‚‚ã€‚ - é–¢æ‰“ã‚¨ã‚¢ã‚³ãƒ³
ä½•ã¨ã‹å‹•ãã‚ˆã†ã«ãªã£ãŸã®ã§è‡ªåˆ†çš„ã¾ã¨ã‚ã€‚ XAMPPãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ã€ŒVersion 1.6.6ã€ã§è¡Œã£ã¦ã„ã‚‹ã€‚ ã€ŒOne-Click Ruby Installerã€ã§Rubyã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ http://rubyforge.org/projects/rubyinstaller/ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å…ˆã¯ã‚ã‹ã‚Šã‚„ã™ã„ã‚ˆã†ã«XAMPPãƒ•ã‚©ãƒ«ãƒ€ä¸‹ã€ŒC:\xampp\rubyã€ã¨ã—ãŸã€‚ ä¸€å¿œã€ä½¿ã£ãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ãƒ¡ãƒ¢ One-Click Installer - Windows 1.8.6-26 Final Release ç’°å¢ƒå¤‰æ•°ã®ã€ŒPathã€ã«ã€ŒC:\xampp\ruby\bin;ã€ãŒè¿½åŠ ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’å¿µã®ãŸã‚ã«ç¢ºèªã—ã¦ãŠãã€‚ï¼ˆè‡ªå‹•ã§è¿½åŠ ã•ã‚Œã‚‹ã®ã§ç¢ºèªã¯ä¸è¦ã§ã¯ã‚ã‚‹ãŒâ€¦ï¼‰ ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã§ã€Œruby -vã€ã‚’å®Ÿè¡Œã—ã¦ãƒãƒ¼ã‚¸ãƒ§ãƒ³æƒ…å ±ã‚’ç¢ºèªã™ã‚‹ã€‚ï¼ˆRubyãŒæ£å¸¸ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã‹ã©ã†ã‹ã®ç¢ºèªã€‚ï¼‰
katow 2011/04/25
XAMPP

Rails

ruby

mysql

windows

TIPS
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¯ãƒ«ã®MySQLæˆ¦ç•¥ã‚’äºˆæƒ³ã™ã‚‹ã€‚ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚µãƒ¼ãƒ“ã‚¹ã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã¨ã—ã¦å¼·åŒ–ã•ã‚Œã‚‹MySQL
ã‚ªãƒ©ã‚¯ãƒ«ãŒã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã‚’è²·åŽå¾Œã€ä¸€éƒ¨ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¨ã®ãƒˆãƒ©ãƒ–ãƒ«ãŒå ±é“ã•ã‚Œã¦ãã¾ã—ãŸã€‚OpenOffice.orgã¯ä¸»è¦ãªé–‹ç™ºè€…ãŒæ–°ãŸã«Document Foundationã‚’è¨ç«‹ã—ã¦LibraOfficeã®é–‹ç™ºã‚’å§‹ã‚ã€Hudsonã‚‚åŒã˜ã‚ˆã†ã«Jenkinsã¨ã—ã¦ã‚ªãƒ©ã‚¯ãƒ«ã‹ã‚‰ç‹¬ç«‹ã—ã¾ã—ãŸã€‚Javaã«é–¢é€£ã—ã¦ã‚ªãƒ©ã‚¯ãƒ«ãŒã‚°ãƒ¼ã‚°ãƒ«ã‚’è¨´ãˆã¦ã‚‚ã„ã¾ã™ã€‚ ã“ã‚Œã‚‰ã‹ã‚‰ã€MySQLã«ã¤ã„ã¦ã®ä»Šå¾Œã‚‚ä¸å®‰è¦–ã•ã‚Œã¦ã„ã‚‹é¢ãŒã‚ã‚Šã¾ã—ãŸã€‚ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Memcached APIã‚’å‚™ãˆã‚‹ï¼ MySQL Conference & Expo 2011åŸºèª¿è¬›æ¼” ï¼ Publickey ã—ã‹ã—æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ãªã‚‹MySQL 5.6ã¨MySQL Cluster 7.2ã®æ©Ÿèƒ½å¼·åŒ–ã‚’ã¿ã‚‹ã¨ã€MySQLã®é–‹ç™ºãƒšãƒ¼ã‚¹ã¯ã‚€ã—ã‚ä»¥å‰ã‚ˆã‚Šä¸ŠãŒã£ã¦ãŠã‚Šã€åŒè£½å“ã®å°†æ¥ã«ã¤ã„ã¦ã®ä¸å®‰ã‚’æ‰•æ‹ã™ã‚‹ã‚‚ã®ã«ãªã£ã¦ã„
katow 2011/04/18
ã¤ã¾ã‚Šã‚ªãƒ©ã‚¯ãƒ«ã«ã¨ã£ã¦ã€MySQLã¯SQLServerã¤ã¶ã—ã®å°–å…µã«ãªã‚‹ã€ã¨ï¼Ÿï½—

DataBase

Oracle

MySQL

Windows
ãƒªãƒ³ã‚¯
NoSQLã¨ã—ã¦MySQLã‚’ä½¿ã†DeNAãŒã€memcachedã‚ˆã‚Šã‚‚é«˜é€Ÿãª75ä¸‡ã‚¯ã‚¨ãƒªï¼ç§’ã‚’å®Ÿç¾
ãƒ¢ãƒã‚²ãƒ¼ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«NoSQLã‚’ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãªãœã‹ï¼Ÿ ãã‚Œã¯MySQL/InnoDB 5.1ã®ç’°å¢ƒã§ç§’é–“75ä¸‡ã‚¯ã‚¨ãƒªã¨ã„ã†ã€å¤šãã®NoSQLã§ã‚‚å®Ÿç¾ã§ããªã„ã‚ˆã†ãªé«˜æ€§èƒ½ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ã‚‰ã€‚DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ã¯ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã«ã“ã‚“ãªå†…å®¹ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverã€ï¼ˆè‹±èªžï¼‰ã‚’ãƒœã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
katow 2010/10/27
ã“ã‚Œã¯é¢ç™½ã„ãªã‚ã€‚ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ä¸–ç•Œã«ã¯é™ç•Œã¯ãªã„ãã€‚

DeNA

memcached

mysql

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

handlersocket
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 2.3.4.8 Windows ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ MySQL ã‚’èµ·å‹•ã™ã‚‹
Windows ã§ MySQL ã‚’å®Ÿè¡Œã™ã‚‹å ´åˆã€Windows ã®èµ·å‹•ãŠã‚ˆã³åœæ¢æ™‚ã« MySQL ãŒè‡ªå‹•çš„ã«èµ·å‹•ãŠã‚ˆã³åœæ¢ã™ã‚‹ã‚ˆã†ã«ã€Windows ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒæŽ¨å¥¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ MySQL Server ã‚’ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã€NET ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ã¦ã‚³ãƒžãƒ³ãƒ‰è¡Œã‹ã‚‰ã€ã‚ã‚‹ã„ã¯ã‚°ãƒ©ãƒ•ã‚£ã‚«ãƒ« Services ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ãƒ¼ã§ç®¡ç†ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ ä¸€èˆ¬ã«ã€MySQL ã‚’ Windows ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ãã¯ã€ç®¡ç†è€…æ¨©é™ã®ã‚ã‚‹ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½¿ã£ã¦ãƒã‚°ã‚¤ãƒ³ã™ã‚‹ã‚ˆã†ã«ã—ã¦ãã ã•ã„ã€‚ Services ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ (Windows Service Control Manager) ã¯ã€Windows ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ‘ãƒãƒ«ã«ã‚ã‚Šã¾ã™ã€‚ ç«¶åˆã‚’é¿ã‘ã‚‹ãŸã‚ã«ã€ã‚µãƒ¼ãƒãƒ¼ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¾ãŸã¯ã‚³ãƒžãƒ³ãƒ‰è¡Œã‹ã‚‰ã®å‰Šé™¤æ“ä½œã®éš›ã«ã¯ã€Services ãƒ¦ãƒ¼ãƒ†
katow 2010/04/06
Windowsã§ã®ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã®æ‰‹æ®µ

MySQL

TIPS

Windows
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
katow 2010/04/06
ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã«ã¤ã„ã¦è¨˜è¿°

mysql

Windows

TIPS
ãƒªãƒ³ã‚¯
Oracleã«ã‚ˆã‚‹Sun Microsystemsè²·åŽã§ã€MySQLã¯ã©ã†ãªã‚‹ï¼Ÿ | isologue
Oracleã«ã‚ˆã‚‹Sun Microsystemsè²·åŽãŒæ±ºã¾ã£ãŸã®ã§ã€ã‚µãƒ³ã®10-K http://www.sec.gov/Archives/edgar/data/709519/000119312508187118/d10k.htm ã‚’èªã¿å§‹ãŸã‚“ã§ã™ãŒã€MySQLã£ã¦ã€ä»Šã€ã‚µãƒ³ãŒæ¨©åˆ©ã‚’æŒã£ã¦ã„ãŸã‚“ã§ã™ããƒ»ãƒ»ãƒ»ã€‚ï¼ˆä¸å‹‰å¼·ã§ã™ã¿ã¾ã›ã‚“ã€‚ï¼‰ MySQLãŒã€Œã‚¿ãƒ€ã€ã§ãªããªã‚‹ã¨ã„ã†ã“ã¨ã¯ã€ã‚ªãƒ©ã‚¯ãƒ«ã«ã¨ã£ã¦ã™ã”ã„ãƒ¡ãƒªãƒƒãƒˆãªã‚“ã˜ã‚ƒãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ï¼ˆãã†ã§ã‚‚ãªã„ã®ã‹ãªï¼Ÿï¼‰ ã‚ªãƒ©ã‚¯ãƒ«ã¨MySQLã‚’è¶³ã—ãŸã‚·ã‚§ã‚¢ã£ã¦ä½•ï¼…ãã‚‰ã„ãªã®ã‹çŸ¥ã‚Šã¾ã›ã‚“ãŒï¼ˆã»ã¨ã‚“ã©ã®é ˜åŸŸã§100%è¿‘ã„ï¼Ÿï¼‰ã€ã‚¢ãƒ¡ãƒªã‚«ã®ç«¶äº‰æ³•ä¸Šã€ãã‚Œã£ã¦ã‚¢ãƒªãªã‚“ã§ã—ã‚‡ã†ã‹ï¼Ÿ ï¼ˆå–ã‚Šæ€¥ãŽã€‚ï¼‰ â€”â€”â€”â€”â€”- ãƒ¡ãƒ¼ãƒ«ãƒžã‚¬ã‚¸ãƒ³é€±åˆŠisologueï¼ˆæ¯Žé€±æœˆæ›œæ—¥ç™ºè¡Œ840å††/æœˆ ç”³è¾¼æœˆç„¡æ–™ï¼‰ã€‚ ä»Šç”³ã—è¾¼ã‚“ã§ã‚‚ã€ä»Šæœˆç™ºè¡Œåˆ†ã®ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼ï¼ˆå‰µåˆŠå·ã€ç¬¬2å·ã€ç¬¬3å·ï¼‰ã‚‚é€ã‚‰
katow 2009/04/22
ãã€ãã†ã‹ã€ä»Šè¨˜äº‹èªã‚“ã§åˆã‚ã¦èªè˜ã—ã¾ã—ãŸï¼›ï¼›ï¼›

Oracle

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

TIPS

MySQL
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã®è©±
ã‹ãªã‚ŠãªãŒãƒ¼ã„ã‚¨ãƒ³ãƒˆãƒªã«ãªã‚‹äºˆå®šãªã®ã§,çµè«–ã ã‘æœ€åˆã«æ›¸ãã¨ã“ã‚“ãªæ„Ÿã˜. ã“ã®è©±é¡Œã«ã¤ã„ã¦ã¯è‡ªåˆ†ã‚‚ ã‚ã¨ã§æ›¸ã ã¨è¨€ã£ã¦æ›¸ã„ã¦ãªã‹ã£ãŸã®ã§æ›¸ã„ã¦ã¿ã¾ã™ã‚ˆã€‚2006å¹´ã®ä¸‹æœŸã«ã‚‚ãªã£ã¦ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã‹ã‚ˆã¨ã„ã†ãƒ„ãƒƒã‚³ãƒŸã‚‚ã‚ã‚Šãã†ã§ã™ãŒã€ã‚ã¨ã§æ›¸ãã¨ã„ã£ãŸã‚‰æ›¸ãã®ã€‚ã‚ã¨ã§èªã‚€ã¨ã„ã£ãŸã‚‰èªã‚€ã€‚ æ™®é€šã€Œã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã€ã¨è¨€ã£ãŸã‚‰ã€ä¸»ã«äºŒã¤ã®å½¹å‰²ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚è©±ã‚’ç°¡å˜ã«ã™ã‚‹ãŸã‚ã«ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«é™å®šã—ã¦è¨€åŠã—ã¾ã™ã€‚ ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ DB ã¸ã®æŽ¥ç¶šã‚’é–‹ã‘ã£æ”¾ã—ã«ã—ã¦ã€æŽ¥ç¶šã«å¿…è¦ã¨ã•ã‚Œã‚‹ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã‚’ã‚«ãƒƒãƒˆã—ã¦åŒæ–¹ã®è² è·ã‚’ä¸‹ã’ã‚‹ã€‚ ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ DB ã¸ã®æŽ¥ç¶šã‚’ã€Œä½¿ã„ã¾ã‚ã™ã€ã“ã¨ã§ã€åŒæ™‚æŽ¥ç¶šæœ¬æ•°ã‚’ç¯€ç´„ã™ã‚‹ã€‚ ã¨ã„ã†ã‚‚ã®ã€‚ mod_perl ã§ DB ã¨æŽ¥ç¶šç¶æŒã™ã‚‹ã¨ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³æ•°å¢—ãˆã¦äº‘ã€…ã¨ã„ã†è©±ã¯ä¸»ã«å‰è€…ã®ã¿ã«ã¤ã„ã¦ã®è©±ã«ãªã‚Šã¾ã™ã€‚Apache::DB
katow 2009/02/19
ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°

MySQL
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 16.5 ARCHIVE ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³
ARCHIVE ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯ MySQL ãƒã‚¤ãƒŠãƒªé…å¸ƒã«å«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ ã‚½ãƒ¼ã‚¹ã‹ã‚‰ MySQL ã‚’æ§‹ç¯‰ã™ã‚‹å ´åˆã«ã“ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æœ‰åŠ¹ã«ã™ã‚‹ã«ã¯ã€CMake ã‚’ -DWITH_ARCHIVE_STORAGE_ENGINE ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§å‘¼ã³å‡ºã—ã¾ã™ã€‚ ARCHIVE ã‚¨ãƒ³ã‚¸ãƒ³ã®ã‚½ãƒ¼ã‚¹ã‚’èª¿ã¹ã‚‹ã«ã¯ã€MySQL ã‚½ãƒ¼ã‚¹é…å¸ƒã® storage/archive ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’æ¤œç´¢ã—ã¾ã™ã€‚ ARCHIVE ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãŒ SHOW ENGINES ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã§ä½¿ç”¨ã§ãã‚‹ã‹ã©ã†ã‹ã‚’ç¢ºèªã§ãã¾ã™ã€‚ ARCHIVE ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹ã¨ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯ãƒ†ãƒ¼ãƒ–ãƒ«åã§å§‹ã¾ã‚‹åå‰ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®æ‹¡å¼µåã¯ .ARZ ã§ã™ã€‚ æœ€é©åŒ–æ“ä½œä¸ã« .ARN ãƒ•ã‚¡ã‚¤ãƒ«ãŒç¾ã‚Œã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ARCHIVE ã‚¨ãƒ³ã‚¸ãƒ³ã§ã¯ã€INSERTã€REPLACE ãŠã‚ˆã³ SELE
katow 2009/02/19
ï¼•ï¼Žï¼ä»¥é™ï¼Ÿselectã¨insertã®ã¿å®Ÿè¡Œã§ãã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ARCHIVEãŒã§ããŸã€å¸¸ã«zlibåœ§ç¸®ã—ã¦ã„ã‚‹ã‚‰ã—ã„ã€‚

MySQL

Archive
ãƒªãƒ³ã‚¯
MySQL AB :: MySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«
æ¦‚è¦ ã“ã‚Œã¯ MySQL ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã™ã€‚ MySQL 8.0 ã‹ã‚‰ 8.0.25ã€ãŠã‚ˆã³ NDB ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 8.0 ã‹ã‚‰ 8.0.25-ndb-8.0.25 ã«åŸºã¥ã NDB Cluster ãƒªãƒªãƒ¼ã‚¹ã«ã¤ã„ã¦ãã‚Œãžã‚Œèª¬æ˜Žã—ã¾ã™ã€‚ ã¾ã ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ãªã„ MySQL ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®æ©Ÿèƒ½ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒå«ã¾ã‚Œã¦ã„ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®è©³ç´°ã¯ã€ã€ŒMySQL 8.0 ãƒªãƒªãƒ¼ã‚¹ãƒŽãƒ¼ãƒˆã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ MySQL 8.0 ã®æ©Ÿèƒ½. ã“ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã§ã¯ã€MySQL 8.0 ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«ã‚ˆã£ã¦ã¯å«ã¾ã‚Œã¦ã„ãªã„æ©Ÿèƒ½ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ã“ã®ã‚ˆã†ãªæ©Ÿèƒ½ã¯ã€ã”è‡ªèº«ã«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ä»˜ä¸Žã•ã‚Œã¦ã„ã‚‹ MySQL 8.0 ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã¦ã„ãªã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ MySQL 8.0 ã®ä½¿ç”¨ã—ã¦ã„ã‚‹ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã«å«ã¾ã‚Œã‚‹æ©Ÿèƒ½ã«é–¢ã™ã‚‹è³ªå•ãŒã‚ã‚‹å ´åˆã¯ã€MySQL 8.0
katow 2009/02/15
æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã®ã‚ã‚Šã‹ãŒã™ãã«åˆ†ã‹ã‚‰ãªããªã‚‹

TIPS

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«

mysql
ãƒªãƒ³ã‚¯
ã‚„ãã†ã‚‰ãŠ - MySQLã®interactive_timeout
ã¡ã‚‡ã£ã¨ã—ãŸã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚²ãƒ¼ãƒ ã‚’ä½œã£ã¦ã„ã‚‹ã®ã ã‘ã©ã€ã‚µãƒ¼ãƒãƒ¼å´ã¯C#ã§æ›¸ã„ã¦ã„ã¦ã€ODBCçµŒç”±ã§MySQLã¨ã‚„ã‚Šã¨ã‚Šã—ã¦ã„ã‚‹ã€‚DBã¯åŒä¸€ã‚µãƒ¼ãƒãƒ¼ä¸Šã«ã‚ã‚‹ã®ã§ã€ã‚²ãƒ¼ãƒ ã‚µãƒ¼ãƒãƒ¼èµ·å‹•ä¸ã¯ã‚µãƒ¼ãƒãƒ¼å´ã®ãƒ—ãƒã‚°ãƒ©ãƒ ãŒMySQLã«å¯¾ã—ã¦ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’å¼µã‚Šã£ã±ãªã—ã«ã™ã‚‹ã€‚ localhostãªã®ã§ã€åˆ‡æ–ã•ã‚Œã‚‹ã“ã¨ã¯æƒ³å®šã—ã¦ãªã‹ã£ãŸã®ã ã‘ã©ã‚‚ã€æ·±å¤œã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒç„¡ã„ã¨åˆ‡æ–ã•ã‚Œã¦ã„ã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚ã“ã‚Œã«ã¯å‚ã£ãŸã€‚ã©ã†ã‚„ã‚‰ã€ã‚ã‚‹ç¨‹åº¦ã®æ™‚é–“ã‚¢ã‚¯ã‚»ã‚¹ãŒç„¡ã„ã¨ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒåˆ‡æ–ã•ã‚Œã‚‹ã‚ˆã†ã ã€‚ åŒã˜å•é¡Œã§æ‚©ã‚“ã§ã„ã‚‹äººã®è¨˜äº‹ã‚’è¦‹ã‚‹ã¨ã€ãªã‚‹ã»ã©ã€MySQLã®è¨å®šã§interactive_timeoutã¨ã„ã†é …ç›®ãŒã‚ã‚Šã€ã“ã‚ŒãŒãƒ‡ã‚£ãƒ•ã‚©ãƒ«ãƒˆã§ã¯8æ™‚é–“ã«è¨å®šã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã ã€‚ã‚ˆã£ã¦8æ™‚é–“é€£ç¶šã§ã€ã‚¯ã‚¨ãƒªç‰ã‚’ç™ºè¡Œã—ãªã‘ã‚Œã°ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã¯è‡ªå‹•çš„ã«åˆ‡æ–ã•ã‚Œã¦ã—ã¾ã†ã®ã ã€‚ ãªã‚“ã¨ã‚‚ä½™è¨ˆãªãŠä¸–è©±ã§ã‚ã‚‹ã€‚ã—ã‹ã—ã€ã“ã®è¨å®šã‚’ç„¡åŠ¹ã«ã™ã‚‹æ–¹
katow 2009/02/08
MySQLã®è‡ªå‹•åˆ‡æ–æ©Ÿèƒ½ã¯OFFã«ã§ããªã„ã®ã§ã€æœ€å¤§é™ä¼¸ã°ã™è¨å®šã‚’æ–½ã—ã¦å¯¾å‡¦ã™ã‚‹ã‚„ã‚Šæ–¹ãŒã‚ã‚‹ã€‚

TIPS

MySQL
ãƒªãƒ³ã‚¯
ã€ŒMySQL server has gone away ã‚¨ãƒ©ãƒ¼ã€ï¼ˆ1ï¼‰ Insider.NET ï¼ ï¼ IT
ï¼ IT ä¼šè°å®¤ Indexãƒªãƒ³ã‚¯ Windows Server Insider Insider.NET System Insider XML & SOA Linux Square Master of IP Network Java Solution Security & Trust Database Expert RFIDï¼‹IC ãƒªãƒƒãƒã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ & å¸³ç¥¨ Server ï¼† Storage Coding Edge ï¼ ITã‚¯ãƒ©ãƒ– Cafe VBæ¥å‹™ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºç ”ç©¶ ï¼ IT SpecialPR
katow 2009/01/17
MySQL server has gone away ä½•ã‚‰ã‹ã®ç†ç”±ã§MySQLãŒé–‰ã˜ã¦ã„ãŸäº‹ãŒåŽŸå› ã®ã‚¨ãƒ©ãƒ¼

.NET

mysql
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MyISAM vs InnoDB
ã‚ãã¾ã§æ†¶æ¸¬ã§ä»®èª¬ã§ã—ã‹ãªã„ã‚“ã§ã™ãŒã€‚ MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ã†ã¡ä»£è¡¨çš„ãªäºŒã¤ã€MyISAM ã¨ InnoDB ã¯ã‚ˆã MyISAM: Read ã¯é€Ÿã„ã‘ã©ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ã®ãŸã‚ä¸¦è¡Œæ€§ãŒä½Žã„ã€‚é‹ç”¨ãŒç°¡å˜ã€‚ InnoDB: MyISAM ã‚ˆã‚Š Read ã¯é…ã„ã‘ã©ä¸¦è¡Œæ€§ãŒé«˜ã„ ã€‚è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ã€‚ã‚ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚„å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã€‚é‹ç”¨ãŒ MyISAM ã‚ˆã‚Šã¡ã‚‡ã£ã¨ã‚ã‚“ã©ãã•ã„ã€‚ ã¨ã„ã†åŒºåˆ¥ãŒã•ã‚Œã¾ã™ã€‚ã“ã“ã‹ã‚‰è»¢ã˜ã¦ã€ MyISAM ã¯å‚ç…§ç³»ã‚¯ã‚¨ãƒªãŒå¤§éƒ¨åˆ†ã‚’å ã‚ã‚‹å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ä¾‹ãˆã° blog ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã‹ã€‚ InnoDB ã¯æ›´æ–°ç³»ã‚¯ã‚¨ãƒªãŒå¤šã„å ´åˆã«é©ç”¨ã™ã‚‹ã¨è‰¯ã„ã€‚ ã¨è¨€ã‚ãŸã‚Šã—ã¾ã™ã€‚å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQL ã§ã‚‚ç¬¬2ç« ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³(ãƒ†ãƒ¼ãƒ–ãƒ«åž‹) P.30 ã« ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹å¿…è¦ãŒãªãã€ä¸»ã« SELECT ã¾ãŸã¯ I
katow 2009/01/05
MySQLã®æ€§èƒ½ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³æ¯”è¼ƒã‚’ç†å±ˆã§è©°ã‚ã‚‹

ã¯ã¦ãª

TIPS

mysql

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