[B! MySQL] plansetã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

planset id:planset

MySQLã«é–¢ã™ã‚‹plansetã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

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

DBAã®ãŸã‚ã®mysqldumpã®tips 25é¸ | Yakst
MySQLæ¨™æº–ã®ãƒ€ãƒ³ãƒ—ãƒ„ãƒ¼ãƒ«mysqldumpã«ã¤ã„ã¦ã€åŸºç¤Žçš„ãªä½¿ã„æ–¹ã‹ã‚‰ã‚ˆãä½¿ã‚ã‚Œã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ç‰¹å¾´ã¾ã§ã‚’å«ã‚€25å€‹ã®å•ç”é›†ã€‚ 1) mysqldumpã¯ãƒ†ã‚ã‚¹ãƒˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ï¼Ÿãã‚Œã¨ã‚‚ãƒã‚¤ãƒŠãƒªãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ï¼Ÿ ãƒ†ã‚ã‚¹ãƒˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã ã€‚ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ã‘ã°ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãã®ä¸ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œã‚Šç›´ã™ãŸã‚ã®å…¨æ–‡ãŒè¦‹ã‚‰ã‚Œã‚‹ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’è©°ã‚è¾¼ã‚€ãŸã‚ã®insertæ–‡ã‚‚ã‚‚ã¡ã‚ã‚“å«ã¾ã‚Œã¦ã„ã‚‹ã€‚ 2) mysqldumpã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¯ï¼Ÿ $ mysqldump -u [uname] -p[pass] â€“databases [dbname] [dbname2] > [backupfile.sql] 3) å…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã©ã†ã—ãŸã‚‰ã„ã„ï¼Ÿ $ mysqldump -u root -p â€“all-databases > backupfile.sql
planset 2015/01/15
mysqldump

mysql
ãƒªãƒ³ã‚¯
Pythonã§ä½œã‚‰ã‚ŒãŸä¾¿åˆ©ãªã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ« MySQL Utilities
MySQL Utilitiesãªã‚‰ã§ã¯ã®æ³¨æ„ç‚¹ MySQL Utilitiesã¯å¾“æ¥ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ç¾¤ã¨ã¯é•ã„ã€ä»¥ä¸‹ã®ã‚ˆã†ãªè¨˜è¿°ã§æŽ¥ç¶šå…ˆã‚’æŒ‡å®šã—ã¾ã™ã€‚ ã“ã‚Œã¯ã€å¾“æ¥ã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ç¾¤ãŒä¸»ã«1ã¤ã®MySQLã‚µãƒ¼ãƒãƒ¼ã‚’å¯¾è±¡ã¨ã—ã¦å‹•ä½œã™ã‚‹ã‚‚ã®ãªã®ã«å¯¾ã—ã¦ã€MySQL Utilitiesã¯2ã¤ä»¥ä¸Šã®MySQLã‚µãƒ¼ãƒãƒ¼ã‚’å¯¾è±¡ã¨ã—ã¦å‹•ä½œã™ã‚‹ã‚‚ã®ãŒå¤šã„ãŸã‚ã€ã“ã®ã‚ˆã†ãªè¨˜æ³•ã«ãªã£ã¦ã„ã¾ã™ã€‚ [MySQL Utilitiesã®è¨˜æ³•] --server=ãƒ¦ãƒ¼ã‚¶å:ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰@ãƒ›ã‚¹ãƒˆå:ãƒãƒ¼ãƒˆç•ªå· [MySQL ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ãƒ¼ãƒ«ç¾¤ã®è¨˜æ³•] --user=ãƒ¦ãƒ¼ã‚¶å --password=ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ --host=ãƒ›ã‚¹ãƒˆå --port=ãƒãƒ¼ãƒˆç•ªå· ãªãŠWindowsç’°å¢ƒã§ã¯ãƒãƒ¼ã‚«ãƒ«ãƒ›ã‚¹ãƒˆã¨ã—ã¦localhostã¨127.0.0.1ã®ã©ã¡ã‚‰ã‚’æŒ‡å®šã—ã¦ã‚‚åŒã˜ã§ã™ãŒã€Linuxã‚„UNIXã§ã¯ãƒ›ã‚¹ãƒˆåã«å¯¾
planset 2014/02/12
MySQL

python
ãƒªãƒ³ã‚¯
FacebookãŒä½•åƒå°ã‚‚ã®MySQLã‚’äººæ‰‹ã‚’ä½¿ã‚ãšè‡ªå¾‹ç®¡ç†ã™ã‚‹ä»•çµ„ã¿ã€ŒMySQL Pool Scannerï¼ˆMPSï¼‰ã€
ãŠãã‚‰ãä¸–ç•Œã§ã‚‚ã£ã¨ã‚‚å¤§è¦æ¨¡ã«MySQLã®ã‚¯ãƒ©ã‚¹ã‚¿ã‚’å±•é–‹ã—ã€é‹ç”¨ã—ã¦ã„ã‚‹ã®ãŒFacebookã§ã—ã‚‡ã†ã€‚è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã‚Šä½•åƒå°ã‚‚ã®MySQLã‚µãƒ¼ãƒã‚’é‹ç”¨ã™ã‚‹ãŸã‚ã«ã€è‡ªå‹•åŒ–ã®ä»•çµ„ã¿ã¯æ¬ ã‹ã›ã¾ã›ã‚“ã€‚ ãã®è‡ªå‹•åŒ–ãŒã©ã®ã‚ˆã†ãªä»•çµ„ã¿ã«ãªã£ã¦ã„ã‚‹ã®ã‹ã€‚Facebookã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹Shlomo Priymakæ°ãŒã€Under the hood: MySQL Pool Scanner (MPS)ã¨ã„ã†è¨˜äº‹ã‚’Facebookã§å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ ã‹ãªã‚Šé•·ã„è¨˜äº‹ãªã®ã§ã€ã“ã“ã§ã¯ãã®ãƒã‚¤ãƒ³ãƒˆã‚’ã¾ã¨ã‚ã¦è§£èª¬ã—ã¦ã¿ã¾ã—ãŸã€‚è©³ç´°ã¯ãœã²åŽŸæ–‡ã‚’ã‚ãŸã£ã¦ã¿ã¦ãã ã•ã„ã€‚ MPSã®ãŠã‚‚ãª3ã¤ã®æ©Ÿèƒ½ Facebookã§ç¨¼åƒã—ã¦ã„ã‚‹MySQLã¯ã€ã¤ãã«1ã¤ã®ãƒžã‚¹ã‚¿ãƒ¼ã¨ãã“ã‹ã‚‰ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã•ã‚ŒãŸè¤‡æ•°ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã‚ˆã‚‹ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã‚’æ§‹æˆã—ã¦ã„ã¾ã™ã€‚ã“ã®ãƒ¬ãƒ—ãƒªã‚«ã‚»ãƒƒãƒˆã®æ§‹é€ ã‚’ç¶æŒã—ç¶šã‘ã‚‹ã“ã¨ã§ã€å¯ç”¨æ€§ã¨
planset 2013/10/28
MySQL
ãƒªãƒ³ã‚¯
(å¸°ã£ã¦ããŸ)InnoDBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æœ€é©åŒ–ã®åŸºç¤Ž | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚Perconaã®ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹ç†è€…ãŒã€InnoDBã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºç¤Žã«ã¤ã„ã¦ã€ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„OSã®é¸å®šã‹ã‚‰ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®æŽ¨å¥¨å€¤ã¾ã§è§£èª¬ã™ã‚‹ã€‚ æœ€è¿‘ã€2007å¹´ã«Peter ZaitevãŒæ›¸ã„ãŸã€ŒInnoDBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æœ€é©åŒ–ã®åŸºç¤Žã€ã¨ã„ã†è¨˜äº‹ã‚’è¦‹ã¤ã‘ãŸã€‚ã“ã‚Œã¯ç´ æ™´ã‚‰ã—ã„è¨˜äº‹ã§ã€èªã‚“ã§ã„ã‚‹ã¨ã€MySQLã¨Percona Serversãã—ã¦ä»Šæ—¥åˆ©ç”¨å¯èƒ½ãªå…¨ã¦ã®åŸºç›¤æŠ€è¡“ã«é–¢ã—ã¦ã€6å¹´è¿‘ãã®é–“ã«ä½•ãŒå¤‰ã‚ã£ã¦ããŸã®ã‹ã‚’è¦‹ç›´ã—ã¦ã¿ãŸã„ã¨æ€ã‚ã›ã‚‹ã‚‚ã®ã ã€‚ æœ¬å½“ã«ãŸãã•ã‚“ã®ã“ã¨ãŒå¤‰ã‚ã£ãŸã‚‚ã®ã ï¼ã“ã®è¨˜äº‹ã§ã¯ã€InnoDBã®ä½¿ç”¨ã«åŠ¹æžœçš„ãªãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®å¤šãã«ã€ç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è¦³ç‚¹ã‹ã‚‰ç„¦ç‚¹ã‚’å½“ã¦ã‚‹ã€‚ç§ã¯ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã€Percona Supportã§ã¯InnoDBãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®é©åˆ‡ãªã‚µã‚¤ã‚ºã«é–¢ã™ã‚‹è³ªå•ãŒãŸãã•ã‚“å¯„ã›ã‚‰ã‚Œã¦ã„ã‚‹
planset 2013/09/28
MySQL

innodb

performance
ãƒªãƒ³ã‚¯
Devsã®å¸¸è˜ã€DBAã¯éžå¸¸è˜
1. MySQL Admin ãŒè¦‹ãŸ Devs ã®å¸¸è˜ã€ DBA ã¯éžå¸¸è˜ 2013/09/14 yoku0825@MyNA PHP Conference 2013 2. ï¼¼ã“ã‚“ã«ã¡ã¯ï¼ï¼ â— yoku0825 â— ã¨ã‚ã‚‹ä¼æ¥ã® DBA â— MySQL æ´ 5 å¹´ãã‚‰ã„ â— ã‚ªãƒ©ã‚¯ã‚Œãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ â— æ—¥æœ¬ MySQL ãƒ¦ãƒ¼ã‚¶ä¼š (MyNA) ã®ã‚¹ãƒ™ã‚Šæ‹…å½“ 3. ï¼¼ã—ã‚ƒã¹ã‚‹ã“ã¨ï¼ï¼ â— æ—¥å¸¸çš„ã« MySQL ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã«è§¦ã‚Œã‚‹å¤‰æ…‹ DBA ãŒãƒ•ãƒ„ãƒ¼ã® Devs ã«æŠ•ã’ãŸæ„›ã®ãƒžã‚µã‚«ãƒªé›† ( ã®ã¤ã‚‚ã‚Š ) â— ã‚¦ãƒã®é–‹ç™ºè¨€èªžã¯ PHP > Java >> Ruby ã‚‰ã—ã„ã§ã™ â— ã‚¦ãƒã§ã¯ DBA ãŒã‚µãƒ¼ãƒãƒ¼ã®æ§‹ç¯‰ã€ Devs ãŒè¨è¨ˆãƒ» ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹ç¯‰ãƒ»é‹å–¶ã€ DBA ã¯ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒˆã‚„æ”¹ å–„ææ¡ˆ ( é‹ç”¨ ) ã€ã¨ã„ã†ã‚µã‚¤ã‚¯ãƒ«ã§å›žã—ã¦ã„ã¾ã™ã€‚
planset 2013/09/15
MySQL

performance
ãƒªãƒ³ã‚¯
KLab Advent Calendar 2011 ã€ŒDSAS for Social ã‚’æ”¯ãˆã‚‹æŠ€è¡“ã€ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
DSAS Blog ã‚‚ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆãƒ»ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã‚’ã¯ã˜ã‚ã¾ã™ã€‚ æœ€è¿‘æ—¥è¨˜ã‚’ã‚µãƒœã‚ŠãŒã¡ã§ã—ãŸãŒã€å¹³æ—¥ã¯æ¯Žæ—¥æ›´æ–°ãŒã‚“ã°ã‚Šã¾ã™ã€‚ 12/1: MySQL ã‚’ PDO ã§ä½¿ã†ã¨ãã¯ ATTR_EMULATE_PREPARES ã‚’è¨å®šã—ã‚ˆã† 12/2: ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯åˆ‡ã£ãŸã»ã†ãŒã„ã„ã‚“ã˜ã‚ƒãªã‚¤ã‚«ï¼Ÿ 12/5: SHOW FULL PROCESSLIST ã‚’ä½¿ã£ãŸ MySQL ã®ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚° 12/6: JavaScriptã§ã¤ãã‚‹é‡åã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ¼ 12/7: DSAS for Social ã§ã® MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ä»Šå¾Œã®æ–¹é‡ 12/8: ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒªã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯èª¿æŸ»ä¾‹ï¼ˆstraceç·¨ï¼‰ 12/9: php ã®ãƒ—ãƒã‚»ã‚¹æ•°ã‚’çµžã‚ã† 12/12: é«˜è² è·ã§ã‚‚å®‰å®šã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã™ã‚‹ãŸã‚ã®ãƒªãƒãƒ¼ã‚¹ãƒ—ãƒã‚ã‚· 12/13: éŽè² è·ã‚’ã‹ã‚ã™ Apache ã®è¨å®š 12/14: Apache
planset 2013/08/28
apache

CPU

MySQL

KLab
ãƒªãƒ³ã‚¯
Migrating from sqlite3 to mysql - Redmine
Given the performance issues we've hit with 0.9.x and sqlite3 as a backend (see here), I've managed to get a good conversion of an sqlite3 dump in to a format that mysql can load to migrate from one to the other. It's attached. Unfortunately its in C# because I had VS2008 to hand, but the source is there and its not long, so I'm sure someone could convert it to a scripting language of your choice
planset 2013/08/21
boolean 't' -> 1, 'f' -> 0

sqlite

mysql

redmine
ãƒªãƒ³ã‚¯
How do I force Django to ignore any caches and reload data?
Having had this probl em and found two definitive solutions for it I thought it worth posting another answer. This is a probl em with MySQL's default transaction mode. Django opens a transaction at the start, which means that by default you won't see changes made in the database. Demonstrate like this Run a django shell in terminal 1 >>> MyModel.objects.get(id=1).my_field u'old' And another in termi
planset 2013/07/10
mysql

python
ãƒªãƒ³ã‚¯
MySQL ã® pager ãŒä¾¿åˆ©ã ã£ãŸ - xykã®æ—¥è¨˜
mysql ã®ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã§ grep ã¨ã‹ä½¿ãˆãªã„ã‹ãªãã¨æ€ã£ã¦ã„ãŸã‚‰ pager ã‚’ä½¿ãˆã°å‡ºæ¥ã‚‹ã“ã¨ã‚’ä»Šæ›´çŸ¥ã£ãŸã€‚ MySQL :: MySQL 5.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 7.7.2 mysql Commands http://dev.mysql.com/doc/refman/5.1/ja/mysql-commands.html mysql ã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã§ä»¥ä¸‹ã®ã‚ˆã†ã« pager (ã¾ãŸã¯\P) ã‚’æŒ‡å®šã™ã‚Œã°ã‚ˆã„ã€‚ ãƒ»grep mysql> pager cat | grep hoge PAGER set to 'cat | grep hoge'ãƒ»ãƒ•ã‚¡ã‚¤ãƒ«ã«ä¿å˜ mysql> \P cat > ~/dump.txt PAGER set to 'cat > ~/dump.txt'ãƒ»less mysql> \P less PAGER set to 'less'less ã® -S ã‚ª
planset 2013/06/21
MySQL
ãƒªãƒ³ã‚¯
1