List:Cluster« Previous MessageNext Message »
From:Lukas Pecha Date:June 26 2009 1:35pm
Subject:Question about communication between mysqld and ndbd
View as plain text  
Hi,
I set up a small mysql-cluster configuration with two ndbd/API machines
- so there is ndbd and mysqld running on both of them. But I am not able
to find a way how to change a way the mysqld process communicates with
ndbd - it seems, that the machines are sending request to remote ndbd
(not local), so even not much complex queries take a long time (one
simple query with "order by" statement takes about 15 second and the
table has only about twenty thousand rows). When I kill one of the ndbd
processes, the query takes only 0,2 sec on the machine with both ndbd
and mysqld running and still 15 seconds on the other machine. When I
start it up again, both machines have again the response time about 15
seconds.

So my question is - is there a way, how to tell mysqld, that it should
use only local ndb daemon for querying? Or will this issue be resolved,
if I start using indexing  everywhere I could?

Thanks in advance
Lukas Pecha

Thread
Question about communication between mysqld and ndbdLukas Pecha26 Jun 2009
  • RE: Question about communication between mysqld and ndbdJeff Sturm26 Jun 2009
    • Re: Question about communication between mysqld and ndbdLukas Pecha26 Jun 2009
      • Re: Question about communication between mysqld and ndbdJonathan \"Jeb\" Miller26 Jun 2009
        • Re: Question about communication between mysqld and ndbdLukas Pecha2 Jul 2009
          • Re: Question about communication between mysqld and ndbdFrazer Clement2 Jul 2009