\! lsof 2>/dev/null | grep mysqld | wc -l
|
1836
|
--------------
|
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
|
1863
|
|
--------------
|
flush tables
|
--------------
|
Query OK, 0 rows affected (0.00 sec)
|
|
\! lsof 2>/dev/null | grep mysqld | wc -l
|
1863
|
|
|
--------------
|
create table t1 (i int)engine=myisam
|
--------------
|
Query OK, 0 rows affected (0.06 sec)
|
|
--------------
|
insert into t1 (i) values (1),(2),(3)
|
--------------
|
Query OK, 3 rows affected (0.00 sec)
|
Records: 3 Duplicates: 0 Warnings: 0
|
|
--------------
|
select * from t1 limit 10
|
--------------
|
+------+
|
| i |
|
+------+
|
| 1 |
|
| 2 |
|
| 3 |
|
+------+
|
3 rows in set (0.00 sec)
|
|
\! lsof 2>/dev/null | grep mysqld | wc -l
|
1917
|
--------------
|
flush tables
|
--------------
|
Query OK, 0 rows affected (0.00 sec)
|
|
\! lsof 2>/dev/null | grep mysqld | wc -l
|
1863
|
|