enterprise-support team mailing list archive

[Valerii Kravchuk <valerii.kravchuk@xxxxxxxxxxx>]

I see the following after running sysbench test with 100 tables and 16
threads:

mysql> show variables like 'table_open_cache%';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| table_open_cache           | 1156  |
| table_open_cache_instances | 10    |
+----------------------------+-------+
2 rows in set (0.00 sec)

mysql> show global status like 'open%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Open_files               | 23    |
| Open_streams             | 0     |
| Open_table_definitions   | 185   |
| Open_tables              | 1106  |
| Opened_files             | 549   |
| Opened_table_definitions | 185   |
| Opened_tables            | 6520  |
+--------------------------+-------+
7 rows in set (0.00 sec)

Compare to this:

mysql> show variables like 'table_open_cache%';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| table_open_cache           | 1156  |
| table_open_cache_instances | 1     |
+----------------------------+-------+
2 rows in set (0.00 sec)

mysql> show global status like 'open%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Open_files               | 48    |
| Open_streams             | 0     |
| Open_table_definitions   | 185   |
| Open_tables              | 543   |
| Opened_files             | 504   |
| Opened_table_definitions | 185   |
| Opened_tables            | 550   |
+--------------------------+-------+
7 rows in set (0.00 sec)

I am not sure how the difference in Open_tables can be explained.

I've used the following sysbench command:

sysbench --test=/home/openxs/bzr/sysbench/sysbench/tests/db/select.lua
--num-threads=16 --oltp-tables-count=100 --oltp-table-size=1000 --max-
requests=0 --max-time=600 --mysql-user=root --mysql-password=root
--rand-init=on --report-interval=1 --oltp-read-only=on run

** Changed in: percona-server/5.6
       Status: New => Confirmed

** Bug watch added: MySQL Bug System #77715
   http://bugs.mysql.com/bug.php?id=77715

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=77715
   Importance: Unknown
       Status: Unknown

** Tags added: upstream

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1474282

Title:
  table_open_cache_instances does not really split table_open_cache

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1474282/+subscriptions