mysql> show index from profiles;' +----------+------------+------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +----------+------------+------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | profiles | 0 | PRIMARY | 1 | id | A | 159192673 | NULL | NULL | | BTREE | | | profiles | 1 | active | 1 | active | A | 159 | NULL | NULL | YES | BTREE | | | profiles | 1 | createdi | 1 | created | A | 53064224 | NULL | NULL | YES | BTREE | | | profiles | 1 | links | 1 | links | A | 42349 | NULL | NULL | YES | BTREE | | | profiles | 1 | age | 1 | age | A | 159 | NULL | NULL | YES | BTREE | | | profiles | 1 | sex | 1 | sex | A | 159 | NULL | NULL | YES | BTREE | | | profiles | 1 | bday | 1 | bday | A | 199739 | NULL | NULL | YES | BTREE | | | profiles | 1 | first_links_sex_age_id | 1 | first_name | A | 78730 | NULL | NULL | YES | BTREE | | | profiles | 1 | first_links_sex_age_id | 2 | links | A | 1337753 | NULL | NULL | YES | BTREE | | | profiles | 1 | first_links_sex_age_id | 3 | sex | A | 2376010 | NULL | NULL | YES | BTREE | | | profiles | 1 | first_links_sex_age_id | 4 | age | A | 22741810 | NULL | NULL | YES | BTREE | | | profiles | 1 | first_links_sex_age_id | 5 | id | A | 159192673 | NULL | NULL | | BTREE | | | profiles | 1 | first_last_middle_links_sex_age_id | 1 | first_name | A | 159 | NULL | NULL | YES | BTREE | | | profiles | 1 | first_last_middle_links_sex_age_id | 2 | last_name | A | 159192673 | NULL | NULL | YES | BTREE | | | profiles | 1 | first_last_middle_links_sex_age_id | 3 | middle_name | A | 159192673 | NULL | NULL | YES | BTREE | | | profiles | 1 | first_last_middle_links_sex_age_id | 4 | links | A | 159192673 | NULL | NULL | YES | BTREE | | | profiles | 1 | first_last_middle_links_sex_age_id | 5 | sex | A | 159192673 | NULL | NULL | YES | BTREE | | | profiles | 1 | first_last_middle_links_sex_age_id | 6 | age | A | 159192673 | NULL | NULL | YES | BTREE | | | profiles | 1 | first_last_middle_links_sex_age_id | 7 | id | A | 159192673 | NULL | NULL | | BTREE | | | profiles | 1 | last_links_sex_age_id | 1 | last_name | A | 1360621 | NULL | NULL | YES | BTREE | | | profiles | 1 | last_links_sex_age_id | 2 | links | A | 6367706 | NULL | NULL | YES | BTREE | | | profiles | 1 | last_links_sex_age_id | 3 | sex | A | 12245590 | NULL | NULL | YES | BTREE | | | profiles | 1 | last_links_sex_age_id | 4 | age | A | 53064224 | NULL | NULL | YES | BTREE | | | profiles | 1 | last_links_sex_age_id | 5 | id | A | 159192673 | NULL | NULL | | BTREE | | | profiles | 1 | sex_age_links_id | 1 | sex | A | 159 | NULL | NULL | YES | BTREE | | | profiles | 1 | sex_age_links_id | 2 | age | A | 159 | NULL | NULL | YES | BTREE | | | profiles | 1 | sex_age_links_id | 3 | links | A | 159 | NULL | NULL | YES | BTREE | | | profiles | 1 | sex_age_links_id | 4 | id | A | 159192673 | NULL | NULL | | BTREE | | +----------+------------+------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ 28 rows in set (6.68 sec) mysql> show create table profiles; CREATE TABLE `profiles` ( `id` int(10) NOT NULL AUTO_INCREMENT, `created` datetime DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `active` tinyint(1) DEFAULT NULL, `locked` tinyint(1) DEFAULT NULL, `links` int(11) DEFAULT '0', `age` int(3) DEFAULT '0', `bday` date DEFAULT '0000-00-00', `sex` char(1) DEFAULT NULL, `first_name` int(8) DEFAULT NULL, `last_name` int(8) DEFAULT NULL, `middle_name` int(8) DEFAULT NULL, PRIMARY KEY (`id`), KEY `active` (`active`), KEY `createdi` (`created`), KEY `links` (`links`), KEY `age` (`age`), KEY `sex` (`sex`), KEY `bday` (`bday`), KEY `first_links_sex_age_id` (`first_name`,`links`,`sex`,`age`,`id`), KEY `first_last_middle_links_sex_age_id` (`first_name`,`last_name`,`middle_name`,`links`,`sex`,`age`,`id`), KEY `last_links_sex_age_id` (`last_name`,`links`,`sex`,`age`,`id`), KEY `sex_age_links_id` (`sex`,`age`,`links`,`id`) ) ENGINE=InnoDB AUTO_INCREMENT=166261131 DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (id) (PARTITION p0 VALUES LESS THAN (20000000) ENGINE = InnoDB, PARTITION p1 VALUES LESS THAN (40000000) ENGINE = InnoDB, PARTITION p2 VALUES LESS THAN (60000000) ENGINE = InnoDB, PARTITION p3 VALUES LESS THAN (80000000) ENGINE = InnoDB, PARTITION p4 VALUES LESS THAN (100000000) ENGINE = InnoDB, PARTITION p5 VALUES LESS THAN (120000000) ENGINE = InnoDB, PARTITION p6 VALUES LESS THAN (140000000) ENGINE = InnoDB, PARTITION p7 VALUES LESS THAN (160000000) ENGINE = InnoDB, PARTITION p8 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; last 3 records: mysql> select * from profiles order by id desc limit 3; +-----------+---------------------+--------+--------+--------+-------+------+------------+------+------------+-----------+-------------+ | id | created | status | active | locked | links | age | bday | sex | first_name | last_name | middle_name | +-----------+---------------------+--------+--------+--------+-------+------+------------+------+------------+-----------+-------------+ | 166261148 | 2009-01-05 01:24:12 | 1 | 1 | 0 | 1 | 20 | 1988-12-15 | f | 10881 | 252789 | 2 | | 166261147 | 2009-01-05 01:24:12 | 1 | 1 | 0 | 1 | 29 | 0000-00-00 | NULL | 3881 | 231785 | 76 | | 166261146 | 2009-01-05 01:24:11 | 1 | 1 | 0 | 1 | 0 | 0000-00-00 | | 11743 | 329473 | 2 |