From: Reindl Harald
Date: October 3 2011 9:59pm
Subject: Re: How  MyISAM handle auto_increment
List-Archive: http://lists.mysql.com/mysql/225908
Message-Id: <4E8A304D.5030601@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig7B4D9D8DDE410C7D1D13C9D8"

--------------enig7B4D9D8DDE410C7D1D13C9D8
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 03.10.2011 23:46, schrieb Angela liu:
> Hi, Folks:
>=20
>=20
> I have questions regarding how MyISAM handles auto_increment clolumn?
>=20
> 1. is there a auto_increment counter for MyISAM to assign a new value t=
o auto_increment columns?
> 2. if MyISAM has the counter, is the counter stored in memory or disk?

it is a table-property and you hould NOT touch it without godd reasons
because it is named AUTO



--------------enig7B4D9D8DDE410C7D1D13C9D8
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk6KMFAACgkQhmBjz394AnkcIQCePlm2tjOcQGObauiEsk/5q6H8
fzgAn1griWaWP2pvCc94em54/7Ko5+44
=KT8U
-----END PGP SIGNATURE-----

--------------enig7B4D9D8DDE410C7D1D13C9D8--