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

msh514 id:msh514

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

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

é‡ã„ALTER TABLEã®å®Ÿè¡Œä¸ã«é€²æ—çŠ¶æ³ã‚’ç¢ºèªã™ã‚‹æ–¹æ³• - CyberAgent SRG #ca_srg
#SRGï¼ˆService Reliability Groupï¼‰ã¯ã€ä¸»ã«å¼Šç¤¾ãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚¤ãƒ³ãƒ•ãƒ©å‘¨ã‚Šã‚’æ¨ªæ–çš„ã«ã‚µãƒãƒ¼ãƒˆã—ã¦ãŠã‚Šã€æ—¢å˜ã‚µãƒ¼ãƒ“ã‚¹ã®æ”¹å–„ã‚„æ–°è¦ç«‹ã¡ä¸Šã’ã€OSSè²¢çŒ®ãªã©ã‚’è¡Œã£ã¦ã„ã‚‹ã‚°ãƒ«ãƒ¼ãƒ—ã§ã™ã€‚
msh514 2024/09/01
mysql
ãƒªãƒ³ã‚¯
INDEXã‚’è²¼ã‚‰ãªã„ã¨è¡Œãƒãƒƒã‚¯ã«ãªã‚‰ãªã„ä»¶ - Qiita
ã‚¿ã‚¤ãƒˆãƒ«ã®ã¨ãŠã‚Šã§ã™ãŒã€InnoDB ã¯è¡Œãƒãƒƒã‚¯ã‚’ã‹ã‘ã‚‹äº‹ã§æœ‰åã§ã™ãŒã€è¡Œãƒãƒƒã‚¯ã‚’ã‹ã‘ã‚‹ã«ã¯å¿…ãš INDEX ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ ä»Šå›žã¯ãã®äº‹ã«ã¤ã„ã¦ç°¡å˜ã«ã¾ã¨ã‚ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ #è¡Œãƒãƒƒã‚¯ãŒã‹ã‹ã‚‰ãªã„ä¾‹ ã¾ãšã¯ã€è¡Œãƒãƒƒã‚¯ãŒã‹ã‹ã‚‰ãªã„ä¾‹ã‚’æ›¸ã„ã¦ã¿ã¾ã™ã€‚ ä¸‹è¨˜ã®ã‚ˆã†ãªå˜ç´”ãª test ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç”¨æ„ã—ã¾ã™ã€‚ +----+--------+ | id | number | +----+--------+ | 1 | 1 | | 2 | 2 | | 3 | 3 | | 4 | 4 | | 5 | 5 | | 6 | 6 | | 7 | 7 | | 8 | 8 | | 9 | 9 | | 10 | 10 | +----+--------+
msh514 2024/04/03
mysql

index

lock
ãƒªãƒ³ã‚¯
Qiita
Qiita is a knowledge sharing service for engineers. You can follow users and tagsYou can stock useful informationYou can make edit suggestions for articlesFunctions that can be used after logging in
msh514 2020/02/18
python

Linux

mysql
ãƒªãƒ³ã‚¯
MyBatisã§auto_incrementã•ã‚ŒãŸPRIMAY KEYã®idã‚’å–å¾—ã™ã‚‹æ–¹æ³• - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
msh514 2019/12/10
springboot

mybatis

lastio

mysql
ãƒªãƒ³ã‚¯
mysqlã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—(mysqldump)ã®ãƒãƒƒã‚¯å•é¡Œ - SEEDS Creator's Blog
ã“ã‚“ã«ã¡ã¯ã€ã¯ã‚‰ãã¡ã§ã™ã€‚ ä»Šå›žãŠè©±ã—ãŸã„ã®ã¯ã€mysqlã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³•ã«ã¤ã„ã¦ã®ã‚ã‚Œã“ã‚Œã§ã™ã€‚ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— mysqldump mysqlã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ã„ãˆã°mysqldumpã§ã™ã€‚ ä»¥ä¸‹ã®ã‚ˆã†ãªå½¢ã§ä½¿ã„ã¾ã™ã€‚ mysqldump -u root -p -x -A > my_dumpall.db ã“ã‚Œã§å…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ€ãƒ³ãƒ—ãŒã§ãã¾ã™ã€‚ ç‰¹å®šã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒ€ãƒ³ãƒ—ã—ãŸã„å ´åˆã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚’æŒ‡å®šã—ã¾ã™ã€‚ mysqldump -u root -p -x ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å > dump.sql å®šæœŸçš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚ŠãŸã„å ´åˆã¯ã€ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã‚’ cronã§å®Ÿè¡Œã—ã¦ã‚ã’ã‚‹ã¨ã„ã„ã§ã—ã‚‡ã†ã€‚ äºŒæ—¥é–“ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ä¿æŒã™ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆä¾‹ã§ã™ã€‚ #!/bin/bash MPASS=ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ mysqldump --defaults-extra-file=<
msh514 2019/11/21
mysql

mysqldump

singletransaction

lock
ãƒªãƒ³ã‚¯
MySQLãƒ¯ãƒ¼ã‚¯ãƒ™ãƒ³ãƒã§updateæ–‡ã‚’å®Ÿè¡Œã™ã‚‹ã¨1175ã®ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿ - é›‘è¨˜å¸³
äº‹è±¡ MySQLã®ãƒ¯ãƒ¼ã‚¯ãƒ™ãƒ³ãƒã§UPDATEæ–‡ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã€ä»¥ä¸‹ã®ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ãŸã€‚ Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 0.062 sec åŽŸå› å¤§é‡ã®(ä¸»ã‚ãƒ¼ä»¥å¤–ã®)update/deleteã‚’èª¤ã£ã¦è¡Œãˆãªã„æ§˜ã«åˆ¶é™ã—ã¦ãã‚Œã¦ã„ã‚‹ãŸã‚ã€‚ å¯¾å¿œæ–¹æ³•(ä¸€æ™‚çš„) SET SQL_SAFE_UPDATES = 0; å‚è€ƒã‚µã‚¤ãƒˆ http://rikutoto.blogspot.jp/2013/11/mysql error-code
msh514 2019/11/15
mysql

SQL

MysqlWorkBench
ãƒªãƒ³ã‚¯
é›‘ãªMySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
26. EXPLAIN mysql> EXPLAIN SELECT * FROM table_1 a JOIN `table_2` s ON a.user_id=s.`user_id` AND s.site_i d=120 WHERE app_id=8250G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: a type: ref possible_keys: PRIMARY,ix_table_1,ix2_table_2,ix3_table_1,idx_table_1_06,idx_table_1_07,idx_t able_1_09 key: idx_table_1_06 key_len: 4 ref: const rows: 13496 Ext
msh514 2019/09/10
mysql

performance
ãƒªãƒ³ã‚¯
ã‚µã‚¤ãƒœã‚¦ã‚ºç‰ˆ MySQL ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ãã®çµæžœ - Cybozu Inside Out | ã‚µã‚¤ãƒœã‚¦ã‚ºã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³åŸºç›¤ãƒãƒ¼ãƒ ã®é’æœ¨(@a_o_k_i_n_g)ã§ã™ã€‚å…ˆæ—¥è¦ªçŸ¥ã‚‰ãšã‚’æŠœæ¯ã—ãŸæ™‚ã€ã¤ã‚‰ã™ãŽãŸã®ã§ MySQL ã® JOIN ã®ã“ã¨ã‚’è€ƒãˆã¦å¿ƒã®å¹³é™ã‚’ä¿ã£ã¦ã„ã¾ã—ãŸã€‚ ã‚µã‚¤ãƒœã‚¦ã‚ºã®è£½å“ã®ã²ã¨ã¤ã§ã‚ã‚‹ kintone ã¯ãƒ‹ãƒ¼ã‚ºã«å¿œã˜ã¦è‡ªç”±ã«æ¥å‹™ã‚¢ãƒ—ãƒªã®ã‚ˆã†ãªã‚‚ã®ã‚’æ‰‹è»½ã«ä½œã‚‹ã“ã¨ãŒã§ãã€ãƒ‡ãƒ¼ã‚¿ã®æ¤œç´¢æ¡ä»¶ã‚„ã‚½ãƒ¼ãƒˆæ¡ä»¶ã‚‚ç´°ã‹ãã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºå¯èƒ½ã§ã€æ§˜ã€…ãªãƒ¬ãƒ™ãƒ«ã§ã®ã‚¢ã‚¯ã‚»ã‚¹æ¨©ã‚‚è¨å®šå¯èƒ½ã¨ã„ã†éžå¸¸ã«ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ã—ã‹ã—ãã®æ©Ÿèƒ½ã‚’æ”¯ãˆã‚‹è£å´ã§ã¯è¤‡é›‘ãªã‚¯ã‚¨ãƒªãŒç™ºè¡Œã•ã‚Œã€MySQL ã«å¤šå¤§ãªè² è·ã‚’ã‹ã‘ã¦ã„ã¾ã™ã€‚ã‚µã‚¤ãƒœã‚¦ã‚ºã®ã‚¯ãƒ©ã‚¦ãƒ‰ã«ã¯æ•°åãƒ†ãƒ©ãƒã‚¤ãƒˆã«ç™»ã‚‹ MySQL ãƒ‡ãƒ¼ã‚¿ãŒã‚ã‚Šã€æ•°åƒä¸‡ä»¶ã‚ªãƒ¼ãƒ€ãƒ¼ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¤‡æ•° JOIN ã™ã‚‹ã‚¯ã‚¨ãƒªãŒæ¯Žç§’ã®ã‚ˆã†ã«å®Ÿè¡Œã•ã‚Œã‚‹ã¨ã„ã†ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢é‚ãŒæ»¾ã‚‹ç’°å¢ƒã§ã™ã€‚ ç¾åœ¨ã‚µã‚¤ãƒœã‚¦ã‚ºã§ã¯æ€§èƒ½æ”¹å–„ã«åŠ›ã‚’å…¥ã‚Œã¦ãŠã‚Šã€åƒ•ã‚‚ãã®æ¥å‹™ã«å¾“äº‹ã—ã¦ã„ã¾ã™ã€‚ä¾‹ãˆã°2018å¹´
msh514 2019/09/10
mysql

performance
ãƒªãƒ³ã‚¯
åŸºç¤ŽMySQL ~ãã®ï¼’~ my.cnf (è¨å®šãƒ•ã‚¡ã‚¤ãƒ«) - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
msh514 2019/09/10
mysql

conf
ãƒªãƒ³ã‚¯
MySQLãƒªãƒ¢ãƒ¼ãƒˆDBã®çµæžœã‚’ãƒãƒ¼ã‚«ãƒ«CSVãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã™ã‚‹æ–¹æ³• | é–‹ç™ºãƒ¡ãƒ¢ã‚‹ã‚¢ãƒ«
MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’CSVãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã—ãŸã„å ´åˆã€ SELECT â€¦ INTO OUTFILE æ§‹æ–‡ã‚’ä½¿ã†ã®ãŒã‚ˆãã‚ã‚‹ãƒ‘ã‚¿ãƒ¼ãƒ³ãªã®ã§ã™ãŒã€ DBã‚µãƒ¼ãƒãƒ¼ãŒãƒªãƒ¢ãƒ¼ãƒˆãƒ›ã‚¹ãƒˆä¸Šã«ã‚ã‚‹å ´åˆã¯ã“ã®æ–¹æ³•ãŒä½¿ãˆã¾ã›ã‚“ã€‚ CSVãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ ã“ã®ã‚³ãƒžãƒ³ãƒ‰ã§ã€ãƒªãƒ¢ãƒ¼ãƒˆDBã®çµæžœã‚’ãƒãƒ¼ã‚«ãƒ«CSVãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã§ãã¾ã™ã€‚ æ§‹æ–‡ mysql -u [ãƒ¦ãƒ¼ã‚¶ãƒ¼å] -p -h [DBã‚µãƒ¼ãƒãƒ¼ãƒ›ã‚¹ãƒˆå] [DBå] -e "`cat [å®Ÿè¡ŒSQLãƒ•ã‚¡ã‚¤ãƒ«å]`" | sed -e 's/\t/,/g' > [å‡ºåŠ›CSVãƒ•ã‚¡ã‚¤ãƒ«ãƒ‘ã‚¹] å®Ÿè¡Œä¾‹ $ mysql -u test -p -h dbhost testdb -e "`cat outcsv.sql`" | sed -e 's/\t/,/g' > /tmp/test.csv ã„ã‚ã„ã‚èª¿ã¹ãŸçµæžœãŸã©ã‚Šç€ã„ãŸã®ãŒä»¥ä¸Šã®æ–¹æ³•ã§ã™ã€‚ ç†ç”±ã¨ã‹æ°—ã«ãªã‚‰ãªã„äººã¯
msh514 2019/09/06
mysql

csv

DB

é–‹ç™º

SQL

export

remote
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° -my.cnfã®è¦‹ç›´ã—- - Qiita
â€»RDSã¯ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ è² è·ã‚’è¦‹ã¦ã¿ã‚‹ DBã‚µãƒ¼ãƒãƒ¼ã®è² è·çŠ¶æ³ã‚’è¦‹ã¦ã¿ã¾ã™ã€‚ å½“æ™‚ã®ç›£è¦–ãƒ„ãƒ¼ãƒ«ã®ç”»åƒãŒãªã„ã®ã§ã™ãŒã€ä»¥ä¸‹ã®çŠ¶æ³ã§ã—ãŸã€‚ LA(Load Average)ãŒçªãæŠœã‘ã¦ã„ã‚‹ ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ•°ã¯ã€Œå¸¸è˜çš„ã«è€ƒãˆã¦ã€ãã‚Œã»ã©ã§ã‚‚ãªã„ ãƒ¡ãƒ¢ãƒªã®ä½¿ç”¨é‡ã«ã‚ã¾ã‚Šå¤‰åŒ–ãŒãªã„ swapã¯ã—ã¦ã„ãªã„ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸å®¹é‡ã‚’çµæ§‹é£Ÿã£ã¦ã„ã‚‹ WEBã‚µãƒ¼ãƒãƒ¼ã‹ã‚‰è¦‹ã‚Œã°ã€å‡¦ç†å¾…ã¡ã®ã¾ã¾ãƒ—ãƒã‚»ã‚¹ãŒå‡¦ç†ã•ã‚Œã¦ã„ãªã„å…¸åž‹çš„ãªãƒ‘ã‚¿ãƒ¼ãƒ³ã ã£ãŸã¨æ€ã„ã¾ã™ã€‚ DBã‚µãƒ¼ãƒãƒ¼ã¨ã—ã¦ã¯ã€LAã«å¯¾ã—ã€ãƒ¡ãƒ¢ãƒªã®ä½¿ç”¨é‡ãŒã‚ã£ã¦ã„ãªã„ã‚ˆã†ã«æ€ã‚ã‚Œã¾ã—ãŸã€‚ ä»®èª¬ ä¸Šè¨˜ã®çŠ¶æ…‹ã‹ã‚‰ã€ä»®èª¬ã‚’ç«‹ã¦ã¾ã™ã€‚ ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒª ãŒé »ç™ºã—ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã‹ ãƒ¡ãƒ¢ãƒª ãŒæ£ã—ãå‰²ã‚Šå½“ã¦ã‚‰ã‚Œã¦ã„ãªã„ã®ã§ã¯ãªã„ã‹ å„ç¨®ãƒã‚° ã®è¨å®šãŒé©åˆ‡ã§ã¯ãªã„ã®ã§ã¯ãªã„ã‹ ä»®èª¬ã‚’æ¤œè¨¼ã™ã‚‹ã“ã¨ã§ã€å¯¾ç–ã‚’ã—ã¦ã„ãã¾ã™ã€‚ è¨å®šã‚’è¦‹ç›´ã™ ä¸Šè¨˜ã®ä»®èª¬ã®è¨å®šã¯ã€MySQLã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã§ã‚ã‚‹ã€Œ
msh514 2019/08/30
mysql

performance

é–‹ç™ºç’°å¢ƒ

mysqld
ãƒªãƒ³ã‚¯
é–‹ç™ºç’°å¢ƒç”¨æœ€ä½Žé™ã®MySQL / MariaDBè¨å®š
å„ã€…ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒé–‹ç™ºã«ä½¿ç”¨ã™ã‚‹Dockerã‚„Vagrantç‰å†…ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã£ã¦ã€ã‚ã¾ã‚Šãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚Œã¦ã„ãªã‹ã£ãŸã‚Šã—ã¾ã™ã‚ˆãã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚Œã¦ã„ã‚‹ã‚µãƒ¼ãƒãƒ¼ã¯ã€ã‚«ãƒ¼ãƒãƒ«ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿å«ã‚å¤šãã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãŒèª¿æ•´ã•ã‚Œã¦ã„ã‚‹ã®ã§ä½•ãŒä¸»è¦ãªãƒã‚¤ãƒ³ãƒˆã‹åˆ†ã‹ã‚‰ãªã„ã€‚ è€éšœå®³æ€§ã‚’æ¨ã¦ã¦ã§ã‚‚é–‹ç™ºç’°å¢ƒã¯é€Ÿãã€‚ ãã‚“ãªæ–¹ã®ãŸã‚ã®é–‹ç™ºç’°å¢ƒç”¨ç°¡æ˜“ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è¨˜äº‹ã§ã™ã€‚ MariaDBã¯10.1(10.xç³»)ã‚’æƒ³å®šã—ã¦ã„ã¾ã™ã€‚ â€»ã¡ãªã¿ã«ç†è€…ã¯ä¾¡æ ¼ã®äº‹ã‚’æ£šã«ä¸Šã’ã‚Œã°SQLServer(MSSQL)ã‚„ PostgreSQLã‚‚9.4ä»¥é™(ç‰¹ã«9.5)ãªã‚‰å¥½ãã§ã™ã—ã€MariaDBã¯Galera ClusterãŒã‚ã‚‹ã‹ã‚‰å¥½ãã§ã™ã€‚ ä»•äº‹ã§ã¯AWSã‚’æ‰±ã†æ©Ÿä¼šãŒéžå¸¸ã«å¤šã„ã®ã§Amazon Auroraã¯å¤–ã›ã¾ã›ã‚“ã€‚ è¨å®šä¾‹ãƒ¡ãƒ¢ãƒª1Gã»ã©ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å‰²ã‚Šå½“ã¦ã‚‹ä¾‹ã§ã™ã€‚ [mysqld] skip-name-resolve
msh514 2019/08/30
mysql

performance

é–‹ç™ºç’°å¢ƒ

mysqld
ãƒªãƒ³ã‚¯
é«˜é€Ÿå‡¦ç†åŒ–ï¼MySQLã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°æ©Ÿèƒ½ã‚’ä½¿ã£ã¦ã¿ã‚ˆã† | æ ªå¼ä¼šç¤¾LIG(ãƒªã‚°)ï½œDXæ”¯æ´ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãƒ»Webåˆ¶ä½œ
ã¿ãªã•ã‚“ã€æœ€è¿‘äººç”Ÿã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã—ã¦ã¾ã™ã‹ï¼Ÿ ã“ã‚“ã«ã¡ã¯ã€å‹åˆ©ã§ã™ã€‚ ä»Šå›žã¯MySQLã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ç´¹ä»‹ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ MySQLã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã¯ï¼Ÿ MySQL5.1ãã‚‰ã„ã‹ã‚‰ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã€1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ†å‰²ã™ã‚‹æ©Ÿèƒ½ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ†å‰²ã™ã‚‹ã®ã§ã€æ ¼ç´ã§ãã‚‹æ ¹æœ¬çš„ãªå®¹é‡ã®æ‹¡å¼µã‚„ã€ã‚„ã‚Šæ–¹(Plunning)ã«ã‚ˆã£ã¦ã¯é«˜é€Ÿå‡¦ç†ã‚’å®Ÿç¾ã§ãã¾ã™ã€‚ åˆ†å‰²ã—ãŸéš›ã®ãƒ‡ãƒ¼ã‚¿æŒ¯ã‚Šåˆ†ã‘æ–¹æ³•ã¨ã—ã¦ã¯å¤§ä½“ä»¥ä¸‹ã®ã‚ˆã†ãªå½¢ãŒã‚ã‚Šã¾ã™ã€‚ RANGEã€€ãƒ»ãƒ»ãƒ»ã€€ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã”ã¨ã«ç¯„å›²ã‚’æŒ‡å®šã—ã¦æŒ¯ã‚Šåˆ†ã‘ã‚‹ LISTã€€ãƒ»ãƒ»ãƒ»ã€€ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã”ã¨ã«æ ¼ç´ã™ã‚‹å€¤ã§æŒ¯ã‚Šåˆ†ã‘ã‚‹ HASHã€€ãƒ»ãƒ»ãƒ»ã€€1ã¤ã®ã‚«ãƒ©ãƒ ã®å€¤ã‚’å¼ã®çµæžœã§æŒ¯ã‚Šåˆ†ã‘ã‚‹ KEYã€€ãƒ»ãƒ»ãƒ»ã€€ï¼‘ã¤ä»¥ä¸Šã®ã‚«ãƒ©ãƒ ã®å€¤ã‚’MD5é–¢æ•°ç‰ã§è©•ä¾¡ã—ã¦åˆ†å‰²ã™ã‚‹ ä½¿ç”¨ã™ã‚‹ãƒ¡ãƒªãƒƒãƒˆã¨ã—ã¦ã¯ä¸‹è¨˜2ç‚¹ã®ã‚ˆã†ãªã“ã¨ãŒè€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ ãƒ¡ãƒªãƒƒãƒˆï¼‘ã€€[é«˜é€ŸåŒ–ãŒè¦‹è¾¼ã‚ã‚‹]
msh514 2019/08/08
mysql

pertiton

ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
MySQL ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚ - Qiita
å‚è€ƒURL ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã¯ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®ç¨®é¡ž RANGE ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° ã“ã®ã‚¿ã‚¤ãƒ—ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¯ã€æŒ‡å®šã•ã‚ŒãŸç¯„å›²ã«å«ã¾ã‚Œã‚‹ã‚«ãƒ©ãƒ å€¤ã«åŸºã¥ã„ã¦ã€è¡Œã‚’ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã«å‰²ã‚Šå½“ã¦ã¾ã™ã€‚ LIST ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° RANGE ã«ã‚ˆã‚‹ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã«ä¼¼ã¦ã„ã¾ã™ãŒã€åˆ¥å€‹ã®å€¤ã®ã‚»ãƒƒãƒˆã®ã„ãšã‚Œã‹ã«ä¸€è‡´ã™ã‚‹ã‚«ãƒ©ãƒ ã«åŸºã¥ã„ã¦ã€ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ãŒé¸æŠžã•ã‚Œã¾ã™ã€‚ HASH ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° ã“ã®ã‚¿ã‚¤ãƒ—ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã§ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«æŒ¿å…¥ã•ã‚Œã‚‹è¡Œå†…ã®ã‚«ãƒ©ãƒ å€¤ã‚’æ“ä½œã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©å¼ã«ã‚ˆã£ã¦è¿”ã•ã‚Œã‚‹å€¤ã«åŸºã¥ã„ã¦ã€ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ãŒé¸æŠžã•ã‚Œã¾ã™ã€‚é–¢æ•°ã¯ã€è² ã§ã¯ãªã„æ•´æ•°å€¤ã‚’è¿”ã™ MySQL ã®æœ‰åŠ¹ãªå¼ã§æ§‹æˆã§ãã¾ã™ã€‚ã“ã®ã‚¿ã‚¤ãƒ—ã‚’æ‹¡å¼µã—ãŸ LINEAR HASH ã‚‚ä½¿ç”¨ã§ãã¾ã™ã€‚ KEY ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° ã“ã®ã‚¿ã‚¤ãƒ—ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¯ã€HASH ã«ã‚ˆã‚‹ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã«ä¼¼ã¦ã„ã¾
msh514 2019/08/08
mysql

ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³

Partition
ãƒªãƒ³ã‚¯
Oracleã‹ã‚‰MySQLã¸ç§»è¡Œã™ã‚‹ãŸã‚ã®æŠ€è¡“çš„ãªè¦ç´ ã¨å…·ä½“çš„ãªæ–¹æ³•ã‚’ã¾ã¨ã‚ãŸç„¡æ–™ã®é›»åæ›¸ç±ï¼šäººæ°—é€£è¼‰ã¾ã¨ã‚èªã¿ï¼ ï¼ IT eBookï¼ˆ42ï¼‰ - ï¼ IT
2016å¹´1æœˆã€Oracle Databaseã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ä½“ç³»ãŒå¤‰æ›´ã•ã‚Œã€æœ€ã‚‚å®‰ä¾¡ã ã£ãŸä¸å°è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®ã€ŒOracle Database Standard Edition Oneï¼ˆä»¥ä¸‹ã€SE1ï¼‰ã€ãŒå»ƒæ¢ã€‚å¾“æ¥ã®ã€ŒOracle Database Standard Editionï¼ˆä»¥ä¸‹ã€SEï¼‰ã€ã®å†…å®¹ã‚’å¤‰æ›´ã—ãŸæ–°ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§ã‚ã‚‹ã€ŒOracle Database Standard Edition 2ï¼ˆSE2ï¼‰ã€ã«ä¸€æœ¬åŒ–ã•ã‚Œã¾ã—ãŸã€‚ ä¾‹ãˆã°ã€ç´„70ä¸‡å††ã ã£ãŸSE1ã®æœ€ä½Žä¾¡æ ¼ã¯ã€SE2ã§ã¯210ä¸‡å††ã‹ã‚‰ã¨é«˜é¡ã«ãªã‚Šã¾ã™ï¼ˆ2016å¹´11æœˆç¾åœ¨ã€ä»¥ä¸‹åŒï¼‰ã€‚ã¾ãŸã€SEã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã—ã¦ã‚‚ã€ç‰©ç†ã‚µãƒ¼ãƒå˜ä½ã®æœ€å¤§æè¼‰CPUã‚½ã‚±ãƒƒãƒˆæ•°ãŒã€SEã®4ã‚½ã‚±ãƒƒãƒˆã‹ã‚‰ã€SE2ã§ã¯2ã‚½ã‚±ãƒƒãƒˆã«æ¸›ã‚‹ã“ã¨ã‹ã‚‰ã€ã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒã«ã‚ˆã£ã¦ã¯ã€ã‚ˆã‚Šä¸Šä½ã§570ä¸‡å††ã‹ã‚‰ã¨ãªã‚‹ã€ŒOracle Database Enterprise Ed
msh514 2018/07/25
oracle

mysql

ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ
ãƒªãƒ³ã‚¯
(pdf) MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ¦‚è¦ - Oracle
<Insert Picture Here> MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ¦‚è¦ æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ« MySQL Global Business Unit CopyrightÂ© 2011, Oracle. All rights reserved. ä»¥ä¸‹ã®äº‹é …ã¯ã€å¼Šç¤¾ã®ä¸€èˆ¬çš„ãªè£½å“ã®æ–¹å‘æ€§ã«é–¢ã™ã‚‹æ¦‚è¦ã‚’èª¬æ˜Žã™ã‚‹ã‚‚ã®ã§ã™ã€‚ ã¾ãŸã€æƒ…å ±æä¾›ã‚’å”¯ä¸€ã®ç›®çš„ã¨ã™ã‚‹ã‚‚ã®ã§ã‚ã‚Šã€ã„ã‹ãªã‚‹å¥‘ç´„ã«ã‚‚çµ„ã¿è¾¼ã‚€ã“ã¨ã¯ ã§ãã¾ã›ã‚“ã€‚ä»¥ä¸‹ã®äº‹é …ã¯ã€ãƒžãƒ†ãƒªã‚¢ãƒ«ã‚„ã‚³ãƒ¼ãƒ‰ã€æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ã“ã¨ã‚’ã‚³ãƒŸãƒƒãƒˆãƒ¡ãƒ³ ãƒˆï¼ˆç¢ºç´„ï¼‰ã™ã‚‹ã‚‚ã®ã§ã¯ãªã„ãŸã‚ã€è³¼è²·æ±ºå®šã‚’è¡Œã†éš›ã®åˆ¤æ–ææ–™ã«ãªã•ã‚‰ãªã„ã§ä¸‹ã• ã„ã€‚ã‚ªãƒ©ã‚¯ãƒ«è£½å“ã«é–¢ã—ã¦è¨˜è¼‰ã•ã‚Œã¦ã„ã‚‹æ©Ÿèƒ½ã®é–‹ç™ºã€ãƒªãƒªãƒ¼ã‚¹ãŠã‚ˆã³æ™‚æœŸã«ã¤ã„ ã¦ã¯ã€å¼Šç¤¾ã®è£é‡ã«ã‚ˆã‚Šæ±ºå®šã•ã‚Œã¾ã™ã€‚ Oracleã¨Javaã¯ã€Oracle Corporation åŠã³ãã®åä¼šç¤¾ã€é–¢é€£ä¼šç¤¾ã®ç±³å›½åŠã³ãã®ä»–ã®å›½ã«ãŠã‘ã‚‹ç™»éŒ²å•†æ¨™ã§ã™ã€‚æ–‡
msh514 2014/09/24
mysql performance
ãƒªãƒ³ã‚¯
Sequel Pro
Full MySQL Support Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. Perfect Web Development Companion Whether you are a Mac Web Developer, Programmer or Software Developer your workflow will be streamlined with a native Mac OS X Application! Flexible Connectivity Sequel Pro gives you direct access to your MySQL Databases on local and remote se
msh514 2012/02/08
mac

database

WEB

MySQL
ãƒªãƒ³ã‚¯
ã•ã‚‰ã«MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹7ã¤ã®æ–¹æ³•
MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†è¨˜äº‹ãŒã¨ã¦ã‚‚å¥½è©•ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚è¨˜äº‹ã‚’èªã‚“ã§é ‚ã„ãŸçš†ã•ã‚“ã€ã‚ã‚ŠãŒã¨ã†ã€‚ ã“ã®è¨˜äº‹ã«å¯¾ã™ã‚‹ä¾¿ä¹—ï¼ˆï¼Ÿï¼‰ã§Webå±‹ã®ãƒã‚¿å¸³: PostgreSQLã‚’é«˜é€ŸåŒ–ã™ã‚‹16ã®ãƒã‚¤ãƒ³ãƒˆã¨ã„ã†è¨˜äº‹ã‚’æ›¸ã„ã¦é ‚ã„ãŸã‚ˆã†ã ãŒã€ãã¡ã‚‰ã®æ–¹ã‚‚ã‹ãªã‚Šäººæ°—ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚ä»–äººãŒä½œã£ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«æ”¹è‰¯ã‚’åŠ ãˆã‚‹ã¨ã„ã†ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ç²¾ç¥žã‚‚åŸºæœ¬ã¯ä¾¿ä¹—ã§ã‚ã‚‹ã®ã§ã€ä¾¿ä¹—ã«ã¤ã„ã¦ã¯å¤§ã„ã«è³›æˆã—ãŸã„ã¨ã„ã†ã‹ã‚€ã—ã‚å–ã‚Šä¸Šã’ã¦ãã‚Œã¦ã‚ã‚ŠãŒã¨ã†ï¼ï¼ã¨æ€ã†ã‚ã‘ã§ã‚ã‚‹ãŒã€ã“ã“ã§ã•ã‚‰ã«ä¿ºã¯ã“ã†è€ƒãˆã‚‹ã€‚ ã¨ã€‚ Webå±‹ã®ãƒã‚¿å¸³ã•ã‚“ã®è¨˜äº‹ã§ã¯16ã®ãƒã‚¤ãƒ³ãƒˆãŒç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ãŒã€æ¼¢ï¼ˆã‚ªãƒˆã‚³ï¼‰ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ã®è¨˜äº‹ã¯10ã®æ–¹æ³•ã ã£ãŸã®ã§ã‚ã¨6ã¤è¶³ã‚Šãªã„ã€‚ã‚ªãƒˆã‚³ã¯æ•°ã§å‹è² ï¼ï¼ã¨ã„ã†ã‚ã‘ã§ä»Šæ—¥ã¯ãƒã‚¿ã‚’æŒ¯ã‚Šçµžã£ã¦ã•ã‚‰ã«7ã¤ã®MySQLé«˜é€ŸåŒ–ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ 1. ã‚¤ãƒ³ãƒ†ãƒ«ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©
msh514 2011/08/02
innodb_thread_concurrency

mysql

ã¾ã¨ã‚

database

performance

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

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚º
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
msh514 2011/08/02
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã€€innodb_thread_concurrency

innodb

mysql
ãƒªãƒ³ã‚¯
MySQL :: MySQL 5.0 Reference Manual :: 13.2.11 InnoDB Performance Tuning Tips
MySQL Enterprise.Â For optimization recommendations geared to your specific circumstances subscribe to the MySQL Enterprise Monitor. For more information, see http://www.mysql.com/products/enterprise/advisors.html.
msh514 2011/08/02
mysql

tuning

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

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