The InnoDB Forums: InnoDB Plugin InnoDB Forums
Discussions about installation and use of the plugin version of InnoDB. 
misbehaving auto_increment values?
Posted by: sbester ()
Date: Apr 17, 2008 14:13

during some insert/update/delete/create/drop tables in 2 threads, the value of all auto_increment columns of all tables having auto-inc is going negative until next restart of mysqld! I am never explicitly setting the value of this column.

+--------------+-----------+----------------------+
| Index_length | Data_free | Auto_increment |
+--------------+-----------+----------------------+
| 2768896 | 1536 | 18446744073709544176 |
| 2293760 | 1600 | 18446744073709551591 |
| 2785280 | 1536 | 18446744073709533706 |
| 2818048 | 1536 | 18446744073709514555 |
| 2506752 | 1600 | 18446744073709546776 |
| 2801664 | 1536 | 18446744073709479735 |
| 2539520 | 1536 | 18446744073709530170 |
| 0 | 1664 | NULL |
| 0 | 0 | NULL |
+--------------+-----------+----------------------+

<restart>

+--------------+-----------+----------------+
| Index_length | Data_free | Auto_increment |
+--------------+-----------+----------------+
| 2768896 | 1536 | 8371318 |
| 2293760 | 1600 | 8337988 |
| 2785280 | 1536 | 8373409 |
| 2818048 | 1536 | 8286416 |
| 2506752 | 1600 | 8384250 |
| 2801664 | 1536 | 8376923 |
| 2539520 | 1536 | 2147483648 |
| 0 | 1664 | NULL |
| 0 | 0 | NULL |
+--------------+-----------+----------------+

will post more details soon.

Navigate: Previous MessageNext Message
Options: ReplyQuote


Subject Views Written By Posted
misbehaving auto_increment values? 3702 sbester 17.04.2008 14:13
Re: misbehaving auto_increment values? 1862 KenJacobs 17.04.2008 17:12


Array
Sorry, only registered users may post in this forum.
Powered by Phorum.