On 11/10/2012 02:15 PM, Federico Razzoli wrote:

I am sure that MySQL had documentation about the optimizer, in dev.mysql.com. It was separated from the general documentation. It explained how the optimizer works and what it can optimize. But, I can't find it anymore. I found "MySQL Internals" http://dev.mysql.com/doc/internals/en/ using Google (but I can't see the link on their site) but it's not what I am looking for. Did Oracle removed it?

Federico Razzoli

See http://dev.mysql.com/doc/refman/5.6/en/optimization-internals.html

Regards, Igor

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

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