maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxxx>]

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