Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1.22
-
None
Description
Number of open files grows after each select in table t2 ( CONNECT engine, DIR type).
\! lsof 2>/dev/null | grep mysqld | wc -l |
2349
|
--------------
|
create table t2 ( |
PATH varchar(256) NOT NULL flag=1, |
FNAME varchar(256) NOT NULL flag=2, |
FTYPE varchar(255) NOT NULL flag=3, |
SIZE double(12,0) NOT NULL flag=5 |
)engine=CONNECT table_type=DIR file_name='/home/alice/Downloads/*' option_list='subdir=1' |
--------------
|
Query OK, 0 rows affected (0.06 sec) |
|
|
--------------
|
select * from t2 limit 10 |
--------------
|
+------------------------+----------------------+-------+-------+ |
| PATH | FNAME | FTYPE | SIZE | |
+------------------------+----------------------+-------+-------+ |
| /home/alice/Downloads/ | b | .sql | 2851 |
|
| /home/alice/Downloads/ | 1 | | 906 |
|
| /home/alice/Downloads/ | dataApr-27-2017 | .csv | 8949 |
|
| /home/alice/Downloads/ | dataApr-28-2017 | .json | 770 |
|
| /home/alice/Downloads/ | drop ndx | | 800 | |
| /home/alice/Downloads/ | dataApr-28-2017.json | .zip | 4095 |
|
| /home/alice/Downloads/ | xx | | 37000 |
|
| /home/alice/Downloads/ | xx1 | | 348 |
|
| /home/alice/Downloads/ | d1 | .zip | 2578 |
|
| /home/alice/Downloads/ | c | .sql | 880 |
|
+------------------------+----------------------+-------+-------+ |
10 rows in set (0.00 sec) |
|
|
\! lsof 2>/dev/null | grep mysqld | wc -l |
2376
|
--------------
|
select * from t2 limit 10 |
--------------
|
+------------------------+----------------------+-------+-------+ |
| PATH | FNAME | FTYPE | SIZE | |
+------------------------+----------------------+-------+-------+ |
| /home/alice/Downloads/ | b | .sql | 2851 |
|
| /home/alice/Downloads/ | 1 | | 906 |
|
| /home/alice/Downloads/ | dataApr-27-2017 | .csv | 8949 |
|
| /home/alice/Downloads/ | dataApr-28-2017 | .json | 770 |
|
| /home/alice/Downloads/ | drop ndx | | 800 | |
| /home/alice/Downloads/ | dataApr-28-2017.json | .zip | 4095 |
|
| /home/alice/Downloads/ | xx | | 37000 |
|
| /home/alice/Downloads/ | xx1 | | 348 |
|
| /home/alice/Downloads/ | d1 | .zip | 2578 |
|
| /home/alice/Downloads/ | c | .sql | 880 |
|
+------------------------+----------------------+-------+-------+ |
10 rows in set (0.00 sec) |
|
|
2403
|
--------------
|
select * from t2 limit 10 |
--------------
|
+------------------------+----------------------+-------+-------+ |
| PATH | FNAME | FTYPE | SIZE | |
+------------------------+----------------------+-------+-------+ |
| /home/alice/Downloads/ | b | .sql | 2851 |
|
| /home/alice/Downloads/ | 1 | | 906 |
|
| /home/alice/Downloads/ | dataApr-27-2017 | .csv | 8949 |
|
| /home/alice/Downloads/ | dataApr-28-2017 | .json | 770 |
|
| /home/alice/Downloads/ | drop ndx | | 800 | |
| /home/alice/Downloads/ | dataApr-28-2017.json | .zip | 4095 |
|
| /home/alice/Downloads/ | xx | | 37000 |
|
| /home/alice/Downloads/ | xx1 | | 348 |
|
| /home/alice/Downloads/ | d1 | .zip | 2578 |
|
| /home/alice/Downloads/ | c | .sql | 880 |
|
+------------------------+----------------------+-------+-------+ |
10 rows in set (0.00 sec) |
|
|
\! lsof 2>/dev/null | grep mysqld | wc -l |
2430
|
Attachments
Issue Links
- relates to
-
-
- Open
-