select @@autocommit;
SELECT @@tx_isolation;
//8.0
SELECT @@transaction_isolation;
SELECT @@global.tx_isolation;
//READ UNCOMMITED
//READ COMMITED
//REPEATABLE READ
//SERIALIZABLE
SET session TRANSACTION ISOLATION LEVEL READ COMMITTED;
show variables like '%log_output%';
show variables like '%general_log%';
show variables like '%version%';
show variables like 'gen%';
SET GLOBAL log_output ='FILE';
SET GLOBAL general_log ='OFF';
show processlist ;
select * from information_schema.`processlist`
where command = 'Sleep' and HOST like '%' and db='';
select concat('KILL ',id,';') from information_schema.`processlist`
where command = 'Sleep' and time <5 and HOST like '%' and db='';
show create table
Mysql个人整理
最新推荐文章于 2024-07-18 04:04:27 发布