一 ,通常,mysql的最大连接数默认是100, 最大可以达到16384。ORACLE的连接数理论上是没有上限的,分析系统,只设置了300.物理硬件好的话,设置3000设置的最大连接数(默认值为150)。
二, 实际的报表库:oracle最大连接processes:2100
实际的报表库:oracle最大连接sessions:3184
当前运行中的processes为221
实际中心库:
实际的报表库:oracle最大连接processes:200
实际的报表库:oracle最大连接sessions:2205
当前运行中的processes为451
apprannk:
show variables like 'max_connections';
show status
最大connections mysql:800
实际connections mysql:21
ad:
最大connections mysql:800
实际connections mysql:19
三:
>mysql -uuser -ppassword(命令行登录MySQL)
mysql>show variables like 'max_connections';(查可以看当前的最大连接数)
msyql>set global max_connections=1000;(设置最大连接数为1000,可以再次查看是否设置成功)
mysql>exit(推出)
四:
1,查看当前的连接数,可以用select count(*) from v$process;
2,设置的最大连接数(默认值为150)select value from v$parameter where name = ‘processes’;3,修改最大连接数alter system set processes = 300 scope = spfile;
1报表 2中心
mysql:
| Table_locks_immediate | 8578 |
| Table_locks_waited | 0 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 21 |
| Threads_created | 6560 |
| Threads_running | 1 |
| Uptime | 4750003 |
| Uptime_since_flush_status | 4750003 |
Innodb_buffer_pool_pages_data | 80401 |
| Innodb_buffer_pool_bytes_data | 1317289984 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 1313 |
| Innodb_buffer_pool_pages_free | 1553690 |
| Innodb_buffer_pool_pages_misc | 4308 |
| Innodb_buffer_pool_pages_total | 1638399 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 25667 |
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 7910182 |
| Innodb_buffer_pool_reads | 54062 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 11382 |
| Innodb_data_fsyncs | 1020 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 1308463104 |
| Innodb_data_reads | 80103 |
| Innodb_data_writes | 2258 |
| Innodb_data_written | 44062208 |
| Innodb_dblwr_pages_written | 1313 |
| Innodb_dblwr_writes | 75 |
| Innodb_have_atomic_builtins | ON |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 1899 |
| Innodb_log_writes | 243 |
| Innodb_os_log_fsyncs | 210 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 998400 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 673 |
| Innodb_pages_read | 79728 |
| Innodb_pages_written | 1313 |
参考:http://jingyan.baidu.com/article/3c48dd34591857e10be358b3.html
http://blog.csdn.net/starnight_cbj/article/details/4492555