Skip to Content
0

Data Services Inserts into MySQL cloud instance (CloudSQL) are very slow

Apr 22 at 01:41 PM

44

avatar image
Former Member

Hi,

We are using Data Services 4.2sp8 to load data into MySQL in the cloud (CloudSQL in the google cloud). The insert rate is very low ~ 40 rows/sec through a single loader using the standard MySQL driver so is unusable. We believe this due to each insert being sent individually so having a call round trip overhead per insert row.

MySQL has a batch insert construct where multiple row values are supplied in a single call. Does anyone know if this can be configuration and used or indeed any other way to increase load throughput?

We have created manual load via a FF using MySQL's 'LOAD DATA LOCAL INFILE' which is not ideal requiring local storage space, configuration etc.

Thanks in advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arun Sasi Apr 23 at 12:20 PM
0

Not sure if the Cloud SQL(Database as a Service) Database service for MySQL is supported. As per the Product Availability attached are the Cloud platforms supported by Data Services

Regards

Arun Sasi


cloud.jpg (151.7 kB)
Share
10 |10000 characters needed characters left characters exceeded