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

uzulla id:uzulla

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

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

https://blogs.oracle.com/mysql/post/json-labs-release-effective-functional-indexes-in-innodb/
uzulla 2015/04/11
ä»®æƒ³ã‚«ãƒ©ãƒ ã‚’ã¤ãã£ã¦æ¨ã¦ã‚‹ã®ãŒæœ¬å½“ã«é«˜é€Ÿã«ã§ãã‚‹ãªã‚‰ä¾¿åˆ©ãã†ã€‚jsoné–¢æ•°ä»•äº‹ã§ã‚‚æ—©ãä½¿ã„ãŸã„ã€‚

mysql
ãƒªãƒ³ã‚¯
MySQLã®rootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ã€ç„¡åœæ¢ã§ãƒªã‚»ãƒƒãƒˆã™ã‚‹ | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚rootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒåˆ†ã‹ã‚‰ãªããªã£ãŸæ™‚ã®å¯¾å‡¦æ³•ã¨ã—ã¦ã¯ã€MySQLã®å†èµ·å‹•ãŒå¿…é ˆã«ãªã‚‹æ–¹æ³•ãŒçŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ãŒã€æœ¬ç•ªDBã§ã¯ã§ãã‚‹é™ã‚Šå†èµ·å‹•ã‚’é¿ã‘ãŸã„ã¨ã“ã‚ã€‚ãã‚“ãªæ™‚ã«ç„¡åœæ¢ã§ãƒªã‚»ãƒƒãƒˆã™ã‚‹ãŸã‚ã®è£æŠ€çš„ãªæ‰‹é †ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ December 10, 2014 by Daniel GuzmÃ¡n Burgos æ³¨æ„ : ã“ã“ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹æ–¹æ³•ã¯ã€è‡ªèº«ã®è²¬ä»»ã§å®Ÿè¡Œã™ã‚‹äº‹ã€‚ãƒ—ãƒ©ã‚¬ãƒ–ãƒ«ãªèªè¨¼ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹æ™‚ã¯ã“ã®æ–¹æ³•ã¯ä½¿ãˆãªã„ã€‚ã¾ãŸã€MySQLã®ã‚·ã‚¹ãƒ†ãƒ ãƒ†ãƒ¼ãƒ–ãƒ«ãŒInnoDBã«ã‚ã‚‹æ™‚ã‚‚åŒã˜ãé©ç”¨ä¸å¯èƒ½ã ã€‚ çŠ¶æ³ å®šç•ªã®ã€ŒMySQLã®rootãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ãƒªã‚»ãƒƒãƒˆã—ãŸã„ã€ã¨ã„ã†çŠ¶æ³ã ãŒã€MySQLã®å†èµ·å‹•ã¯ã§ããš(æœ¬ç•ªã®ãƒžã‚¹ã‚¿ãªã©)ã€--skip-grant-tablesã‚’ä½¿ã£ãŸãƒªã‚»ãƒƒãƒˆæ–¹æ³•ãŒä½¿ãˆãªã„æ™‚ã€‚ (è¨³æ³¨ : MySQLã®å†èµ·å‹•ãŒå¿…è¦ã«ãªã‚‹ãƒªã‚»ãƒƒãƒˆæ–¹æ³•
uzulla 2014/12/16
æ€–ã„ãƒ†ã‚¯ã

mysql
ãƒªãƒ³ã‚¯
ISUCON4 äºˆé¸å•é¡Œã§(ä¸ç•¥)ã€â€my.cnfâ€ã«1è¡Œã ã‘è¶³ã—ã¦äºˆé¸é€šéŽãƒ©ã‚¤ãƒ³ã‚’çªç ´ã™ã‚‹ã®è¡“
Advanced nginx in mercari - How to handle over 1,200,000 HTTPS Reqs/Min
uzulla 2014/12/15
â€¦ç²¾é€²ã—ã¾ã™ã€ã¨ã„ã†æ°—åˆ†ã«ãªã‚Œã‚‹ï¼

MySQL
ãƒªãƒ³ã‚¯
ã€ŽMySQLåˆå¿ƒè€…ã«è´ˆã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆã¾ã¨ã‚2014ã€
ã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆå…¬å¼ãƒ–ãƒã‚°ã‚’ã”è¦§ã®çš†ã•ã‚“ã“ã‚“ã°ã‚“ã¯ã€ã‚¤ãƒ³ãƒ•ãƒ©ï¼†ã‚³ã‚¢ãƒ†ã‚¯æœ¬éƒ¨ã®é ˆè—¤(@strsk)ã§ã™ã€‚æ™®æ®µã¯Amebaã®ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ å…¨èˆ¬ã®ã‚¤ãƒ³ãƒ•ãƒ©ã‚’è¦‹ã¤ã¤ã€æ—¥æœ¬èªžãƒ©ãƒƒãƒ—ã®å•“è’™ã‚’ã—ãªãŒã‚‰å¼Šç¤¾ç¤¾å“¡ã‚’ç´ æã«ã‚³ãƒ©ç”»åƒã‚’ã¤ãã£ãŸã‚Šã—ã¦ã„ã¾ã™ã€‚å¥½ããªAAã¯éº»å‘‚ã§ã™ã€‚ ã¯ã„ã€ã¨ã„ã†ã‚ã‘ã§ä»Šå›žã¯MySQLã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬çš„ãªæµã‚Œã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã¯æ›´æ–°ã‚‚å‚ç…§ã‚‚ã‚ã¡ã‚ƒãã¡ã‚ƒå¤šã„ã§ã™ã€‚æ•°ç§’ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é…å»¶ã‚‚è‡´å‘½çš„ãªã®ã§é©åˆ‡ãªãƒ†ãƒ¼ãƒ–ãƒ«ã€ã‚¯ã‚¨ãƒªã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¨è¨ˆãŒé‡è¦ã§ã™ã€‚ï¼ˆä½•ã§ã‚‚ãã†ã§ã™ã‘ã©ï¼‰ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒå¤šããªã‚‹ã¨æ›´æ–°ã‚³ã‚¹ãƒˆãªã©ãŒæ‡¸å¿µã•ã‚Œã¾ã™ãŒã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒæ£ã—ãä½¿ã‚ã‚Œã¦ã„ãªã„ã‚¯ã‚¨ãƒªã‚’æ”¾ç½®ã—ã¦ã„ã‚‹æ–¹ãŒæ‚ªã§ã™ã€‚ãã‚“ãªã“ã‚“ãªã§ã€å‰²ã¨ä¾‹ã‚‚åã£ãŸã‚Šã—ã¦ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã‚ã—ã‹ã‚‰ãšã€‚ å‰æã¨ã—ã¦ã¯InnoDBã‚’æƒ³å®šã—ã¦ã„ã¾ã™ã€‚MyISAMã¯ã»ã¨ã‚“ã©ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚
uzulla 2014/09/20
mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ - SH2ã®æ—¥è¨˜
JPOUG> SET EVENTS 20140907 | Japan Oracle User Group (JPOUG)ã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚IIJã•ã¾ã®ã‚»ãƒŸãƒŠãƒ«ãƒ¼ãƒ ã¯çª“ã‹ã‚‰ã®çœºã‚ãŒã™ã°ã‚‰ã—ã„ã§ã™ãã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸIIJã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ŒMySQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ã€ã¨é¡Œã—ã¦ãƒã‚¯ã‚¹ãƒˆã‚ãƒ¼ãƒãƒƒã‚¯ãªã©ã®èª¬æ˜Žã‚’ã—ã¾ã—ãŸã€‚ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã¨ã€èª¿æŸ»ã®ãŸã‚ã«ä½œæˆã—ãŸãƒ„ãƒ¼ãƒ«ã‚’å…¬é–‹ã—ã¾ã™ã€‚ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ (PDF) Lock Inspector 1.0 ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã‹ã‚‰ãƒªãƒ³ã‚¯ã—ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä¸€è¦§ã§ã™ã€‚ MySQL Lists: mysql: Re: InnoDB's inner workings + checkpoints éŽåŽ»è¨˜äº‹ã®è¨‚æ£ @kami
uzulla 2014/09/15
mysql
ãƒªãƒ³ã‚¯
MySQLã®æœ€å…ˆç«¯ã‚’è¡Œãç¾å ´äººãŒé›†ã† MySQL Casual Talks #6ã«è¡Œã£ã¦ããŸï¼ - ã‚‚ãã‚ã½ã‚ã
TokuDBã¨ã¯TokutekãŒä½œã£ãŸFractalTree(R)Indexã‚’å®Ÿè£…ã—ãŸã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ ç‰¹å¾´ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ALTER TABLE(ADD INDEX, ADD COLUMN)ã«å¯¾å¿œ åœ§ç¸®ãŒã‚¤ã‚±ã¦ã‚‹ æ–ç‰‡åŒ–ã—ãªã„ ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è¤‡æ•°ä½œã‚Œã‚‹ infromation_schema, show engine tokuDB ã§æƒ…å ±ã¿ã‚Œã‚‹ãŒãªã‚Œã‚‹ã®ã«æ™‚é–“ã‹ã‹ã‚‹ foreign keyã¯å¯¾å¿œã—ã¦ãªã„ How TokuDB Fractal TreeTM Indexes Work ãƒ©ãƒ³ãƒ€ãƒ ãƒ©ã‚¤ãƒˆãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹ç¯‰ãŒæ—©ã„ Insertã®TPSã¯ã„ã¤ã¾ã§ã‚‚ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆãŒå¤‰ã‚ã‚‰ãªã„ ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ twitterã¿ãŸã„ãªã“ã¨ã‚’ã‚„ã‚ã†ã¨ã—ãŸ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚¯ãƒã‚¹ã—ã¦timelineãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ timelineãƒ†ãƒ¼ãƒ–ãƒ«ã¯6å„„ä»¶ ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºå›³ã£ãŸã‚‰innodb compactã¯60Gå¼±ã€
uzulla 2014/07/14
mysql
ãƒªãƒ³ã‚¯
èª°ã‚‚æ•™ãˆã¦ãã‚Œãªã‹ã£ãŸMySQLã®éšœå®³è§£æžæ–¹æ³• - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
uzulla 2014/07/14
mysql

éšœå®³å¯¾å¿œ
ãƒªãƒ³ã‚¯
DataGrip | JetBrains for Data
Your powerful cross-platform IDE for relational and NoSQL databases. Effortlessly connect, manage, and query multiple databases with one intuitive interface. Get a free 30-day trial.
uzulla 2014/06/10
JetBrainè£½ã®DBæ“ä½œãƒ„ãƒ¼ãƒ«ã€ã“ã‚Œã¯æœŸå¾…ã›ã–ã‚‹ã‚’ãˆãªã„ã€‚

mysql
ãƒªãƒ³ã‚¯
Percona Server 5.5ã«ã¦10ç§’é–“éš”ã§Disk I/OãŒé‡ããªã‚‹å•é¡Œ | å¤–é“çˆ¶ã®åŒ
ä¹…ã—ã¶ã‚Šã«DBAã¨ã—ã¦ãŠæ‰‹ä¼ã„ã—ãŸæ™‚ã®æ±šã„ãƒ¡ãƒ¢ã«ãªã‚Šã¾ã™ã€‚ Percona Server5.5ï¼‹ioDriveã®MySQLã§ã€ã‚¤ãƒ™ãƒ³ãƒˆæ™‚ã‚„ãƒ”ãƒ¼ã‚¯ã‚¿ã‚¤ãƒ ã«ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®DBåˆ©ç”¨ãŒé‡ããªã‚‹ã€ã¨ã„ã†ã“ã¨ã§èª¿æŸ»ã‹ã‚‰å¯¾å¿œæ–¹æ³•ã¾ã§è€ƒãˆã¦ã¿ã¾ã—ãŸã€‚ å•é¡Œç‚¹ã®å¤§é›‘æŠŠãªç‰¹å®š é«˜ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯æ™‚ã«ã€Rubyã‹ã‚‰MySQLã®æŽ¥ç¶šã‚„ã‚¯ã‚¨ãƒªãŒã¡ã‚‡ã“ã¡ã‚‡ã“é‡ããªã‚Šã€ãƒ¬ã‚¹ãƒãƒ³ã‚¹é€Ÿåº¦ã«å½±éŸ¿ãŒå‡ºã‚‹ã€ã¨ã®ã“ã¨ã€‚ã§èª¿æŸ»é–‹å§‹ã€‚ä»Šå›žã®Percona Serverã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 5.5.34 ã§ã—ãŸã€‚ top -d1 ã§è§¦è¨ºã—ã¦ã¿ã‚‹ã¨ã€è¬Žã®10ç§’é–“éš”ã§iowaitãŒ5ï½ž10ï¼…ã«ä¸ŠãŒã‚‹ã“ã¨ã‚’ç¢ºèª 5åˆ†å¹³å‡ã®iowaitã‚°ãƒ©ãƒ•ã‚’è¦‹ã¦ã‚‚ã€ãƒ”ãƒ¼ã‚¯æ™‚ã¯50ï½ž60ï¼…ã§ã‚ã‚‹ã“ã¨ã‚’ç¢ºèªã€‚ioDriveã§ã“ã‚Œã¯ã‚¤ã‚«ãƒ³ dstat ã§è¦‹ã‚‹ã¨ã€å¹³æ™‚ã¯writeæ•°MB/sï½žåæ•°MB/sã®ã¨ã“ã‚ãŒã€ã‚„ã¯ã‚Š10ç§’é–“éš”ã§write æ•°ç™¾MBã‚’ç¢ºèªã€‚ãƒ”ãƒ¼ã‚¯æ™‚
uzulla 2014/05/10
mysql

linux.admin
ãƒªãƒ³ã‚¯
MySQLã§å‡¦ç†ã«é•·æ™‚é–“ã‹ã‹ã£ã¦ã„ã‚‹è¤‡æ•°ã‚¯ã‚¨ãƒªã‚’ã¾ã¨ã‚ã¦æ®ºã™æ–¹æ³• | Basicinc Enjoy Hacking!
ã‚ã¾ã‚Šã«ã‚‚å‡¦ç†ã«æ™‚é–“ãŒã‹ã‹ã‚‹ã‚ˆã†ãªSQLã‚’å®Ÿè¡Œã—ã¦ã—ã¾ã„ã€MySQLãŒã†ã‚“ã¨ã‚‚ã™ã‚“ã¨ã‚‚è¨€ã‚ãªããªã£ã¦ã—ã¾ã†ã‚ˆã†ãªçŠ¶æ³ã€ã‚ˆãã‚ã‚Šã¾ã™ã‚ˆãã€‚ã£ã¦ã„ã†ã‹ã€ã¾ããã‚“ãªçŠ¶æ³ã‚ã£ã¦ã¯ãªã‚‰ãªã„ã‚“ã§ã™ãŒã€æ™‚ãŸã¾ã‚ã‚Šã¾ã™ã€‚ãã‚“ãªæ™‚ã€å•é¡Œã¨ãªã£ã¦ã„ã‚‹ã‚¯ã‚¨ãƒªã®å‡¦ç†ã‚’æ¢ã‚ãŸã„ã‚ã‘ã§ã™ã€‚ ç‰¹å®šã®ã‚¯ã‚¨ãƒªã‚’æ¢ã‚ã‚‹æ–¹æ³• MySQLã§å®Ÿè¡Œä¸ã®ã‚¯ã‚¨ãƒªä¸€è¦§ã‚’è¦‹ã¦ã€SQLã‚’å¼·åˆ¶çµ‚äº†ã™ã‚‹æ–¹æ³• ã“ã¡ã‚‰ã‚’è¦‹ã¦ã‚‚ã‚‰ãˆã‚Œã°ã‚„ã‚Šæ–¹ã¯åˆ†ã‹ã‚Šã¾ã™ã€‚å˜ç´”ã«MySQLã«å…¥ã£ã¦ã€show processlist;ã§å•é¡Œã®ã‚ã‚‹ã‚¯ã‚¨ãƒªã‚’ç™ºè¦‹ã—ã€ãƒ—ãƒã‚»ã‚¹IDã‚’ kill ã™ã‚‹ã ã‘ã€‚ã¨ã¦ã‚‚ç°¡å˜ã€‚ è¤‡æ•°ã®ã‚¯ã‚¨ãƒªã‚’ä¸€æ‹¬ã§æ¢ã‚ã‚‹æ–¹æ³• ä»Šå›žã¯å•é¡Œã®ã‚ã‚‹ã‚¯ã‚¨ãƒªãŒ100å€‹ã‚ã£ãŸã‚‰ã©ã†ã™ã‚‹â€¦ï¼Ÿçš„ãªã®ã‚’è§£æ±ºã™ã‚‹ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã™ã€‚ã¾ãã€å•é¡Œã‚ã‚‹ã‚¯ã‚¨ãƒª100å€‹ã‚ã‚‹çŠ¶æ³ã¯ã€ã‚¢ãƒ—ãƒªçš„ã«å•é¡Œã‚ã‚‹ã‚“ã˜ã‚ƒãï¼Ÿã£ã¦ã„ã†ãƒ¬ãƒ™ãƒ«ã§ã™ãŒã€‚ 1å€‹ãšã¤ãƒ—ãƒã‚»ã‚¹IDã‚’ã‚³ãƒ”ãƒšã—ã¦â€¦ãªã‚“ã¦ã‚„ã£ã¦ã‚‰ã‚Œãªã„ã§ã™
uzulla 2014/04/16
ãªã‚‹ã»ã©æ¥½ã

mysql
ãƒªãƒ³ã‚¯
MySQLã®ALTER TABLEã‚’ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã™ã‚‹ | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚ALTER TABLEã«ã‚ˆã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å¤‰æ›´ã®é€²æ—çŠ¶æ³ã‚’ç¢ºèªã™ã‚‹ã«ã¯ã€ã„ãã¤ã‹ã®æ–¹æ³•ãŒã‚ã‚‹ã€‚ãã‚Œãžã‚Œã®æ–¹æ³•ã¨åˆ©ç‚¹ã€æ¬ ç‚¹ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ February 26, 2014 By Nilnandan Joshi Percona Supportã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ç¾åœ¨é–¢ã‚ã£ã¦ã„ã‚‹æ¡ˆä»¶ã®ä¸ã§ã€ALTER TABLEã®é€²æ—çŠ¶æ³ã‚’ç¢ºèªã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦é¡§å®¢ã‹ã‚‰å°‹ãã‚‰ã‚ŒãŸã€‚å®Ÿã¯ã€MySQL 5.5ä»¥å‰ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹ALTERã®å®Ÿè¡ŒçŠ¶æ³ã‚’æœ¬ç•ªç’°å¢ƒã§ç¢ºèªã™ã‚‹ã®ã¯å°‘ã€…é›£ã—ãã€(æ•°ç™¾ä¸‡è¡Œã‚‚ã‚ã‚‹ã‚ˆã†ãª)å·¨å¤§ãªãƒ†ãƒ¼ãƒ–ãƒ«ã§ã¯ãªãŠã•ã‚‰ã ã£ãŸã€‚ã“ã‚Œã¯ã€ãƒªãƒ“ãƒ«ãƒ‰ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒãƒƒã‚¯ã‚’ä¼´ã†ãŸã‚ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ä½Žä¸‹ã ã‘ã§ãªããƒ¦ãƒ¼ã‚¶å½±éŸ¿ã‚‚ã‚ã£ãŸãŸã‚ã ã€‚ã¨ã¯ã„ãˆã€ALTERã‚’å§‹ã‚ã¦ã—ã¾ãˆã°ã€ãã‚ŒãŒã„ã¤çµ‚ã‚ã‚‹ã®ã‹ã‚’çŸ¥ã‚‹ã®ã¯ã¨ã¦ã‚‚é‡è¦ãªã“ã¨ã ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã—ã¦ã„ã‚‹é–“ã€fast_ind
uzulla 2014/03/05
mysql
ãƒªãƒ³ã‚¯
Peyote :: Build MySQL Queries the OOP Way
uzulla 2014/02/13
php

mysql
ãƒªãƒ³ã‚¯
MySQL 5.6ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã¹ãé …ç›® | Yakst
MySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒžãƒãƒ¼ã‚¸ãƒ£ã®Morgan Tockeræ°ã«ã‚ˆã‚‹ã€MySQL 5.6ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå¾Œã«ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‹ã‚‰å¤‰æ›´ã—ãŸæ–¹ãŒã‚ˆã„ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®è§£èª¬ã€‚ æ•°ã€…ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®æ”¹å–„ã«ã‚ˆã£ã¦ã€éŽåŽ»ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨æ¯”ã¹ã¦MySQL 5.6ã§ã¯è¨å®šã—ãªãã¦ã¯ãªã‚‰ãªã„å€¤ãŒã‹ãªã‚Šæ¸›ã£ãŸã€‚ã¨ã¯è¨€ãˆã€å¤‰æ›´ã™ã¹ãã‚‚ã®ã«ã¤ã„ã¦ã“ã“ã§æ›¸ã„ã¦ãŠããŸã„ã€‚ InnoDBã®è¨å®š innodb_buffer_pool_size - ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯128Mã€‚ã“ã‚Œã¯ã€ãƒ¡ãƒ¢ãƒªã«ãƒãƒ¼ãƒ‰ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãŸã‚ã«InnoDBãŒã©ã®ãã‚‰ã„ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã‹ã‚’æŒ‡å®šã™ã‚‹ã‚‚ã®ãªã®ã§ã€è¨å®šã™ã¹ãé‡è¦ãªå€¤ã ã€‚MySQLã®å°‚ç”¨ã‚µãƒ¼ãƒãªã‚‰ã€æè¼‰ã•ã‚Œã¦ã„ã‚‹ãƒ¡ãƒ¢ãƒªã®50%ã‹ã‚‰80%ãŒæŽ¨å¥¨ã•ã‚Œã‚‹è¨å®šå€¤ã ã€‚ä¾‹ãˆã°ã€64GBã®RAMã‚’æè¼‰ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒãªã‚‰ã€ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã¯50GBç¨‹åº¦ã«ã™ã¹ãã ã‚ã†ã€‚ innodb_log_file_size -
uzulla 2014/01/19
mysql

MySQL.ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
å¿«é©mysqlã‚³ãƒžãƒ³ãƒ‰â˜…ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã®æ±ºå®šç‰ˆ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
ã“ã®è¨˜äº‹ã¯ MySQL Casual Advent Calendar 2013 ã®25æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ è‡ªåˆ†ã®éŽåŽ»ã®ãƒ–ãƒã‚°ã‚‚å«ã‚ã¦ã€mysqlã‚³ãƒžãƒ³ãƒ‰ã®ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã«ã¤ã„ã¦ã„ã‚ã„ã‚ãªæƒ…å ±ãŒã‚ã‚Šã¾ã™ãŒã€ã‚ãŸã—ãŒã‚ªã‚¹ã‚¹ãƒ¡ã®ç§˜ä¼ã®ã‚¿ãƒ¬ã‚’ã¾ã¨ã‚ãŸã„ã¨æ€ã„ã¾ã™ã€‚æ˜¯éžã€ã”å‚è€ƒã«ã€‚ å®šåž‹æ–‡(SQL)ã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆå…¥åŠ› ã€Œshow create table TABLENAME\Gã€ã¨ã‹ã€Œselect user,host,password from mysql.user order by user,host;ã€ã¨ã‹ã€ã‚ˆãå®Ÿè¡Œã™ã‚‹ã‘ã©é•·ãã¦å…¥åŠ›ã™ã‚‹ã®ãŒã‚ã‚“ã©ã†ãªã®ãŒã‚ã‚Šã¾ã™ã‚ˆãã€‚ãã‚Œã‚’ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã§å…¥åŠ›ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹æ–¹æ³•ã§ã™ã€‚ mysqlã‚³ãƒžãƒ³ãƒ‰ã§è¡Œç·¨é›†ãŒã§ãã‚‹ã®ã¯ã€readlineã‚„libeditã‚’ãƒªãƒ³ã‚¯ã—ã¦ã„ã‚‹ãŠã‹ã’ã§ã™ã€‚ å¾“æ¥ã®å…¬å¼ãƒã‚¤ãƒŠãƒªé…å¸ƒç‰©ã«å«ã¾ã‚Œã‚‹mysqlã‚³ãƒžãƒ³ãƒ‰ã¯readlineã§ã—ãŸ
uzulla 2013/12/25
mysql CLI Clientã®ç§˜ä¼ã®ã‚¿ãƒ¬ã€ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚„ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºãªã©

mysql
ãƒªãƒ³ã‚¯
Nginx + Lua ã‹ã‚‰ MySQL ã‚’ä½¿ã† - æ˜¼ãƒ¡ã‚·ç‰©èªž
ã“ã®è¨˜äº‹ã¯ MySQL Casual Advent Calendar 2013 ã® 12 æ—¥ç›®ã§ã™ã€‚ ã¿ã‚“ãªå¤§å¥½ã Nginx + Lua ã§ã™ãŒã€ãã® Lua ã‹ã‚‰ MySQL ãŒå©ã‘ã‚‹ã¨ãªã‚‹ã¨ã€Nginx ã ã‘ã§ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒæ›¸ã‘ã¡ã‚ƒã†ã¨ã„ã†å¤¢ãŒåºƒãŒã‚Šã¾ã™ãã€‚ é›£ã—ãã†ã¨ã„ã†ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€å®Ÿã¯ OpenResty ã‚’ä½¿ã†ã¨ã€ãã‚“ãªç’°å¢ƒãŒç°¡å˜ã«ä½œã‚Œã¦ã—ã¾ã†ã®ã§ã€ä»Šæ—¥ã¯ãã®æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ngx_openresty ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ä»Šå›žã¯ Ubuntu 12.04 ã§ã®ä¾‹ã§ã™ãŒã€ã»ã¨ã‚“ã©åŒæ§˜ã®æ‰‹é †ã§ CentOS 6.5 ã§ã‚‚å‹•ãã“ã¨ã‚’ç¢ºèªã—ã¦ã„ã¾ã™ã€‚ *1 $ sudo apt-get -y install gcc make libpcre3-dev libssl-dev perl5 wget $ sudo apt-get -y install libmy
uzulla 2013/12/12
mysql

lua

nginx
ãƒªãƒ³ã‚¯
wingãƒªãƒã‚¸ãƒˆãƒª ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆæ—¥æœ¬èªžãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ - OSDN
uzulla 2013/11/30
groonga

mysql
ãƒªãƒ³ã‚¯
DimitriK's (dim) Weblog : October 2013
As promised my slides from the morning session and files for PFS lab this afternoon: MySQL Performance slides (my talk from MySQL Connect 2013) Intro to MySQL Performance Schema: slides support file world database As well you may follow the event with #mysql techday @twitter ;-) Rgds, -Dimitri As promised, my slides from MySQL Connect talks are now uploaded to the #OOW13 site and also available fro
uzulla 2013/10/09
MySQL
ãƒªãƒ³ã‚¯
MySQL 5.6ã«ãŠã‘ã‚‹å¤§é‡ãƒ‡ãƒ¼ã‚¿ãƒãƒ¼ãƒ‰æ™‚ã®è€ƒæ…®ç‚¹ - SH2ã®æ—¥è¨˜
ã”ç¸ãŒã‚ã£ã¦AWS User Group - Japanã«ãŠèª˜ã„ã„ãŸã ãã€10æœˆ4æ—¥ã«ç¬¬18å›ž AWS User Group - Japan æ±äº¬å‹‰å¼·ä¼šã§ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é‹å–¶ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€Œç§‹ã®DBç¥ã‚Šã€ã¨ã„ã†ã“ã¨ã§ã€MySQLã«é™ã‚‰ãšã•ã¾ã–ã¾ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹è©±é¡ŒãŒå–ã‚Šæ‰±ã‚ã‚Œã¦ã„ã¾ã—ãŸã€‚ãã®ä¸ã§ã‚‚Redshiftã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ãŒè¤‡æ•°ã‚ã‚Šã€æ³¨ç›®åº¦ã®é«˜ã•ãŒä¼ºãˆã¾ã—ãŸã€‚ã‚¯ãƒ©ã‚¹ãƒ¡ã‚½ãƒƒãƒ‰ã•ã‚“ã€EnterpriseZineã•ã‚“ãŒå‹‰å¼·ä¼šã®æ§˜åã‚’è©³ã—ããƒ¬ãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã¾ã™ã€‚ ç¬¬18å›ž AWS User Group - Japan æ±äº¬å‹‰å¼·ä¼š ã«å‚åŠ ã—ã¦ããŸ #jawsug ï½œ Developers.IO JAWS-UGæ±äº¬å‹‰å¼·ä¼šã§æ¿ƒã‚†ãƒ¼ã„ã€Œç§‹ã®DBç¥ã‚Šã€ï¼šä¼æ¥ã®ITãƒ»çµŒå–¶ãƒ»ãƒ“ã‚¸ãƒã‚¹ã‚’ã¤ãªãæƒ…å ±ã‚µã‚¤ãƒˆ EnterpriseZine (E
uzulla 2013/10/07
mysql

MySQL.ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
chef ã§ mysql ã®ãƒ¦ãƒ¼ã‚¶ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç®¡ç†ã™ã‚‹ - Hack like a rolling stone
ä»¥å‰ã€ã‚ã‚‹ç’°å¢ƒã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã£ãŸã¨ãã¯ã€å¿™ã—ãã¦æ‰‹ãŒå›žã‚‰ãªã„ã¨ã„ã†ç†ç”±ã§ ãƒ¦ãƒ¼ã‚¶ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã¯ script ãƒªã‚½ãƒ¼ã‚¹ã‚’ä½œã£ã¦ãˆã„ã‚„ã¨æ¸ˆã¾ã›ã¦ã—ã¾ã£ãŸ tk0miya ã§ã™ã€‚ã“ã‚“ã«ã¡ã¯ã€‚ ä»Šå›žã¯ã™ã¹ã¦ community cookbook ã§ç’°å¢ƒã‚’ä½œã‚‹æ–¹æ³•ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ã‚„ã‚Šæ–¹ãŒåˆ†ã‹ã£ã¦ã—ã¾ãˆã°ã‚·ãƒ³ãƒ—ãƒ«ã«å®Ÿç¾ã§ãã‚‹ã®ã§ã€æ³¥è‡ã script ãƒªã‚½ãƒ¼ã‚¹ã‚’ä½œã‚‰ãšã«æ¸ˆã¿ãã†ã§ã™ã€‚ éµã¯ database cookbook ãƒ¦ãƒ¼ã‚¶ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹ãƒ¬ã‚·ãƒ”ãŒ mysql cookbook ã«å…¥ã£ã¦ã„ãªã„ãŸã‚ã€ å…¬å¼ã«ã¯æä¾›ã•ã‚Œã¦ã„ãªã„ã‚‚ã®ã¨ã„ã¾ã¾ã§è«¦ã‚ã¦ã„ãŸã®ã§ã™ãŒã€ èª¿ã¹ã¦ã¿ã‚‹ã¨ mysqll cookbook ã§ã¯ãªã database cookbook ã§ãƒªã‚½ãƒ¼ã‚¹ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ ä»¥ä¸‹ã€README ã®èª¬æ˜Žã§ã™ã€‚ The main highlight of
uzulla 2013/09/04
chef

mysql
ãƒªãƒ³ã‚¯
500 Days Later... (é‚¦é¡Œã€Windowsã‚µãƒ¼ãƒãƒ¼ã§èµ·å‹•ã‹ã‚‰500æ—¥) - uzullaãŒãƒ–ãƒã‚°
å…ˆæ—¥ã‚ˆã‚Šçªç„¶æŠ•ã’æ¸¡ã•ã‚ŒãŸWindowsã‚·ã‚¹ãƒ†ãƒ ã‚’æ‰±ã†äº‹ã«ãªã£ã¦ã‚‹ç§ã§ã™ãŒã€æ§˜ã€…ãªæ´—ç¤¼ã‚’å—ã‘ã€ç€ã€…ã¨ã‚¦ã‚¤ãƒ³ãƒ‰ãƒ¼ã‚ºåŠ›ã‚’é«˜ã‚ã¦ãŠã‚Šã¾ã™ã€‚ ã•ã¦ã€ã‚¿ã‚¤ãƒˆãƒ«ã ã‘ã§Windowsãƒžã‚¹ã‚¿ãƒ¼ã®çš†æ§˜ãªã‚‰ã€ã€Œã‚ã‚â€¦ã€ã£ã¦ã‚ã‹ã‚Šã¾ã™ã‚ˆãã€ãã‚Œã«ã²ã£ã‹ã‹ã‚Šã¾ã—ãŸã€‚ æ£ã—ãã¯ã€497æ—¥2æ™‚é–“27åˆ†52ç§’950ãƒŸãƒªç§’ http://support.microsoft.com/kb/2553549/ja http://operationslab.wordpress.com/2013/03/01/windows-%E3%81%AE497%E6%97%A5%E5%95%8F%E9%A1%8C-%E3%81%9D%E3%81%AE%E5%BE%8C/ åŽ»å¹´ãã‚‰ã„ã«è©±é¡Œã«ãªã£ãŸã€ã€ŒWindows Vistaã€Windows 7ã€Windows Server 2008 ãŠã‚ˆã³ Windows Server 2008 R2 ã§ã€ã‚·
uzulla 2013/08/30
Windowsã®æ´—ç¤¼å—ã‘ç¶šã‘ã¦ã„ã¾ã™ã€æ—¥ã€…å‹‰å¼·ã§ã™ã€‚Linuxã§ã‚‚ã«ãŸã‚ˆã†ãªã®ã‚ã‚‹ã¨ã®ã“ã¨ã ã‘ã©ã€ã¾ã ã‹ã‹ã£ãŸã“ã¨ãŒãªã„ãªã€œ(é‹ãŒã‚ˆã„ã ã‘ã‹æ°—ã¥ã„ã¦ãªã„ã®ã‹)

windows

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