[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:14738

From: Hiroyuki Ogawa <Hiroyuki Ogawa <eng16danbo@xxxxxxxxxx>>
Date: Mon, 23 Feb 2009 13:40:06 +0900
Subject: [mysql 14738] Fwd: Re: Fwd: Re: Fwd: Re: [mysql cluster]sql¥Î¡¼¥É¤Î¹½ÃÛ

¤ªÀ¤ÏäˤʤäƤª¤ê¤Þ¤¹¡£
SHOW¤Î·ë²Ì¤ò˺¤ì¤Æ¤¤¤Þ¤·¤¿¤Î¤Ç¥á¡¼¥ë¤òÁ÷¤ê¤Þ¤¹¡£
¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¡£
[ndbd(NDB)] 2 node(s)
id=2    @xxxxxxxxxx (mysql-5.1.30 ndb-6.30.20, Nodegroup:0,Master)
id=3    @xxxxxxxxxx (mysql-5.1.30 ndb-6.30.20, Nodegroup:0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @xxxxxxxxxx (mysql-5.1.30 ndb-6.30.20)

[mysqld(API) 4node(s)
id=4 (not connected,accepting connect from 192.168.116.132)
id=5 (not connected,accepting connect from 192.168.116.133)
id=6 (not connected,accepting connect from any host)
id=7 (not connected,accepting connect from any host)
---------- žÁ÷¥á¥Ã¥»¡¼¥¸ ----------
From: Hiroyuki Ogawa <eng16danbo@xxxxxxxxxx>
ÆüÉÕ: 2009/02/23 12:45
·ï̾: Re: [mysql 14736] Re: Fwd: Re: Fwd: Re: [mysql cluster]sql¥Î¡¼¥É¤Î¹½ÃÛ
To: ml@xxxxxxxxxx


¤ªÀ¤ÏäˤʤäƤ¤¤Þ¤¹¡£
³Æ¼ï¥Õ¥¡¥¤¥ë¤ÎÀßÄê¤Ï°Ê²¼¤ÎÄ̤ê¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
¢£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]