mysql:14737
From: Hiroyuki Ogawa <Hiroyuki Ogawa <eng16danbo@xxxxxxxxxx>>
Date: Mon, 23 Feb 2009 12:45:16 +0900
Subject: [mysql 14737] Re: Fwd: Re: Fwd: Re: [mysql cluster]sql¥Î¡¼¥É¤Î¹½ÃÛ
¤ªÀ¤ÏäˤʤäƤ¤¤Þ¤¹¡£ ³Æ¼ï¥Õ¥¡¥¤¥ë¤ÎÀßÄê¤Ï°Ê²¼¤ÎÄ̤ê¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£ ¢£config.ini¤ÎÆâÍƤˤĤ¤¤Æ [ndbd default] NoOfReplicas= 2 MaxNoOfConcurrentOperations= 10000 DataMemory= 80M IndexMemory= 24M TimeBetweenWatchDogCheck= 30000 DataDir= /var/lib/mysql-cluster MaxNoOfOrderedIndexes= 512 [ndb_mgmd default] DataDir= /var/lib/mysql-cluster [ndb_mgmd] Id=1 HostName= 192.168.116.128 [ndbd] Id= 2 HostName= 192.168.116.129 [ndbd] Id= 3 HostName= 192.168.116.131 [mysqld] Id= 4 HostName= 192.168.116.132 [mysqld] Id= 5 HostName= 192.168.116.133 [mysqld] Id= 6 [mysqld] Id= 7 ¢£sql¥Î¡¼¥É¤Îmy.cnf¤ÎÀßÄê¤Ë¤Ä¤¤¤Æ ¡/usr/share/doc/my-large.cnf¤ò/etc/my.cnf¤Ë¥³¥Ô¡¼ ¢my.cnf¤Î[mysqld]¤Ë°Ê²¼¤òÄɲà ndbcluster ndb-connectstring = 192.168.116.128 ¢£¥¨¥é¡¼¥í¥°¤Ë¤Ä¤¤¤Æ ¡Ê¥Û¥¹¥È̾).err¤Ï°Ê²¼¤ÎÄ̤ê¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£ 090223 12:03:06 [Note] /usr/sbin/mysqld: Normal shutdown 090223 12:03:06 [Note] Event Scheduler: Purging the queue. 0 events 090223 12:03:06 InnoDB: Starting shutdown... 090223 12:03:07 InnoDB: Shutdown completed; log sequence number 0 46409 090223 12:03:07 [Note] /usr/sbin/mysqld: Shutdown complete 090223 12:03:07 mysqld_safe mysqld from pid file /var/lib/mysql/als803.pid ended 090223 12:03:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 090223 12:03:39 InnoDB: Started; log sequence number 0 46409 090223 12:03:39 [Note] Event Scheduler: Loaded 0 events 090223 12:03:39 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.30-ndb-6.3.20-cluster-gpl' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Cluster Server (GPL) °Ê¾å¡¢²óÅú¤¬ÃÙ¤¯¤Ê¤Ã¤Æ¤·¤Þ¤¤¡¢¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¤¬¤è¤í¤·¤¯¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£ 2009/02/23 10:27 Mikiya Okuno <Mikiya.Okuno@xxxxxxxxxx>: > ¤ª¤Ï¤è¤¦¤´¤¶¤¤¤Þ¤¹¡£ > > config.ini > my.cnf > SHOW¤Î½ÐÎÏ > ¥¨¥é¡¼¥í¥° > > ¤¢¤¿¤ê¤Ï¤É¤¦¤Ê¤Ã¤Æ¤¤¤Þ¤¹¤«¡© > -- > Mikiya Okuno, MySQL Support Engineer > Sun Microsystems KK, Tokyo, Japan > http://www-jp.mysql.com/ > > On 20/02/2009, at 7:50 PM, Hiroyuki Ogawa wrote: > > > ´ÉÍý¥Î¡¼¥É¤È¥Ç¡¼¥¿¥Î¡¼¥É¡¢¤ª¤è¤ÓSQL¥Î¡¼¥É¤Ï°Ê²¼¤Î¥µ¥¤¥È¤ò»²¹Í¤·¤Þ¤·¤¿¡£ > > http://blog.technology-knowledge.jp/2008/04/16/120/ > > http://blog.technology-knowledge.jp/2008/04/16/122/ > > http://blog.technology-knowledge.jp/2008/04/16/124/ > > > > ndb_mgm>show¤ò¼Â¹Ô¤·¤¿¤È¤¡¢¥¹¥Æ¡¼¥¿¥¹¤ò³Îǧ¤¹¤ë¤È > > ´ÉÍý¥Î¡¼¥É¤È¥Ç¡¼¥¿¥Î¡¼¥É¤ÎÀßÄê¤Ï¤¢¤Ã¤Æ¤¤¤ë¤è¤¦¤Ë»×¤¨¤Þ¤¹¡£ > > > > ʳƮ¤·¤Æ¤¤¤Þ¤¹¤¬SQL¥Î¡¼¥É¤ÎÀßÄê¼ê½ç¤¬¤ï¤«¤ê¤Þ¤»¤ó¡£ > > ¾Ò²ð¤·¤Æ¤¤¤¿¤À¤¤¤¿¥µ¥¤¥È¤ò»²¹Í¤Ë¤·¤Æ¤â¾õ¶·¤ÏÊѤï¤ê¤Þ¤»¤ó¡£ > > ¤É¤Ê¤¿¤«¡¢ÀßÄê¼ê½ç¤Ë¤Ä¤¤¤Æ¤´¶µ¼ø´ê¤¤¤Þ¤¹¡£ > > ---------- žÁ÷¥á¥Ã¥»¡¼¥¸ ---------- > > From: Mikiya Okuno <Mikiya.Okuno@xxxxxxxxxx> > > ÆüÉÕ: 2009/02/20 18:56 > > ·ï̾: [mysql 14734] Re: Fwd: Re: [mysql cluster]sql¥Î¡¼¥É¤Î¹½ÃÛ > > To: ml@xxxxxxxxxx > > > > > > ¤³¤ó¤Ð¤ó¤Ï¡£ > > > > ¤½¤Î¼ê½ç¤À¤È¡¢´ÉÍý¥Î¡¼¥É¤ä¥Ç¡¼¥¿¥Î¡¼¥É¤ÎÀßÄ꤬¤Þ¤À¤Ê¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£ > > ÀßÄê¤Î¼ê½ç¤ò°ÊÁ°ThinkIT¤ËÅê¹Æ¤·¤¿¤Î¤Ç¤³¤ÎÊÕ¤òÆɤó¤ÇÀßÄꤷ¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£ > > http://www.thinkit.co.jp/article/95/ > > > > > ¤³¤ì¤é¤ÏMySQL Server¤Î¥Ñ¥Ã¥±¡¼¥¸¤È¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¤Ï > > > Ʊ¤¸¤Ê¤Î¤Ç¤·¤ç¤¦¤«¡£ > > > > MySQL Cluster¤¬Æþ¤Ã¤Æ¤¤¤ë°Ê³°¤ÏƱ¤¸¤Ç¤¹¡£ > > > > ¤Ç¤ÏÎɤ¤½µËö¤ò¡ª > > -- > > ±üÌî ´´Ìé > > MySQL¥µ¥Ý¡¼¥È¥¨¥ó¥¸¥Ë¥¢ > > ¥µ¥ó¡¦¥Þ¥¤¥¯¥í¥·¥¹¥Æ¥à¥º³ô¼°²ñ¼Ò > > http://www-jp.mysql.com/ > > > > MySQL¥Ö¥í¥°½¸Ìó¥µ¥¤¥È¡ÖPlanet MySQL¡×ÆüËܸìÈÇ¥ª¡¼¥×¥ó¡ª > > http://jp.planetmysql.org/ > > > > > > > > >
@ 14730 2009-02-20 16:57 [Hiroyuki Ogawa <eng1] [mysql cluster]sql¥Î¡¼¥É¤Î¹½ÃÛ @ 14731 2009-02-20 17:00 ¨²[Hiroyuki Ogawa <eng1] Fwd: [mysql cluster]sql¥Î¡¼¥É¤Î¹½ÃÛ 14732 2009-02-20 17:11 ¨±[Mikiya Okuno <Mikiya] @ 14733 2009-02-20 18:46 ¡¡¨±[Hiroyuki Ogawa <eng1] Fwd: Re: [mysql cluster]sql¥Î¡¼¥É¤Î¹½ÃÛ 14734 2009-02-20 18:56 ¡¡¡¡¨±[Mikiya Okuno <Mikiya] @ 14735 2009-02-20 19:50 ¡¡¡¡¡¡¨±[Hiroyuki Ogawa <eng1] Fwd: Re: Fwd: Re: [mysql cluster]sql¥Î¡¼¥É¤Î¹½ÃÛ 14736 2009-02-23 10:27 ¡¡¡¡¡¡¡¡¨±[Mikiya Okuno <Mikiya] -> @ 14737 2009-02-23 12:45 ¡¡¡¡¡¡¡¡¡¡¨±[Hiroyuki Ogawa <eng1] @ 14738 2009-02-23 13:40 ¡¡¡¡¡¡¡¡¡¡¡¡¨±[Hiroyuki Ogawa <eng1] Fwd: Re: Fwd: Re: Fwd: Re: [mysql cluster]sql¥Î¡¼¥É¤Î¹½ÃÛ 14739 2009-02-24 14:48 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±[Mikiya Okuno <Mikiya] @ 14756 2009-03-04 19:30 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±[Hiroyuki Ogawa <eng1]