Ask Your Question


asked 2019-07-15 17:25:03 -0500

CaptinCCat gravatar image

Hi All,

I testing out some stuff for my company at this given moment. But i need to move multiple tables into one and i am using JDBC Multitable to do this. When i only have one table in the multi table i can transfer data just fine. However when i add more then one table im getting the ACQUIRED_RATE_LIMIT_PERMIT. Even thought i have no rate limit set.

If someone could help me with this, im not sure what is needed for the assistance, just let me know and i should be able to aquire it.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2019-07-18 15:41:59 -0500

jeff gravatar image

What do you have the "Queries Per Second" config option set to? In any event, ACQUIRED_RATE_LIMIT_PERMIT means that the thread has actually acquired the permit. It's not waiting (which would be called WAITING_FOR_RATE_LIMIT_PERMIT). How large are the tables? Do they have primary keys defined? What have you set the multithreading mode to, and the number of threads?

edit flag offensive delete link more


"Queries per Second": 10 --> Threads: 1 --> Table size: 176 million records total on Test DB, with 2mil records added per hour on production. --> Reading from 4 different tables --> It does work, just takes about 10-15min to get going --> And yes, to the primary Keys --> No Multithreading

CaptinCCat gravatar imageCaptinCCat ( 2019-07-26 09:04:57 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-15 17:25:03 -0500

Seen: 296 times

Last updated: Jul 18 '19