when i use CTRL-C to break a query that works fine in interactive mode.
mysql> select sleep(10) ; ^CCtrl-C -- sending "KILL QUERY 24289" to server ... Ctrl-C -- query aborted. +-----------+ | sleep(10) | +-----------+ +-----------+ 1 row in set (0.86 sec)
but when i use the noninteractive mode timeout 5 mysql -BAN -e "select now(); select sleep (100) ; select now() "
i looks like that but "show full processlist;" shows otherwise and that is true as a list of long running querys showed.
Is there a way to make it behave like the interactive version ? Now it is a bit confusing for everyone.
re, wh
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Dec 02
Johan De Meersman Re: signal handling in mysql cli
Dec 02, 2014; 18:31
Johan De Meersman
Re: signal handling in mysql cli
Dec 03
walter harms Re: signal handling in mysql cli
Dec 03, 2014; 09:53
walter harms
Re: signal handling in mysql cli
Dec 03
Sebastien FLAESCH Re: signal handling in mysql cli
Dec 03, 2014; 17:25
Sebastien FLAESCH
Re: signal handling in mysql cli
Dec 10
Sebastien FLAESCH Re: signal handling in mysql cli
Dec 10, 2014; 11:30
Sebastien FLAESCH
Re: signal handling in mysql cli
Dec 10
Johan De Meersman Re: signal handling in mysql cli
Dec 10, 2014; 12:00
Johan De Meersman
Re: signal handling in mysql cli
Dec 12
rafal somla Re: Re: signal handling in mysql cli
Dec 12, 2014; 12:12
rafal somla
Re: Re: signal handling in mysql cli
Dec 12
Sebastien FLAESCH Re: signal handling in mysql cli
Dec 12, 2014; 14:49
Sebastien FLAESCH
Re: signal handling in mysql cli
Jun 21
Sebastien FLAESCH Re: signal handling in mysql cli
Jun 21, 2016; 16:03
Sebastien FLAESCH
Re: signal handling in mysql cli
Jun 21
Sebastien FLAESCH Re: signal handling in mysql cli
Jun 21, 2016; 16:59
Sebastien FLAESCH
Re: signal handling in mysql cli
Jun 21
Sebastien FLAESCH Re: signal handling in mysql cli
Jun 21, 2016; 18:27
Sebastien FLAESCH
Re: signal handling in mysql cli
Jun 21
Sebastien FLAESCH Re: signal handling in mysql cli
Jun 21, 2016; 18:45
Sebastien FLAESCH
Re: signal handling in mysql cli
Jun 30
shawn l.green Re: signal handling in mysql cli
Jun 30, 2016; 12:33
shawn l.green
Re: signal handling in mysql cli
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!