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
klrumpf@gmail.com
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, Karl

Sorry, 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