Hi, there is any way to chnage the default querytimeout for a user?... i need to use this to make a restriction for long querys, if i run call sys.settimeout(1) this change is only apllied to the current session and if i login again with the same user the timeout is not longer applied. +---------+-----------------+------+------------------+------+-------+ | user | login | sess | lastcommand | quer | activ | : : : iont : : ytim : e : : : : imeo : : eout : : : : : ut : : : : +=========+=================+======+==================+======+=======+ | monetdb | 2017-02-03 19:1 | 0 | 2017-02-03 19:13 | 1 | true | : : 2:37.000000 : : :28.000000 : : : | monetdb | 2017-02-03 18:0 | 0 | 2017-02-03 18:10 | 0 | false | : : 9:47.000000 : : :18.000000 : : : | monetdb | 2017-02-03 19:1 | 0 | 2017-02-03 19:13 | 0 | false | : : 3:10.000000 : : :12.000000 : : : +---------+-----------------+------+------------------+------+-------+ Thanks Sebastián Acevedo
Hi Indeed, logging the queries is a client/session specific action. To capture all interactions for pos-session analysis, you can consider using the stethoscope[1] regards, Martin [1] https://www.monetdb.org/Documentation/Manuals/MonetDB/Profiler/Stethoscope On 03/02/2017 20:15, Sebastián Acevedo wrote:
Hi, there is any way to chnage the default querytimeout for a user?... i need to use this to make a restriction for long querys, if i run call sys.settimeout(1) this change is only apllied to the current session and if i login again with the same user the timeout is not longer applied.
+---------+-----------------+------+------------------+------+-------+ | user | login | sess | lastcommand | quer | activ | : : : iont : : ytim : e : : : : imeo : : eout : : : : : ut : : : : +=========+=================+======+==================+======+=======+ | monetdb | 2017-02-03 19:1 | 0 | 2017-02-03 19:13 | 1 | true | : : 2:37.000000 : : :28.000000 : : : | monetdb | 2017-02-03 18:0 | 0 | 2017-02-03 18:10 | 0 | false | : : 9:47.000000 : : :18.000000 : : : | monetdb | 2017-02-03 19:1 | 0 | 2017-02-03 19:13 | 0 | false | : : 3:10.000000 : : :12.000000 : : : +---------+-----------------+------+------------------+------+-------+
Thanks
Sebastián Acevedo _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Thanks, stethoscope is very usefull to analyze the querys, but i need to restrict the querys that are taking a lot of time in the system , is there any way to set the querytimeout to a default value for a specific session or for all the users or something like that?. Most of the users are making connections using jdbc and i need to restrict the querytimeout for them. El 2017-02-04 04:15, Martin Kersten escribió:
Hi
Indeed, logging the queries is a client/session specific action. To capture all interactions for pos-session analysis, you can consider using the stethoscope[1]
regards, Martin [1] https://www.monetdb.org/Documentation/Manuals/MonetDB/Profiler/Stethoscope
On 03/02/2017 20:15, Sebastián Acevedo wrote:
Hi, there is any way to chnage the default querytimeout for a user?... i need to use this to make a restriction for long querys, if i run call sys.settimeout(1) this change is only apllied to the current session and if i login again with the same user the timeout is not longer applied.
+---------+-----------------+------+------------------+------+-------+ | user | login | sess | lastcommand | quer | activ | : : : iont : : ytim : e : : : : imeo : : eout : : : : : ut : : : : +=========+=================+======+==================+======+=======+ | monetdb | 2017-02-03 19:1 | 0 | 2017-02-03 19:13 | 1 | true | : : 2:37.000000 : : :28.000000 : : : | monetdb | 2017-02-03 18:0 | 0 | 2017-02-03 18:10 | 0 | false | : : 9:47.000000 : : :18.000000 : : : | monetdb | 2017-02-03 19:1 | 0 | 2017-02-03 19:13 | 0 | false | : : 3:10.000000 : : :12.000000 : : : +---------+-----------------+------+------------------+------+-------+
Thanks
Sebastián Acevedo _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Yes, see sql/scripts/15_querylog.sql create procedure sys.querylog_enable(threshold smallint) external name sql.querylog_enable_threshold; On 08/02/2017 20:06, Sebastián Acevedo wrote:
Thanks, stethoscope is very usefull to analyze the querys, but i need to restrict the querys that are taking a lot of time in the system , is there any way to set the querytimeout to a default value for a specific session or for all the users or something like that?. Most of the users are making connections using jdbc and i need to restrict the querytimeout for them.
El 2017-02-04 04:15, Martin Kersten escribió:
Hi
Indeed, logging the queries is a client/session specific action. To capture all interactions for pos-session analysis, you can consider using the stethoscope[1]
regards, Martin [1] https://www.monetdb.org/Documentation/Manuals/MonetDB/Profiler/Stethoscope
On 03/02/2017 20:15, Sebastián Acevedo wrote:
Hi, there is any way to chnage the default querytimeout for a user?... i need to use this to make a restriction for long querys, if i run call sys.settimeout(1) this change is only apllied to the current session and if i login again with the same user the timeout is not longer applied.
+---------+-----------------+------+------------------+------+-------+ | user | login | sess | lastcommand | quer | activ | : : : iont : : ytim : e : : : : imeo : : eout : : : : : ut : : : : +=========+=================+======+==================+======+=======+ | monetdb | 2017-02-03 19:1 | 0 | 2017-02-03 19:13 | 1 | true | : : 2:37.000000 : : :28.000000 : : : | monetdb | 2017-02-03 18:0 | 0 | 2017-02-03 18:10 | 0 | false | : : 9:47.000000 : : :18.000000 : : : | monetdb | 2017-02-03 19:1 | 0 | 2017-02-03 19:13 | 0 | false | : : 3:10.000000 : : :12.000000 : : : +---------+-----------------+------+------------------+------+-------+
Thanks
Sebastián Acevedo _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Martin Kersten -
martin van dinther -
Sebastián Acevedo