Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_stats_usersemail_stats_users
An index has been added on jobid (Query took 0.0544 sec)
SQL-query: 
ALTER TABLE `email_stats_users` ADD INDEX ( `jobid` )
 [Edit] [Create PHP Code]


InnoDB free: 781312 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Relation viewRelation view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 75  Edit Drop statid
statid_2 UNIQUE 75  Edit Drop statid
statid_4 UNIQUE 75  Edit Drop statid
statid_6 UNIQUE 75  Edit Drop statid
statid_7 UNIQUE 75  Edit Drop statid
statid_11 UNIQUE 75  Edit Drop statid
statid_12 UNIQUE 75  Edit Drop statid
statid_14 UNIQUE 75  Edit Drop statid
jobid_2 UNIQUE 75  Edit Drop jobid
queuetime_2 UNIQUE 75  Edit Drop queuetime
jobid_3 UNIQUE 75  Edit Drop jobid
queuetime_4 UNIQUE 75  Edit Drop queuetime
jobid_5 UNIQUE 75  Edit Drop jobid
queuetime_5 UNIQUE 75  Edit Drop queuetime
jobid_7 UNIQUE 75  Edit Drop jobid
queuetime_8 UNIQUE 75  Edit Drop queuetime
queuetime_9 UNIQUE 75  Edit Drop queuetime
jobid_9 UNIQUE 75  Edit Drop jobid
jobid_11 UNIQUE 75  Edit Drop jobid
jobid_13 UNIQUE 75  Edit Drop jobid
queuetime_13 UNIQUE 75  Edit Drop queuetime
queuetime_14 UNIQUE 75  Edit Drop queuetime
email_stats_users_all_idx INDEX 75  Edit Drop userid
queuetime
queuesize
email_stats_users_statid_idx INDEX 75  Edit Drop statid
userid INDEX Edit Drop userid
statid INDEX 75  Edit Drop statid
jobid INDEX 75  Edit Drop jobid
queuesize INDEX 75  Edit Drop queuesize
queuetime INDEX 75  Edit Drop queuetime
statid_3 INDEX 75  Edit Drop statid
userid_2 INDEX Edit Drop userid
queuetime_3 INDEX 75  Edit Drop queuetime
queuesize_2 INDEX 75  Edit Drop queuesize
jobid_4 INDEX 75  Edit Drop jobid
userid_3 INDEX Edit Drop userid
statid_5 INDEX 75  Edit Drop statid
queuetime_6 INDEX 75  Edit Drop queuetime
jobid_6 INDEX 75  Edit Drop jobid
queuesize_3 INDEX 75  Edit Drop queuesize
statid_8 INDEX 75  Edit Drop statid
userid_4 INDEX Edit Drop userid
queuetime_7 INDEX 75  Edit Drop queuetime
queuesize_4 INDEX 75  Edit Drop queuesize
jobid_8 INDEX 75  Edit Drop jobid
statid_9 INDEX 75  Edit Drop statid
queuesize_5 INDEX 75  Edit Drop queuesize
statid_10 INDEX 75  Edit Drop statid
userid_5 INDEX Edit Drop userid
queuetime_10 INDEX 75  Edit Drop queuetime
queuetime_11 INDEX 75  Edit Drop queuetime
jobid_10 INDEX 75  Edit Drop jobid
userid_6 INDEX Edit Drop userid
queuesize_6 INDEX 75  Edit Drop queuesize
userid_7 INDEX Edit Drop userid
statid_13 INDEX 75  Edit Drop statid
jobid_12 INDEX 75  Edit Drop jobid
queuesize_7 INDEX 75  Edit Drop queuesize
queuetime_12 INDEX 75  Edit Drop queuetime
jobid_14 INDEX 75  Edit Drop jobid
Create an index on  columns  
 
Space usage: 
Type Usage
Data 16,384 Bytes
Index 950,272 Bytes
Total 966,656 Bytes
 
Row Statistic: 
Statements Value
Format fixed
Collation utf8_general_ci
Creation Apr 26, 2018 at 02:59 PM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: