ペパボにおける 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