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 'help;' or '/h' for help. Type '/c' to clear the current input statement.12-- 使用xuexi数据库13mysql> use xuexi14Database changed15-- 查看字符集16mysql> SHOW VARIABLES LIKE 'character_set%';17-- 控制台汉字乱码，将编码改为gbk，控制台就可以显示中文了18mysql> set character_set_results='gbk';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='ACTIVE';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