Re: Utilize maximum system resources for better performance
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)
Subject
Views
Written By
Posted
2688
July 14, 2015 01:54AM
1060
July 14, 2015 01:58AM
Re: Utilize maximum system resources for better performance
1012
July 14, 2015 02:12AM
944
July 14, 2015 11:30AM
967
July 14, 2015 11:57AM
1067
July 15, 2015 08:36PM
1288
July 30, 2015 07:22AM
1093
July 30, 2015 07:26AM
1089
July 31, 2015 10:20PM
1038
August 02, 2015 01:27AM
1089
August 02, 2015 11:10AM
1335
August 08, 2015 01:27AM
1019
August 08, 2015 11:49AM
995
August 08, 2015 01:01PM
1002
August 08, 2015 03:43PM
1111
August 09, 2015 12:40AM
880
August 09, 2015 07:33AM
949
August 09, 2015 03:53PM
1127
August 09, 2015 08:04PM
881
August 09, 2015 11:17PM
979
August 10, 2015 12:00AM
1017
August 10, 2015 08:36AM
1117
August 10, 2015 11:00AM
1066
August 10, 2015 11:03AM
1055
September 16, 2015 11:39AM
1119
September 18, 2015 09:54PM
758
September 19, 2015 01:18AM
1045
October 02, 2015 08:50PM
929
October 02, 2015 09:09PM
886
October 03, 2015 04:46PM
1005
August 09, 2015 01:07AM
829
September 23, 2015 09:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.