title: Reduce data size of a table in MySQL
body: <p>In one of table, there are around 900 thousand records. when we checked the data size it is around 800 MB. Can we reduce the data size with out deleting data.</p>
  
  <p>Thanks In Advance.</p>
  
  <hr>
  
  <pre><code>CREATE TABLE snmptraps(
   SiteID int(11) NOT NULL default 1,
   SystemID int(11) NOT NULL,
   EnterpriseID varchar(255) default NULL,
   IPAddress varchar(255) default NULL,
   GenericTrap varchar(255) default NULL,
   SpecificTrap varchar(255) default NULL,
   TimestampGen varchar(255) default NULL,
   TimestampRec datetime default NULL,
   OID varchar(1024) default NULL,
   OIDValue varchar(1024) default NULL,
   TimePeriod TIMESTAMP NOT NULL default CURRENT_TIMESTAMP,
   PDUType int(11),
   Description varchar(255) default NULL,
  );
  </code></pre>