Digital Marketing

Loading...

Kill Multiple MySQL Queries

- 
SELECT 
    GROUP_CONCAT(CONCAT('KILL ', id, ';')
        SEPARATOR ' ')
FROM
    information_schema.processlist
WHERE
    user <> 'system user';
    
SELECT 
    GROUP_CONCAT(CONCAT('KILL ', id, ';')
        SEPARATOR ' ')
FROM
    information_schema.processlist
WHERE
    Command <> 'Slepp';
    
#kill the query being implemented by a thread and leave the connection active, 
#use the KILL QUERY command instead. 
SELECT 
    GROUP_CONCAT(CONCAT('KILL QUERY ', id, ';')
        SEPARATOR ' ')
FROM
    information_schema.processlist
WHERE
    Command <> 'Slepp';


https://gist.github.com/i88ca/cea1853ed4f548caa2c7f611f2c41b5b

Popular posts from this blog

How to fix Google Apps Script: Script function not found: doGet

-
Every webapp in Google Apps Script must have a main function called doGet() which is the entry point of the app, the function that your app will start with when you type the webapp url. This is true for every application deployed as a standalone app and called by its url - with a user interface or not. If you read the documentation you'll see that all the standalone apps examples for HTMLService or UiApp have a doGet function. Only container embedded ui scripts or scripts that run on triggers are not concerned by this rule.
Read more

Selenium supports Java

-
Programs written in Java are faster than other popular languages like Python Java is more widely used in commercial applications as compared to other programming languages like Python and hence integrating Selenium tests it easier
Read more

Creating sort index in MySQL

-
'Creating sort index' is the database figuring out the order of the returned values based on ‘order by’ clause. Main resources limit here would be available CPU and memory. The sort won't be done until the data is already all in memory if the result is small. Adding suitable index could make the query faster.
Read more