Mysql and Oracle database connection count analysis _ MySQL

Analysis of Mysql and Oracle database connections bitsCN. comMysql, Oracle Database Connection analysis Mysql 01D:/Program Files/MySQL Server 5.1/bin> mysql-u root-p02Enter password: ***** 03 Welcome to the MySQL monitor. commands end with; or/g.04Your MySQL connection id is 183 05 Server version: 5.1.58-community MySQL Community Server (GPL) 06 07 Copyright (c) 2000,201 0, 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 11 Type 'help; 'or'/h' for help. type '/C' to clear the current input statement.12 -- use xuexi database 13 mysql> use xuexi14Database changed15 -- View character set 16 mysql> show variables like 'character _ set % '; 17 -- garbled characters in the console. change the encoding to gbk. the console displays Chinese characters 18 mysql> set character_set_results = 'gbk'; 19 -- View connections 20 mysql> show processlist; -- 100 21 mysql> show full processlist; 22 -- Server status Information 23 mysql> show status; Oracle 01SQL> conn/as sysdba02Connected. 03 -- connections 04SQL> select count (*) from v $ session; 05 -- concurrent connections 06SQL> Select count (*) from v $ session where status = 'active '; 07 -- maximum connection 08SQL> show parameter processes; 09 -- modify the values of processes and sessions 10SQL> alter system set processes = 300 scope = spfile; 11SQL> alter system set sessions = 300 scope = spfile;
Author: car Water Code agricultural bitsCN.com