Starting MySQL in Maintenance mode

------_=_NextPart_001_01C9D989.C1F650FD
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

How do I start MySQL in maintenance/single user mode so I can create
indexes on a table that is being updated often?=20
I prefer for the update transactions to fail immediately with a
connection error rather than to wait for a lock to be released.=20
=20
In Oracle you can startup nomount. What is the equivalent for MySQL?
=20
George Tetterton
Alcatel-Lucent
3400 W. Plano Pkwy=20
Plano, TX 75075
Office: 972-477-1571
Cell: 972-400-0887
Email: george.tetterton@alcatel-lucent.com
=20
Yahoo Messenger ID: george_tetterton
=20

------_=_NextPart_001_01C9D989.C1F650FD--

RE: Starting MySQL in Maintenance mode

Do 'service mysql restart --skip-networking'

This prevents all TCP/IP connections

You can login as root@localhost and the client program will use the socket =
file rather than TCP/IP.
Do all your DDL work.

When done, 'service mysql restart'

Rolando A. Edwards
MySQL DBA (CMDBA)

155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM & Skype : RolandoLogicWorx
redwards@logicworks.net

-----Original Message-----
From: TETTERTON George [mailto:George.Tetterton@alcatel-lucent.com]=20
Sent: Wednesday, May 20, 2009 4:30 PM
To: mysql@lists.mysql.com
Subject: Starting MySQL in Maintenance mode

How do I start MySQL in maintenance/single user mode so I can create
indexes on a table that is being updated often?=20
I prefer for the update transactions to fail immediately with a
connection error rather than to wait for a lock to be released.=20
=20
In Oracle you can startup nomount. What is the equivalent for MySQL?
=20
George Tetterton
Alcatel-Lucent
3400 W. Plano Pkwy=20
Plano, TX 75075
Office: 972-477-1571
Cell: 972-400-0887
Email: george.tetterton@alcatel-lucent.com
=20
Yahoo Messenger ID: george_tetterton
=20

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Starting MySQL in Maintenance mode

But my updates are coming from a web server on the localhost so will
this still block connections? Sounds like the answer is no.=20

I forgot to say that I am running MySql 5.0 on Solaris 10 if that makes
a difference. =20

-----Original Message-----
From: Rolando Edwards [mailto:redwards@logicworks.net]=20
Sent: Wednesday, May 20, 2009 4:13 PM
To: TETTERTON George; mysql@lists.mysql.com
Subject: RE: Starting MySQL in Maintenance mode

Do 'service mysql restart --skip-networking'

This prevents all TCP/IP connections

You can login as root@localhost and the client program will use the
socket file rather than TCP/IP.
Do all your DDL work.

When done, 'service mysql restart'

Rolando A. Edwards
MySQL DBA (CMDBA)

155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM & Skype : RolandoLogicWorx
redwards@logicworks.net

-----Original Message-----
From: TETTERTON George [mailto:George.Tetterton@alcatel-lucent.com]
Sent: Wednesday, May 20, 2009 4:30 PM
To: mysql@lists.mysql.com
Subject: Starting MySQL in Maintenance mode

How do I start MySQL in maintenance/single user mode so I can create
indexes on a table that is being updated often?=20
I prefer for the update transactions to fail immediately with a
connection error rather than to wait for a lock to be released.=20
=20
In Oracle you can startup nomount. What is the equivalent for MySQL?
=20
George Tetterton
Alcatel-Lucent
3400 W. Plano Pkwy
Plano, TX 75075
Office: 972-477-1571
Cell: 972-400-0887
Email: george.tetterton@alcatel-lucent.com

Yahoo Messenger ID: george_tetterton
=20

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg