Database table redesign for minimize data and increse performance

[Devrishi Shandilya]

Hi Friends,

I have a table sendgrid_data, and data in this table like mentioned below, for every unique event, multiple user entry as per event and timestamp.

show create table and real time data are as follows :


CREATE TABLE `sendgrid_data` (
`id` int(50) NOT NULL AUTO_INCREMENT,
`email` varchar(100) DEFAULT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`smtp-id` varchar(100) DEFAULT NULL,
`event` varchar(100) DEFAULT NULL,
`status` smallint(10) DEFAULT '1',
`url` varchar(250) DEFAULT NULL,
`useragent` varchar(250) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `IDX_EVENT_DATE` (`event`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=625810598 DEFAULT CHARSET=latin1


+-----------+--------------------------------+---------------------+--------------------------------------------------------+-------------+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------+
| id | email | date | smtp-id | event | status | url | useragent |
+-----------+--------------------------------+---------------------+--------------------------------------------------------+-------------+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------+
| 625607848 | [e-mail] | 2015-11-17 12:17:50 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625757142 | [e-mail] | 2015-11-17 08:33:09 | <[e-mail]> | deferred | 1 | | |
| 625690383 | [e-mail] | 2015-11-17 05:16:43 | <[e-mail]> | deferred | 1 | | |
| 625638607 | [e-mail] | 2015-11-17 02:13:47 | <[e-mail]> | deferred | 1 | | |
| 625689911 | [e-mail] | 2015-11-17 05:14:49 | <[e-mail]> | deferred | 1 | | |
| 625639176 | [e-mail] | 2015-11-17 02:16:09 | <[e-mail]> | deferred | 1 | | |
| 625750025 | [e-mail] | 2015-11-17 08:17:18 | <[e-mail]> | deferred | 1 | | |
| 625749845 | [e-mail] | 2015-11-17 08:16:47 | <[e-mail]> | deferred | 1 | | |
| 625695798 | [e-mail] | 2015-11-17 05:32:34 | <[e-mail]> | deferred | 1 | | |
| 625644537 | [e-mail] | 2015-11-17 02:31:59 | <[e-mail]> | deferred | 1 | | |
| 625782893 | [e-mail] | 2015-11-17 09:21:08 | <[e-mail]> | deferred | 1 | | |
| 625715187 | [e-mail] | 2015-11-17 06:20:33 | <[e-mail]> | deferred | 1 | | |
| 625638958 | [e-mail] | 2015-11-17 02:15:11 | <[e-mail]> | deferred | 1 | | |
| 625608244 | [e-mail] | 2015-11-17 12:18:54 | <[e-mail]> | deferred | 1 | | |
| 625662998 | [e-mail] | 2015-11-17 03:19:29 | <[e-mail]> | deferred | 1 | | |
| 625796489 | [e-mail] | 2015-11-17 09:53:20 | <[e-mail]> | deferred | 1 | | |
| 625749505 | [e-mail] | 2015-11-17 08:15:55 | <[e-mail]> | deferred | 1 | | |
| 625723405 | [e-mail] | 2015-11-17 06:52:46 | <[e-mail]> | deferred | 1 | | |
| 625690131 | [e-mail] | 2015-11-17 05:15:47 | <[e-mail]> | deferred | 1 | | |
| 625669911 | [e-mail] | 2015-11-17 03:51:44 | <[e-mail]> | deferred | 1 | | |
| 625617082 | [e-mail] | 2015-11-17 12:50:38 | <[e-mail]> | deferred | 1 | | |
| 625636731 | [e-mail] | 2015-11-17 02:05:06 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625785846 | [e-mail] | 2015-11-17 09:27:55 | | open | 1 | | Mozilla/5.0 (Linux; U; Android 4.4.2; en-us; GT-I9192 Build/KOT49H) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Mobile Safari/534.30 |
| 625751311 | [e-mail] | 2015-11-17 08:20:41 | <[e-mail]> | deferred | 1 | | |
| 625701827 | [e-mail] | 2015-11-17 05:45:44 | <[e-mail]> | deferred | 1 | | |
| 625642178 | [e-mail] | 2015-11-17 02:25:48 | <[e-mail]> | deferred | 1 | | |
| 625650424 | [e-mail] | 2015-11-17 02:45:09 | <[e-mail]> | deferred | 1 | | |
| 625693057 | [e-mail] | 2015-11-17 05:25:18 | <[e-mail]> | deferred | 1 | | |
| 625787701 | [e-mail] | 2015-11-17 09:32:29 | <[e-mail]> | deferred | 1 | | |
| 625639938 | [e-mail] | 2015-11-17 02:19:01 | <[e-mail]> | deferred | 1 | | |
| 625611715 | [e-mail] | 2015-11-17 12:30:10 | <[e-mail]> | deferred | 1 | | |
| 625619938 | [e-mail] | 2015-11-17 12:57:56 | <[e-mail]> | deferred | 1 | | |
| 625672328 | [e-mail] | 2015-11-17 03:58:58 | <[e-mail]> | deferred | 1 | | |
| 625753617 | [e-mail] | 2015-11-17 08:25:54 | <[e-mail]> | deferred | 1 | | |
| 625800521 | [e-mail] | 2015-11-17 10:00:36 | <[e-mail]> | deferred | 1 | | |
| 625725930 | [e-mail] | 2015-11-17 06:59:31 | <[e-mail]> | deferred | 1 | | |
| 625693610 | [e-mail] | 2015-11-17 05:26:53 | <[e-mail]> | deferred | 1 | | |
| 625717966 | [e-mail] | 2015-11-17 06:31:23 | <[e-mail]> | deferred | 1 | | |
| 625754575 | [e-mail] | 2015-11-17 08:27:54 | <[e-mail]> | deferred | 1 | | |
| 625641801 | [e-mail] | 2015-11-17 02:24:43 | <[e-mail]> | deferred | 1 | | |
| 625665544 | [e-mail] | 2015-11-17 03:30:43 | <[e-mail]> | deferred | 1 | | |
| 625691321 | [e-mail] | 2015-11-17 05:20:06 | <[e-mail]> | deferred | 1 | | |
| 625765195 | [e-mail] | 2015-11-17 08:46:49 | <[e-mail]> | deferred | 1 | | |
| 625814521 | [e-mail] | 2015-11-17 10:27:35 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625635397 | [e-mail] | 2015-11-17 01:56:29 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625635479 | [e-mail] | 2015-11-17 01:56:57 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625635882 | [e-mail] | 2015-11-17 01:59:11 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625794611 | [e-mail] | 2015-11-17 09:49:15 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625794579 | [e-mail] | 2015-11-17 09:49:09 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625799303 | [e-mail] | 2015-11-17 09:58:12 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625664675 | [e-mail] | 2015-11-17 03:26:45 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625780641 | [e-mail] | 2015-11-17 09:16:04 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625612050 | [e-mail] | 2015-11-17 12:31:37 | <[e-mail]> | deferred | 1 | | |
| 625755734 | [e-mail] | 2015-11-17 08:30:03 | <[e-mail]> | deferred | 1 | | |
| 625694682 | [e-mail] | 2015-11-17 05:29:28 | <[e-mail]> | deferred | 1 | | |
| 625650929 | [e-mail] | 2015-11-17 02:46:09 | <[e-mail]> | deferred | 1 | | |
| 625643228 | [e-mail] | 2015-11-17 02:28:25 | <[e-mail]> | deferred | 1 | | |
| 625674575 | [e-mail] | 2015-11-17 04:06:16 | <[e-mail]> | deferred | 1 | | |
| 625728614 | [e-mail] | 2015-11-17 07:07:21 | <[e-mail]> | deferred | 1 | | |
| 625665767 | [e-mail] | 2015-11-17 03:32:09 | <[e-mail]> | deferred | 1 | | |
| 625788288 | [e-mail] | 2015-11-17 09:33:47 | <[e-mail]> | deferred | 1 | | |
| 625694887 | [e-mail] | 2015-11-17 05:30:02 | <[e-mail]> | deferred | 1 | | |
| 625692883 | [e-mail] | 2015-11-17 05:24:48 | <[e-mail]> | deferred | 1 | | |
| 625755952 | [e-mail] | 2015-11-17 08:30:36 | <[e-mail]> | deferred | 1 | | |
| 625622440 | [e-mail] | 2015-11-17 01:05:11 | <[e-mail]> | deferred | 1 | | |
| 625765903 | [e-mail] | 2015-11-17 08:47:49 | <[e-mail]> | deferred | 1 | | |
| 625753353 | [e-mail] | 2015-11-17 08:25:20 | <[e-mail]> | deferred | 1 | | |
| 625643619 | [e-mail] | 2015-11-17 02:29:27 | <[e-mail]> | deferred | 1 | | |
| 625804606 | [e-mail] | 2015-11-17 10:07:56 | <[e-mail]> | deferred | 1 | | |
| 625641435 | [e-mail] | 2015-11-17 02:23:44 | <[e-mail]> | deferred | 1 | | |
| 625718394 | [e-mail] | 2015-11-17 06:33:15 | <[e-mail]> | deferred | 1 | | |
| 625702380 | [e-mail] | 2015-11-17 05:46:45 | <[e-mail]> | deferred | 1 | | |
| 625750321 | [e-mail] | 2015-11-17 08:18:01 | <[e-mail]> | deferred | 1 | | |
| 625751441 | [e-mail] | 2015-11-17 08:20:59 | <[e-mail]> | deferred | 1 | | |
| 625608440 | [e-mail] | 2015-11-17 12:19:25 | <[e-mail]> | deferred | 1 | | |
| 625662999 | [e-mail] | 2015-11-17 03:19:30 | <[e-mail]> | deferred | 1 | | |
| 625618584 | [e-mail] | 2015-11-17 12:54:14 | <[e-mail]> | deferred | 1 | | |
| 625753937 | [e-mail] | 2015-11-17 08:26:35 | <[e-mail]> | deferred | 1 | | |
| 625637496 | [e-mail] | 2015-11-17 02:09:12 | <[e-mail]> | deferred | 1 | | |
| 625688511 | [e-mail] | 2015-11-17 05:09:17 | <[e-mail]> | deferred | 1 | | |
| 625782180 | [e-mail] | 2015-11-17 09:19:39 | <[e-mail]> | deferred | 1 | | |
| 625693477 | [e-mail] | 2015-11-17 05:26:30 | <[e-mail]> | deferred | 1 | | |
| 625747249 | [e-mail] | 2015-11-17 08:09:22 | <[e-mail]> | deferred | 1 | | |
| 625642428 | [e-mail] | 2015-11-17 02:26:24 | <[e-mail]> | deferred | 1 | | |
| 625723985 | [e-mail] | 2015-11-17 06:54:23 | <[e-mail]> | deferred | 1 | | |
| 625670774 | [e-mail] | 2015-11-17 03:54:17 | <[e-mail]> | deferred | 1 | | |
| 625714919 | [e-mail] | 2015-11-17 06:19:34 | <[e-mail]> | deferred | 1 | | |
| 625639617 | [e-mail] | 2015-11-17 02:17:50 | <[e-mail]> | deferred | 1 | | |
| 625690696 | [e-mail] | 2015-11-17 05:17:54 | <[e-mail]> | deferred | 1 | | |
| 625797094 | [e-mail] | 2015-11-17 09:54:28 | <[e-mail]> | deferred | 1 | | |
| 625691561 | [e-mail] | 2015-11-17 05:20:56 | <[e-mail]> | deferred | 1 | | |
| 625640469 | [e-mail] | 2015-11-17 02:20:50 | <[e-mail]> | deferred | 1 | | |
| 625617200 | [e-mail] | 2015-11-17 12:51:02 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625617289 | [e-mail] | 2015-11-17 12:51:15 | | unsubscribe | 1 | | |
| 625829685 | [e-mail] | 2015-11-17 11:01:10 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625638418 | [e-mail] | 2015-11-17 02:12:57 | <[e-mail]> | deferred | 1 | | |
| 625644845 | [e-mail] | 2015-11-17 02:32:56 | <[e-mail]> | deferred | 1 | | |
| 625752057 | [e-mail] | 2015-11-17 08:22:24 | <[e-mail]> | deferred | 1 | | |
| 625620646 | [e-mail] | 2015-11-17 12:59:59 | <[e-mail]> | deferred | 1 | | |
| 625784216 | [e-mail] | 2015-11-17 09:24:09 | <[e-mail]> | deferred | 1 | | |
| 625748519 | [e-mail] | 2015-11-17 08:13:07 | <[e-mail]> | deferred | 1 | | |
| 625691990 | [e-mail] | 2015-11-17 05:22:19 | <[e-mail]> | deferred | 1 | | |
| 625609855 | [e-mail] | 2015-11-17 12:23:55 | <[e-mail]> | deferred | 1 | | |
| 625642195 | [e-mail] | 2015-11-17 02:25:53 | <[e-mail]> | deferred | 1 | | |
| 625693259 | [e-mail] | 2015-11-17 05:25:55 | <[e-mail]> | deferred | 1 | | |
| 625695920 | [e-mail] | 2015-11-17 05:33:00 | <[e-mail]> | deferred | 1 | | |
| 625672656 | [e-mail] | 2015-11-17 04:00:01 | <[e-mail]> | deferred | 1 | | |
| 625640972 | [e-mail] | 2015-11-17 02:22:15 | <[e-mail]> | deferred | 1 | | |
| 625753666 | [e-mail] | 2015-11-17 08:25:58 | <[e-mail]> | deferred | 1 | | |
| 625664055 | [e-mail] | 2015-11-17 03:23:59 | <[e-mail]> | deferred | 1 | | |
| 625689439 | [e-mail] | 2015-11-17 05:13:03 | <[e-mail]> | deferred | 1 | | |
| 625757141 | [e-mail] | 2015-11-17 08:33:05 | <[e-mail]> | deferred | 1 | | |
| 625726104 | [e-mail] | 2015-11-17 07:00:09 | <[e-mail]> | deferred | 1 | | |
| 625800332 | [e-mail] | 2015-11-17 10:00:14 | <[e-mail]> | deferred | 1 | | |
| 625716115 | [e-mail] | 2015-11-17 06:24:04 | <[e-mail]> | deferred | 1 | | |
| 625754004 | [e-mail] | 2015-11-17 08:26:47 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625757703 | [e-mail] | 2015-11-17 08:34:17 | <[e-mail]> | deferred | 1 | | |
| 625697983 | [e-mail] | 2015-11-17 05:37:28 | <[e-mail]> | deferred | 1 | | |
| 625770211 | [e-mail] | 2015-11-17 08:55:04 | <[e-mail]> | deferred | 1 | | |
| 625705821 | [e-mail] | 2015-11-17 05:54:00 | <[e-mail]> | deferred | 1 | | |
| 625625553 | [e-mail] | 2015-11-17 01:14:52 | <[e-mail]> | deferred | 1 | | |
| 625809215 | [e-mail] | 2015-11-17 10:17:07 | <[e-mail]> | deferred | 1 | | |
| 625731793 | [e-mail] | 2015-11-17 07:16:31 | <[e-mail]> | deferred | 1 | | |
| 625696261 | [e-mail] | 2015-11-17 05:33:49 | <[e-mail]> | deferred | 1 | | |
| 625613672 | [e-mail] | 2015-11-17 12:38:21 | <[e-mail]> | deferred | 1 | | |
| 625644762 | [e-mail] | 2015-11-17 02:32:44 | <[e-mail]> | deferred | 1 | | |
| 625790745 | [e-mail] | 2015-11-17 09:40:04 | <[e-mail]> | deferred | 1 | | |
| 625644938 | [e-mail] | 2015-11-17 02:33:11 | <[e-mail]> | deferred | 1 | | |
| 625646682 | [e-mail] | 2015-11-17 02:36:57 | <[e-mail]> | deferred | 1 | | |
| 625654294 | [e-mail] | 2015-11-17 02:53:26 | <[e-mail]> | deferred | 1 | | |
| 625759968 | [e-mail] | 2015-11-17 08:37:59 | <[e-mail]> | deferred | 1 | | |
| 625696240 | [e-mail] | 2015-11-17 05:33:46 | <[e-mail]> | deferred | 1 | | |
| 625719799 | [e-mail] | 2015-11-17 06:39:29 | <[e-mail]> | deferred | 1 | | |
| 625757845 | [e-mail] | 2015-11-17 08:34:25 | <[e-mail]> | deferred | 1 | | |
| 625677293 | [e-mail] | 2015-11-17 04:15:58 | <[e-mail]> | deferred | 1 | | |
| 625667037 | [e-mail] | 2015-11-17 03:38:55 | <[e-mail]> | deferred | 1 | | |
| 625831050 | [e-mail] | 2015-11-17 11:04:44 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625728700 | [e-mail] | 2015-11-17 07:07:37 | | open | 1 | | Mozilla/5.0 (iPad; CPU OS 8_1 like Mac OS X) AppleWebKit/600.1.4 (KHTML, like Gecko) Mobile/12B410 |
| 625821427 | [e-mail] | 2015-11-17 10:42:41 | <[e-mail]> | deferred | 1 | | |
| 625784938 | [e-mail] | 2015-11-17 09:25:46 | <[e-mail]> | deferred | 1 | | |
| 625740151 | [e-mail] | 2015-11-17 07:42:35 | <[e-mail]> | deferred | 1 | | |
| 625683688 | [e-mail] | 2015-11-17 04:42:31 | <[e-mail]> | deferred | 1 | | |
| 625716534 | [e-mail] | 2015-11-17 06:25:42 | <[e-mail]> | deferred | 1 | | |
| 625610306 | [e-mail] | 2015-11-17 12:25:33 | <[e-mail]> | deferred | 1 | | |
| 625664416 | [e-mail] | 2015-11-17 03:25:37 | <[e-mail]> | deferred | 1 | | |
| 625632870 | [e-mail] | 2015-11-17 01:42:27 | <[e-mail]> | deferred | 1 | | |
| 625653608 | [e-mail] | 2015-11-17 02:51:47 | <[e-mail]> | deferred | 1 | | |
| 625768473 | [e-mail] | 2015-11-17 08:51:56 | <[e-mail]> | deferred | 1 | | |
| 625757876 | [e-mail] | 2015-11-17 08:34:32 | <[e-mail]> | deferred | 1 | | |
| 625650149 | [e-mail] | 2015-11-17 02:44:34 | <[e-mail]> | deferred | 1 | | |
| 625792820 | [e-mail] | 2015-11-17 09:44:43 | <[e-mail]> | deferred | 1 | | |
| 625701213 | [e-mail] | 2015-11-17 05:44:39 | <[e-mail]> | deferred | 1 | | |
| 625668255 | [e-mail] | 2015-11-17 03:44:34 | <[e-mail]> | deferred | 1 | | |
| 625651020 | [e-mail] | 2015-11-17 02:46:24 | <[e-mail]> | deferred | 1 | | |
| 625627578 | [e-mail] | 2015-11-17 01:20:27 | <[e-mail]> | deferred | 1 | | |
| 625764958 | [e-mail] | 2015-11-17 08:46:35 | <[e-mail]> | deferred | 1 | | |
| 625811093 | [e-mail] | 2015-11-17 10:20:36 | <[e-mail]> | deferred | 1 | | |
| 625733336 | [e-mail] | 2015-11-17 07:20:33 | <[e-mail]> | deferred | 1 | | |
| 625721175 | [e-mail] | 2015-11-17 06:44:39 | <[e-mail]> | deferred | 1 | | |
| 625678808 | [e-mail] | 2015-11-17 04:20:30 | <[e-mail]> | deferred | 1 | | |
| 625763821 | [e-mail] | 2015-11-17 08:44:46 | <[e-mail]> | deferred | 1 | | |
| 625696561 | [e-mail] | 2015-11-17 05:34:27 | <[e-mail]> | deferred | 1 | | |
| 625704887 | [e-mail] | 2015-11-17 05:51:50 | <[e-mail]> | deferred | 1 | | |
| 625645452 | [e-mail] | 2015-11-17 02:34:23 | <[e-mail]> | deferred | 1 | | |
| 625615377 | [e-mail] | 2015-11-17 12:44:32 | <[e-mail]> | deferred | 1 | | |
| 625702178 | [e-mail] | 2015-11-17 05:46:29 | <[e-mail]> | deferred | 1 | | |
| 625786052 | [e-mail] | 2015-11-17 09:28:19 | <[e-mail]> | deferred | 1 | | |
| 625742932 | [e-mail] | 2015-11-17 07:53:27 | <[e-mail]> | deferred | 1 | | |
| 625781250 | [e-mail] | 2015-11-17 09:17:30 | <[e-mail]> | deferred | 1 | | |
| 625826740 | [e-mail] | 2015-11-17 10:54:32 | <[e-mail]> | deferred | 1 | | |
| 625635729 | [e-mail] | 2015-11-17 01:58:10 | <[e-mail]> | deferred | 1 | | |
| 625744692 | [e-mail] | 2015-11-17 07:59:19 | <[e-mail]> | deferred | 1 | | |
| 625685645 | [e-mail] | 2015-11-17 04:52:23 | <[e-mail]> | deferred | 1 | | |
| 625829427 | [e-mail] | 2015-11-17 11:00:25 | <[e-mail]> | deferred | 1 | | |
| 625664674 | [e-mail] | 2015-11-17 03:26:40 | <[e-mail]> | deferred | 1 | | |
| 625714101 | [e-mail] | 2015-11-17 06:16:55 | <[e-mail]> | deferred | 1 | | |
| 625690789 | [e-mail] | 2015-11-17 05:18:15 | <[e-mail]> | deferred | 1 | | |
| 625717096 | [e-mail] | 2015-11-17 06:27:45 | <[e-mail]> | deferred | 1 | | |
| 625606994 | [e-mail] | 2015-11-17 12:15:20 | <[e-mail]> | deferred | 1 | | |
| 625639444 | [e-mail] | 2015-11-17 02:17:10 | <[e-mail]> | deferred | 1 | | |
| 625750785 | [e-mail] | 2015-11-17 08:19:20 | <[e-mail]> | deferred | 1 | | |
| 625610327 | [e-mail] | 2015-11-17 12:25:36 | <[e-mail]> | deferred | 1 | | |
| 625747247 | [e-mail] | 2015-11-17 08:09:21 | <[e-mail]> | deferred | 1 | | |
| 625688410 | [e-mail] | 2015-11-17 05:08:46 | <[e-mail]> | deferred | 1 | | |
| 625686754 | [e-mail] | 2015-11-17 04:58:47 | <[e-mail]> | deferred | 1 | | |
| 625662144 | [e-mail] | 2015-11-17 03:16:21 | <[e-mail]> | deferred | 1 | | |
| 625637278 | [e-mail] | 2015-11-17 02:08:12 | <[e-mail]> | deferred | 1 | | |
| 625634444 | [e-mail] | 2015-11-17 01:51:20 | <[e-mail]> | deferred | 1 | | |
| 625644579 | [e-mail] | 2015-11-17 02:32:07 | <[e-mail]> | deferred | 1 | | |
| 625756749 | [e-mail] | 2015-11-17 08:32:15 | <[e-mail]> | deferred | 1 | | |
| 625695659 | [e-mail] | 2015-11-17 05:32:10 | <[e-mail]> | deferred | 1 | | |
| 625825100 | [e-mail] | 2015-11-17 10:50:45 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625812884 | [e-mail] | 2015-11-17 10:24:18 | | open | 1 | | Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko Firefox/11.0 (via ggpht.com GoogleImageProxy) |
| 625762812 | [e-mail] | 2015-11-17 08:42:58 | <[e-mail]> | deferred | 1 | | |
| 625694684 | [e-mail] | 2015-11-17 05:29:27 | <[e-mail]> | deferred | 1 | | |
| 625678119 | [e-mail] | 2015-11-17 04:18:22 | <[e-mail]> | deferred | 1 | | |
| 625699054 | [e-mail] | 2015-11-17 05:39:45 | <[e-mail]> | deferred | 1 | | |
| 625647844 | [e-mail] | 2015-11-17 02:39:40 | <[e-mail]> | deferred | 1 | | |
| 625761055 | [e-mail] | 2015-11-17 08:39:52 | <[e-mail]> | deferred | 1 | | |
| 625790675 | [e-mail] | 2015-11-17 09:39:54 | <[e-mail]> | deferred | 1 | | |
+-----------+--------------------------------+---------------------+--------------------------------------------------------+-------------+--------+------+---------------------------------------------------------------------------------------------------------------------------------------------+
200 rows in set (19 min 51.80 sec)



My issue is that, data is huge in this table 90 GB and it's rapidly growing, and very soon we have space problem and might be performance problem too.

data insertion rate is very high and we fetch report from tables based on index IDX_EVENT_DATE.

Can anyone suggest best design for reduce data storage and maximize performance for this table.