why infinidb slow than mysql when I insert data

2 posts / 0 new
Last post
perlish
perlish's picture
Offline
Last seen: 1 year 4 months ago
Joined: Mar 14 2013
Junior Boarder

Posts: 2

cuen ming
why infinidb slow than mysql when I insert data

Why infinidb slow than mysql when I insert 1M records to them in the same box ?

for mysql:
Server version: 5.1.67 Source distribution
Query OK, 1051492 rows affected (2.91 sec)
Records: 1051492 Duplicates: 0 Warnings: 0

for infinidb:
Server version: 5.1.39 MySQL Community / Calpont InfiniDB Community 2.2.11-1 Final (COSS LA)
Query OK, 1051492 rows affected (4.72 sec)
Records: 1051492 Duplicates: 0 Warnings: 0

sanjv
sanjv's picture
Offline
Last seen: 2 weeks 2 days ago
Joined: Mar 10 2010
Junior Boarder

Posts: 10

Sanjay Vekaria
Re: why infinidb slow than mysql when I insert data

Are you inserting using the included cpimport tool?