List:Cluster« Previous MessageNext Message »
From:Stewart Smith Date:January 14 2010 7:14am
Subject:Re: Time difference between MySQL Cluster create table and other
storage engines
View as plain text  
On Sat, Jan 09, 2010 at 01:01:19AM -0500, Manasi Save wrote:
> There is a big time difference between the creation of table on different storage
> engines. and I am unable to trace the problem:
> 
> When I am creating those tables with MyIsAm :- It is taking 0.12 Sec
> When I am creating those tables with InnoDB :- It is taking 0.42 Sec
> and When I am creating those tables with NDB :- It is taking 4.25 Sec
> 
> Is it because ndb is giving me response after it writes the same create table
> statement on both the data nodes. 

NDB makes sure the data dictionary is in sync on all nodes (2 phase
commit) as well as waiting for a GCP (Global Checkpoint).

Theoretically we could now do the multiple table creation in a single
metadata transaction.... but the SQL layer is the bottleneck there :)

-- 
Stewart Smith
Thread
Time difference between MySQL Cluster create table and otherstorage enginesManasi Save9 Jan
  • Re: Time difference between MySQL Cluster create table and otherstorage enginesAndrew Hutchings9 Jan
    • Re: Time difference between MySQL Cluster create table and otherstorage enginesMatthew Montgomery9 Jan
  • Re: Time difference between MySQL Cluster create table and otherstorage enginesStewart Smith14 Jan