- 论坛徽章:
- 0
|
本帖最后由 justin033 于 2010-08-20 23:04 编辑
背景:我们这边大量的分库分表,总共354个库,表总共7W多个,3分1是MyISAM表。
系统版本:CentOS release 5.4 (Final) MySQL 版本5.1.39 - [root@~]# find /data02/mysql/ -name "*.frm" | wc -l
- 70468
复制代码 sysctl.conf和limit.conf的配置,如下:- # Add By Justin
- vm.swappiness = 10
- fs.file-max = 204800
复制代码- # Add By Justin
- * soft nofile 204800
- * hard nofile 204800
复制代码- [root@~]# ulimit -a
- core file size (blocks, -c) 0
- data seg size (kbytes, -d) unlimited
- scheduling priority (-e) 0
- file size (blocks, -f) unlimited
- pending signals (-i) 81920
- max locked memory (kbytes, -l) 32
- max memory size (kbytes, -m) unlimited
- open files (-n) 204800
- pipe size (512 bytes, -p) 8
- POSIX message queues (bytes, -q) 819200
- real-time priority (-r) 0
- stack size (kbytes, -s) 10240
- cpu time (seconds, -t) unlimited
- max user processes (-u) 81920
- virtual memory (kbytes, -v) unlimited
- file locks (-x) unlimited
- [root@~]# cat /proc/sys/fs/file-nr
- 4590 0 204800
复制代码 用户MySQL的环境设置:- [root@~]# su - mysql
- [mysql@~]$ whoami
- mysql
- [mysql@~]$ ulimit -a
- core file size (blocks, -c) 0
- data seg size (kbytes, -d) unlimited
- scheduling priority (-e) 0
- file size (blocks, -f) unlimited
- pending signals (-i) 81920
- max locked memory (kbytes, -l) 32
- max memory size (kbytes, -m) unlimited
- open files (-n) 204800
- pipe size (512 bytes, -p) 8
- POSIX message queues (bytes, -q) 819200
- real-time priority (-r) 0
- stack size (kbytes, -s) 10240
- cpu time (seconds, -t) unlimited
- max user processes (-u) 81920
- virtual memory (kbytes, -v) unlimited
- file locks (-x) unlimited
复制代码
但是:mysql里open_files_limit只到65535,没达到我设置的值,如下:- "Variable_name","Value"
- "open_files_limit","65535"
复制代码 主机也重启了,mysql的open_files_limit的值还没超过65535。。。有人遇到过没。。。。。。。。。。。。。。。。。。。。。。。。 |
|