Optimise table question

am 08.01.2005 15:29:35 von Greg Quinn

--=======AVGMAIL-41DFEE5002A6=======
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0003_01C4F59F.3DC4A840"

------=_NextPart_000_0003_01C4F59F.3DC4A840
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Is it dangerous if a database request occurs while optimise table is =
being run on a table?

If so, how can I prevent any requests from happening on the db while =
optimise table is running?

Thanks
------=_NextPart_000_0003_01C4F59F.3DC4A840
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

charset=3Diso-8859-1">

Is it dangerous if a database request =
occurs while=20
optimise table is being run on a table?

If so, how can I prevent any requests =
from=20
happening on the db while optimise table is running?

Thanks

------=_NextPart_000_0003_01C4F59F.3DC4A840--
--=======AVGMAIL-41DFEE5002A6=======
Content-Type: text/plain; x-avg=cert; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Content-Description: "AVG certification"

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.9 - Release Date: 1/6/2005

--=======AVGMAIL-41DFEE5002A6=======
Content-Type: text/plain; charset=us-ascii

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
--=======AVGMAIL-41DFEE5002A6=======--

Re: Optimise table question

am 08.01.2005 18:04:18 von Marcel Forget

As per http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html, the tables=
are locked while the command is executing therefore there is not need to=
be concerned about requests causing table corruption.

Marcel

*********** REPLY SEPARATOR ***********

On 08/01/2005 at 16:29 Greg Quinn wrote:

>Is it dangerous if a database request occurs while optimise table is
>being run on a table?
>
>If so, how can I prevent any requests from happening on the db while
>optimise table is running?
>
>Thanks
>No virus found in this outgoing message.
>Checked by AVG Anti-Virus.
>Version: 7.0.300 / Virus Database: 265.6.9 - Release Date: 1/6/2005
>
>
>--
>MySQL Windows Mailing List
>For list archives: http://lists.mysql.com/win32
>To unsubscribe:=
http://lists.mysql.com/win32?unsub=3Dlmforget2@rogers.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org