1、查看所有进程show processlist;2、所有进程查询生成杀掉进程的命令select concat('KILL ',id,';') from information_schema.processlist WHERE time >100;3、查询数据库所有表名和注释生成添加语句SELECT concat('ALTER TABLE ',tableName,'COMMENT=',"'
一、查看sql执行计划explain + sql 语句—>查看 执行计划 示例：EXPLAIN SELECT * FROM user WHERE nid = 3; 结果示例：二、查询进程列表show processlist 语句—>显示进程列表 示例：-- 跳转到 information_schema 数据库
USE information_schema;
-- 显示进程列表
SHOW
# -*- coding:utf-8 -*-
#多进程
import time
import requests
import multiprocessing
from multiprocessing import Pool
from bs4 import BeautifulSoup
def job(url,header):
r = requests.get(url,headers =
1、启动mysql，输入show processlist可以看见全部的线程，(最高权限)mysql> show processlist;+-----+-------------+--------------------+-------+---------+-------+| Id | User | Host | db | Command | Time| State | Info+-----+
