Mysql个人整理

最新推荐文章于 2024-07-18 04:04:27 发布

EruruI

最新推荐文章于 2024-07-18 04:04:27 发布

阅读量75

点赞数

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/lsy1162526799/article/details/128218944

版权

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