Hi,
after some testing on a new db, I have this status:
[root@rachab /root]# mysqladmin e | grep "onn\|pen.*es"
| Aborted_connects | 12 |
| Connections | 150194 |
| Max_used_connections | 24 |
| Open_tables | 0 |
| Open_files | 7909 |
| Opened_tables | 222981 |
| Slave_open_temp_tables | 0 |
| Threads_connected | 1 |
Option open-files-limit is set to 8192. But why Open_files is 7909 when
Open_tables is 0 and only one connection (own mysqladmin) is
estabilished? Is there any relation in Open_files, Open_tables and
Threads_connected? Manual says yes, but these numbers doesn't agree
with. Could it rather be Opened_files than Open_files?
Kernel shows in /proc/sys/fs/file-nr:
2155 1806 16384
AFAIK there are about 350 open files in system. Output from lsof
coresponds with kernel status:
[root@rachab /root]# lsof | grep mysqld | wc
113 1005 10028
RH 7.1, kernel 2.4.3-12enterprise, mysql-3.23.42-1 (rawhide) with
modified convert.cc (#define DEFINE_ALL_CHARACTER_SETS). File my.conf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
default-character-set=czech
language=czech
log
set-variable = key_buffer_size=16M
set-variable = max_allowed_packet=10M
set-variable = max_connections=200
set-variable = record_buffer=1M
set-variable = sort_buffer=4M
set-variable = table_cache=512
set-variable = tmp_table_size=8M
skip-innodb
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open-files-limit=8192
--
Ing. Michal Žejdl e-mail: [EMAIL PROTECTED]
Sokolovská uhelná, a.s. tel.: +420 168 46-5418
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
