Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_stats_usersemail_stats_users

email_stats_users

Table comments : InnoDB free: 781312 kB

Field Type Null Default
userid  int(11) Yes 
statid  int(11) No 
jobid  int(11) Yes 
queuesize  int(11) Yes 
queuetime  int(11) Yes 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 75 statid
statid_2 UNIQUE 75 statid
statid_4 UNIQUE 75 statid
statid_6 UNIQUE 75 statid
statid_7 UNIQUE 75 statid
statid_11 UNIQUE 75 statid
statid_12 UNIQUE 75 statid
statid_14 UNIQUE 75 statid
jobid_2 UNIQUE 75 jobid
queuetime_2 UNIQUE 75 queuetime
jobid_3 UNIQUE 75 jobid
queuetime_4 UNIQUE 75 queuetime
jobid_5 UNIQUE 75 jobid
queuetime_5 UNIQUE 75 queuetime
jobid_7 UNIQUE 75 jobid
queuetime_8 UNIQUE 75 queuetime
queuetime_9 UNIQUE 75 queuetime
jobid_9 UNIQUE 75 jobid
jobid_11 UNIQUE 75 jobid
jobid_13 UNIQUE 75 jobid
queuetime_13 UNIQUE 75 queuetime
queuetime_14 UNIQUE 75 queuetime
email_stats_users_all_idx INDEX 75 userid
queuetime
queuesize
email_stats_users_statid_idx INDEX 75 statid
userid INDEX 2 userid
statid INDEX 75 statid
jobid INDEX 75 jobid
queuesize INDEX 75 queuesize
queuetime INDEX 75 queuetime
statid_3 INDEX 75 statid
userid_2 INDEX 2 userid
queuetime_3 INDEX 75 queuetime
queuesize_2 INDEX 75 queuesize
jobid_4 INDEX 75 jobid
userid_3 INDEX 2 userid
statid_5 INDEX 75 statid
queuetime_6 INDEX 75 queuetime
jobid_6 INDEX 75 jobid
queuesize_3 INDEX 75 queuesize
statid_8 INDEX 75 statid
userid_4 INDEX 2 userid
queuetime_7 INDEX 75 queuetime
queuesize_4 INDEX 75 queuesize
jobid_8 INDEX 75 jobid
statid_9 INDEX 75 statid
queuesize_5 INDEX 75 queuesize
statid_10 INDEX 75 statid
userid_5 INDEX 2 userid
queuetime_10 INDEX 75 queuetime
queuetime_11 INDEX 75 queuetime
jobid_10 INDEX 75 jobid
userid_6 INDEX 2 userid
queuesize_6 INDEX 75 queuesize
userid_7 INDEX 2 userid
statid_13 INDEX 75 statid
jobid_12 INDEX 75 jobid
queuesize_7 INDEX 75 queuesize
queuetime_12 INDEX 75 queuetime


 Space usage :
Type Usage
Data 16,384 Bytes
Index 933,888 Bytes
Total 950,272 Bytes
   Row Statistic :
Statements Value
Format fixed
Rows 75
Row length ø 218
Row size  ø 12,670 Bytes
Creation Apr 19, 2018 at 07:32 AM