Hi, klrumpf! On Nov 15, klrumpf wrote:
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?
Not necessarily. If your MySQL connector library uses persistent connections, database connections aren't closed, but reused for new requests.
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.
That mariasql node binding uses our client library, but it can use MySQL server too, it does not require MariaDB on the server side. But, of course, if your application mainly uses synced queries, you probably won't benefit from the upgrade. Regards, Sergei