im quite confused with the max cursor setting in "show parameters".

for example i set it at 3000. does this mean that each connection will have 3000 or a shared by different connectioN?

what if 2 applications uses the same user/pass, do they share with the 3000 or they have individual 3000 cursors?

thanks.