> -----Original Message----- > From: andrew.2.mo...@nokia.com [mailto:andrew.2.mo...@nokia.com] > Sent: Thursday, December 30, 2010 2:45 AM > To: dae...@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-existingdata.html > Andy > > > ________________________________________ > From: ext Daevid Vincent [dae...@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.mo...@nokia.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org