30days Album における MogileFS

mysql> select fid from file order by fid desc limit 3;
+-----------+
| fid       |
+-----------+
| 529889169 |
| 529889167 |
| 529889166 |
+-----------+
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.00 sec)

mysql> 

がんばります

はてなにおける MogileFS - mura日記 (halfrack)