首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Mysql >

MySQL施用federated 实现Oacle链路效果

2013-03-21 
MySQL使用federated 实现Oacle链路效果SHOW STATUS LIKE %connect% Threads_connected is the current

MySQL使用federated 实现Oacle链路效果

SHOW STATUS LIKE '%connect%';
Threads_connected is the current count, Max_used_connections is the highest value seen since the last time FLUSH STATUS was issued.

If that max value is the same as (or 1 more than) the value returned by SHOW VARIABLES LIKE 'max_connections'; then at some point that server was maxed out and could have returned this message.

If the remote server shows a lot of idle inbound federated connections, you may find that issuing FLUSH TABLES on the local server will release them.

热点排行