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

fumi1 id:fumi1

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

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

utf8_unicode_ci ã«å¯¾ã™ã‚‹æ—¥æœ¬ã®é–‹ç™ºè€…ã®è¦‹è§£ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
RailsãŒMySQLã®collationã‚’ã‚µãƒ¼ãƒãƒ¼å´ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®utf8_general_ciã‹ã‚‰utf8_unicode_ciã«ã‚ã–ã‚ã–å¤‰ãˆã¦ã‚‹ã®ã©ã†ã›å¤§ã—ãŸç†ç”±ã˜ã‚ƒãªã„ã ã‚ã¨æ€ã£ã¦æŽ˜ã£ã¦ã¿ãŸã‚‰ã‚„ã£ã±ã‚Šå¤§ã—ãŸç†ç”±ã˜ã‚ƒãªã‹ã£ãŸâ€¦ https://t.co/6NeetGhTF0â€” Ryuta Kamizono (@kamipo) April 18, 2014 Railsã§collationã¨ã—ã¦utf8_unicode_ci(Railsã®DEFAULT_COLLATION)ãŒæŽ¡ç”¨ã•ã‚Œã‚‹ã®ã¯charsetãŒæœªæŒ‡å®šã‚‚ã—ãã¯utf8(Railsã®DEFAULT_CHARSET)ã®ã¨ãã ã‘ã§ã€utf8mb4ã«ã™ã‚‹ã“ã¨ã¨ã‹ã¯å…¨ãè€ƒæ…®ã•ã‚Œã¦ãªã„ã€‚â€” Ryuta Kamizono (@kamipo) April 19, 2014 @frsyuki MySQLã®charset utf8ã®ã¨ãã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ
fumi1 2015/03/08
Unicode

MySQL

Rails
ãƒªãƒ³ã‚¯
ActiveRecordã§ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ç…§åˆé †åºã‚’å¤‰æ›´ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
fumi1 2015/03/08
Unicode

MySQL

Rails
ãƒªãƒ³ã‚¯
MySQL 5.5.11 unicode_ci ã§åŒä¸€è¦–ã•ã‚Œã‚‹æ–‡å—
MySQL 5.5.11 unicode_ci ã§åŒä¸€è¦–ã•ã‚Œã‚‹æ–‡å— Unicode 002000A02000200120022003200420052006200720082009200A202F205F3000 Character Unicode 0021FE57FF01 Character !ï¹—ï¼ Unicode 0022FF02 Character "ï¼‚ Unicode 0023FE5FFF03 Character #ï¹Ÿï¼ƒ Unicode 0024FE69FF04 Character $ï¹©ï¼„ Unicode 0025FE6AFF05 Character %ï¹ªï¼… Unicode 0026FE60FF06 Character &ï¹ ï¼† Unicode 0027FF07 Character 'ï¼‡ Unicode 0028207D208DFE35FE59FF08 Character (â½â‚ï¸µï¹™
fumi1 2015/03/08
Unicode

MySQL
ãƒªãƒ³ã‚¯
What's the difference between utf8_general_ci and utf8_unicode_ci?
Ask questions, find answers and collaborate at work with Stack Overflow Internal. Explore Teams Collectivesâ„¢ on Stack Overflow Find centralized, trusted content and collaborate around the techno logies you use most. Learn more about Collectives
fumi1 2015/03/08
Unicode

MySQL
ãƒªãƒ³ã‚¯
Facebookã‚„Googleã€ã€ŒWebScaleSQLã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹
ç±³Facebookã¯3æœˆ27æ—¥ï¼ˆç¾åœ°æ™‚é–“ï¼‰ã€ç±³Googleã€ç±³Twitterã€ç±³LinkedInã¨å”åŠ›ã—ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMySQLã€ã®ãƒ–ãƒ©ãƒ³ãƒã€ŒWebScaleSQLã€ã‚’GitHubã§å…¬é–‹ã—ãŸã¨ç™ºè¡¨ã—ãŸã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯GNU General Public License Ver.2ã€‚ WebScaleSQLã¯ã€MySQLã‚’å¤§è¦æ¨¡ãªã‚·ã‚¹ãƒ†ãƒ ã§ä½¿ã†4ç¤¾ãŒç›´é¢ã™ã‚‹å…±é€šã®å•é¡Œã‚’è§£æ±ºã™ã‚‹ç›®çš„ã§å…±åŒé–‹ç™ºã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€MySQLã«å¤§è¦æ¨¡ãªç’°å¢ƒã¸ã®å°Žå…¥ã«ç‰¹åŒ–ã—ãŸæ©Ÿèƒ½ã‚’è¿½åŠ ã—ãŸã‚‚ã®ã¨ã„ã†ã€‚ é–¢é€£è¨˜äº‹ Facebookã€æ–°ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã€ŒHackã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ FacebookãŒç¤¾å†…ã§ä½¿ã£ã¦ã„ã‚‹PHPãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã€ŒHackã€ã‚’BSDãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§å…¬é–‹ã—ãŸã€‚ Twitterã€MySQLã®ç‹¬è‡ªãƒ„ãƒ¼ãƒ«ã‚’GitHubã§å…¬é–‹ TwitterãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹My
fumi1 2014/03/28
MySQL
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã¨MariaDBã®é•ã„ä¸€è¦§ - æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´
(2014.12.3è¿½è¨˜ï¼šã“ã®blogã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚åæ˜ ã•ã›ãŸã€‚) SQLãƒ¬ãƒ™ãƒ«ã®å·®ç•° MariaDB5.5ã¨MySQL5.5ã§ã¯SQLãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã»ã¨ã‚“ã©ãªã‹ã£ãŸã€‚autoincrementã®æœ€å¤§å€¤ã®æ‰±ã„ãã‚‰ã„ã€‚ ãŸã ã—ã€MariaDB10.0ã§REGEXPãŒãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œã«ãªã£ãŸã®ã§ã€ã‚¢ãƒ—ãƒªå´ã¯æ³¨æ„ã€‚ é …ç›® MySQL MariaDB Autoincrement æœ€å¤§å€¤ã«é”ã™ã‚‹ã¨ã€ä»¥é™ã¯æœ€å¤§å€¤ã‚’ç¹°ã‚Šè¿”ã™ã€‚Warningã®ã¿ã€‚ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãªã„ã€‚tinyintãªã‚‰â€¦,125,126,127,127,127â€¦ æœ€å¤§å€¤-1ã¾ã§ã€‚ä»¥é™ã¯ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™ã€‚tinyintãªã‚‰â€¦,125,126,ERROR,ERROR,â€¦ EXPLAINæ–‡ JSONå½¢å¼ ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œ Optimizer Trace ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œï¼ˆãŸã ã—ã€MariaDBã®ã»ã†ãŒã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶
fumi1 2013/09/20
MySQL

MariaDB
ãƒªãƒ³ã‚¯
Devsã®å¸¸è˜ã€DBAã¯éžå¸¸è˜
PostgreSQLã‚’Kubernetesä¸Šã§æ´»ç”¨ã™ã‚‹ãŸã‚ã®Operatorç´¹ä»‹ï¼ï¼ˆCloud Native Database Meetup #3 ç™ºè¡¨è³‡æ–™ï¼‰
fumi1 2013/09/17
MySQL

DB
ãƒªãƒ³ã‚¯
Wikipediaè‹±èªžç‰ˆã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã€MySQL 5.1ã‹ã‚‰MariaDB 5.5ã¸ç§»è¡Œå®Œäº†ã¨ã®å ±å‘Š
Wikipedia è‹±èªžç‰ˆã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã€MySQL 5.1ã‹ã‚‰MariaDB 5.5ã¸ç§»è¡Œå®Œäº†ã¨ã®å ±å‘Š ã“ã‚Œã¾ã§MySQL 5.1ã®Facebookã«ã‚ˆã‚‹ãƒ•ã‚©ãƒ¼ã‚¯ã‚’åˆ©ç”¨ã—ã¦ã„ãŸWikipediaãŒã€MariaDBã¸ã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é€²ã‚ã¦ã„ã¾ã™ã€‚4æœˆ22æ—¥ã€è‹±èªžç‰ˆã¨ãƒ‰ã‚¤ãƒ„èªžç‰ˆã®Wikipediaã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒã€MariaDB 5.5ã¸ã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Œäº†ã—ãŸã¨å ±å‘Šã•ã‚Œã¾ã—ãŸã€‚ ãªãœMySQL 5.5ã§ã¯ãªãMariaDB 5.5ã‚’é¸æŠžã—ãŸã®ã‹ã€‚Wikimedia Foundationã®ã‚µã‚¤ãƒˆã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆ Asher Feldmanæ°ã¯æ˜Žç¢ºãªå½¢ã§ã®èª¬æ˜Žã¯é¿ã‘ã¤ã¤ã€æ¬¡ã®ã‚ˆã†ã«æ›¸ã„ã¦ã„ã¾ã™ã€‚ That said, MariaDBâ€™s optimizer enhancements, the feature set of Perconaâ€™s XtraDB (many overla
fumi1 2013/04/24
MySQL

MariaDB
ãƒªãƒ³ã‚¯
ãªãœMySQLã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã¯é…ã„ã®ã‹ã€‚
ã‚ˆãMySQLã¯ã‚µãƒ–ã‚¯ã‚¨ãƒªãŒå¼±ã„ã¨è¨€ã‚ã‚Œã‚‹ãŒã€ã“ã‚Œã¯æœ¬å½“ã ã‚ã†ã‹ï¼ŸåŠåˆ†ã¯æœ¬å½“ã§åŠåˆ†ã¯å˜˜ã§ã‚ã‚‹ã€‚MySQLã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã ã£ã¦ãªã‚“ã§ã‚‚ã‹ã‚“ã§ã‚‚é…ã„ã‚ã‘ã§ã¯ãªã„ã€‚è½ã¨ã—ç©´ã‚’ã—ã£ã‹ã‚Šé¿ã‘ã€ä½¿ã„ã©ã“ã‚ã‚’é–“é•ãˆãªã‘ã‚Œã°ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚‚é«˜é€Ÿã«å®Ÿè¡Œã§ãã‚‹ã®ã§ã‚ã‚‹ã€‚ä»Šæ—¥ã¯MySQLãŒã©ã‚“ãªé¢¨ã«ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã€ã©ã®ã‚ˆã†ãªå ´åˆã«é…ã„ã®ã‹ã¨ã„ã†ã“ã¨ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã€‚ EXPLAINã§å®Ÿè¡Œè¨ˆç”»ã‚’èª¿ã¹ãŸéš›ã«ã€select_typeã«ã¯ã‚¯ã‚¨ãƒªã®ç¨®é¡žãŒè¡¨ç¤ºã•ã‚Œã‚‹ã®ã ãŒã€ä»£è¡¨çš„ãªã‚µãƒ–ã‚¯ã‚¨ãƒªã«ã¯æ¬¡ã®3ã¤ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚‹ã€‚ SUBQUERY DEPENDENT SUBQUERY DERIVED çµè«–ã‹ã‚‰è¨€ãŠã†ã€‚é…ã„ã®ã¯2ç•ªç›®ã€DEPENDENT SUBQUERYã§ã‚ã‚‹ã€‚DEPENDENT SUBQUERYã¨ã¯ã„ã‚ã‚†ã‚‹ç›¸é–¢ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ç›¸å½“ã™ã‚‹ã‚‚ã®ã§ã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã«ãŠã„ã¦å¤–éƒ¨ã‚¯ã‚¨ãƒªã®ã‚«ãƒ©ãƒ ã‚’å‚ç…§ã—ã¦ã„ã‚‹ã‚µãƒ–ã‚¯ã‚¨ãƒªã®ã“ã¨ã§ã‚ã‚‹ã€‚ãã—
fumi1 2012/12/08
MySQL
ãƒªãƒ³ã‚¯
GitHub - vitessio/vitess: Vitess is a database clustering system for horizontal scaling of MySQL.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
fumi1 2012/02/29
MySQL
ãƒªãƒ³ã‚¯
ã€ŒGoogle Cloud SQLã€ç™ºè¡¨ã€Google App Engineã§SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨å¯èƒ½ã«ã€€
fumi1 2011/10/07
Google

GAE

MySQL
ãƒªãƒ³ã‚¯
ã€Žã€ç ”ç©¶èª²é¡Œãƒ¬ãƒãƒ¼ãƒˆã€‘MySQL ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³æ€§èƒ½æ¯”è¼ƒã€
ï¼‘ï¼Žï¼“ã€€ä»Šå›žã®æ¤œè¨¼ã«åˆ©ç”¨ã™ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ ãƒ–ãƒã‚°(mobile)ã®ãƒã‚°ã‚¤ãƒ³ç®¡ç†ç”¨ã¨ã‚¹ã‚ãƒ³æƒ…å ±ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ ï¼‘ï¼Žï¼”ã€€ä½¿ç”¨ã™ã‚‹DBã®è©³ç´°æƒ…å ± DBæ§‹æˆ Masterï¼š1å° Slaveï¼š3å° ãƒ–ãƒã‚°ãƒ¢ãƒã‚¤ãƒ«ã§2å° ãã®ä»–ã‚µãƒ¼ãƒ“ã‚¹ã§1å° å„ãƒ‡ãƒ¼ã‚¿ä»¶æ•° ãƒ¢ãƒã‚¤ãƒ«ç™»éŒ²ãƒ¦ãƒ¼ã‚¶ãƒ¼åŠã³ãƒã‚°ã‚¤ãƒ³æƒ…å ±ï¼šå½¹2,000,000ä»¶ ç·ã‚¹ã‚ãƒ³æ•°ï¼š155ä»¶ ã‚¹ã‚ãƒ³é©ç”¨ãƒ¦ãƒ¼ã‚¶æ•°ï¼šç´„1,100,000ä¼šå“¡ ãƒ”ãƒ¼ã‚¯ã‚¿ã‚¤ãƒ æ™‚ã®SQLç™ºè¡Œå›žæ•°(Slave1å°ã‚ãŸã‚Šã®ç™ºè¡Œå›žæ•°) ãƒ–ãƒã‚°ãƒ¢ãƒã‚¤ãƒ«ã®ã¿ Selectï¼š58,000/åˆ†ç¨‹åº¦ ãƒ–ãƒã‚°ãƒ¢ãƒã‚¤ãƒ«ä»¥å¤–ã®ã‚µãƒ¼ãƒ“ã‚¹ Selectï¼š20,000/åˆ†ç¨‹åº¦ ä»¥ä¸‹ã¯å…±é€š Insertï¼š60/åˆ†ç¨‹åº¦ Updateï¼š900/åˆ†ç¨‹åº¦ Deleteï¼š10/åˆ†ç¨‹åº¦ ï¼‘ï¼Žï¼•ã€€ä½¿ç”¨ã™ã‚‹ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ« super-smack-1.3 ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã§ä½¿ç”¨ã™ã‚‹SQLã®å†…å®¹ãƒã‚°ã‚¤ãƒ³çŠ¶æ…‹ãƒã‚§ãƒƒã‚¯SQL 1ä»¶å•
fumi1 2011/08/03
MySQL

Performance
ãƒªãƒ³ã‚¯
MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° (ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã®æ¤œå‡º) : Figure out!! -ãƒ‰ãƒªã‚³ãƒ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ï¼ onk ã§ã™ã€‚ SAPã•ã‚“ãŒå„ç¤¾ã¨ã‚‚ã€Œã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒªã¯è² è·å¯¾ç–ãŒå¤§äº‹ã€ã£ã¦è¨€ã£ã¦ã„ã¾ã™ãã€‚å¼Šç¤¾ã§ã‚‚ mixi ã‚¢ãƒ—ãƒª(PC)ï¼Œmixi ã‚¢ãƒ—ãƒªãƒ¢ãƒã‚¤ãƒ«ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ãŸã¨ãã¯ãŠç¥ã‚ŠçŠ¶æ…‹ã ã£ãŸã®ã§ï¼Œãµã‚Šã‹ãˆã‚Šã‚‚å…¼ãã¦ MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’èª¿ã¹ã‚‹æ–¹æ³•ã‚’æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚(å¹¸ã„ï¼Œãƒ¢ãƒã‚²ãƒ¼ã‚ªãƒ¼ãƒ—ãƒ³ã‚²ãƒ¼ãƒ ã®ãƒªãƒªãƒ¼ã‚¹æ™‚ã¯ã“ã‚Œã‚‰ã®çµŒé¨“ãŒå½¹ã«ç«‹ã£ãŸã®ã§ä½•ã¨ã‚‚ãªã‹ã£ãŸã§ã™) ã¨ã„ã£ã¦ã‚‚ 9 å‰²æ–¹ ãã‚‚ãã‚‚ã‚µãƒ¼ãƒã®è¨å®šãŒãŠã‹ã—ã„ æ›´æ–°ãŒå¤šã„ãƒ†ãƒ¼ãƒ–ãƒ«ãªã®ã« MyISAM ã‚¨ãƒ³ã‚¸ãƒ³ for æ–‡ã®ä¸ã§ã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œ INDEX å¼µã£ã¦ãªã„ ãƒ‡ãƒ¼ã‚¿é‡ãŒãˆã‚‰ã„ã“ã¨ã«ãªã£ã¦ã‚‹ è¾ºã‚Šãªã‚“ã§ã™ã‘ã©ããƒ¼ã€‚ åŸºæœ¬ã¯ä¸‹ã‹ã‚‰ ã¾ãšï¼Œãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’èª¿ã¹ã‚‹ã¨ãã¯ä¸‹ã®å±¤ã‹ã‚‰ä¸ŠãŒã£ã¦ã„ãã®ãŒåŸºæœ¬ã§ã™ã€‚ãŸã¶ã‚“ã€‚ ãªã®ã§ ssh ã§ã‚µãƒ¼ãƒã«å…¥ã£ã¦ (LoadAverage 300 ãã‚‰ã„ã¾ã§ãªã‚‰ãªã‚“ã¨ã‹å…¥ã‚Œã¾ã™ã) ä»¥ä¸‹ã®ã‚³ãƒžãƒ³
fumi1 2011/06/10
MySQL

Performance
ãƒªãƒ³ã‚¯
layer8.sh
Weâ€™re getting things ready Loading your experienceâ€¦ This wonâ€™t take long.
fumi1 2011/05/27
MySQL

Performance
ãƒªãƒ³ã‚¯
MySQL
HeatWave Use automated and integrated generative AI and machine learning (ML) in one cloud service for transactions and lakehouse scale analytics. Get faster insights from all your data with unmatched performance and deploy apps in your choice of cloud providers. Learn More Â» MySQL Enterprise Edition The most comprehensive set of advanced features, management tools and technical support to achieve
fumi1 2011/05/27
MySQL

Performance
ãƒªãƒ³ã‚¯
http://www.mysqlpracticewiki.com/index.php/MySQL%E3%82%B5%E3%83%BC%E3%83%90%E3%81%8C%E6%B6%88%E8%B2%BB%E3%81%99%E3%82%8B%E3%83%A1%E3%83%A2%E3%83%AA
fumi1 2011/05/27
MySQL

Performance
ãƒªãƒ³ã‚¯
Ring
Ringã¨ã¯ã€ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ä¼šç¤¾å¾“æ¥å“¡ã‚’å¯¾è±¡ã«ã—ãŸæ–°è¦äº‹æ¥ææ¡ˆåˆ¶åº¦ã§ã™ã€‚ ã€Žã‚¼ã‚¯ã‚·ã‚£ã€ã€ŽR25ã€ã€Žã‚¹ã‚¿ãƒ‡ã‚£ã‚µãƒ—ãƒªã€ãªã©æ•°å¤šãã®äº‹æ¥ã‚’ç”Ÿã¿å‡ºã—ã¦ããŸæ–°è¦äº‹æ¥åˆ¶åº¦ã¯ã€ 1982å¹´ã«ã€ŒRINGã€ã¨ã—ã¦ã‚¹ã‚¿ãƒ¼ãƒˆã—ã€1990å¹´ã€ŒNew RINGã€ã¨æ”¹å®šã€ãã—ã¦2018å¹´ã€ŒRingã€ã«ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã—ã¾ã—ãŸã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã‚°ãƒ«ãƒ¼ãƒ—ã®å¾“æ¥å“¡ã¯èª°ã§ã‚‚è‡ªç”±ã«å‚åŠ ã™ã‚‹ã“ã¨ãŒã§ãã€ ãƒ†ãƒ¼ãƒžã¯ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã®æ—¢å˜é ˜åŸŸã«é™ã‚‰ãšã€ã‚ã‚Šã¨ã‚ã‚‰ã‚†ã‚‹é ˜åŸŸãŒå¯¾è±¡ã§ã™ã€‚ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆã«ã¨ã£ã¦ã€Ringã¨ã¯ã€Œæ–°ã—ã„ä¾¡å€¤ã®å‰µé€ ã€ã¨ã„ã†ã‚°ãƒ«ãƒ¼ãƒ—çµŒå–¶ç†å¿µã‚’ä½“ç¾ã™ã‚‹å ´ã§ã‚ã‚Šã€ å¾“æ¥å“¡ãŒè‡ªåˆ†ã®æ„æ€ã§æ–°è¦äº‹æ¥ã‚’ææ¡ˆãƒ»å®Ÿç¾ã§ãã‚‹æ©Ÿä¼šã§ã™ã€‚ Ringãƒ•ãƒãƒ¼ ãã®å¾Œã®äº‹æ¥é–‹ç™ºæ‰‹æ³• Ringã‚’é€šéŽã—ãŸæ¡ˆä»¶ã¯ã€äº‹æ¥åŒ–ã‚’æ¤œè¨Žã™ã‚‹æ¨©åˆ©ã‚’å¾—ã¦ã€äº‹æ¥é–‹ç™ºã‚’è¡Œã„ã¾ã™ã€‚ ã•ã¾ã–ã¾ãªäº‹æ¥é–‹ç™ºã®æ‰‹æ³•ãŒã‚ã‚Šã¾ã™ãŒã€ä¾‹ãˆã°æ—¢å˜é ˜åŸŸã§ã®äº‹æ¥é–‹ç™ºã®å ´åˆã¯ã€ æ‹…å½“äº‹æ¥ä¼šç¤¾å†…ã§äºˆç®—ã‚„
fumi1 2011/05/27
MySQL

Performance
ãƒªãƒ³ã‚¯
MySQL/ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - ãŒã—ã¾ã£ãã™
çµ±è¨ˆæƒ…å ±ã‚’å–ã‚‹ â€ å®šé‡çš„ãªæƒ…å ±åŽé›†ã®ã‚¹ã‚¹ãƒ¡ mysql> show global status; (5.0.2ä»¥ä¸Šã®å ´åˆ) mysql> show status; (5.0.2æœªæº€ã®å ´åˆ) â†‘ ãƒ•ã‚¡ã‚¤ãƒ«ã‚ªãƒ¼ãƒ—ãƒ³æ•°ã®èª¿æ•´ â€ é«˜è² è·ãªã¨ãã«ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œ $ mysqladmin -u root -p extended-status | grep Open Enter password: | Open_files | 515 | | Open_streams | 0 | | Open_tables | 256 | | Opened_tables | 45281 | Open_files, Open_tablesã®æ•°ãŒå¤šã„å ´åˆã¯ /etc/my.cnf ã®ä»¥ä¸‹ã‚’èª¿æ•´ã€‚ã“ã®å€¤ãŒå¤§ãã™ãŽã‚‹ã¨ã€ŒError in accept: Too many open filesã€ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã€MyS
fumi1 2011/05/27
MySQL

Performance
ãƒªãƒ³ã‚¯
FriendFeedã¯ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ãªãƒ‡ãƒ¼ã‚¿ã‚’MySQLã«æ ¼ç´ã—ã¦ã„ã‚‹ã‹ - ãƒ¢ã‚¸ãƒã‚°
FriendFeedã®Bret TaylorãŒã€ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ãªãƒ‡ãƒ¼ã‚¿ï¼ˆã‚¹ã‚ãƒ¼ãƒžï¼ˆåž‹ï¼‰ã«åˆ¶ç´„ã•ã‚Œãªã„ãƒ‡ãƒ¼ã‚¿ï¼‰ã‚’MySQLã«æ ¼ç´ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¦ã„ã‚‹ã€‚å®Ÿéš›ã«FriendFeedã§ä½¿ã£ã¦ã„ã‚‹æ–¹æ³•ã§ã€æœ€æ–°ã®ã‚‚ã®ã‚‰ã—ã„ã€‚ Bret Taylor's blog - How FriendFeed uses MySQL to store schema-less data http://bret.appspot.com/entry/how-friendfeed-uses-mysql MySQLã‚’é€šå¸¸ã®RDBçš„ãªæ–¹æ³•ã§ãªãã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸çš„ã«ä½¿ã„ã€JOINã‚’ä½¿ã‚ãªã„ã§ã‚¹ã‚±ãƒ¼ãƒ«ã•ã›ã‚‹ã¨ã„ã†ã‚‚ã®ã€‚CouchDBãªã©ã«ã‚‚è¿‘ã„ã€æœ€è¿‘æœ‰åŠ›ã«ãªã‚Šã¤ã¤ã‚ã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã ã€‚ã“ã‚Œã‚’ã€å®Ÿç¸¾ã‚‚ã‚ã‚Šæ™®åŠã—ã¦ã„ã‚‹MySQLã‚’ä½¿ã£ã¦å®Ÿç¾ã—ã€è¨€èªžã¯Pythonã§å®Ÿè£…ã—ã¦ã„ã‚‹ã€‚ ãƒ¡ã‚¤ãƒ³ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯æ¬¡ã®ã‚ˆã†ãªã‚‚ã®ã€‚ CREATE TABLE ent
fumi1 2011/05/17
MySQL
ãƒªãƒ³ã‚¯
OpenStackãŒã€DaaSï¼ˆDatabase as a Serviceï¼‰ã‚’å®Ÿç¾ã™ã‚‹ã€ŒProject RedDwarfã€ã‚’ç«‹ã¡ä¸Šã’
OpenStackãŒã€DaaSï¼ˆDatabase as a Serviceï¼‰ã‚’å®Ÿç¾ã™ã‚‹ã€ŒProject RedDwarfã€ã‚’ç«‹ã¡ä¸Šã’ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ã‚¯ãƒ©ã‚¦ãƒ‰åŸºç›¤ã€ŒOpenStackã€ã¯ã€ã‚¯ãƒ©ã‚¦ãƒ‰äº‹æ¥è€…ã®Rackspace Hostingã‚„ã€NASAï¼ˆã‚¢ãƒ¡ãƒªã‚«èˆªç©ºå®‡å®™å±€ï¼‰ãŒä¸å¿ƒã¨ãªã‚Šã€ã‚·ãƒˆãƒªãƒƒã‚¯ã‚¹ã€ãƒ‡ãƒ«ã€ã‚¤ãƒ³ãƒ†ãƒ«ã€NTTãƒ‡ãƒ¼ã‚¿ãªã©å¤šãã®ä¼æ¥ãŒå‚åŠ ã—ã¦é–‹ç™ºãŒè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ ãã®OpenStackã§ã€ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã®æä¾›ã‚’ç›®æŒ‡ã™Database as a Serviceï¼ˆDaaSï¼‰ã®é–‹ç™ºãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã€ŒProject RedDwarfã€ãŒæ–°ãŸã«ç«‹ã¡ä¸ŠãŒã‚Šã¾ã—ãŸã€‚ ãƒ™ãƒ¼ã‚¹ã¯MySQLã‚’åˆ©ç”¨ DaaSã®ãƒ™ãƒ¼ã‚¹ã¨ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯MySQLã‚’æŽ¡ç”¨ã™ã‚‹ã¨ã®ã“ã¨ã§ã€Project RedDwarfã®å½“åˆã®è¨ˆç”»ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ã«èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ Initially, our
fumi1 2011/04/27
Cloud

DaaS

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