Mysql,Oracle数据库连接数简析_MySQL

bitsCN.com Mysql,Oracle数据库连接数简析 Mysql 01D:/Program Files/MySQL/MySQL Server 5.1/bin>mysql -u root -p02Enter password: ****03Welcome to the MySQL monitor. Commands end with ; or /g.04Your MySQL connection id is 183 05Server version: 5.1.58-community MySQL Community Server (GPL)06 07Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.08This software comes with ABSOLUTELY NO WARRANTY. This is free software,09and you are welcome to modify and redistribute it under the GPL v2 license10 11Type &＃39;help;&＃39; or &＃39;/h&＃39; for help. Type &＃39;/c&＃39; to clear the current input statement.12-- 使用xuexi数据库13mysql> use xuexi14Database changed15-- 查看字符集16mysql> SHOW VARIABLES LIKE &＃39;character_set%&＃39;;17-- 控制台汉字乱码，将编码改为gbk，控制台就可以显示中文了18mysql> set character_set_results=&＃39;gbk&＃39;;19-- 查看连接数 20mysql> SHOW PROCESSLIST;--100条21mysql> show full processlist;22-- 服务器的状态信息23mysql> show status; Oracle 01SQL> conn / as sysdba02Connected.03-- 连接数04SQL> select count(*) from v$session;05-- 并发连接数06SQL> Select count(*) from v$session where status=&＃39;ACTIVE&＃39;;07--最大连接08SQL> show parameter processes;09-- 修改processes和sessions值10SQL> alter system set processes=300 scope=spfile;11SQL> alter system set sessiOns=300 scope=spfile;
作者 车水码农 bitsCN.com