ResultSet repairResult = sStatement.executeQuery( "repair table " + this.getTableName() ); StringBuilder repairString = new StringBuilder(); int numColumns = repairResult.getMetaData().getColumnCount();
ResultSet repairResult = sStatement.executeQuery( "repair table " + this.getTableName() ); StringBuilder repairString = new StringBuilder(); int numColumns = repairResult.getMetaData().getColumnCount();
if ( log.isInfoEnabled() ) log.info( "Optimizing table [" + this.getTableName() + "]" ); ResultSet rs = sStatement.executeQuery( "optimize table " + this.getTableName() ); if ( log.isInfoEnabled() ) log.info( "Table status after optimizing table [" + this.getTableName() + "]\n" + statusString ); log.error( "Problem optimizing table [" + this.getTableName() + "]", e ); return false; if ( log.isInfoEnabled() ) log.info( "Optimization of table [" + this.getTableName() + "] took " + ( end - start ) + " ms." );
if ( log.isInfoEnabled() ) log.info( "Optimizing table [" + this.getTableName() + "]" ); ResultSet rs = sStatement.executeQuery( "optimize table " + this.getTableName() ); if ( log.isInfoEnabled() ) log.info( "Table status after optimizing table [" + this.getTableName() + "]\n" + statusString ); log.error( "Problem optimizing table [" + this.getTableName() + "]", e ); return false; if ( log.isInfoEnabled() ) log.info( "Optimization of table [" + this.getTableName() + "] took " + ( end - start ) + " ms." );