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?
Hello Ventuzians!
THE FORUMS ARE CLOSED!
Please join our discord server HERE!! << click me
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!
THE FORUMS ARE CLOSED!
Please join our discord server HERE!! << click me
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
Moderator: Support
Re: Ventuz connect MySql database sleep question
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:
Show all configparameters concerning timeouts:
Best
David
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;
Code: Select all
show variables like "%timeout%";
David
Re: Ventuz connect MySql database sleep question
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!
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!
Re: Ventuz connect MySql database sleep question
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!!
I have the same problem! Can you share your c# code? or your component?
I think may be a big contributtion,
Thanks very much!!