How do I start MySQL in maintenance/single user mode so I can create
indexes on a table that is being updated often?
I prefer for the update transactions to fail immediately with a
connection error rather than to wait for a lock to be released.
In Oracle you can startup nomount. What is the
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?
I prefer for the update transactions to fail immediately with a
connection error rather than to wait for a lock to be released
...@logicworks.net]
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 r...@localhost and the client program will use the
socket file