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 :)