MySQL中IN和NOT IN的大小限制是多少？

I get out of memory exception in my application, when the condition for IN or NOT IN is very large. I would like to know what is the limitation for that. I get out of memory exception in my application