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
. 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 [dae...@daevid.com]
Sent: 29 December 2010 20:25
To: 'mysql'
Subject: /etc/init.d/mysql start WITHOUT
-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
?
_
From: Wagner Bianchi [mailto:wagnerbianch...@gmail.com]
Sent: Thursday, December 30, 2010 5:01 AM
To: andrew.2.mo...@nokia.com
Cc: dae...@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
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.
develo...@mypse:/etc/init.d$
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'
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