Hello Ventuzians!
THE FORUMS ARE CLOSED!

Please join our discord server HERE!! << click me :D

We are shutting our Ventuz Forum, but don't worry, it will all be archived for you to search in if you have a query. From now on, please add all your comments, questions or observations into our Discord Server

Thanks for the great time - see you on discord!!
Dee, Karol, Daniel and the whoooole Product and Support team!

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: 15
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!

pmunoz
Posts: 5
Joined: 17 Feb 2018, 10:22

Re: Ventuz connect MySql database sleep question

Post by pmunoz » 21 Oct 2021, 12:38

Hi Cogitator!

I have the same problem! Can you share your c# code? or your component?
I think may be a big contributtion,

Thanks very much!!

Post Reply