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

email_queues

Table comments : InnoDB free: 730112 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 4 processtime
processed_2 INDEX 4 processed
recipient_2 INDEX 51043 recipient
queuetype_2 INDEX 4 queuetype
ownerid_2 INDEX 4 ownerid
processtime_2 INDEX 4 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 4 processtime
ownerid_3 INDEX 4 ownerid
queueid_3 INDEX 4 queueid
recipient_3 INDEX 51043 recipient
queuetype_4 INDEX 4 queuetype
processtime_4 INDEX 4 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 32 queueid
recipient_5 INDEX 51043 recipient
queuetype_5 INDEX 4 queuetype
processtime_5 INDEX 4 processtime
sent_5 INDEX 4 sent
queuetype_6 INDEX 4 queuetype
queueid_6 INDEX 4 queueid
processed_6 INDEX 4 processed
ownerid_6 INDEX 4 ownerid
sent_6 INDEX 4 sent
recipient_6 INDEX 51043 recipient
queueid_7 INDEX 4 queueid
queuetype_7 INDEX 4 queuetype
ownerid_7 INDEX 4 ownerid
recipient_7 INDEX 102086 recipient
processed_7 INDEX 4 processed
sent_7 INDEX 4 sent
processtime_6 INDEX 34028 processtime
processtime_7 INDEX 34028 processtime
queueid_8 INDEX 4 queueid
sent_8 INDEX 4 sent
queueid_9 INDEX 32 queueid
processtime_8 INDEX 4 processtime
queuetype_8 INDEX 4 queuetype
sent_9 INDEX 4 sent
ownerid_8 INDEX 4 ownerid
recipient_8 INDEX 51043 recipient
ownerid_9 INDEX 4 ownerid
recipient_9 INDEX 51043 recipient
processed_8 INDEX 4 processed


 Space usage :
Type Usage
Data 7,696 KB
Index 175,600 KB
Total 183,296 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 102,086
Row length ø 77
Row size  ø 1,839 Bytes
Creation Apr 25, 2024 at 04:23 PM