Re: Show innodb engine status tuning db server

[Frwa Onto]

Dear Rick,
The autocommit is set to false at the very top.I saw this but is very rarely appears and could not catch the innodb log.

CREATE TABLE IF NOT EXISTS `tblAst` (
  `astID` int(5) NOT NULL,
  `entID` int(5) NOT NULL,
  `ctID` int(5) NOT NULL,
  `ast` varchar(50) NOT NULL,
  `vID` int(5) NOT NULL,
  `mstID` int(5) NOT NULL,
  `emIDInsert` int(5) NOT NULL,
  `dateTimeInsert` datetime NOT NULL,
  `dateTimeStart` datetime NOT NULL,
  `emIDEnd` int(5) NOT NULL DEFAULT '0',
  `dateTimeEnd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `astType` enum('S','SM','SSS') NOT NULL,
  `astStatus` enum('a','d','e','m') NOT NULL,
  PRIMARY KEY (`astID`),
  KEY `astStatus` (`astStatus`),
  KEY `entID` (`entID`),
  KEY `mstID` (`mstID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

UPDATE tblAst SET dateTimeStart='2013-09-21 19:11:12' Where astID=3458