Hi,
can somebody answer my question?
> Subject: what does it mean Open_files?
> Date: Mon, 22 Oct 2001 06:41:03 +0200
> From: Michal Žejdl <[EMAIL PROTECTED]>
> To: MySQL list <[EMAIL PROTECTED]>
>
> 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
