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...

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

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

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,

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: /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 understand

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 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.d$

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: 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 ly...@lydiarowe.com: 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