ペパボにおける MogileFS

晒すのが流行ったようなので。id:halfrack:20111108

mysql> select fid from file order by fid desc limit 3;
+-----------+
| fid       |
+-----------+
| 530626772 |
| 530626770 |
| 530626769 |
+-----------+
3 rows in set (0.00 sec)

mysql> desc file;
+----------+----------------------+------+-----+---------+-------+
| Field    | Type                 | Null | Key | Default | Extra |
+----------+----------------------+------+-----+---------+-------+
| fid      | int(10) unsigned     | NO   | PRI | NULL    |       |
| dmid     | smallint(5) unsigned | NO   | MUL | NULL    |       |
| dkey     | varchar(255)         | YES  |     | NULL    |       |
| length   | int(10) unsigned     | YES  |     | NULL    |       |
| classid  | tinyint(3) unsigned  | NO   |     | NULL    |       |
| devcount | tinyint(3) unsigned  | NO   |     | NULL    |       |
+----------+----------------------+------+-----+---------+-------+
6 rows in set (0.01 sec)
mysql>

刺身サンが先に書いてた… http://kyanny.hatenablog.jp/entry/2011/11/08/202124