Ventuz connect MySql database sleep question

Q and A about functionality and how to solve a special task for your application.

Moderator: Support

Post Reply
BaldwinHu
Posts: 15
Joined: 21 Mar 2014, 03:41

Ventuz connect MySql database sleep question

Post by BaldwinHu » 05 Aug 2019, 15:30

Hi,everyone

Ihave question about ventuz connect MySql database

i want to get some data from Mysql in ventuz,so i use ventuz original node database to connect mysql and use query to select data,i can get the data easily,but it doesn't work a few munites.
I have chacked the mysql processlist by using navicat,there are 12 process sleep in there which all is come from my computer,i have used many mathed just like changed the wait_timeout and interactive_timeout to short,and changed the query node all different properties,but this question is still in there.

somebody can help me?

User avatar
cogitator
Posts: 13
Joined: 04 Mar 2016, 14:33

Re: Ventuz connect MySql database sleep question

Post by cogitator » 21 Aug 2019, 17:07

Hey,
sorry for this late response, but maybe it helps you anyway:

Depending on how your ventuz-patch is handling the connection-socket it could be that it reconnects often without closing the connections properly. This could lead to the problem that max_connections is reached very early and if interactive_timeout is set very high, queries will only be successful from time to time.
So you should checkout the max_connections Parameter as well

You could validate it by showing the mysql connections:

Code: Select all

show full processlist;
Show all configparameters concerning timeouts:

Code: Select all

show variables like "%timeout%";
Best
David

BaldwinHu
Posts: 15
Joined: 21 Mar 2014, 03:41

Re: Ventuz connect MySql database sleep question

Post by BaldwinHu » 09 Oct 2019, 10:17

hi,cogitator

i do this work by using ventuz node ,and i have tried every properties,and i have tried to changed interactive_timeout and max_connections too,but it doesn't work.
so i write C# in Ventuz by using MySql.Data.dll in the end,and this problem have solved.
thanks very much!

Post Reply