MySQL Forums
Forum List  »  General

Max 8 connections for a user?
Posted by: Jeremy Suiter
Date: March 23, 2017 09:42AM

Hi,

I'm using MySQL 5.6 CE and any user connecting to the database can only open 8 threads at a time. I've checked and the following variables are set:

max_connections = 200
thread_cache_size=0
thread_concurrency=0
innodb_thread_concurrency=0
User connection is set to 0 so not limited in number of connections it can make.

The app that connects in (Jasper Reports) is set to allow a thread pool of 100 and I cannot spot any other settings that would limit the number of threads to 8 for this user.

I really need some help in lookig at where the limit is.

Thanks

Jeremy

Options: ReplyQuote


Subject
Written By
Posted
Max 8 connections for a user?
March 23, 2017 09:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.