Re: Utilize maximum system resources for better performance

[Ronald Brown]

here are moredetails of content table.

mysql> show indexes from content;
+---------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| content | 0 | PRIMARY | 1 | record_num | A | 6560305 | NULL | NULL | | BTREE | | |
| content | 0 | hash | 1 | hash | A | 6560305 | NULL | NULL | | BTREE | | |
| content | 1 | upload_date | 1 | upload_date | A | 6560305 | NULL | NULL | | BTREE | | |
| content | 1 | seeders | 1 | seeders | A | 2172 | NULL | NULL | | BTREE | | |
| content | 1 | leechers | 1 | leechers | A | 1178 | NULL | NULL | | BTREE | | |
| content | 1 | vote_up | 1 | vote_up | A | 1 | NULL | NULL | | BTREE | | |
| content | 1 | comments_count | 1 | comments_count | A | 1 | NULL | NULL | | BTREE | | |
| content | 1 | tfile_size | 1 | tfile_size | A | 242974 | NULL | NULL | | BTREE | | |
| content | 1 | e_c_d_v | 1 | enabled | A | 1 | NULL | NULL | | BTREE | | |
| content | 1 | e_c_d_v | 2 | category | A | 148 | NULL | NULL | | BTREE | | |
| content | 1 | e_c_d_v | 3 | upload_date | A | 6560305 | NULL | NULL | | BTREE | | |
| content | 1 | e_c_d_v | 4 | verified | A | 6560305 | NULL | NULL | | BTREE | | |
| content | 1 | e_d_v | 1 | enabled | A | 1 | NULL | NULL | | BTREE | | |
| content | 1 | e_d_v | 2 | upload_date | A | 6560305 | NULL | NULL | | BTREE | | |
| content | 1 | e_d_v | 3 | verified | A | 6560305 | NULL | NULL | | BTREE | | |
| content | 1 | e_c_v | 1 | enabled | A | 1 | NULL | NULL | | BTREE | | |
| content | 1 | e_c_v | 2 | category | A | 148 | NULL | NULL | | BTREE | | |
| content | 1 | e_c_v | 3 | verified | A | 291 | NULL | NULL | | BTREE | | |
| content | 1 | e_v | 1 | enabled | A | 1 | NULL | NULL | | BTREE | | |
| content | 1 | e_v | 2 | verified | A | 4 | NULL | NULL | | BTREE | | |
| content | 1 | e | 1 | enabled | A | 1 | NULL | NULL | | BTREE | | |
| content | 1 | e_u | 1 | enabled | A | 1 | NULL | NULL | | BTREE | | |
| content | 1 | e_u | 2 | uploader | A | 1 | NULL | NULL | | BTREE | | |
+---------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
23 rows in set (0.00 sec)