title: Autoincrement id increase by 2
body: <p>I use following query to create table <code>news</code>:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `news` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `news_title` varchar(500) NOT NULL,
    `news_detail` varchar(5000) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 
  
  mysql&gt; desc news;
  +-------------+---------------+------+-----+---------+----------------+
  | Field       | Type          | Null | Key | Default | Extra          |
  +-------------+---------------+------+-----+---------+----------------+
  | id          | int(11)       | NO   | PRI | NULL    | auto_increment |
  | news_title  | varchar(500)  | NO   |     |         |                |
  | news_detail | varchar(5000) | NO   |     |         |                |
  +-------------+---------------+------+-----+---------+----------------+
  
  mysql&gt; insert into news (news_title, news_detail) values ('test','demod demo');
  
  
  
  mysql&gt; select * from news;
  +----+--------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------+
  | id | news_title                                                               | news_detail                                                                                                        |
  +----+--------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------+
  |  3 | Advani wants to shift from Gujarat, BJP trying to convince him otherwise | testt |
  |  5 | test                                                                     | demod demo                                                                                                         |
  +----+--------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------+
  </code></pre>
  
  <p>as you see in the <code>select</code> query the <code>id</code> is increment like <code>1,3,5,7...</code>. means it increment by 2. So what is the problem here?  </p>
  
  <p>actually in my local, it is increment by 1 and working perfectly. but in my server it creates the problem. 
  Thanks in advance.  </p>