|
It's not timeoutd, I think
the DB connections from the webpage are not getting closed correctly for some reason, the c application that uses the same DB opens and closes them when you leave the programs. Will also try access simply with a different user from the web app and review my code. MariaDB [bodywrappers]> show processlist; +------+-------------+-----------------+--------------+---------+------+-------+------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +------+-------------+-----------------+--------------+---------+------+-------+------------------+----------+ | 6248 | userpt18z97 | localhost | bodywrappers | Query | 0 | NULL | show processlist | 0.000 | | 6249 | userpt18z97 | localhost | bodywrappers | Sleep | 74 | | NULL | 0.000 | | 6251 | userpt18z97 | localhost:35025 | bodywrappers | Sleep | 23 | | NULL | 0.000 | | 6252 | userpt18z97 | localhost:35026 | bodywrappers | Sleep | 23 | | NULL | 0.000 | | 6253 | userpt18z97 | localhost:35027 | bodywrappers | Sleep | 18 | | NULL | 0.000 | | 6254 | userpt18z97 | localhost:35028 | bodywrappers | Sleep | 18 | | NULL | 0.000 | | 6255 | userpt18z97 | localhost:35029 | bodywrappers | Sleep | 12 | | NULL | 0.000 | | 6256 | userpt18z97 | localhost:35030 | bodywrappers | Sleep | 12 | | NULL | 0.000 | +------+-------------+-----------------+--------------+---------+------+-------+------------------+----------+ 8 rows in set (0.00 sec) 6248=open command line query 6249= open C program, it corectly disappear when leaving the app 6251-6256= various q. from the web app, should they not disappear, too? As to the MariaSQL lib for node thanks for the info. For the moment I have to hang on to node-mysql because I have to leave the back door open to mysql because of the other applications. Most of the queries are nested synced anyway because of the nature of the program logic (stock control) but in the future I will definitely look at this lib. Thanks for the great job with MariaDB! Karl Karl-L. Rumpf [email protected] Málaga, Spain On 07/11/12 20:46, Sergei Golubchik wrote: Hi, Karl!On Nov 06, klrumpf wrote:Hi list, I have newbeeish question, I have just changed from MySQL to MariaDB in production. This gets accessed from Nodejs and from a 4GL/C application, both assume it is MySQL. When I log in with several SSH sessions at the same time from the 4GL/C app under the same user the DB suddenly hangs up, this did not happen before. Where would I configure this to correct? Debian Wheezy 3.2.0-3-amd64 MariaDB5.5 Any other parameters I should check? Thanks, KarlSorry, I cannot think of anything specific. There are no changes in MariaDB as compared to MySQL that might've caused it. You can compare the config files to make sure it's not a configuration change. By the way - unrelated comment - you've mentioned node.js. Do you use https://npmjs.org/package/mariasql ? If you haven't heard about it, see the page and see the benchmarks. Regards, Sergei |
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
