Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 23 at 12:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded