Re: my.cnf file

2010-12-30 Thread Sharl.Jimh.Tsin
rpm -qpi mysql*.rpm | grep my.cnf Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/30 Lydia Rowe : > find / -name my.cnf > > -- > Lydia > > On Thu, 2010-12-30 at 11:09 -0200, Wagner Bianchi wrote: >> I am seeing you're using an operate system based on Red Hat dis

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

2010-12-30 Thread Wagner Bianchi
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'

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

2010-12-30 Thread 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. develo...@mypse:/etc/init.

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

2010-12-30 Thread Daevid Vincent
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$ ps aux | grep mysql 46:root 10239 0.0

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

2010-12-30 Thread Daevid Vincent
> -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 under

Re: my.cnf file

2010-12-30 Thread Lydia Rowe
find / -name my.cnf -- Lydia On Thu, 2010-12-30 at 11:09 -0200, Wagner Bianchi wrote: > I am seeing you're using an operate system based on Red Hat distro. Well, > after install MySQL via yum or via rpm packages, the location of MySQL > samples configuration file usually is /usr/share/mysql. > >

Re: my.cnf file

2010-12-30 Thread Wagner Bianchi
I am seeing you're using an operate system based on Red Hat distro. Well, after install MySQL via yum or via rpm packages, the location of MySQL samples configuration file usually is /usr/share/mysql. After to check the existence of sample configuration files (my-huge.cnf, my-large.cnf, my-medium.

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

2010-12-30 Thread Wagner Bianchi
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 w

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

2010-12-30 Thread andrew.2.moore
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 [dae...@daevid.com] Sent: 29 D

RE: my.cnf file

2010-12-30 Thread andrew.2.moore
Adam, you should look upon this as an opportunity to write a my.cnf that suits your application and hardware. Understanding the options in this configuration can be paramount to a well tuned server. a few resources to kick it all off... http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tabl