MySQL Connection stuck at 2% (writing to table)

Question

I have dataset which has 300,000 rows and I am trying to write it on a MySQL database but it is always getting stuck at 2% and its not going anywhere.

Then I broke the data down to 50k rows each and it took approx 8 mins to write data into MySQL table. I have 2 questions:

1) Is there a record limit to write to mysql table from alteryx?

2) is there a way to increase the speed?

shancmiralles · Accepted Answer

hi  @ushuja ,

1)In Alteryx, there isn't a strict, fixed limit on the number of records you can output to an SQL database, but there are practical constraints that may affect performance or cause issues based on your specific setup. These limits depend on a combination of factors, including the type of database you're writing to, your Alteryx configuration, and system resources.
2) you can try and optimize output via output data tool  ( max rows per insert to large value = ex: 10,000 - 50,000 ,  enable transaction mode if required for consistency(never have to use this but some people i know does this) , utilize bulk insert if DB supports it) ..
it's a case to case basis but i hope the above info helps a bit, goodluck!