Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value 
SELECT * FROM `event`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
Filter rows:
Sort by key:
Full texts db name body definer execute_at interval_value interval_field created modified last_executed starts ends status on_completion sql_mode comment originator time_zone character_set_client collation_connection db_collation body_utf8
Edit Edit Copy Copy Delete Delete
DELETE FROM event WHERE `event`.`db` = 'accounting' AND `event`.`name` = 'kill_long_transactions'
 		accounting kill_long_transactions 
BEGIN
      DECLARE max_transaction_time INT DEFAULT 10; 
      DECLARE done INT DEFAULT 0;
      DECLARE killed_id BIGINT;
      DECLARE killed_user VARCHAR(16);
      DECLARE killed_host VARCHAR(64);
      DECLARE kill_stmt VARCHAR(20);
      DECLARE running_stmt TEXT;
 
      DECLARE long_transactions CURSOR FOR
       SELECT CONCAT('KILL ', ps.id) kill_statement,
             ps.id thd_id,
              ps.user,
              ps.host,
             trx.trx_query
         FROM  INFORMATION_SCHEMA.PROCESSLIST ps 
         LEFT JOIN INFORMATION_SCHEMA.INNODB_TRX trx ON trx.trx_mysql_thread_id = ps.id
        WHERE
           USER NOT IN ('system_user','rep')
           AND ps.DB NOT IN ('accounting')
           AND TIME > 100 AND command = 'sleep';
      DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
     
      OPEN long_transactions;
       
      kill_loop: LOOP
        FETCH long_transactions INTO
          kill_stmt, killed_id, killed_user, killed_host, running_stmt;
     
        IF done THEN
          LEAVE kill_loop;
        END IF;
         
        SET @kill := kill_stmt;
         
        PREPARE stmt FROM @kill;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
         
        INSERT INTO kill_long_transactions_log (thd, USER, HOST, statement)
        VALUES (killed_id, killed_user, killed_host, running_stmt);
         
      END LOOP;
      CLOSE long_transactions;
       
      DELETE FROM kill_long_transactions_log
       WHERE ts < NOW() - INTERVAL 7 DAY;
  END
root@localhost NULL 10 SECOND 2025-05-14 09:38:50 2025-05-14 09:38:50 2026-04-15 10:22:11 2018-07-12 03:31:31 NULL ENABLED DROP NO_AUTO_VALUE_ON_ZERO Saves total number of sessions then clears the tab... 0 SYSTEM utf8 utf8_general_ci latin1_swedish_ci 
BEGIN
      DECLARE max_transaction_time INT DEFAULT 10; 
      DECLARE done INT DEFAULT 0;
      DECLARE killed_id BIGINT;
      DECLARE killed_user VARCHAR(16);
      DECLARE killed_host VARCHAR(64);
      DECLARE kill_stmt VARCHAR(20);
      DECLARE running_stmt TEXT;
 
      DECLARE long_transactions CURSOR FOR
       SELECT CONCAT('KILL ', ps.id) kill_statement,
             ps.id thd_id,
              ps.user,
              ps.host,
             trx.trx_query
         FROM  INFORMATION_SCHEMA.PROCESSLIST ps 
         LEFT JOIN INFORMATION_SCHEMA.INNODB_TRX trx ON trx.trx_mysql_thread_id = ps.id
        WHERE
           USER NOT IN ('system_user','rep')
           AND ps.DB NOT IN ('accounting')
           AND TIME > 100 AND command = 'sleep';
      DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
     
      OPEN long_transactions;
       
      kill_loop: LOOP
        FETCH long_transactions INTO
          kill_stmt, killed_id, killed_user, killed_host, running_stmt;
     
        IF done THEN
          LEAVE kill_loop;
        END IF;
         
        SET @kill := kill_stmt;
         
        PREPARE stmt FROM @kill;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
         
        INSERT INTO kill_long_transactions_log (thd, USER, HOST, statement)
        VALUES (killed_id, killed_user, killed_host, running_stmt);
         
      END LOOP;
      CLOSE long_transactions;
       
      DELETE FROM kill_long_transactions_log
       WHERE ts < NOW() - INTERVAL 7 DAY;
  END
Edit Edit Copy Copy Delete Delete
DELETE FROM event WHERE `event`.`db` = 'humanresource' AND `event`.`name` = 'kill_long_transactions'
 		humanresource kill_long_transactions 
BEGIN
      DECLARE max_transaction_time INT DEFAULT 10; 
      DECLARE done INT DEFAULT 0;
      DECLARE killed_id BIGINT;
      DECLARE killed_user VARCHAR(16);
      DECLARE killed_host VARCHAR(64);
      DECLARE kill_stmt VARCHAR(20);
      DECLARE running_stmt TEXT;
 
      DECLARE long_transactions CURSOR FOR
       SELECT CONCAT('KILL ', ps.id) kill_statement,
             ps.id thd_id,
              ps.user,
              ps.host,
             trx.trx_query
         FROM  INFORMATION_SCHEMA.PROCESSLIST ps 
         LEFT JOIN INFORMATION_SCHEMA.INNODB_TRX trx ON trx.trx_mysql_thread_id = ps.id
        WHERE
           USER NOT IN ('system_user','rep')
           AND ps.DB NOT IN ('accounting')
           AND TIME > 100 AND command = 'sleep';
      DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
     
      OPEN long_transactions;
       
      kill_loop: LOOP
        FETCH long_transactions INTO
          kill_stmt, killed_id, killed_user, killed_host, running_stmt;
     
        IF done THEN
          LEAVE kill_loop;
        END IF;
         
        SET @kill := kill_stmt;
         
        PREPARE stmt FROM @kill;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
         
        INSERT INTO kill_long_transactions_log (thd, USER, HOST, statement)
        VALUES (killed_id, killed_user, killed_host, running_stmt);
         
      END LOOP;
      CLOSE long_transactions;
       
      DELETE FROM kill_long_transactions_log
       WHERE ts < NOW() - INTERVAL 7 DAY;
  END
root@localhost NULL 10 SECOND 2025-12-04 10:00:57 2025-12-04 10:00:57 2026-04-15 10:22:11 2018-07-12 18:31:31 NULL ENABLED DROP NO_AUTO_VALUE_ON_ZERO Saves total number of sessions then clears the tab... 0 SYSTEM utf8 utf8_general_ci latin1_swedish_ci 
BEGIN
      DECLARE max_transaction_time INT DEFAULT 10; 
      DECLARE done INT DEFAULT 0;
      DECLARE killed_id BIGINT;
      DECLARE killed_user VARCHAR(16);
      DECLARE killed_host VARCHAR(64);
      DECLARE kill_stmt VARCHAR(20);
      DECLARE running_stmt TEXT;
 
      DECLARE long_transactions CURSOR FOR
       SELECT CONCAT('KILL ', ps.id) kill_statement,
             ps.id thd_id,
              ps.user,
              ps.host,
             trx.trx_query
         FROM  INFORMATION_SCHEMA.PROCESSLIST ps 
         LEFT JOIN INFORMATION_SCHEMA.INNODB_TRX trx ON trx.trx_mysql_thread_id = ps.id
        WHERE
           USER NOT IN ('system_user','rep')
           AND ps.DB NOT IN ('accounting')
           AND TIME > 100 AND command = 'sleep';
      DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
     
      OPEN long_transactions;
       
      kill_loop: LOOP
        FETCH long_transactions INTO
          kill_stmt, killed_id, killed_user, killed_host, running_stmt;
     
        IF done THEN
          LEAVE kill_loop;
        END IF;
         
        SET @kill := kill_stmt;
         
        PREPARE stmt FROM @kill;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
         
        INSERT INTO kill_long_transactions_log (thd, USER, HOST, statement)
        VALUES (killed_id, killed_user, killed_host, running_stmt);
         
      END LOOP;
      CLOSE long_transactions;
       
      DELETE FROM kill_long_transactions_log
       WHERE ts < NOW() - INTERVAL 7 DAY;
  END
Edit Edit Copy Copy Delete Delete
DELETE FROM event WHERE `event`.`db` = 'qpsii_lguprocurement' AND `event`.`name` = 'kill_long_transactions'
 		qpsii_lguprocurement kill_long_transactions 
BEGIN
      DECLARE max_transaction_time INT DEFAULT 10; 
      DECLARE done INT DEFAULT 0;
      DECLARE killed_id BIGINT;
      DECLARE killed_user VARCHAR(16);
      DECLARE killed_host VARCHAR(64);
      DECLARE kill_stmt VARCHAR(20);
      DECLARE running_stmt TEXT;
 
      DECLARE long_transactions CURSOR FOR
       SELECT CONCAT('KILL ', ps.id) kill_statement,
             ps.id thd_id,
              ps.user,
              ps.host,
             trx.trx_query
         FROM  INFORMATION_SCHEMA.PROCESSLIST ps 
         LEFT JOIN INFORMATION_SCHEMA.INNODB_TRX trx ON trx.trx_mysql_thread_id = ps.id
        WHERE
           USER NOT IN ('system_user','rep')
           AND ps.DB NOT IN ('accounting')
           AND TIME > 100 AND command = 'sleep';
      DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
     
      OPEN long_transactions;
       
      kill_loop: LOOP
        FETCH long_transactions INTO
          kill_stmt, killed_id, killed_user, killed_host, running_stmt;
     
        IF done THEN
          LEAVE kill_loop;
        END IF;
         
        SET @kill := kill_stmt;
         
        PREPARE stmt FROM @kill;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
         
        INSERT INTO kill_long_transactions_log (thd, USER, HOST, statement)
        VALUES (killed_id, killed_user, killed_host, running_stmt);
         
      END LOOP;
      CLOSE long_transactions;
       
      DELETE FROM kill_long_transactions_log
       WHERE ts < NOW() - INTERVAL 7 DAY;
  END
root@localhost NULL 10 SECOND 2025-05-15 11:46:51 2025-05-15 11:46:51 2026-04-15 10:22:11 2018-07-12 03:31:31 NULL ENABLED DROP NO_AUTO_VALUE_ON_ZERO Saves total number of sessions then clears the tab... 0 SYSTEM utf8 utf8_general_ci latin1_swedish_ci 
BEGIN
      DECLARE max_transaction_time INT DEFAULT 10; 
      DECLARE done INT DEFAULT 0;
      DECLARE killed_id BIGINT;
      DECLARE killed_user VARCHAR(16);
      DECLARE killed_host VARCHAR(64);
      DECLARE kill_stmt VARCHAR(20);
      DECLARE running_stmt TEXT;
 
      DECLARE long_transactions CURSOR FOR
       SELECT CONCAT('KILL ', ps.id) kill_statement,
             ps.id thd_id,
              ps.user,
              ps.host,
             trx.trx_query
         FROM  INFORMATION_SCHEMA.PROCESSLIST ps 
         LEFT JOIN INFORMATION_SCHEMA.INNODB_TRX trx ON trx.trx_mysql_thread_id = ps.id
        WHERE
           USER NOT IN ('system_user','rep')
           AND ps.DB NOT IN ('accounting')
           AND TIME > 100 AND command = 'sleep';
      DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
     
      OPEN long_transactions;
       
      kill_loop: LOOP
        FETCH long_transactions INTO
          kill_stmt, killed_id, killed_user, killed_host, running_stmt;
     
        IF done THEN
          LEAVE kill_loop;
        END IF;
         
        SET @kill := kill_stmt;
         
        PREPARE stmt FROM @kill;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
         
        INSERT INTO kill_long_transactions_log (thd, USER, HOST, statement)
        VALUES (killed_id, killed_user, killed_host, running_stmt);
         
      END LOOP;
      CLOSE long_transactions;
       
      DELETE FROM kill_long_transactions_log
       WHERE ts < NOW() - INTERVAL 7 DAY;
  END
Edit Edit Copy Copy Delete Delete
DELETE FROM event WHERE `event`.`db` = 'qpsii_lgusystem' AND `event`.`name` = 'event_business_penalty'
 		qpsii_lgusystem event_business_penalty 
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION 
BEGIN END;
	
	
	/*
	IF MAKEDATE(YEAR(CURDATE()), 1) + INTERVAL QUARTER(CURDATE()) QUARTER - INTERVAL 1 DAY = CONCAT(YEAR(CURDATE()),'-','03','-','31') THEN
		UPDATE cto_bpls_tax_bills  
		SET interest_rate = 6, interest = (6/100) * Amount
		WHERE `status`='UNPAID' AND category='Business Tax';	
	ELSEIF MAKEDATE(YEAR(CURDATE()), 1) + INTERVAL QUARTER(CURDATE()) QUARTER - INTERVAL 1 DAY = CONCAT(YEAR(CURDATE()),'-','06','-','30') THEN
		UPDATE cto_bpls_tax_bills  
		SET interest_rate = 12, interest = (12/100) * Amount
		WHERE `status`='UNPAID' AND category='Business Tax';		
	ELSEIF MAKEDATE(YEAR(CURDATE()), 1) + INTERVAL QUARTER(CURDATE()) QUARTER - INTERVAL 1 DAY = CONCAT(YEAR(CURDATE()),'-','09','-','30') THEN
		UPDATE cto_bpls_tax_bills  
		SET interest_rate = 18, interest = (18/100) * Amount
		WHERE `status`='UNPAID' AND category='Business Tax';	
	ELSEIF MAKEDATE(YEAR(CURDATE()), 1) + INTERVAL QUARTER(CURDATE()) QUARTER - INTERVAL 1 DAY = CONCAT(YEAR(CURDATE()),'-','12','-','31') THEN
		UPDATE cto_bpls_tax_bills  
		SET interest_rate = 24, interest = (24/100) * Amount
		WHERE `status`='UNPAID' AND category='Business Tax';	
	END IF;
	
	
	update cto_bpls_tax_bills set sucharges = (select amount from cto_surcharge where qrter=quarter(CURDATE())) WHERE `status`='UNPAID' AND category='Business Tax';
	UPDATE cto_bpls_tax_bills SET total_tax_due =  sucharges + interest + Amount WHERE `status`='UNPAID' AND category='Business Tax';
	*/	    
END
root@localhost NULL 1 SECOND 2026-02-25 12:04:02 2026-02-25 12:04:02 2026-04-15 10:22:18 2015-08-22 17:45:11 NULL ENABLED DROP NO_AUTO_VALUE_ON_ZERO Saves total number of sessions then clears the tab... 0 SYSTEM utf8 utf8_general_ci latin1_swedish_ci 
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION 
BEGIN END;
	
	
	/*
	IF MAKEDATE(YEAR(CURDATE()), 1) + INTERVAL QUARTER(CURDATE()) QUARTER - INTERVAL 1 DAY = CONCAT(YEAR(CURDATE()),'-','03','-','31') THEN
		UPDATE cto_bpls_tax_bills  
		SET interest_rate = 6, interest = (6/100) * Amount
		WHERE `status`='UNPAID' AND category='Business Tax';	
	ELSEIF MAKEDATE(YEAR(CURDATE()), 1) + INTERVAL QUARTER(CURDATE()) QUARTER - INTERVAL 1 DAY = CONCAT(YEAR(CURDATE()),'-','06','-','30') THEN
		UPDATE cto_bpls_tax_bills  
		SET interest_rate = 12, interest = (12/100) * Amount
		WHERE `status`='UNPAID' AND category='Business Tax';		
	ELSEIF MAKEDATE(YEAR(CURDATE()), 1) + INTERVAL QUARTER(CURDATE()) QUARTER - INTERVAL 1 DAY = CONCAT(YEAR(CURDATE()),'-','09','-','30') THEN
		UPDATE cto_bpls_tax_bills  
		SET interest_rate = 18, interest = (18/100) * Amount
		WHERE `status`='UNPAID' AND category='Business Tax';	
	ELSEIF MAKEDATE(YEAR(CURDATE()), 1) + INTERVAL QUARTER(CURDATE()) QUARTER - INTERVAL 1 DAY = CONCAT(YEAR(CURDATE()),'-','12','-','31') THEN
		UPDATE cto_bpls_tax_bills  
		SET interest_rate = 24, interest = (24/100) * Amount
		WHERE `status`='UNPAID' AND category='Business Tax';	
	END IF;
	
	
	update cto_bpls_tax_bills set sucharges = (select amount from cto_surcharge where qrter=quarter(CURDATE())) WHERE `status`='UNPAID' AND category='Business Tax';
	UPDATE cto_bpls_tax_bills SET total_tax_due =  sucharges + interest + Amount WHERE `status`='UNPAID' AND category='Business Tax';
	*/	    
END
Edit Edit Copy Copy Delete Delete
DELETE FROM event WHERE `event`.`db` = 'qpsii_lgusystem' AND `event`.`name` = 'kill_long_transactions'
 		qpsii_lgusystem kill_long_transactions 
BEGIN
      DECLARE max_transaction_time INT DEFAULT 10; 
      DECLARE done INT DEFAULT 0;
      DECLARE killed_id BIGINT;
      DECLARE killed_user VARCHAR(16);
      DECLARE killed_host VARCHAR(64);
      DECLARE kill_stmt VARCHAR(20);
      DECLARE running_stmt TEXT;
 
      DECLARE long_transactions CURSOR FOR
       SELECT CONCAT('KILL ', ps.id) kill_statement,
             ps.id thd_id,
              ps.user,
              ps.host,
             trx.trx_query
         FROM  INFORMATION_SCHEMA.PROCESSLIST ps 
         LEFT JOIN INFORMATION_SCHEMA.INNODB_TRX trx ON trx.trx_mysql_thread_id = ps.id
        WHERE
           USER NOT IN ('system_user','rep')
           AND ps.DB NOT IN ('accounting')
           AND TIME > 100 AND command = 'sleep';
      DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
     
      OPEN long_transactions;
       
      kill_loop: LOOP
        FETCH long_transactions INTO
          kill_stmt, killed_id, killed_user, killed_host, running_stmt;
     
        IF done THEN
          LEAVE kill_loop;
        END IF;
         
        SET @kill := kill_stmt;
         
        PREPARE stmt FROM @kill;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
         
        INSERT INTO kill_long_transactions_log (thd, USER, HOST, statement)
        VALUES (killed_id, killed_user, killed_host, running_stmt);
         
      END LOOP;
      CLOSE long_transactions;
       
      DELETE FROM kill_long_transactions_log
       WHERE ts < NOW() - INTERVAL 7 DAY;
  END
root@localhost NULL 10 SECOND 2026-02-25 12:04:02 2026-02-25 12:04:02 2026-04-15 10:22:11 2018-07-12 18:31:31 NULL ENABLED DROP NO_AUTO_VALUE_ON_ZERO Saves total number of sessions then clears the tab... 0 SYSTEM utf8 utf8_general_ci latin1_swedish_ci 
BEGIN
      DECLARE max_transaction_time INT DEFAULT 10; 
      DECLARE done INT DEFAULT 0;
      DECLARE killed_id BIGINT;
      DECLARE killed_user VARCHAR(16);
      DECLARE killed_host VARCHAR(64);
      DECLARE kill_stmt VARCHAR(20);
      DECLARE running_stmt TEXT;
 
      DECLARE long_transactions CURSOR FOR
       SELECT CONCAT('KILL ', ps.id) kill_statement,
             ps.id thd_id,
              ps.user,
              ps.host,
             trx.trx_query
         FROM  INFORMATION_SCHEMA.PROCESSLIST ps 
         LEFT JOIN INFORMATION_SCHEMA.INNODB_TRX trx ON trx.trx_mysql_thread_id = ps.id
        WHERE
           USER NOT IN ('system_user','rep')
           AND ps.DB NOT IN ('accounting')
           AND TIME > 100 AND command = 'sleep';
      DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
     
      OPEN long_transactions;
       
      kill_loop: LOOP
        FETCH long_transactions INTO
          kill_stmt, killed_id, killed_user, killed_host, running_stmt;
     
        IF done THEN
          LEAVE kill_loop;
        END IF;
         
        SET @kill := kill_stmt;
         
        PREPARE stmt FROM @kill;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
         
        INSERT INTO kill_long_transactions_log (thd, USER, HOST, statement)
        VALUES (killed_id, killed_user, killed_host, running_stmt);
         
      END LOOP;
      CLOSE long_transactions;
       
      DELETE FROM kill_long_transactions_log
       WHERE ts < NOW() - INTERVAL 7 DAY;
  END
With selected: With selected:
|
|
|
Filter rows:
Sort by key:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view