process missing from the processlist in external database when I run the Data Loading(RDBMS) activity

Avatar

Avatar

felixsongfei

Avatar

felixsongfei

felixsongfei

01-03-2021

I created a FDA connnection to a MySQL database. And then I use the activity "data loading(RDBMS)" to synchronize the data from the MySQL tables, the table has aout 30 million rows in it, after I run the activity for 10 mins, the SQL process in the MYSQL database missing from the processlist. How can I confirgure the FDA connnections and let the Adobe campaign can load the data from the external MySQL database?

 

felixsongfei_0-1614590337648.png

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

01-03-2021

Hi,

 

Try setting session max_execution_time to 0 in External Account's PostConnect script?

 

Thanks,

-Jon

Answers (1)

Answers (1)

Avatar

Avatar

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

10-03-2021

Hi @felixsongfei,

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!