prototype for filesystem plugin
create a prototype for plugin filesystem, it gets my hands dirty and gets myself familiar with the interfaces in storage engines.
Blueprint information
Whiteboard
- create a file named 'demo.txt'
- put the below information into this file:
0.00 0.00 0.00 1/97 6061
- save it to your drizzle's deployment directory.
- at the drizzle prompt, create a table and select the contents from the table:
drizzle> CREATE TABLE LoadAverage (
load1 DECIMAL(3, 2),
load5 DECIMAL(3, 2),
load15 DECIMAL(3, 2),
lastpid INTEGER) ENGINE=FILESYSTEM;
drizzle> select * from LoadAverage;
+------
| load1 | load5 | load15 | active_processes | lastpid |
+------
| 0.00 | 0.00 | 0.00 | 1/97 | 6061 |
+------
It works! :-)