\! 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
|