RE: my.cnf file
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-tables.html http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION000150 http://ronaldbradford.com/blog/tag/my-cnf/ Andy From: ext Adarsh Sharma [adarsh.sha...@orkash.com] Sent: 30 December 2010 06:37 To: mysql@lists.mysql.com Subject: my.cnf file Dear all, I am able to install Mysql-5.1.4 o a Linux Machine without any error. All is working fine. But I am searching a file my.cnf which is most important and is used in mysql but cannot able to find it. I install mysql by yum install mysql-server and yum install mysql-client commands. I find only a folder in /var/lib/ i.e mysql folder that contains ibdata and database folder plus .sock and .err file. After some research i find default path of my.cnf is /etc/my.cnf, /etc/mysql/my.cnf, /var/lib/mysql/my.cnf. But couldn,t locate it as it is needed for changing data dirs. Please help. Thanks Adarsh Sharma -- 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
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? 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
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 andrew.2.mo...@nokia.com 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 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=wagnerbianch...@gmail.com
Re: my.cnf file
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.cnf ...), use linux command line cp to copy it to /etc or /etc/mysql and restart mysqld. Could you check it? Best regards. -- Wagner Bianchi 2010/12/30 andrew.2.mo...@nokia.com 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-tables.html http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION000150 http://ronaldbradford.com/blog/tag/my-cnf/ Andy From: ext Adarsh Sharma [adarsh.sha...@orkash.com] Sent: 30 December 2010 06:37 To: mysql@lists.mysql.com Subject: my.cnf file Dear all, I am able to install Mysql-5.1.4 o a Linux Machine without any error. All is working fine. But I am searching a file my.cnf which is most important and is used in mysql but cannot able to find it. I install mysql by yum install mysql-server and yum install mysql-client commands. I find only a folder in /var/lib/ i.e mysql folder that contains ibdata and database folder plus .sock and .err file. After some research i find default path of my.cnf is /etc/my.cnf, /etc/mysql/my.cnf, /var/lib/mysql/my.cnf. But couldn,t locate it as it is needed for changing data dirs. Please help. Thanks Adarsh Sharma -- 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=wagnerbianch...@gmail.com
Re: my.cnf file
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. After to check the existence of sample configuration files (my-huge.cnf, my-large.cnf, my-medium.cnf ...), use linux command line cp to copy it to /etc or /etc/mysql and restart mysqld. Could you check it? Best regards. -- Wagner Bianchi 2010/12/30 andrew.2.mo...@nokia.com 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-tables.html http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION000150 http://ronaldbradford.com/blog/tag/my-cnf/ Andy From: ext Adarsh Sharma [adarsh.sha...@orkash.com] Sent: 30 December 2010 06:37 To: mysql@lists.mysql.com Subject: my.cnf file Dear all, I am able to install Mysql-5.1.4 o a Linux Machine without any error. All is working fine. But I am searching a file my.cnf which is most important and is used in mysql but cannot able to find it. I install mysql by yum install mysql-server and yum install mysql-client commands. I find only a folder in /var/lib/ i.e mysql folder that contains ibdata and database folder plus .sock and .err file. After some research i find default path of my.cnf is /etc/my.cnf, /etc/mysql/my.cnf, /var/lib/mysql/my.cnf. But couldn,t locate it as it is needed for changing data dirs. Please help. Thanks Adarsh Sharma -- 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=wagnerbianch...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: /etc/init.d/mysql start WITHOUT integrity check?
-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
RE: /etc/init.d/mysql start WITHOUT integrity check?
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 0.1 1680 520 ?SDec25 0:00 /bin/sh /usr/bin/mysqld_safe 49:mysql11165 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 ?SDec25 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld 81:1000 19149 0.0 0.1 3004 788 pts/0R+ 21:54 0:00 grep -n -i --color=auto mysql mailto:develo...@mypse:/etc/init.d$ develo...@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=3306--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: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 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 andrew.2.mo...@nokia.com 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 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=wagnerbianch...@gmail.com
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. develo...@mypse:/etc/init.d$ ps aux | grep mysql 46:root 10239 0.0 0.1 1680 520 ?SDec25 0:00 /bin/sh /usr/bin/mysqld_safe 49:mysql11165 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 ?SDec25 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld 81:1000 19149 0.0 0.1 3004 788 pts/0R+ 21:54 0:00 grep -n -i --color=auto mysql mailto:develo...@mypse:/etc/init.d$ develo...@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=3306--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-response.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=arch...@jab.org
Re: /etc/init.d/mysql start WITHOUT integrity check?
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 shawn.l.gr...@oracle.com 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$ ps aux | grep mysql 46:root 10239 0.0 0.1 1680 520 ?SDec25 0:00 /bin/sh /usr/bin/mysqld_safe 49:mysql11165 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 ?SDec25 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld 81:1000 19149 0.0 0.1 3004 788 pts/0R+ 21:54 0:00 grep -n -i --color=auto mysql mailto:develo...@mypse:/etc/init.d$ develo...@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=3306--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-response.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=wagnerbianch...@gmail.com
Re: my.cnf file
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 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.cnf ...), use linux command line cp to copy it to /etc or /etc/mysql and restart mysqld. Could you check it? Best regards. -- Wagner Bianchi 2010/12/30 andrew.2.mo...@nokia.com 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-tables.html http://dev.mysql.com/tech-resources/articles/mysql_intro.html#SECTION000150 http://ronaldbradford.com/blog/tag/my-cnf/ Andy From: ext Adarsh Sharma [adarsh.sha...@orkash.com] Sent: 30 December 2010 06:37 To: mysql@lists.mysql.com Subject: my.cnf file Dear all, I am able to install Mysql-5.1.4 o a Linux Machine without any error. All is working fine. But I am searching a file my.cnf which is most important and is used in mysql but cannot able to find it. I install mysql by yum install mysql-server and yum install mysql-client commands. I find only a folder in /var/lib/ i.e mysql folder that contains ibdata and database folder plus .sock and .err file. After some research i find default path of my.cnf is /etc/my.cnf, /etc/mysql/my.cnf, /var/lib/mysql/my.cnf. But couldn,t locate it as it is needed for changing data dirs. Please help. Thanks Adarsh Sharma -- 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=wagnerbianch...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org