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

cu39 id:cu39

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

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

WP-CLI ã‚³ãƒžãƒ³ãƒ‰ã§æŠ•ç¨¿ã‚’è¡Œã†å ´åˆã«é™ã‚Š â€œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šç¢ºç«‹ã‚¨ãƒ©ãƒ¼â€ãŒç™ºç”Ÿã™ã‚‹
MAMPã‚’ä½¿ç”¨ã—local ç’°å¢ƒã«ã¦ãƒ†ã‚¹ãƒˆã‚’è¡Œãªã£ã¦ãŠã‚Šã¾ã™ã€‚ é€šå¸¸ã®WordPress ç®¡ç†ç”»é¢ã§ã¯æŠ•ç¨¿ãŒå¯èƒ½ã§ã™ãŒ WP-CLIã‚’ä½¿ç”¨ã—ãŸå ´åˆã«é™ã‚Š ä»¥ä¸‹ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—æŽ¥ç¶šãŒã§ãã¾ã›ã‚“ã€‚ Warning: mysqli_real_connect(): (HY000/2002): Connection refused in /Applications/MAMP/htdocs/wordpress/wp-includes/wp-db.php on line 1612 Error: Connection refused ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šç¢ºç«‹ã‚¨ãƒ©ãƒ¼ ã“ã‚Œã¯ã€<code>wp-config.php</code> ãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼åã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒæ£ã—ããªã„ã‹ã€ã‚ã‚‹ã„ã¯ <code>127.0.0.1</code> ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã«æŽ¥ç¶šã§ããªã„ã‹ã®ã©ã¡ã‚‰ã‹ã‚’æ„å‘³ã—ã¾ã™ã€‚ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã®
cu39 2019/09/19
DB_HOSTã«ã‚½ã‚±ãƒƒãƒˆã¸ã®pathã‚’è¿½åŠ ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚

coding

admin

mac

mysql

wordpress
ãƒªãƒ³ã‚¯
macOSã§MySQLã‚’5.7ã‹ã‚‰8.0ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã™ã‚‹ï¼ˆHomebrewä½¿ç”¨ï¼‰ | ç¶ºéº—ã«æ»ã¬ITã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢
/usr/local/opt/mysql@5.7/bin/mysql.server start /usr/local/opt/mysql@5.7/bin/mysql.server stop ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®MySQLã‚’èµ·å‹•ãƒ»åœæ¢ã—ã¾ã™ã€‚ $ sudo mysql.server start Starting MySQL ... SUCCESS! èµ·å‹•æˆåŠŸã™ã‚Œã°å¯¾å‡¦å®Œäº†ã§ã™ã€‚ åŽŸå› 2: MySQL5.7ã®è¨å®šãŒæ®‹ã£ã¦ã„ã‚‹ä»¥ä¸‹ã¨åŒæ§˜ã®ã‚¨ãƒ©ãƒ¼ãƒã‚°ãŒå‡ºã¦ã„ãŸå ´åˆã®å¯¾å‡¦æ³•ã¨ãªã‚Šã¾ã™ã€‚ $ sudo cat /usr/local/var/mysql/*.err | grep ERROR | tail yyyy-MM-ddTHH:mm:ss.ffffffZ 0 [ERROR] [MY-011071] [Server] unknown variable 'innodb_large_prefix=
cu39 2018/10/22
mac

admin

mysql
ãƒªãƒ³ã‚¯
mysqldumpã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã™ã‚‹æ™‚ã«ã¤ã‘ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ - oinume journal
MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹éš›ã«mysqldumpã‚’ä½¿ç”¨ã—ã¾ã™ãŒã€å€‹äººçš„ã«ã€Œã“ã‚Œã¯ã¤ã‘ãŸã‚‰ã‚ˆã•ãã†ã€ã¨æ€ã£ã¦ã„ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ --opt --quick --add-drop-table --add-locks --extended-insert --lock-tables ã‚’æŒ‡å®šã™ã‚‹ã®ã¨åŒã˜ã§ã™ã€‚ãƒ€ãƒ³ãƒ—ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQL ã‚µãƒ¼ãƒã«èªã¿è¾¼ã‚€ãŸã‚ã®æœ€é€Ÿãƒ€ãƒ³ãƒ—ã‚’æä¾›ã—ã¾ã™ã€‚(ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãã®ã¾ã‚“ã¾) --single-transaction ãƒ€ãƒ³ãƒ—ã™ã‚‹éš›ã«å…ˆé ã«BEGINã‚’ã¤ã‘ã‚‹ãŸã‚ã€ãƒ€ãƒ³ãƒ—æ™‚ã®ãƒ‡ãƒ¼ã‚¿ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ä¸€è²«æ€§ã‚’ä¿ã¤ã“ã¨ãŒã§ãã¾ã™ã€‚ãŸã ã—InnoDBãªã©ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒæœ‰åŠ¹ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã¯ãªã„ã¨æ„å‘³ãŒãªã„ã§ã™ã€‚ --flush-logs ãƒ€ãƒ³ãƒ—ã‚’é–‹å§‹ã™ã‚‹å‰ã«ã€MySQL ã‚µãƒ¼ãƒå†…ã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ã—ã¾ã™ã€‚ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ä¿å˜ã™ã‚‹ã‚ˆã†
cu39 2017/04/29
admin

rdb

mysql
ãƒªãƒ³ã‚¯
mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists
While starting mysql server 5.7.17 using mysqld_safe, following error occcours. 2017-02-10T17:05:44.870970Z mysqld_safe Logging to '/var/log/mysql/error.log'. 2017-02-10T17:05:44.872874Z mysqld_safe Logging to '/var/log/mysql/error.log'. 2017-02-10T17:05:44.874547Z mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists. How to fix it ?
cu39 2017/04/23
admin

mysql

trouble
ãƒªãƒ³ã‚¯
MySQLã§ã®ã€ŒAccess denied for user â€˜rootâ€™@â€™localhostâ€™ (using password: NO) ã€ã¸ã®å¯¾å‡¦ | ã‚°ãƒ¼ãƒ•ãƒ¼ WordPressã®ãŸã‚ã®LinuxãƒŽãƒ¼ãƒˆ
MySQLã§ã®ã€ŒAccess denied for user â€˜rootâ€™@â€™localhostâ€™ (using password: NO) ã€ã¸ã®å¯¾å‡¦ MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸç›´å¾Œã«ã€ç§ã‚‚éé‡ã—ã¾ã—ãŸãŒã€rootãƒ¦ãƒ¼ã‚¶ã®æ¨©é™è¨å®šãŒã•ã‚Œã¦ã„ãªãã€ä¸‹è¨˜ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ã“ã¨ãŒã‚ã‚‹ã‚ˆã†ã§ã™ã€‚ [root ~]# mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) ã“ã“ã§ã¯ã€ãã®å ´åˆã®å¯¾å‡¦æ–¹æ³•ã‚’æ•´ç†ã—ã¦ãŠãã¾ã™ã€‚ 1ï¼ŽMySQLã®åœæ¢ MySQL(mysqld)ãŒç¨¼åƒã—ã¦ã„ã‚‹å ´åˆã«ã¯ã€ä¸€æ—¦åœæ¢ã—ã¾ã™ã€‚ [root ~]# service mysqld stop mysqld ã‚’åœæ¢ä¸: [ OK ] 2ï¼Žã‚ªãƒ—ã‚·ãƒ§ãƒ³ä»˜ãã§èµ·å‹• MySQLã‚’â€“ski
cu39 2017/04/23
admin

mysql

trouble
ãƒªãƒ³ã‚¯
Ask HN: What are pros and cons of PostgreSQL and MySQL? | Hacker News
I searched the web but most of the articles are written several years before. Many cons have been fixed. From many years of hosting both - MySQL seems easier at first but there are so, so many probl ems with its internal design that hide probl ems until its too late. PostgreSQL in my eyes is engineered in a much smarter way and has sensible defaults. PostgreSQL won't implement something unless it's
cu39 2017/04/09
coding

admin

rdb

mysql

postgres
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚µã‚¤ã‚ºã‚’ç¢ºèªã™ã‚‹æ–¹æ³• - Simple, Slowly
ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚µã‚¤ã‚ºã¯phpMyAdminã§ã‚‚è¦‹ã‚Œã¾ã™ãŒã€ã‚³ãƒžãƒ³ãƒ‰ã‹ã‚‰è¦‹ã‚ŒãŸã»ã†ãŒä½•ã‹ã¨ä¾¿åˆ©ãªã®ã§ã€èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ å…¨ã¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚µã‚¤ã‚ºã‚’ç¢ºèªã™ã‚‹ # MBå˜ä½ select table_schema, sum(data_length+index_length) /1024 /1024 as MB from information_schema.tables group by table_schema order by sum(data_length+index_length) desc; +--------------------------+---------------+ | table_schema | MB | +--------------------------+---------------+ | database1 | 5579.89978790| | databas
cu39 2017/03/08
admin

coding

rdb

mysql
ãƒªãƒ³ã‚¯
Creating DATETIME from DATE and TIME
cu39 2016/07/24
mysql

time

timezone
ãƒªãƒ³ã‚¯
MySQLã®æš—é»™ã®åž‹å¤‰æ›ã®è©±
ã“ã®è¨˜äº‹ã¯MySQL Casual Advent Calendar 2015ã®18æ—¥ç›®ã§ã™ã€‚ æ˜¨æ—¥ã¯winebarrelã•ã‚“ã®ã€Œbinlog_cache_sizeã«ãƒ¡ãƒ¢ãƒªã‚’é£Ÿã‚ã‚ŒãŸè©±ã€ã§ã—ãŸã€‚ ã“ã†ã„ã£ãŸå®Ÿè·µã®è©±ã¯éžå¸¸ã«è²´é‡ãªã®ã§å‹‰å¼·ã«ãªã‚Šã¾ã—ãŸã€‚ ã•ã¦ã€ŒPostgreSQLã¨æ¯”ã¹ã¦MySQLã®ã„ã„ã¨ã“ã‚æ›¸ãï¼ã€ã‚’æ›¸ã“ã†ã¨æ€ã£ã¦ãŸã®ã§ã™ãŒæ˜¨æ—¥ã“ã‚“ãªãƒ„ã‚¤ãƒ¼ãƒˆã‚’è¦‹ã‹ã‘ã¾ã—ãŸã€‚ "NOT NULL ã¨ã—ã¦å®£è¨€ã•ã‚ŒãŸ DATE ãŠã‚ˆã³ DATETIME ã‚«ãƒ©ãƒ ã§ã¯ã€æ¬¡ã®ã‚ˆã†ãªã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§ã€ç‰¹æ®Šãªæ—¥ä»˜ '0000-00-00' ã‚’æ¤œç´¢ã§ãã¾ã™" https://t.co/qLBYqy7FZm ã„ã‚„ã€ã§ããªãã¦ã„ã„ã‚“ã§ã™ã‘ã©â€¦ã€‚ â€” ã¨ã¿ãŸã¾ã•ã²ã‚ (@tmtms) 2015, 12æœˆ 17 @sakaik IS NULL ã¨ IS NOT NULL ã®ä¸¡æ–¹ã«å«ã¾ã‚Œã¾ã™ï¼ â€” ã¨ã¿ãŸ
cu39 2015/12/18
åºƒãæ™®åŠã—ãŸãŒã‚†ãˆã«æŠ±ãˆã–ã‚‹ã‚’å¾—ãªã„è¤‡é›‘ã•ã€‚

rdb

mysql
ãƒªãƒ³ã‚¯
RDB - å®Ÿä¾‹ã§å¦ã¶ã€JOIN (NLJ) ãŒé…ããªã‚‹ç†å±ˆã¨å¯¾å‡¦æ³• - Qiita
"Nested Loop Joinã—ã‹å–ã‚Šä¸Šã’ã¦ç„¡ã„ã®ã«ã‚¿ã‚¤ãƒˆãƒ«ãŒå¤§ãã™ãŽãªã„ã‹" ã¨æŒ‡æ‘˜ã‚’é ‚ã„ãŸã®ã§ã€ã‚¿ã‚¤ãƒˆãƒ«ã‚’ä¿®æ£ã—ã¾ã—ãŸã€‚Merge Joinã¨Hash Joinã®ã“ã¨ã¯ã¾ãŸä»Šåº¦æ›¸ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ã€ŒJOINã¯é…ã„ã€ã¨ã‚ˆãè¨€ã‚ã‚Œã¾ã™ã€‚ç‰¹ã«RDBã‚’ä½¿ã„å§‹ã‚ã¦é–“ãŒãªã„å†…ã«ãã†ã„ã†è¨€èª¬ã«è§¦ã‚ŒãŸçµæžœã€ŒJOIN=æ‚ªã€ã¨ã„ã†èªè˜ã§å›ºå®šåŒ–ã•ã‚Œã¦ã—ã¾ã£ã¦ã„ã‚‹äººã‚‚å¤šã„ã‚ˆã†ã«æ„Ÿã˜ã¦ã„ã¾ã™ã€‚ ãŸã—ã‹ã«ã€JOINã‚’å«ã‚€ã‚ˆã†ãªSELECTæ–‡ã¯ã€å«ã¾ãªã„ã‚‚ã®ã«æ¯”ã¹ã¦é‡ãŸããªã‚‹å‚¾å‘ãŒã‚ã‚‹ã“ã¨ã¯äº‹å®Ÿã§ã™ã€‚ã¾ãŸã€æœ¬è³ªçš„ã«å•ã„åˆã‚ã›ãŸã„å†…å®¹ãŒè¤‡é›‘ã§ã€å¯¾å‡¦ã™ã‚‹ã“ã¨ãŒé›£ã—ã„ã‚‚ã®ã‚‚å˜åœ¨ã—ã¾ã™ã€‚ã—ã‹ã—ã€RDBã®ä¸ã§ä¸€ä½“ã©ã†ã„ã†ã“ã¨ãŒèµ·ãã¦ã„ã‚‹ã®ã‹ã‚’çŸ¥ã‚Šã€ãã‚Œã«åŸºã„ã¦å¯¾å‡¦ã™ã‚Œã°é«˜é€ŸåŒ–ã§ãã‚‹ã“ã¨ã‚‚å°‘ãªããªã„ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ æœ¬ç¨¿ã§ã¯ã€JOINã®å†…éƒ¨å‹•ä½œã‚’è§£èª¬ã—ãŸä¸Šã§ã€Webã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½œã£ã¦ã„ã‚‹ã¨ã‚ˆãå‡ºã¦ãã‚‹JOIN SQLã‚’ä¾‹é¡Œã«
cu39 2015/07/13
coding

admin

rdb

mysql

web
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.4 Reference Manual :: 14.7 Date and Time Functions
Functions That Test Spatial Relations Between Geometry Objects
cu39 2015/01/23
rdb

mysql

time

timezone
ãƒªãƒ³ã‚¯
CONVERT_TZ() ãŒæ£ã—ã„çµæžœã‚’è¿”ã•ãªã„ã¨ãã®å¯¾å‡¦æ³• - Craftworks Tech Blog - Branch
4.10.8. MySQL ã‚µãƒ¼ãƒã®ã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ ã‚µãƒãƒ¼ãƒˆã«ã‚ã‚‹ä¾‹ã®ã‚¯ã‚¨ãƒªã‚’æŠ•ã’ãŸã¨ã“ã‚ã€CONVERT_TZ() ã®çµæžœãŒ NULL ã«ãªã£ã¦ã—ã¾ã£ã¦ã„ã¾ã—ãŸã€‚ > SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); +-----------------------------------------------+ | CONVERT_TZ('2004-01-01 12:00:00','GMT','MET') | +-----------------------------------------------+ | NULL | +-----------------------------------------------+ 1 row in set (0.00 sec) èª¿ã¹ã¦ã¿ãŸã‚‰ 4.5.5. mysql_tzinfo_t
cu39 2015/01/23
rdb

mysql

time

timezone
ãƒªãƒ³ã‚¯
Converting Timezone-Specific Times in MySQL | Mozilla IT
cu39 2015/01/23
rdb

mysql

time

timezone
ãƒªãƒ³ã‚¯
MySQLã®æ—¥ä»˜åž‹ã®æ‰±ã„æ–¹ã‚„æ©Ÿèƒ½ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸ
å°æ•°éƒ¨ã®é ˜åŸŸã€ã¨ã‚ã‚Šã¾ã™ãŒã€ã“ã‚Œã¯0ï½ž3 bytesã§ã™ã€‚å°æ•°éƒ¨ãŒ1, 2æ¡ãªã‚‰1 byteã€3, 4æ¡ãªã‚‰2 bytesã€5, 6æ¡ãªã‚‰3bytesã§ã™ã€‚ TIMESTAMPåž‹ã®å€¤ã®ç¯„å›² TIMESTAMPã¯ã„ã‚ã‚†ã‚‹UNIXæ™‚é–“ã€time_tã§ã€1970å¹´ã‹ã‚‰å§‹ã¾ã‚‹æ—¥ä»˜ã§ã‚ã‚Šã€4byteã§ã™ã€‚ãã®ãŸã‚ã€2038å¹´ã¾ã§ã—ã‹æ ¼ç´ã§ãã¾ã›ã‚“ã€‚MySQLã ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€2038å¹´å•é¡Œã¨ã„ã†ã‚‚ã®ã§ã™ã€‚åˆ©ç”¨ã™ã‚‹æ™‚ã¯æ°—ã‚’ä»˜ã‘ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ TIMESTAMPåž‹ã®ãƒ‡ãƒ¼ã‚¿ä¿æŒå½¢å¼(UTC) ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«TIMESTAMPã¯å†…éƒ¨ã§UTCã§æŒã¤ã¨æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ã“ã‚ŒãŒã©ã†ã„ã†ã“ã¨ãªã®ã‹ç¢ºã‹ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãšã¯ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ã¦ã¿ã¾ã™ã€‚ create table TIMESTAMP_SAMPLE(DT datetime, TS timestamp); insert into TIMESTAMP_
cu39 2015/01/23
coding

rdb

mysql

time
ãƒªãƒ³ã‚¯
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
cu39 2014/04/28
admin

mysql
ãƒªãƒ³ã‚¯
DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦éžå¸¸ã«é‡è¦ã¨ãªã‚‹ãƒ¡ãƒ¢ãƒª(ãƒãƒƒãƒ•ã‚¡)é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ DSASã®ã¨ã‚ã‚‹DBã‚µãƒ¼ãƒ(å®Ÿãƒ¡ãƒ¢ãƒª4GB)ã®å®Ÿéš›ã®è¨å®šå€¤ ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãŸã€å¿…è¦ãƒ¡ãƒ¢ãƒªã®ç·é‡ã®è¨ˆç®—ã‚„é™ç•Œå€¤ã‚’è¶Šãˆã¦ãªã„ã‹ãƒã‚§ãƒƒã‚¯ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚‚ç´¹ä»‹ã—ã¾ã™ã€‚ æ˜¯éžã€å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ï¼ ã¾ãšæœ€åˆã«æ³¨æ„ç‚¹ã‚’ã€‚ ãƒãƒƒãƒ•ã‚¡ã«ã¯2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¯mysqldå…¨ä½“ã§ãã®ãƒãƒƒãƒ•ã‚¡ãŒ1ã¤ã ã‘ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã€ ã“ã‚Œã«å¯¾ã—ã€ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã¯ã‚¹ãƒ¬ãƒƒãƒ‰(ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³)ã”ã¨ã«ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®éš›ã«ã¯ã‚°ãƒãƒ¼ãƒãƒ«/ã‚¹ãƒ¬ãƒƒãƒ‰ã®é•ã„ã‚’æ„è˜ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ ãªãœãªã‚‰ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã«å¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¢—ãˆãŸã¨ãŸã‚“ã«ã‚¢ãƒƒã¨ã„ã†é–“ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã£ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ in
cu39 2014/04/28
admin

mysql

configuration
ãƒªãƒ³ã‚¯
MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚‰ã€å¿…ãšç¢ºèªã™ã¹ã10ã®è¨å®š | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«å¿…ãšè¨å®šã‚’ç¢ºèªã—ãªã‘ã‚Œã°ãªã‚‰ãªã„è¨å®šãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿10ã¤ã‚’æŒ™ã’ã€ãã®æ„å‘³ã‚’è§£èª¬ã™ã‚‹ã€‚MySQLã®è¨å®šå¤‰æ›´æ™‚ã®ã€ä¸€èˆ¬çš„ãªæ³¨æ„ç‚¹ã‚‚åˆã‚ã›ã¦ã€‚ January 28, 2014 By Stephane Combaudon æˆ‘ã€…ãŒãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£æŸ»ã®ä»•äº‹ã‚’ã™ã‚‹æ™‚ã«ã¯ã€MySQLã®è¨å®šã®ãƒ¬ãƒ“ãƒ¥ãƒ¼ã¨æ”¹å–„ææ¡ˆã‚’æ±‚ã‚ã‚‰ã‚Œã‚‹ã€‚å¤§æŠµã®å ´åˆã€ãŸãã•ã‚“ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ä¸ã§ã»ã‚“ã®ã„ãã¤ã‹ã®è¨å®šã—ã‹å¤‰æ›´ã™ã‚‹ã‚ˆã†ã«ææ¡ˆã—ãªã„ã“ã¨ã«ã€å¤šãã®é¡§å®¢ã¯é©šãã€‚ã“ã®è¨˜äº‹ã®ã‚´ãƒ¼ãƒ«ã¯ã€ã‚‚ã£ã¨ã‚‚é‡è¦ãªè¨å®šã‚’ã„ãã¤ã‹æŒ™ã’ã¦ã¿ã‚‹ã“ã¨ã«ã‚ã‚‹ã€‚ æ—¢ã«ã“ã†ã„ã£ãŸææ¡ˆã¯éŽåŽ»ã«ã‚‚ã—ã¦ã„ã‚‹ãŒæ•°å¹´å‰ã®ã‚‚ã®ã§ã€ãã‚Œä»¥æ¥MySQLã®ä¸–ç•Œã§ã¯ãŸãã•ã‚“ã®å¤‰åŒ–ãŒã‚ã£ãŸã®ã ã€‚ è©±ã®å‰ã« ç†Ÿç·´ã—ãŸäººã§ã‚‚ã€é‡å¤§ãªãƒˆãƒ©ãƒ–ãƒ«ã‚’å¼•ãèµ·ã“ã™ãƒŸã‚¹ã‚’ã—ã§ã‹ã™ã“ã¨ãŒã‚ã‚‹ã€‚å¾“ã£ã¦ã€ã“ã“ã«æŒ™ã’ãŸã‚‚ã®ã‚’ç›²ç›®çš„ã«é©ç”¨ã™ã‚‹å‰ã«ã€
cu39 2014/02/03
admin

rdb

mysql

config

learn
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¯ãƒ«ã¯ã¿ã‚“ãªãŒæ€ã£ã¦ã„ã‚‹ã»ã©æ‚ªè€…ã§ã¯ãªã„ | readwrite.jp
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«æ˜Žã‚‹ããªã„äººã€…ã«ã¨ã£ã¦ã¯ã€ã‚ªãƒ©ã‚¯ãƒ«ã®MySQLé‹ç”¨ã«ã¾ã¤ã‚ã‚‹é¨’å‹•ã¯ã‚ã¾ã‚Šãƒ”ãƒ³ã¨æ¥ãªã„ã‹ã‚‚ã—ã‚Œãªã„ã€‚ã‚ªãƒ©ã‚¯ãƒ«ãŒ2010å¹´ã«ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã‚’è²·åŽã—ãŸéš›ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®æŠ€è¡“è€…ãŸã¡ï¼ˆç§ã‚‚ãã®ä¸€äººã ï¼‰ã¯ã€ã‚ªãƒ©ã‚¯ãƒ«ãŒMySQLã‚’å°ç„¡ã—ã«ã™ã‚‹ã®ã§ã¯ãªã„ã‹ã¨å±æƒ§ã—ãŸã€‚ã‚ªãƒ©ã‚¯ãƒ«ãŒé–‹ç™ºã¸ã®æŠ•è³‡ã‚’ç¸®å°ã—ãŸã‚Šã€æŠ€è¡“ã‚’ã‚¯ãƒãƒ¼ã‚ºãƒ‰åŒ–ã™ã‚‹ã‚ˆã†ãªäº‹æ…‹ã‚’æƒ³å®šã—ãŸã®ã§ã‚ã‚‹ã€‚ã—ã‹ã—ãã‚“ãªã“ã¨ã¯èµ·ã“ã‚‰ãªã‹ã£ãŸã€‚å®Ÿéš›ã«ã¯ã‚ªãƒ©ã‚¯ãƒ«ã®ç®¡ç†ã®ä¸‹ã€MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯åŠ‡çš„ã«æ”¹å–„ã•ã‚Œã€ã‚³ãƒ¼ãƒ‰ã®å¤§éƒ¨åˆ†ã‚‚ã‚ªãƒ¼ãƒ—ãƒ³ã®ã¾ã¾æ®‹ã•ã‚Œã¦ã„ã‚‹ã€‚ ãã‚Œã§ã‚‚ãªãŠã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã«ã¯æœªã ã«ã‚ªãƒ©ã‚¯ãƒ«ã®MySQLé‹ç”¨ã‚’ãƒãƒƒã‚·ãƒ³ã‚°ã™ã‚‹äººãŸã¡ãŒã„ã‚‹ã€‚ã¡ã‚‡ã£ã¨ã‚ªãƒ©ã‚¯ãƒ«ãŒæ°—ã®æ¯’ã«ãªã‚‹ã»ã©ã ã€‚ å´©å£Šã®å±æ©Ÿã«ã•ã‚‰ã•ã‚ŒãŸMySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ç¢ºã‹ã«ã‚ªãƒ©ã‚¯ãƒ«ã¯ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã«å¯¾ã—ã¦ã‚ã¾ã‚Šå‹å¥½çš„ã§ã¯ãªã‹ã£ãŸã€‚ãã—ã¦ã€åŒç¤¾ã«ä½•åå„„ãƒ‰ãƒ«ã‚‚
cu39 2013/12/31
oracle

mysql

rdb

software

floss
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã‚ãªã„MySQLã®å†—é•·åŒ–
ãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10æœˆ1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ãƒ–ãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚LINEãƒ¤ãƒ•ãƒ¼ Tech Blog ã“ã‚“ã«ã¡ã¯ã€DBMSãƒãƒ¼ãƒ ã®ä¸‰è°·ã§ã™ã€‚ ãƒ¤ãƒ•ãƒ¼ã§ã¯å¤šãã®ã‚µãƒ¼ãƒ“ã‚¹ã§MySQLã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚MySQLã¯ãƒ¤ãƒ•ãƒ¼ã‚’æ”¯ãˆã‚‹é‡è¦ãªæŠ€è¡“ã®1ã¤ã§ã™ã€‚ ç§ã®ãƒãƒ¼ãƒ ã§ã¯ãƒ¤ãƒ•ãƒ¼ã®ã•ã¾ã–ã¾ãªã‚µãƒ¼ãƒ“ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é›†ç´„ã—ã¦ç®¡ç†ãƒ»é‹ç”¨ã—ã¦ã„ã¾ã™ã€‚ é›†ç´„ã™ã‚‹ã“ã¨ã§ã‚³ã‚¹ãƒˆã®å‰Šæ¸›ã‚„ãƒŽã‚¦ãƒã‚¦ã®è“„ç©ã¨ã„ã£ãŸåŠ¹æžœã‚’ç”Ÿã¿å‡ºã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ã“ã®é›†ç´„ç’°å¢ƒã®å†—é•·åŒ–æ–¹æ³•ã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ é›†ç´„ç’°å¢ƒã®æ§‹æˆ é›†ç´„ç’°å¢ƒã§ã¯ãƒžã‚¹ã‚¿ãƒ¼ã®å†—é•·åŒ–ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã›ãšã€ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘ã®å…±æœ‰ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’åˆ©ç”¨ã—ãŸã‚¢ã‚¯ãƒ†ã‚£ãƒ–ãƒ»ãƒ‘ãƒƒã‚·ãƒ–åž‹ã®HAæ§‹æˆã‚’æŽ¡ç”¨ã—ã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å…±æœ‰ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã«ç½®ãã€ã©ã®ãƒžã‚¹ã‚¿ãƒ¼ã‚µãƒ¼ãƒãƒ¼ã‹ã‚‰ã§ã‚‚åŒã˜ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã‚ˆã†ã«
cu39 2012/11/23
admin

rdb

mysql
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ - ä¹…ä¿æ¸…éš†ã®ãƒ–ãƒã‚°
ä»•äº‹ã§MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ã„ã¦ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ã¦ã„ãªã„ã“ã¨ãŒå¤šã‹ã£ãŸã®ã§èª¿ã¹ãŸã“ã¨ã‚’ãƒ¡ãƒ¢ã€‚åŸºæœ¬çš„ãªã¨ã“ã‚ã‹ã‚‰å¦ç¿’ã—ãªãŠã—ãŸã€‚ MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã€ã‚«ãƒ©ãƒ ãŒç‰¹å®šã®å€¤ã‚’ã‚‚ã¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã®è¿…é€Ÿãªæ¤œç´¢ã«ä½¿ç”¨ã•ã‚Œã‚‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã™ã‚Œã°ã€æ•°ç™¾ã¨ã‹æ•°å„„ã‚‚ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå…¥ã£ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ã€ä¸€çµ„ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿…é€Ÿã«è¦‹ã¤ã‘ã¦å–ã‚Šå‡ºã™ã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ã€‚ ã—ã‹ã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é€Ÿåº¦ã‚’æ”¹å–„ã™ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ãŒã€æŒ¿å…¥ã®é‚ªé”ã«ãªã£ã¦é…ããªã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é©åˆ‡ã«ä½¿ã†ãŸã‚ã«ã€ã¾ãšã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºæœ¬æ¦‚å¿µã‚’ãŠã•ãˆã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ¦‚å¿µ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä»•çµ„ã¿ã‚’ç†è§£ã™ã‚‹ã«ã¯ã€ã¾ãšMySQLãŒã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªã«å¿œç”ã™ã‚‹ã‹ã‚’çŸ¥ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ä¾‹ãˆã°ã€ SELECT * FROM phone_book WHERE last_name = 'Hoge'
cu39 2012/09/25
coding

mysql
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸