查看mysql线程数,包数,事务是否自动提交的

-- SELECT @@session.autocommit

-- show variables like 'max_connections';//768

-- show STATUS like 'Thread%';

-- Threadpool_idle_threads 0
-- Threadpool_threads 0
-- Threads_cached 3
-- Threads_connected 186
-- Threads_created 468567
-- Threads_running 2

-- show PROCESSLIST;

show variables like '%max_allowed_packet%'

posted on 2020-12-10 16:27  woshare  阅读(138)  评论(0编辑  收藏  举报