SEO

Hi Chris,

In my.cnf in the following section, remove comment from skip-networking
statement, and re-start your MySQL

# Don't listen on a TCP/IP port at all. This can be a security
enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named
pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< <<<<<<<<<<<<<<<<<<<<<<
<<<<<<< This to be uncommented before running administrative task, and
commented back to put MySQL back to live

Regards,

Mikhail Berman

-----Original Message-----
From: Wagner, Chris (GEAE, CBTS) [mailto:chris.wagner@ae.ge.com]
Sent: Thursday, September 14, 2006 4:08 PM
To: mysql@lists.mysql.com
Subject: taking MySQL down into "admin" mode

Greetz. We have a database that is highly used, around 500 queries/s,
and doing administrative tasks can stuff up the database. Is there a
way to temporarily prevent client connections from within MySQL? Like
unix u can drop the runlevel to do administration, is there something
similar in MySQL? I haven't seen anything promising in the manual.
We're on 5.0.24.


--
Chris Wagner
CBTS
GE Aircraft Engines
Chris.Wagner@ae.ge.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=mberman@ivesinc.com

Thanks for that but I was hoping there was a way to do it "live" that
didn't require restarting/reloading. Something to do at the mysql>
prompt. We had to repair a table and all the backed up connections were
threatening to take down the daemon.

Mikhail Berman wrote:
>
> Hi Chris,
>
> In my.cnf in the following section, remove comment from skip-networking
> statement, and re-start your MySQL

--
Chris Wagner
CBTS
GE Aircraft Engines
Chris.Wagner@ae.ge.com