Re: Require help in fine tuning MySQL 5.5 query

[Kushal M]

Hi Peter,

Thanks for you reply.

Below is the result for the query Show Create Table CP_DataPoints;


+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| CP_DataPoints | CREATE TABLE `CP_DataPoints` (
`Identifier` varchar(100) NOT NULL DEFAULT '',
`Host_PODS` varchar(50) NOT NULL DEFAULT '',
`Epoch_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`Metric_ID` int(11) NOT NULL DEFAULT '0',
`Metric_Value` double DEFAULT NULL,
`DiskSpace_Info` varchar(100) DEFAULT NULL,
PRIMARY KEY (`Identifier`,`Host_PODS`,`Epoch_time`,`Metric_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Currently on the server I have 16 GB RAM, innodb_buffer_pool_size is 128MB and there is no swapping that takes place during the query.

Thanks,
Kushal M