From: Reindl Harald
Date: June 4 2012 12:42pm
Subject: Re: i am running mysqlrepair on 80G myisam table.
List-Archive: http://lists.mysql.com/mysql/227582
Message-Id: <4FCCAD29.7000200@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig19EC35C88C98309368083207"

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



Am 04.06.2012 14:35, schrieb Joey L:
> i am running mysqlrepair on 80G myisam table.
> It is taking forever to repair - i am getting a lot of  "Waiting for
> table" messeges when i execute "show full processlist"
>=20
> 613 | p_040912   | localhost | p_040912    | Query   |   24 | Waiting
> for table | SELECT `oldurl`, `newurl
>=20
> Can anyone help for this ? is there anything i can tweak in the my.cnf
> file that avoids this issue - it is taking forever !!!

no - a repair always locks a table

how would you avoid this technically?
the whole table is re-created and mysql can not deal with queries at this=
 time

additionally MyISAM does ALWAYS full table locks



--------------enig19EC35C88C98309368083207
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.12 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk/MrSkACgkQhmBjz394AnkVSwCfVxpsY5NGYrh3RqF9ZEIpf/uf
URYAnif9dJbN5oCeJnCQVYXhCVRXPx1u
=RzU2
-----END PGP SIGNATURE-----

--------------enig19EC35C88C98309368083207--