Re: High concurrency for master and high reading from slave slowing down insert

[Frwa Onto]

Dear Peter,
Here is my main table structure.
`gdata` (
`alarmTypeID` tinyint(4) NOT NULL DEFAULT '0',
`fleetID` smallint(11) NOT NULL,
`fleetGroupID` smallint(11) DEFAULT NULL,
`fleetSubGroupID` smallint(11) DEFAULT NULL,
`deviceID` mediumint(11) NOT NULL,
`vehicleID` mediumint(11) NOT NULL,
`gDateTime` datetime NOT NULL,
`insertDateTime` datetime NOT NULL,
`latitude` float NOT NULL,
`longitude` float NOT NULL,
`speed` smallint(11) NOT NULL,
(see full text)
ALTER TABLE `gdata`
ADD PRIMARY KEY (`alarmTypeID`,`vehicleID`,`gDateTime`),
ADD KEY `gDateTime` (`gDateTime`),
ADD KEY `fleetID` (`fleetID`,`vehicleID`,`gDateTime`);
COMMIT;

I will have 30000 devices with interval time 1 minute meaning within every minute we can anticipate 30000 data coming. So I plan to split the java server in to smaller chunks.