MySQL Forums
Forum List  »  NDB clusters

Re: Sending data slow in NDB cluster compared to Innodb
Posted by: Mikael Ronström
Date: April 14, 2016 04:44PM

Hi,

Krishnachytanya Ayyagari Wrote:
-------------------------------------------------------
> Hi All,
> We are running two parallel environments. One with
> InnoDB & NBD cluster. Both these environments are
> running on Azure. Here are the details of NDB
> cluster.
>
> MySQL NDB Version: 7.4.10
> Distributed data nodes Cluster between two data
> center with 200 Mbps backup and latency/ttl is
> 40msec
> Ubuntu 14.04
> Storage ENgine: NDB
> SSD Drive
> Table Entries: 1 Lakh Rows
>
> Issue is response time for simple Select Query by
> selecting all column (instead of select *) is
> taking 5 Secs for of 1 Lakh rows table. For InnoDB
> it is taking 1.6 secs. Is this expected?
>
> Will NDB cluster takes more time for a select
> query than InnoDB? When we profile the query,
> sending data phase takes 5 secs in our case for
> NDB cluster compared to 1.6 secs on InnoDB.
>

When a query is executed towards InnoDB with small
amount of data then InnoDB also retrieves data from
memory. Also InnoDB is not a distributed database.

So NDB is sometimes faster than InnoDB but also
many times slower. NDB has more scalability since
it is distributed database, it can handle parallelism
in some queries and it is more highly available.

Most people choose using MySQL Cluster for reasons
of high availability and write scalability. But it
is also very capable in many select queries.

Rgrds Mikael


> Please help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Sending data slow in NDB cluster compared to Innodb
922
April 14, 2016 04:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.