Can not create a new thread (Can not create a new thread) Error 1135, MySQL, persistent connection

Navigation
0

It turns out that we are implementing a new data synchronization scheme in which each branch transmits the news by doing INSERT / UPDATE / DELETE.

The issue is that when there were few branches, there is no problem, but today among all the branches and work positions, there are more than 200 and the server pulls the error mentioned in the title.

What can be done to get around this problem?

The server is a Windows Server 2008, 8GB, and is usually at 10% CPU usage and 15% memory.

The system that transimite is developed in VB6 and makes a persistent connection.

    
asked by OTANO 03.04.2018 в 17:42
source

1 answer

0

Thanks to @Quinqui for the help, as you mentioned in your last comment, it seemed to be an operating system problem, and looking on the internet they said they fixed it by increasing the limit of threads for not super users, but this only in Linux. Windows does not have this problem, so I assumed that the error should be in MySQL:

It turns out that there is a parameter called open-files-limit

in my.ini we must add the line: 

[mysqld_safe]
open-files-limit=10240

Which increases the limit of open files and stops throwing the error.

I'm still proving no error, but I've already gone through a lot of simultaneous users connected and it has not given me an error.

    
answered by 03.04.2018 в 19:17
trigger in tables with foreign keys? The default constructor does not work for me (Relational Object Database)