|
|
|
User Rating:
Rated by: |
Fair (2.2/5)
13 user(s) |
|
|
|
MySQL Filesystem Engine description |
|
|
MySQL Filesystem Engine is a database storage engine for arbitrary filesystem files. MySQL Filesystem Engine is a database storage engine for arbitrary filesystem files.
It translates normal files on your server into relational tables inside of MySQL. It is a very alpha project at the moment, but works for basic usage.
Example
mysql> CREATE TABLE LoadAverage (
load1 DECIMAL(3, 2),
load5 DECIMAL(3, 2),
load15 DECIMAL(3, 2),
active_processes VARCHAR(12),
lastpid INTEGER) ENGINE=FILESYSTEM connection='file:///proc/loadavg';
Query OK, 0 rows affected (0.00 sec)
mysql> select * from LoadAverage;
------- ------- -------- ------------------ ---------
| load1 | load5 | load15 | active_processes | lastpid |
------- ------- -------- ------------------ ---------
| 0.00 | 0.00 | 0.00 | 1/97 | 6061 |
------- ------- -------- ------------------ ---------
1 row in set (0.00 sec)
Security
Anyone who can create tables on your MySQL server will be able to read any file that mysqld can read! Hopefully this will be fixed in the future, but remember, even temporary tables could be used, so proceed with caution.
|
|
