Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

killtransaction


Version 9.2.0

 

Description

Delete transactions, and return the rest of trasactions infomation.

Request Json Syntax

Key Description
task task name
token token string encrypted.
type

options from killtransaction command. The value should be as follow:  

i-- kill transactions in a specified index. 

u -- kill transactions for a specified user.

h -- kill transactions for a specified host name

p -- kill transactions for a specified program

s -- kill transactions for a specified SQL ID

q -- Displays the query-running status of transactions. 

d  -- dispaly transactions infomation. it doesn't need paramter.

other letters should cause an error. 

parameter

a paramter according to the option in "type" field

 

Request Sample

{
 
 "task":"startinfo",
 
 "token":"4504b930fc1be99bf5dfd31fc5799faaa3f117fb903f397de087cd3544165d857926f07dd201b6aa"
 
 }

 

Response Json Syntax

Key Description
task task name
status execution result, success or failed.
note if failed, a brief description will be given here
dbname database name
transactioninfo transaction information list
transaction transaction list
tranindex transaction flag
user user name
host host name
pid process id
program process name

Response Sample

{
   "__EXEC_TIME" : "35 ms",
   "dbname" : "demodb",
   "note" : "none",
   "status" : "success",
   "task" : "gettransactioninfo",
   "transactioninfo" : 
      {
         "transaction" : [
            {
               "@user" : "DBA",
               "host" : "huangqiyu-VirtualBox",
               "pid" : "6632",
               "program" : "query_editor_cub_cas_1",
               "tranindex" : "1(ACTIVE)"
            }
         
      }
   ]
}
comments powered by Disqus
Page info
viewed 448 times
translations en
Author
posted last year by
cheeray
Contributors
updated last year by
View revisions
Share this article