In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
This article mainly introduces "brief analysis of Mysql and Oracle database connections". In daily operation, I believe that many people have doubts about the number of Mysql and Oracle database connections. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "brief analysis of Mysql and Oracle database connections". Next, please follow the editor to study!
A brief Analysis of the number of Mysql,Oracle connections
Mysql
01
D:\ Program Files\ MySQL\ MySQL Server 5.1\ bin >-u root-p
02
Enter password: *
03
Welcome to the MySQL monitor. Commands end with; or\ g.
04
Your MySQL connection id is 183 www.2cto.com
05
Server version: 5.1.58-community MySQL Community Server (GPL)
06
07
Copyright (c) 2000, 2010, and/or its affiliates. All rights reserved.
08
This software comes with ABSOLUTELY NO WARRANTY. This is free software
09
And you are welcome to modify and redistribute it under the GPL v2 license
ten
eleven
Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.
twelve
-- using the xuexi database
thirteen
Mysql > use xuexi
fourteen
Database changed
fifteen
-- View character set
sixteen
Mysql > SHOW VARIABLES LIKE 'character_set%'
seventeen
-- Chinese characters are garbled in the console. Change the code to gbk, and the console can display Chinese characters.
eighteen
Mysql > set character_set_results='gbk'
nineteen
-- check the number of connections www.2cto.com
twenty
Mysql > SHOW PROCESSLIST;--100 bar
twenty-one
Mysql > show full processlist
twenty-two
-- status information of the server
twenty-three
Mysql > show status
Oracle
01
SQL > conn / as sysdba
02
Connected.
03
-number of connections
04
SQL > select count (*) from v$session
05
-- number of concurrent connections
06
SQL > Select count (*) from v$session where status='ACTIVE'
07
-- maximum connection
08
SQL > show parameter processes
09
-- modify processes and sessions values
ten
SQL > alter system set processes=300 scope=spfile
eleven
SQL > alter system set sessions=300 scope=spfile
At this point, the study on "A brief Analysis of the number of Mysql and Oracle Database connections" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.