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

nobusue id:nobusue

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

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

ç¬¬7å›žã€€Uberã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒãƒ–ãƒã‚°ã§PostgreSQLã«ãƒ€ãƒ¡å‡ºã—ã€PostgreSQLã‚³ãƒŸãƒƒã‚¿ãƒ¼çŸ³äº•é”å¤«æ°ã«åè«–ã‚’èžã | gihyo.jp
IT Cutting Edge â”€ä¸–ç•Œã‚’å¤‰ãˆã‚‹ãƒ†ã‚¯ãƒŽãƒã‚¸ã®æœ€å‰ç·š ç¬¬7å›žUberã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒãƒ–ãƒã‚°ã§PostgreSQLã«ãƒ€ãƒ¡å‡ºã—ã€PostgreSQLã‚³ãƒŸãƒƒã‚¿ãƒ¼çŸ³äº•é”å¤«æ°ã«åè«–ã‚’èžã ãƒ‡ã‚¸ã‚¿ãƒ«ãƒ‡ã‚£ã‚¹ãƒ©ãƒ—ã‚·ãƒ§ãƒ³ã‚’è±¡å¾´ã™ã‚‹ä¼æ¥ã¨ã—ã¦ã€ã„ã¾ã“ã®çž¬é–“ã‚‚ç ´ç«¹ã®å‹¢ã„ã§æˆé•·ã‚’ç¶šã‘ã€äº¤é€šã‚µãƒ¼ãƒ“ã‚¹ã®ä¸–ç•Œã‚’å¤§èƒ†ã«å¡—ã‚Šæ›¿ãˆã¦ã„ã‚‹Uberã€‚æœªä¸Šå ´ãªãŒã‚‰ã™ã§ã«ä¼æ¥ä¾¡å€¤ã¯6å…†å††ã‚’è¶…ãˆã¦ã„ã‚‹ã¨ã‚‚è¨€ã‚ã‚Œã¦ãŠã‚Šã€ä¸–ç•Œæœ€å¤§ã®ãƒ¦ãƒ‹ã‚³ãƒ¼ãƒ³ä¼æ¥ã¨ã—ã¦ã€ãã®å‹•å‘ã¯ã¤ãã«æ³¨ç›®ã•ã‚Œã¤ã¥ã‘ã¦ã„ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã‚„ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿åˆ†æžã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãªã©ã€æœ€å…ˆç«¯ã®ITã‚’ãƒ•ãƒ«æ´»ç”¨ã—ã€ã”ãçŸæœŸé–“ã§åŠ‡çš„ã«ãƒ“ã‚¸ãƒã‚¹ã‚’æ‹¡å¤§ã•ã›ãŸUberã«å¯¾ã—ã¦ã¯ã€ã‚„ã¯ã‚ŠæŠ€è¡“è€…ã‹ã‚‰ã®å¼·ã„é–¢å¿ƒãŒã‚ã¤ã¾ã‚Šã¾ã™ã€‚ç¾åœ¨ã€1200åã‚’è¶…ãˆã‚‹ã¨è¨€ã‚ã‚Œã‚‹Uberã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŸã¡ã¯ä½•ã‚’ã©ã‚“ãªç’°å¢ƒã§ä½¿ã„ã€ã©ã†å‹•ã‹ã—ã¦ã„ã‚‹ã®ã‹ â€•Uberã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒãƒ¼ãƒ ãŒå…¬é–‹ã—ã¦ã„ã‚‹æŠ€è¡“ãƒ–ãƒã‚°ã€ŒUb
nobusue 2016/08/09
ãã‚‚ãã‚‚RDBMSã‚’ä½¿ã†ã¹ããƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ãªã®ã‹ãŒç–‘å•

postgresql

MySQL

NoSQL
ãƒªãƒ³ã‚¯
[CentOS6] Postfixã«ã‚ˆã‚‹ãƒ¡ãƒ¼ãƒ«ã‚µãƒ¼ãƒæ§‹ç¯‰ ãã®2 (MySQLã®è¨å®šã¨postfixadminã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«) â€“ Rocky Linux ã‚µãƒ¼ãƒæ§‹ç¯‰è¡“ æ–‡å…·å ‚
[CentOS6] Postfixã«ã‚ˆã‚‹ãƒ¡ãƒ¼ãƒ«ã‚µãƒ¼ãƒæ§‹ç¯‰ ãã®1 (Postfixã‚’SRPMã‹ã‚‰ãƒªãƒ“ãƒ«ãƒ‰) [CentOS6] Postfixã«ã‚ˆã‚‹ãƒ¡ãƒ¼ãƒ«ã‚µãƒ¼ãƒæ§‹ç¯‰ ãã®2 (MySQLã®è¨å®šã¨postfixadminã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«) [CentOS6] Postfixã«ã‚ˆã‚‹ãƒ¡ãƒ¼ãƒ«ã‚µãƒ¼ãƒæ§‹ç¯‰ ãã®3 (Postfixã®è¨å®š) [CentOS6] Postfixã«ã‚ˆã‚‹ãƒ¡ãƒ¼ãƒ«ã‚µãƒ¼ãƒæ§‹ç¯‰ ãã®4 (Dovecotã®è¨å®š) URL: http:/www.example.com/postfixadmin/ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ä¿å˜å½¢å¼: dovecot CRAM-MD5å½¢å¼ æº–å‚™ ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®ä¿å˜ã«dovecotã®CRAM-MD5å½¢å¼ã‚’æŽ¡ç”¨ã—ã¦ã„ã‚‹ãŸã‚ã€postfixadminã§ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ç™»éŒ²ã‚„èªè¨¼ã«doveadmã‚³ãƒžãƒ³ãƒ‰ãŒå¿…è¦ã¨ãªã‚Šã¾ã™ã€‚ãã®ãŸã‚äº‹å‰ã«dovecotã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ãŠãã¾ã™ã€‚ yum i
nobusue 2015/04/06
postfix

dovecot

MySQL
ãƒªãƒ³ã‚¯
CentOS 6.5 ã«php5.5ã¨MySQL5.6ã‚’yumã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
nobusue 2015/03/06
CentOS

PHP

MySQL
ãƒªãƒ³ã‚¯
java-mysql-diff ãŒå‡ºãŸ - ãã®æ‰‹ã®å¹³ã¯å°»ã‚‚ã¤ã‹ã‚ã‚‹ã•
java-mysql-diff ãŒå‡ºã¾ã—ãŸï¼ŽMaven Central ã«ã‚‚ãƒªãƒªãƒ¼ã‚¹ã—ã¦ã„ã¾ã™ï¼Ž http://search.maven.org/#artifactdetails|net.moznion|mysql-diff|1.0.0| æœ¬ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¯ id:onishi ã•ã‚“ä½œã® mysqldiff ã® Java 8 ç§»æ¤ç‰ˆã§ã™ï¼Ž æœ€è¿‘ Java ã®ç’°å¢ƒã§ä½œæ¥ã™ã‚‹ã“ã¨ãŒå¤šã„ã®ã§ï¼Œãªã‚“ã ã‹ã‚“ã ã§ Java ç‰ˆãŒã‚ã‚‹ã¨ä¾¿åˆ©ã ã‚ˆãã€œã¨ã„ã†ã“ã¨ã§ä½œæˆã—ã¾ã—ãŸï¼Ž æœ¬å®¶ã® Perl ç‰ˆ mysqldiff ã¨åŒã˜ã‚ˆã†ãªæ„Ÿè¦šã§åˆ©ç”¨ã—ãŸã‹ã£ãŸã®ã§ï¼Œå…¨éƒ¨ã®ä¾å˜ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’1ã¤ã«ã¾ã¨ã‚ãŸ fat-jar ã‚‚ç”¨æ„ã—ã¦ã‚ã‚Šã¾ã™ï¼Ž java -jar ã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½™åˆ†ã«ã‚¿ã‚¤ãƒ—ã™ã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã™ãŒï¼ŒPerl ç‰ˆã¨åŒã˜ã‚ˆã†ãªæ„Ÿè¦šã§åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ï¼Ž https://github.com/moznion/j
nobusue 2015/01/03
Java

MySQL
ãƒªãƒ³ã‚¯
RDS ã§ GRANT ALL ã™ã‚‹ã¨ ERROR 1045 (28000): Access denied ãŒå‡ºã‚‹ - tkuchikiã®æ—¥è¨˜
è¡¨é¡Œã®é€šã‚Šã‚¨ãƒ©ãƒ¼ãŒã§ã‚‹ã€‚ èª¿æŸ»ã—ãŸçµæžœã€Using "GRANT ALL" With Amazon's MySQL RDS - fidian.com ã§è§£æ±ºã§ããŸã€‚ ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ GRANT ALL ON `%`.* TO ...; DB åã« % ã‚’ä½¿ãˆã°è‰¯ã„ã‚ˆã†ã ã€‚
nobusue 2014/12/04
AWS

RDS

MySQL
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ã‚ˆãä½¿ã†ã‚³ãƒžãƒ³ãƒ‰é›† - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
nobusue 2014/11/12
Linux

MySQL
ãƒªãƒ³ã‚¯
http://blog.tomoattori.info/article/18585618.html
nobusue 2014/08/20
./mysql/host.frm ãŒãªãœã‹rootã®æŒã¡ç‰©ã«ãªã£ã¦ãŸãƒ»ãƒ»ãƒ»

MySQL
ãƒªãƒ³ã‚¯
CentOSã«Mysqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã®ãƒ¡ãƒ¢
[root@localhost ~]# vi /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 #aracter-set = utf8<span>←コメントアウト</span>+ default-character-set=utf8<span>←追&#211
nobusue 2014/08/20
MySQL
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
12æœˆ3æ—¥éŸ“å›½ã«æˆ’åŽ³ä»¤ãŒå®£è¨€ã•ã‚ŒãŸã€‚ãã—ã¦å¯’ç©ºã®å…ƒã«å±Šã‘ã‚‰ã‚Œã‚‹ã‚³ãƒ¼ãƒ’ãƒ¼ã€‚ 12æœˆ3æ—¥22æ™‚åŠã”ã‚ã€ ã©ã†ã„ã†ã‚ã‘ã‹å°¹éŒ«æ‚¦å¤§çµ±é ˜ã«ã‚ˆã‚Šéžå¸¸æˆ’åŽ³ãŒå®£è¨€ã•ã‚ŒãŸã€‚ãã‚Œã«ã¤ã„ã¦ã€éŸ“å›½ã§ç”Ÿæ´»ã‚’ã™ã‚‹ç§ã®è¦–ç·šã§è¨˜éŒ²ã‚’ã—ã¦ãŠããŸã„ã¨æ€ã†ã€‚ä»Šé€±ã¯æ›¸ãã‹ã‘ã ã£ãŸé«˜é›„&å°å—æ—…è¡Œè¨˜ã‚’ã‚¹ã‚¿ãƒ¼ãƒˆã•ã›ãŸã‹ã£ãŸãŒã€å¾Œå›žã—ã«ã™ã‚‹ã€‚ ï¼ˆå†™çœŸã¯ä»Šå›žã®å¼¾åŠ¾ã‚’æ±‚ã‚ã‚‹ãƒ‡ãƒ¢ã§â€¦
nobusue 2014/08/20
MySQL
ãƒªãƒ³ã‚¯
http://blog.flatlabs.net/20100727_212649/
nobusue 2014/08/20
MySQL
ãƒªãƒ³ã‚¯
MySQLãƒã‚¤ãƒŠãƒªãƒã‚°ã®ä»•æ§˜ â€“ OpenGroove
MySQLã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã«ã¤ã„ã¦ã€ã†ã£ã™ã‚‰ã¾ã¨ã‚ã¦ã¿ã‚ˆã†ã‹ã¨ã€‚ RDBMSã§æ›´æ–°ãƒã‚°ã¾ãŸã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°ã¨å‘¼ã°ã‚Œã¦ã„ã‚‹ãƒã‚°ã®æ©Ÿèƒ½ã¯ã€ MySQLã§ã¯ã€Œãƒã‚¤ãƒŠãƒªãƒã‚°ã€ãŒæ‹…ã£ã¦ã„ã‚‹ã€‚ ã“ã‚Œã‚‰ã®å†…å®¹ã¯ã€ã€ŒCREATE TABLEæ–‡ã‚„INSERTæ–‡ã¨ã„ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸èº«ã‚’ å¤‰æ›´ã™ã‚‹æ“ä½œã‚’è¡Œã£ãŸéš›ã®æ“ä½œå±¥æ´ã‚’è¿½è·¡ã§ãã‚‹å½¢ã§è¨˜éŒ²ã—ãŸæƒ…å ±ã€ã§ã‚ã‚Šã€ ã‚³ãƒŸãƒƒãƒˆã•ã‚ŒãŸãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æƒ…å ±ãŒä¿å˜ã•ã‚Œã‚‹ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°ã®ä¸èº«ã¯RDBMSã«ã‚ˆã£ã¦ç•°ãªã‚Šã€ã€Œè«–ç†ãƒã‚®ãƒ³ã‚°ã€ã¨ ã€Œç‰©ç†ãƒã‚®ãƒ³ã‚°ã€ãŒã‚ã‚‹ã€‚ã€Œè«–ç†ãƒã‚®ãƒ³ã‚°ã€ã¯SQLæ–‡ãƒ¬ãƒ™ãƒ«ã§å¤‰æ›´å±¥æ´ã‚’ç®¡ç†ã—ã€ ã€Œç‰©ç†ãƒã‚®ãƒ³ã‚°ã€ã¯å¤‰æ›´ãŒã‚ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ–ãƒãƒƒã‚¯ã‚’ãƒã‚¤ãƒŠãƒªã‚¤ãƒ¡ãƒ¼ã‚¸ã¨ã—ã¦ç®¡ç†ã™ã‚‹ã€‚ MySQLã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã¯è«–ç†ãƒã‚®ãƒ³ã‚°ã ãŒã€Oracleã®REDOãƒã‚°ã‚„InnoDBãƒã‚°ã¯ ç‰©ç†ãƒã‚®ãƒ³ã‚°ã§ã‚ã‚‹ã€‚ ãƒã‚¤ãƒŠãƒªãƒã‚°ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ä½œæˆã•ã‚Œãªã„ã®ã§ã€my.c
nobusue 2014/08/20
MySQL
ãƒªãƒ³ã‚¯
MySQLã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’latin1ã‹ã‚‰utf8ã¸å¤‰æ›´ã™ã‚‹ã€‚ | 514design
514design website is maintenance now. See you soon.
nobusue 2014/07/30
MySQL
ãƒªãƒ³ã‚¯
Monitoring MySQL with OpenTSDB
A monitoring system is arguably the most crucial system to have in place when administering and tweaking the performance of any database system. DBAs also find themselves with a variety of monitoring systems and plugins to use; ranging from small scripts in cron to complex data collection systems. In this talk, Iâ€™ll discuss how Box made a shift from the Cacti monitoring system and other various sh
nobusue 2014/07/24
OpenTSDB

MySQL
ãƒªãƒ³ã‚¯
Dockerã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨MySQLã‚’ã‚³ãƒ³ãƒ†ãƒŠåŒ–ã—ã¦Redmineã‚’æ§‹ç¯‰ã™ã‚‹ - hidemium's blog
Dockerã®å…¬å¼ãƒªãƒã‚¸ãƒˆãƒªã«sameersbn/redmineã¨ã„ã†Redmineã®ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒã‚ã£ãŸã®ã§è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ ã“ã®ã‚¤ãƒ¡ãƒ¼ã‚¸ã®é¢ç™½ã„ã¨ã“ã‚ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã ã‘ã§ãªããƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚ã‚³ãƒ³ãƒ†ãƒŠã«ã—ã€ã•ã‚‰ã«ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚³ãƒ³ãƒ†ãƒŠã‹ã‚‰åˆ†é›¢ã—ã¦ã‚‹ã¨ã“ã‚ã§ã™ã€‚ æ§‹æˆ Ubuntu 12.04: Docker 0.10.0ã€Redmine 2.5.1ã€MySQL 5.6 â€»ä¸Šè¨˜ã®ã‚µãƒ¼ãƒã¯VMware ESXi 5.1ä¸Šã§å‹•ä½œã—ã¦ã„ã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« MySQL ã¾ãšã¯ã€ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã§MySQLã®ã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚ $ sudo docker pull sameersbn/mysql:latestæ¬¡ã«MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ãƒ›ã‚¹ãƒˆå´ã§ä¿å˜ã™ã‚‹ãŸã‚ã€ãƒ›ã‚¹ãƒˆå´ã§ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ä½œæˆã—ã¾ã™ã€‚ $ sudo mkdir -p /opt/mysql/datadocker run
nobusue 2014/06/17
ãã†ã‹ã€MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã ã‘ãƒ›ã‚¹ãƒˆOSä¸Šã«ç½®ã‘ã°ã„ã„ã®ã‹!

redmine

docker

MySQL
ãƒªãƒ³ã‚¯
H2ã®MODEã‚ªãƒ—ã‚·ãƒ§ãƒ³ - ãŸã‘ãžã†ç€•æ»ãƒ–ãƒã‚°
æ˜¨æ—¥ã€åŒåƒšã«H2ã®JDBC URLã«ã€Œ;MODE=MySQLã€ã®ã‚ˆã†ã«ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ä»˜ã‘ã‚‹ã“ã¨ã§H2ã®æŒ™å‹•ã‚’MySQLé¢¨ã€PostgreSQLé¢¨ã€Oracleé¢¨ãªã©ã®ã‚ˆã†ã«åˆ‡ã‚Šæ›¿ãˆã‚‹ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ã“ã¨ã‚’æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚H2ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã§ã¯ä»¥ä¸‹ã®ã‚ãŸã‚Šã«æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ http://www.h2database.com/html/features.html#compatibility ã€Œãªã€ãªã‚“ã ã£ã¦ãƒ¼ï¼ï¼ã€ã¨ã„ã†ã“ã¨ã§å®Ÿéš›ã©ã®ã‚ˆã†ã«åˆ‡ã‚Šæ›¿ã‚ã‚‹ã®ã‹ã‚½ãƒ¼ã‚¹ã‚’è¦‹ã¦ã¿ã¾ã—ãŸã€‚ org.h2.engine.Modeã§ä»¥ä¸‹ã®ã‚ˆã†ãªæ„Ÿã˜ã§å®šç¾©ã•ã‚Œã¦ã„ã¾ã™ã€‚ mode = new Mode("MySQL"); mode.convertInsertNullToZero = true; mode.indexDefinitionInCreateTable = true; mode.lowerCaseI
nobusue 2014/06/04
H2

MySQL
ãƒªãƒ³ã‚¯
WebScaleSQL | "We're Gonna Need A Bigger Database"
What is WebScaleSQL? WebScaleSQL is a collaboration among engineers from several companies that face similar challenges in running MySQL at scale, and seek greater performance from a database techno logy tailored for their needs. Our goal in launching WebScaleSQL is to enable the scale-oriented members of the MySQL community to work more closely together in order to prioritize the aspects that are
nobusue 2014/03/28
WebScaleSQL

MySQL
ãƒªãƒ³ã‚¯
ãƒ ãƒƒã‚¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾¹åº•æ”»ç•¥ã€ - MySQL/Redis/MongoDB/Redshift
æœ€è¿‘ç™ºå£²ã•ã‚ŒãŸæŠ€è¡“è©•è«–ç¤¾ã®ãƒ ãƒƒã‚¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾¹åº•æ”»ç•¥ã€ã«å¯„ç¨¿ã—ã¾ã—ãŸã€‚ ã“ã®æœ¬ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãŸã‚ã®æœ¬ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€SQLã€MySQLã€Redisã€Mongo DBã€Redshiftã¨ã„ã†ä»£è¡¨çš„ãªè¦ç´ æŠ€è¡“ã«ã¤ã„ã¦ã®ã¾ã¨ã‚ã¨ãªã£ã¦ã„ã¾ã™ã€‚å„ãƒ—ãƒãƒ€ã‚¯ãƒˆ(MySQLã€Redisã€Mongo DBã€Redshift)ã«ã¤ã„ã¦ã¯ã€ç¾å ´ã§å®Ÿéš›ã«æœ¬æ ¼çš„ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹æ–¹ã€…ã«ã‚ˆã‚‹è¨˜äº‹ãªã®ã§å¤§ã„ã«å‚è€ƒã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç§ã¯å†’é ã®ã¾ã¨ã‚è¨˜äº‹ã‚’å¯„ç¨¿ã—ã¾ã—ãŸã€‚è©³ç´°ã¯ãœã²ãŠæ‰‹ã«å–ã£ã¦èªã‚“ã§ãã ã•ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ã“ã“ã§ã‚‚è‡ªåˆ†ãŒå„æŠ€è¡“ã‚’ç¾æ™‚ç‚¹ã§ã©ã®ã‚ˆã†ã«ã¨ã‚‰ãˆã¦ã„ã‚‹ã‹ã€æœ¬ã§ã¯ã„ã•ã•ã‹æ›¸ãã¥ã‚‰ã„å†…å®¹ã«ã¤ã„ã¦ã€æœ€è¿‘æµè¡Œã‚Šã®è¨€è‘‰ã§ã‚‚ã‚ã‚‹ã€ŒæŠ€è¡“çš„è² å‚µã€ã¨ã„ã†è¦³ç‚¹ã‚‚è¸ã¾ãˆã¦æ›¸ã„ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ ãƒ»MySQL (RDBMS) ç§ã¯MySQLã®ä¸ã®äººã§ã‚‚ã‚ã‚Šã¾ã—ãŸã—ã€ã“ã‚Œã¾ã§è‡³ã‚‹ã¨ã“ã‚ã§è©±ã—ã¦ããŸã®ã§çœç•¥ã—ã¾ã™
nobusue 2014/03/25
MySQL

Redis

mongodb

Redshift
ãƒªãƒ³ã‚¯
JNDI_MySQL - Manjyu Wiki - Manjyu - OSDN
Cambios recientes2012-11-06FrontPage 2012-10-17Facelets 2012-09-25Facelets_Dialog 2012-08-20Facelets_Xhtml Facelets_Download Facelets_Upload Ãšltimos archivo liberadosmanjyu (manjyu-0.0.9)2012-11-21 21:12 Wiki GuideWiki Syntax Wiki Links Block Processor Plugins Sidebar SidebarAcerca de Sidebar EdiciÃ³n de Sidebar JDBC Driver for MySQL (Connector/J) ãŠã™ã™ã‚è¨å®šä½¿ã„æ–¹MySQL ã®ã€ŒJDBC Driver for MySQL (Connector/J
nobusue 2014/03/04
ã‚ã‚“ã¾ã‚ŠMySQLä½¿ã‚ãªã„ã®ã§çŸ¥ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ã€‚ã€‚

MySQL

Java
ãƒªãƒ³ã‚¯
MariaDBã®JDBCãƒ‰ãƒ©ã‚¤ãƒã¯useCursorFetchãŒã§ããªã„ - ãŠã£ã•ã‚“ãƒ—ãƒã‚°ãƒ©ãƒžã®æˆ¯ã‚Œè¨€
MariaDB 5.5 MariaDB Java Client 1.1.5 ä»Šå¹´ã®å¤é ƒã‹ã‚‰MariaDBã‚’ä½¿ã£ã¦ã„ã‚‹ã€‚ ä»Šã®ã¨ã“ã‚ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¯ä¸»ã«Javaãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã‚‹ã€‚ ã“ã®æ•°ãƒ¶æœˆé–“ã€MariaDBã«ã¯é©šã‹ã•ã‚Œã¦ã°ã‹ã‚Šã ã€‚ éé‡ã—ãŸã™ã¹ã¦ã®çŠ¶æ³ã‚’è¨˜äº‹ã«ã™ã‚‹ã“ã¨ã¯ç¾çŠ¶ã§ãã¦ã„ãªã„ãŒã€å°å‡ºã—ã«ãªã£ã¦ã—ã¾ã†ã«ã›ã‚ˆã€ãã®ã†ã¡æ™‚é–“ã‚’è¦‹ã¤ã‘ã¦è¨˜è¼‰ã™ã‚‹ã¤ã‚‚ã‚Šã§ã„ã‚‹ã€‚ ä¾‹ãˆã°ã€ã“ã‚“ãªã“ã¨ãŒã‚ã£ãŸã€‚ ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«åãªã©ã®è˜åˆ¥åã®å¤§æ–‡å—å°æ–‡å—ã‚’ã€ŒåŒºåˆ¥ã™ã‚‹ã€ ãƒ»ã—ã‹ã‚‚ã€Windowsã¨OS Xã§ã¯è˜åˆ¥åã®å¤§æ–‡å—å°æ–‡å—ã‚’ã€ŒåŒºåˆ¥ã—ãªã„ã€ ãƒ»VARCHARåž‹ã®å¤§æ–‡å—å°æ–‡å—ã‚’ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã€ŒåŒºåˆ¥ã—ãªã„ã€ ãƒ»DATETIMEåž‹ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã«NOW()ã‚’æŒ‡å®šã§ããªã„ ãƒ»TIMESTAMPåž‹ã®æ‰±ã„ãŒã‚„ã‚„ã“ã—ã„ ãƒ»è¡Œãƒãƒƒã‚¯ã®æŒ™å‹•ãŒæ™®é€šã˜ã‚ƒãªã„ ãªã©ãªã©ã€‚ ä¸Šã«æŒ™ã’ãŸã™ã¹ã¦ã®ã“ã¨ã¯ã€MariaDBã¨ã„ã†ã‚ˆã‚Šã‚‚ã€MySQLã®ä»•
nobusue 2014/03/04
MySQL5.0.2ä»¥é™ãªã‚‰useCursorFetchãŒä½¿ãˆã‚‹ã¿ãŸã„ ãŸã ã—MariaDBã¯é™¤ã

MySQL

MariaDB

Java
ãƒªãƒ³ã‚¯
How to read row-by-row from a large MySQL table into Java, without running out of memory
nobusue 2014/03/04
MySQLã®JDBCãƒ‰ãƒ©ã‚¤ãƒã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå…¨ä»¶fetchãªã®ã§æ³¨æ„ã€ã¨ã„ã†è©±

MySQL

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