/etc/init.d/mysql start WITHOUT integrity check?

Is there a way to "/etc/init.d/mysql start" WITHOUT doing an integrity
check?

Can I pass in a command line parameter or set something in the my.cnf file?

Our DB is a Billion rows (with a "B") and that check can take HOURS.

All we want to do is restart the server to put another slave online because
sadly "/etc/init.d/mysql reload" does NOT re-load the config file (as one
might hope), it is only to reload PRIVS (how useless is that since GRANT
already does that).


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

RE: /etc/init.d/mysql start WITHOUT integrity check?

Daevid,

I'm not quite sure I understand why you want to restart your master. Adding=
a slave shouldn't require any restarts/reloads.=20

What have you changed in the my.cnf to solicit a restart?

Andy=20


________________________________________
From: ext Daevid Vincent [daevid@daevid.com]
Sent: 29 December 2010 20:25
To: 'mysql'
Subject: /etc/init.d/mysql start WITHOUT integrity check?

Is there a way to "/etc/init.d/mysql start" WITHOUT doing an integrity
check?

Can I pass in a command line parameter or set something in the my.cnf file?

Our DB is a Billion rows (with a "B") and that check can take HOURS.

All we want to do is restart the server to put another slave online because
sadly "/etc/init.d/mysql reload" does NOT re-load the config file (as one
might hope), it is only to reload PRIVS (how useless is that since GRANT
already does that).


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dandrew.2.moore@noki=
a.com


--
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: /etc/init.d/mysql start WITHOUT integrity check?

--0016e6d588d78c81a30498a04537
Content-Type: text/plain; charset=ISO-8859-1

Let me know with you whether I understood what do you want to do. Normally,
after mysqld restart on OSs as Ubuntu/Debian, we can observe a script
execution, which will check integrity of all databases tables and present a
message of "Corrupt ...". What I did when I wanted to get rid this check of
was comment the lines inside the file script with # character.

Please, let us know if it is the operation do you want to avoid when restart
mysqld.

Best regards.
--
Wagner Bianchi


2010/12/30

> Daevid,
>
> I'm not quite sure I understand why you want to restart your master. Adding
> a slave shouldn't require any restarts/reloads.
>
> What have you changed in the my.cnf to solicit a restart?
>
> Andy
>
>
> ________________________________________
> From: ext Daevid Vincent [daevid@daevid.com]
> Sent: 29 December 2010 20:25
> To: 'mysql'
> Subject: /etc/init.d/mysql start WITHOUT integrity check?
>
> Is there a way to "/etc/init.d/mysql start" WITHOUT doing an integrity
> check?
>
> Can I pass in a command line parameter or set something in the my.cnf file?
>
> Our DB is a Billion rows (with a "B") and that check can take HOURS.
>
> All we want to do is restart the server to put another slave online because
> sadly "/etc/init.d/mysql reload" does NOT re-load the config file (as one
> might hope), it is only to reload PRIVS (how useless is that since GRANT
> already does that).
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=andrew.2.moore@nokia.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=wagnerbianchijr@gmail.com
>
>

--0016e6d588d78c81a30498a04537--

RE: /etc/init.d/mysql start WITHOUT integrity check?

> -----Original Message-----
> From: andrew.2.moore@nokia.com [mailto:andrew.2.moore@nokia.com]
> Sent: Thursday, December 30, 2010 2:45 AM
> To: daevid@daevid.com; mysql@lists.mysql.com
> Subject: RE: /etc/init.d/mysql start WITHOUT integrity check?
>
> Daevid,
>
> I'm not quite sure I understand why you want to restart your
> master. Adding a slave shouldn't require any restarts/reloads.
>
> What have you changed in the my.cnf to solicit a restart?

It requires a restart of the slave mysql server. It also requires shutting
down the master so that no data is written while we copy the snapshot to
the slave.

http://dev.mysql.com/doc/refman/5.0/en/replication-howto-exi stingdata.html

> Andy
>
>
> ________________________________________
> From: ext Daevid Vincent [daevid@daevid.com]
> Sent: 29 December 2010 20:25
> To: 'mysql'
> Subject: /etc/init.d/mysql start WITHOUT integrity check?
>
> Is there a way to "/etc/init.d/mysql start" WITHOUT doing an integrity
> check?
>
> Can I pass in a command line parameter or set something in
> the my.cnf file?
>
> Our DB is a Billion rows (with a "B") and that check can take HOURS.
>
> All we want to do is restart the server to put another slave
> online because
> sadly "/etc/init.d/mysql reload" does NOT re-load the config
> file (as one
> might hope), it is only to reload PRIVS (how useless is that
> since GRANT
> already does that).
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=andrew.2.moore@nokia.com
>


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

RE: /etc/init.d/mysql start WITHOUT integrity check?

------=_NextPart_000_085D_01CBA829.F75D8D60
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Comment WHAT lines?

I looked through /etc/init.d/mysql and don't see anything related to
"check" or "chk". I eyeballed each line in the file and nothing stands out
as the culprit causing an integrity check of the databases.

developer@mypse:/etc/init.d$ ps aux | grep mysql
46:root 10239 0.0 0.1 1680 520 ? S Dec25 0:00 /bin/sh
/usr/bin/mysqld_safe
49:mysql 11165 0.0 5.4 129924 27864 ? Sl Dec25 0:58
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
50:root 11167 0.0 0.1 2920 692 ? S Dec25 0:00 logger
-p daemon.err -t mysqld_safe -i -t mysqld
81:1000 19149 0.0 0.1 3004 788 pts/0 R+ 21:54 0:00 grep -n
-i --color=auto mysql

developer@mypse:/etc/init.d$ cat
/proc/11165/cmdline
/usr/sbin/mysqld--basedir=/usr--datadir=/var/lib/mysql--user =mysql--pid-fil
e=/var/run/mysqld/mysqld.pid--skip-external-locking--port=33 06--socket=/var
/run/mysqld/mysqld.sockd

Does anyone know if a "kill -SIGHUP 11165" will cause a reload of the
configuration?


_____

From: Wagner Bianchi [mailto:wagnerbianchijr@gmail.com]
Sent: Thursday, December 30, 2010 5:01 AM
To: andrew.2.moore@nokia.com
Cc: daevid@daevid.com; mysql@lists.mysql.com
Subject: Re: /etc/init.d/mysql start WITHOUT integrity check?


Let me know with you whether I understood what do you want to do. Normally,
after mysqld restart on OSs as Ubuntu/Debian, we can observe a script
execution, which will check integrity of all databases tables and present a
message of "Corrupt ...". What I did when I wanted to get rid this check of
was comment the lines inside the file script with # character.

Please, let us know if it is the operation do you want to avoid when
restart mysqld.

Best regards.
--
Wagner Bianchi


2010/12/30


Daevid,

I'm not quite sure I understand why you want to restart your master. Adding
a slave shouldn't require any restarts/reloads.

What have you changed in the my.cnf to solicit a restart?

Andy


________________________________________
From: ext Daevid Vincent [daevid@daevid.com]
Sent: 29 December 2010 20:25
To: 'mysql'
Subject: /etc/init.d/mysql start WITHOUT integrity check?


Is there a way to "/etc/init.d/mysql start" WITHOUT doing an integrity
check?

Can I pass in a command line parameter or set something in the my.cnf file?

Our DB is a Billion rows (with a "B") and that check can take HOURS.

All we want to do is restart the server to put another slave online because
sadly "/etc/init.d/mysql reload" does NOT re-load the config file (as one
might hope), it is only to reload PRIVS (how useless is that since GRANT
already does that).


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

To unsubscribe:
http://lists.mysql.com/mysql?unsub=andrew.2.moore@nokia.com



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





------=_NextPart_000_085D_01CBA829.F75D8D60--

Re: /etc/init.d/mysql start WITHOUT integrity check?

On 12/30/2010 5:00 PM, Daevid Vincent wrote:
> Comment WHAT lines?
>
> I looked through /etc/init.d/mysql and don't see anything related to
> "check" or "chk". I eyeballed each line in the file and nothing stands out
> as the culprit causing an integrity check of the databases.
>
> developer@mypse:/etc/init.d$ ps aux | grep mysql
> 46:root 10239 0.0 0.1 1680 520 ? S Dec25 0:00 /bin/sh
> /usr/bin/mysqld_safe
> 49:mysql 11165 0.0 5.4 129924 27864 ? Sl Dec25 0:58
> /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
> --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306
> --socket=/var/run/mysqld/mysqld.sock
> 50:root 11167 0.0 0.1 2920 692 ? S Dec25 0:00 logger
> -p daemon.err -t mysqld_safe -i -t mysqld
> 81:1000 19149 0.0 0.1 3004 788 pts/0 R+ 21:54 0:00 grep -n
> -i --color=auto mysql
>
> developer@mypse:/etc/init.d$ cat
> /proc/11165/cmdline
> /usr/sbin/mysqld--basedir=/usr--datadir=/var/lib/mysql--user =mysql--pid-fil
> e=/var/run/mysqld/mysqld.pid--skip-external-locking--port=33 06--socket=/var
> /run/mysqld/mysqld.sockd
>
> Does anyone know if a "kill -SIGHUP 11165" will cause a reload of the
> configuration?
>
>

It won't reload the configuration.
http://dev.mysql.com/doc/refman/5.1/en/server-signal-respons e.html

Are you sure you aren't seeing the results of a dirty shutdown and
auto-recovery?

--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN

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

Re: /etc/init.d/mysql start WITHOUT integrity check?

--0016e6d97652dbcf6e0498a83b36
Content-Type: text/plain; charset=ISO-8859-1

There are different and connected things being discussed here.

1-) Is there a way to read new configurations from my.cnf whithout restart
server?
=> No. A simple mysqladmin reaload don't submit server to read configuration
file again.

2-) Is there a way to avoid debian-script to check databases' integrity?
=> Yeah, there is! Open the debian script and comment all rows.

Best regards.
--
Wagner Bianchi

2010/12/30 Shawn Green

> On 12/30/2010 5:00 PM, Daevid Vincent wrote:
>
>> Comment WHAT lines?
>>
>> I looked through /etc/init.d/mysql and don't see anything related to
>> "check" or "chk". I eyeballed each line in the file and nothing stands out
>> as the culprit causing an integrity check of the databases.
>>
>> developer@mypse:/etc/init.d$ ps aux | grep mysql
>> 46:root 10239 0.0 0.1 1680 520 ? S Dec25 0:00
>> /bin/sh
>> /usr/bin/mysqld_safe
>> 49:mysql 11165 0.0 5.4 129924 27864 ? Sl Dec25 0:58
>> /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
>> --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306
>> --socket=/var/run/mysqld/mysqld.sock
>> 50:root 11167 0.0 0.1 2920 692 ? S Dec25 0:00 logger
>> -p daemon.err -t mysqld_safe -i -t mysqld
>> 81:1000 19149 0.0 0.1 3004 788 pts/0 R+ 21:54 0:00 grep
>> -n
>> -i --color=auto mysql
>>
>> developer@mypse:/etc/init.d$ cat
>>
>> /proc/11165/cmdline
>>
>> /usr/sbin/mysqld--basedir=/usr--datadir=/var/lib/mysql--user =mysql--pid-fil
>>
>> e=/var/run/mysqld/mysqld.pid--skip-external-locking--port=33 06--socket=/var
>> /run/mysqld/mysqld.sockd
>>
>> Does anyone know if a "kill -SIGHUP 11165" will cause a reload of the
>> configuration?
>>
>>
>>
> It won't reload the configuration.
> http://dev.mysql.com/doc/refman/5.1/en/server-signal-respons e.html
>
> Are you sure you aren't seeing the results of a dirty shutdown and
> auto-recovery?
>
> --
> Shawn Green
> MySQL Principal Technical Support Engineer
> Oracle USA, Inc.
> Office: Blountville, TN
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=wagnerbianchijr@gmail.com
>
>

--0016e6d97652dbcf6e0498a83b36--