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

email_queues

Table comments : InnoDB free: 776192 kB

Field Type Null Default
queueid  int(11) Yes 
queuetype  varchar(255) Yes  NULL 
ownerid  int(11) No 
recipient  int(11) Yes 
processed  char(1) Yes 
sent  char(1) Yes 
processtime  datetime Yes  NULL 


 Indexes :
Keyname Type Cardinality Field
email_queues_id_type_recip_idx INDEX 102086 queueid
queuetype
recipient
email_queues_id_type_processed_idx INDEX 6 queueid
queuetype
processed
email_queuetype_recipient_idx INDEX 51043 queuetype
recipient
queueid INDEX 4 queueid
queuetype INDEX 4 queuetype
ownerid INDEX 4 ownerid
recipient INDEX 51043 recipient
processed INDEX 4 processed
sent INDEX 4 sent
processtime INDEX 38 processtime
processed_2 INDEX 4 processed
recipient_2 INDEX 51043 recipient
queuetype_2 INDEX 4 queuetype
ownerid_2 INDEX 4 ownerid
processtime_2 INDEX 102086 processtime
queueid_2 INDEX 4 queueid
sent_2 INDEX 4 sent
processed_3 INDEX 4 processed
queuetype_3 INDEX 4 queuetype
sent_3 INDEX 4 sent
processtime_3 INDEX 102086 processtime
ownerid_3 INDEX 4 ownerid
queueid_3 INDEX 4 queueid
recipient_3 INDEX 51043 recipient
queuetype_4 INDEX 4 queuetype
processtime_4 INDEX 25521 processtime
ownerid_4 INDEX 4 ownerid
queueid_4 INDEX 4 queueid
sent_4 INDEX 4 sent
recipient_4 INDEX 51043 recipient
processed_4 INDEX 4 processed
ownerid_5 INDEX 4 ownerid
processed_5 INDEX 4 processed
queueid_5 INDEX 4 queueid
recipient_5 INDEX 102086 recipient
queuetype_5 INDEX 4 queuetype
processtime_5 INDEX 4 processtime
sent_5 INDEX 4 sent
queuetype_6 INDEX 4 queuetype
queueid_6 INDEX 32 queueid
processed_6 INDEX 4 processed
ownerid_6 INDEX 4 ownerid
sent_6 INDEX 4 sent
recipient_6 INDEX 51043 recipient
queueid_7 INDEX 32 queueid
queuetype_7 INDEX 4 queuetype
ownerid_7 INDEX 4 ownerid
recipient_7 INDEX 51043 recipient
processed_7 INDEX 4 processed
sent_7 INDEX 4 sent
processtime_6 INDEX 34028 processtime


 Space usage :
Type Usage
Data 7,696 KB
Index 142,640 KB
Total 150,336 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 102,086
Row length ø 77
Row size  ø 1,508 Bytes
Creation Apr 15, 2018 at 06:15 PM