table cache value error in my.cnf file
i am getting this wierd error in the mysql log: 120604 8:31:32 [Warning] option 'table_cache': unsigned value 536870912 adjusted to 524288 I have 28G of ram in my server, can anyone tell me what this value should be set to ? what is the syntax - i have tried different syntax -- get the same error. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: table cache value error in my.cnf file
Am 04.06.2012 14:39, schrieb Joey L: i am getting this wierd error in the mysql log: 120604 8:31:32 [Warning] option 'table_cache': unsigned value 536870912 adjusted to 524288 I have 28G of ram in my server, can anyone tell me what this value should be set to ? what is the syntax - i have tried different syntax -- get the same error table count * expected connections signature.asc Description: OpenPGP digital signature
Re: table cache value error in my.cnf file
Can you explain this further ? Sorry a little slow ? table count * expected connections -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: table cache value error in my.cnf file
Am 04.06.2012 14:45, schrieb Joey L: Can you explain this further ? Sorry a little slow ? table count * expected connections http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_table_cache signature.asc Description: OpenPGP digital signature
Re: table cache value error in my.cnf file
Joey, you've over allocated the cache. MySQL is telling you that it has corrected the allocation. Check out the docs for the meaning behind the numbers. On Mon, Jun 4, 2012 at 2:01 PM, Reindl Harald h.rei...@thelounge.netwrote: Am 04.06.2012 14:45, schrieb Joey L: Can you explain this further ? Sorry a little slow ? table count * expected connections http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_table_cache
Not finding my.cnf file
Dear all, I install mysql in CentOS -5.4 through 2 commands : yum install mysql-server yum install mysql-client And I can see directories created in /var/lib/mysql directory. But now i want to change it to my /hdd1-1 diretcory and alse set logging directories. So , I search my.cnf file as: [root@ws-test ~]# find / -name my.cnf [root@ws-test ~]# Now how could I solve this issue from where mysql picks its configuration or it go for its default. Thanks best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Not finding my.cnf file
You need to provide a my.cnf for your server. There are some sample files included with the server binaries that you can start with. These won't be tailored for your application/server so will need to be changed as per your requirements. Note that several of the options are static values so will require a MySQL restart before they will work. Best of luck Andrew On Wed, Jun 1, 2011 at 10:24 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Dear all, I install mysql in CentOS -5.4 through 2 commands : yum install mysql-server yum install mysql-client And I can see directories created in /var/lib/mysql directory. But now i want to change it to my /hdd1-1 diretcory and alse set logging directories. So , I search my.cnf file as: [root@ws-test ~]# find / -name my.cnf [root@ws-test ~]# Now how could I solve this issue from where mysql picks its configuration or it go for its default. Thanks best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
Re: Not finding my.cnf file
I think the default location on Centos is /etc/my.cnf Regards John On 1 June 2011 10:24, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear all, I install mysql in CentOS -5.4 through 2 commands : yum install mysql-server yum install mysql-client And I can see directories created in /var/lib/mysql directory. But now i want to change it to my /hdd1-1 diretcory and alse set logging directories. So , I search my.cnf file as: [root@ws-test ~]# find / -name my.cnf [root@ws-test ~]# Now how could I solve this issue from where mysql picks its configuration or it go for its default. Thanks best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk -- John Daisley Certified MySQL 5 Database Administrator Certified MySQL 5 Developer Cognos BI Developer Telephone: +44 (0)7918 621621 Email: john.dais...@butterflysystems.co.uk
Re: Not finding my.cnf file
I got the error after setting my.cnf file in /etc directory. 110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist After some research i found the cause of this error : the new my.cnf is very old and mysql_upgrade is needed So , Can someone Please give my a standard my.cnf file that contains all the parameters. Is my.cnf file is different for different versions. My mysql version is 5.1.4. Please check my attached my.cnf file Thanks John Daisley wrote: I think the default location on Centos is /etc/my.cnf Regards John On 1 June 2011 10:24, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear all, I install mysql in CentOS -5.4 through 2 commands : yum install mysql-server yum install mysql-client And I can see directories created in /var/lib/mysql directory. But now i want to change it to my /hdd1-1 diretcory and alse set logging directories. So , I search my.cnf file as: [root@ws-test ~]# find / -name my.cnf [root@ws-test ~]# Now how could I solve this issue from where mysql picks its configuration or it go for its default. Thanks best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk #This is for a large system with memory = 512M where the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is @localstatedir@) or # ~/.my.cnf to set user-specific options. # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock #skip-locking # Caches and Buffer Sizes key_buffer = 256M max_allowed_packet=16M table_cache = 256 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 4M #record_buffer = 1M myisam_sort_buffer_size = 128M thread_cache = 128 query_cache_limit = 2M query_cache_type = 1 query_cache_size = 32M key_buffer = 16M join_buffer = 2M table_cache = 1024 datadir = /hdd2-1/myisam_data log-bin=mysql-bin #Time Outs interactive_timeout = 100 wait_timeout = 100 connect_timeout = 10 # Try number of CPU's*2 for thread_concurrency thread_concurrency = 2 # Maximum connections allowed max_connections = 100 max_user_connections = 50 max_connect_errors = 10 # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the enable-named-pipe option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between # two methods : # # 1) Use the CHANGE MASTER TO command (fully described in our manual) - #the syntax is: # #CHANGE MASTER TO MASTER_HOST=host, MASTER_PORT=port, #MASTER_USER=user, MASTER_PASSWORD=password ; # #where you replace host, user, password by quoted strings and #port by the master's port number (3306 by default). # #Example: # #CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, #MASTER_USER='joe', MASTER_PASSWORD='secret'; # # OR # # 2) Set the variables below. However, in case you choose this method, then #start replication for the first time (even unsuccessfully, for example #if you mistyped the password in master-password and the slave fails to #connect), the slave will create a master.info file, and any later #change in this file to the variables' values below will be ignored and #overridden by the content of the master.info file, unless you shutdown #the slave server, delete master.info and restart the slaver server. #For that reason, you may want to leave the lines below untouched #(commented) and instead use CHANGE MASTER TO (see above) # # required unique id between 2 and 2^32 - 1 # (and different from the master) # defaults to 2 if master-host is set # but will not function as a slave if omitted #server-id = 2 # # The replication master for this slave - required #master-host= hostname # # The username the slave will use for authentication when connecting
Re: Not finding my.cnf file
Hi, You probably didn't run mysql_install_db. Peter Boros On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote: I got the error after setting my.cnf file in /etc directory. 110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist After some research i found the cause of this error : the new my.cnf is very old and mysql_upgrade is needed So , Can someone Please give my a standard my.cnf file that contains all the parameters. Is my.cnf file is different for different versions. My mysql version is 5.1.4. Please check my attached my.cnf file Thanks John Daisley wrote: I think the default location on Centos is /etc/my.cnf Regards John On 1 June 2011 10:24, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear all, I install mysql in CentOS -5.4 through 2 commands : yum install mysql-server yum install mysql-client And I can see directories created in /var/lib/mysql directory. But now i want to change it to my /hdd1-1 diretcory and alse set logging directories. So , I search my.cnf file as: [root@ws-test ~]# find / -name my.cnf [root@ws-test ~]# Now how could I solve this issue from where mysql picks its configuration or it go for its default. Thanks best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk plain text document attachment (my.cnf) #This is for a large system with memory = 512M where the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is @localstatedir@) or # ~/.my.cnf to set user-specific options. # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock #skip-locking # Caches and Buffer Sizes key_buffer = 256M max_allowed_packet=16M table_cache = 256 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 4M #record_buffer = 1M myisam_sort_buffer_size = 128M thread_cache = 128 query_cache_limit = 2M query_cache_type = 1 query_cache_size = 32M key_buffer = 16M join_buffer = 2M table_cache = 1024 datadir = /hdd2-1/myisam_data log-bin=mysql-bin #Time Outs interactive_timeout = 100 wait_timeout = 100 connect_timeout = 10 # Try number of CPU's*2 for thread_concurrency thread_concurrency = 2 # Maximum connections allowed max_connections = 100 max_user_connections = 50 max_connect_errors = 10 # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the enable-named-pipe option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between # two methods : # # 1) Use the CHANGE MASTER TO command (fully described in our manual) - #the syntax is: # #CHANGE MASTER TO MASTER_HOST=host, MASTER_PORT=port, #MASTER_USER=user, MASTER_PASSWORD=password ; # #where you replace host, user, password by quoted strings and #port by the master's port number (3306 by default). # #Example: # #CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, #MASTER_USER='joe', MASTER_PASSWORD='secret'; # # OR # # 2) Set the variables below. However, in case you choose this method, then #start replication for the first time (even unsuccessfully, for example #if you mistyped the password in master-password and the slave fails to #connect), the slave will create a master.info file, and any later #change in this file to the variables' values below will be ignored and #overridden by the content of the master.info file, unless you shutdown #the slave server, delete master.info and restart the slaver server. #For that reason, you may want to leave the lines below untouched #(commented
Re: Not finding my.cnf file
Thanks, It works a new error occurs as : 110601 16:16:16 mysqld_safe Starting mysqld daemon with databases from /hdd2-1/myisam_data /usr/sbin/mysqld: File '/hdd2-1/myisam_data/mysql-bin.index' not found (Errcode: 13) 110601 16:16:16 [ERROR] Aborting 110601 16:16:16 [Note] /usr/sbin/mysqld: Shutdown complete I checked /hdd2-1/myisam_data/mysql-bin.index file is there , how to comes Thanks Peter Boros wrote: Hi, You probably didn't run mysql_install_db. Peter Boros On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote: I got the error after setting my.cnf file in /etc directory. 110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist After some research i found the cause of this error : the new my.cnf is very old and mysql_upgrade is needed So , Can someone Please give my a standard my.cnf file that contains all the parameters. Is my.cnf file is different for different versions. My mysql version is 5.1.4. Please check my attached my.cnf file Thanks John Daisley wrote: I think the default location on Centos is /etc/my.cnf Regards John On 1 June 2011 10:24, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear all, I install mysql in CentOS -5.4 through 2 commands : yum install mysql-server yum install mysql-client And I can see directories created in /var/lib/mysql directory. But now i want to change it to my /hdd1-1 diretcory and alse set logging directories. So , I search my.cnf file as: [root@ws-test ~]# find / -name my.cnf [root@ws-test ~]# Now how could I solve this issue from where mysql picks its configuration or it go for its default. Thanks best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk plain text document attachment (my.cnf) #This is for a large system with memory = 512M where the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is @localstatedir@) or # ~/.my.cnf to set user-specific options. # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock #skip-locking # Caches and Buffer Sizes key_buffer = 256M max_allowed_packet=16M table_cache = 256 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 4M #record_buffer = 1M myisam_sort_buffer_size = 128M thread_cache = 128 query_cache_limit = 2M query_cache_type = 1 query_cache_size = 32M key_buffer = 16M join_buffer = 2M table_cache = 1024 datadir = /hdd2-1/myisam_data log-bin=mysql-bin #Time Outs interactive_timeout = 100 wait_timeout = 100 connect_timeout = 10 # Try number of CPU's*2 for thread_concurrency thread_concurrency = 2 # Maximum connections allowed max_connections = 100 max_user_connections = 50 max_connect_errors = 10 # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the enable-named-pipe option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between # two methods : # # 1) Use the CHANGE MASTER TO command (fully described in our manual) - #the syntax is: # #CHANGE MASTER TO MASTER_HOST=host, MASTER_PORT=port, #MASTER_USER=user, MASTER_PASSWORD=password ; # #where you replace host, user, password by quoted strings and #port by the master's port number (3306 by default). # #Example: # #CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, #MASTER_USER='joe', MASTER_PASSWORD='secret'; # # OR # # 2) Set the variables below. However, in case you choose this method, then #start replication for the first time (even unsuccessfully, for example #if you mistyped the password in master-password and the slave fails to #connect), the slave will create a master.info file, and any later #change in this file to the variables' values below will be ignored and #overridden
Re: Not finding my.cnf file
Check the permissions in the datadir. On Wed, Jun 1, 2011 at 11:50 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Thanks, It works a new error occurs as : 110601 16:16:16 mysqld_safe Starting mysqld daemon with databases from /hdd2-1/myisam_data /usr/sbin/mysqld: File '/hdd2-1/myisam_data/mysql-bin.index' not found (Errcode: 13) 110601 16:16:16 [ERROR] Aborting 110601 16:16:16 [Note] /usr/sbin/mysqld: Shutdown complete I checked /hdd2-1/myisam_data/mysql-bin.index file is there , how to comes Thanks Peter Boros wrote: Hi, You probably didn't run mysql_install_db. Peter Boros On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote: I got the error after setting my.cnf file in /etc directory. 110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist After some research i found the cause of this error : the new my.cnf is very old and mysql_upgrade is needed So , Can someone Please give my a standard my.cnf file that contains all the parameters. Is my.cnf file is different for different versions. My mysql version is 5.1.4. Please check my attached my.cnf file Thanks John Daisley wrote: I think the default location on Centos is /etc/my.cnf Regards John On 1 June 2011 10:24, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear all, I install mysql in CentOS -5.4 through 2 commands : yum install mysql-server yum install mysql-client And I can see directories created in /var/lib/mysql directory. But now i want to change it to my /hdd1-1 diretcory and alse set logging directories. So , I search my.cnf file as: [root@ws-test ~]# find / -name my.cnf [root@ws-test ~]# Now how could I solve this issue from where mysql picks its configuration or it go for its default. Thanks best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk plain text document attachment (my.cnf) #This is for a large system with memory = 512M where the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is @localstatedir@) or # ~/.my.cnf to set user-specific options. # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock #skip-locking # Caches and Buffer Sizes key_buffer = 256M max_allowed_packet=16M table_cache = 256 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 4M #record_buffer = 1M myisam_sort_buffer_size = 128M thread_cache = 128 query_cache_limit = 2M query_cache_type = 1 query_cache_size = 32M key_buffer = 16M join_buffer = 2M table_cache = 1024 datadir = /hdd2-1/myisam_data log-bin=mysql-bin #Time Outs interactive_timeout = 100 wait_timeout = 100 connect_timeout = 10 # Try number of CPU's*2 for thread_concurrency thread_concurrency = 2 # Maximum connections allowed max_connections = 100 max_user_connections = 50 max_connect_errors = 10 # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the enable-named-pipe option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between # two methods : # # 1) Use the CHANGE MASTER TO command (fully described in our manual) - #the syntax is: # #CHANGE MASTER TO MASTER_HOST=host, MASTER_PORT=port, #MASTER_USER=user, MASTER_PASSWORD=password ; # #where you replace host, user, password by quoted strings and #port by the master's port number (3306 by default). # #Example: # #CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, #MASTER_USER='joe', MASTER_PASSWORD='secret'; # # OR # # 2) Set the variables below. However, in case you choose this method, then #start replication for the first time (even unsuccessfully, for example #if you mistyped
Re: my.cnf file
Are you show about the non-outage operation with this command? Best regards. -- Wagner Bianchi 2010/12/31 Sharl.Jimh.Tsin amoiz.sh...@gmail.com 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
Re: my.cnf file
Please, forget my last note, I answered in a wrong thread! Sorry. Best regards. -- Wagner Bianchi 2010/12/31 Wagner Bianchi wagnerbianch...@gmail.com Are you show about the non-outage operation with this command? Best regards. -- Wagner Bianchi 2010/12/31 Sharl.Jimh.Tsin amoiz.sh...@gmail.com 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
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: 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: 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
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=arch...@jab.org
Re: cannot find my.cnf file
Sydney Puente schrieb: Hello, I want to log all sql queries made against a mysql db. Googled and found I should add a line to my.cnf. However I cannot find a my.cnf file [r...@radium init.d]# ps -ef | grep mysql root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid mysql13669 13614 0 Sep24 ?00:21:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid root 23050 22746 0 19:05 pts/000:00:00 grep mysql [r...@radium init.d]# locate cnf /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf /usr/share/man/man8/cnfsheadconf.8.gz /usr/share/man/man8/cnfsstat.8.gz /usr/share/ssl/openssl.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Any ideas? I might add i did not install mysql and I did not start it and the guy who did is in holiday! Systemwide config files are always in /etc/ (see: man hier). re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: cannot find my.cnf file
Please look in /etc/my.cnf If not found create one. Of cause, MySQL can start and run without a 'my.cnf' file that’s why you couldn't find one. In the absence of the my.cnf file, MySQL will use default for every parameter . Charles, -Original Message- From: walter harms [mailto:wha...@bfs.de] Sent: Friday, November 13, 2009 2:44 AM To: Sydney Puente Cc: mysql@lists.mysql.com Subject: Re: cannot find my.cnf file Sydney Puente schrieb: Hello, I want to log all sql queries made against a mysql db. Googled and found I should add a line to my.cnf. However I cannot find a my.cnf file [r...@radium init.d]# ps -ef | grep mysql root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid mysql13669 13614 0 Sep24 ?00:21:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid root 23050 22746 0 19:05 pts/000:00:00 grep mysql [r...@radium init.d]# locate cnf /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf /usr/share/man/man8/cnfsheadconf.8.gz /usr/share/man/man8/cnfsstat.8.gz /usr/share/ssl/openssl.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Any ideas? I might add i did not install mysql and I did not start it and the guy who did is in holiday! Systemwide config files are always in /etc/ (see: man hier). re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=cbr...@bmi.com This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Fw: cannot find my.cnf file
Guys, That's a great response. Thanks. I have copied /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnfto /etc/my.cnf and restarted. However I can no longer log on via the command line from the database box, I can still log via a remote client So I presume the problem is related to the host in the mysql.user table. mysql -h localhost -u martin -p Enter password: ERROR 1045 (28000): Access denied for user 'martin'@'localhost' (using password: YES) mysql select host from mysql.user where user = 'martin'; +--+ | host | +--+ | %| +--+ mysql select host from mysql.user where user = 'root'; +---+ | host | +---+ | % | | 127.0.0.1 | | localhost | | object01 | +---+ Sydney Puente schrieb: Hello, I want to log all sql queries made against a mysql db. Googled and found I should add a line to my.cnf. However I cannot find a my.cnf file [r...@radium init.d]# ps -ef | grep mysql root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid mysql13669 13614 0 Sep24 ?00:21:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid root 23050 22746 0 19:05 pts/000:00:00 grep mysql [r...@radium init.d]# locate cnf /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf /usr/share/man/man8/cnfsheadconf.8.gz /usr/share/man/man8/cnfsstat.8.gz /usr/share/ssl/openssl.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Any ideas? I might add i did not install mysql and I did not start it and the guy who did is in holiday! Systemwide config files are always in /etc/ (see: man hier). re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Fw: cannot find my.cnf file
H I wouldn't use that my-huge.cnf file unless that machine is a dedicated mysql server with plenty of ram and even then I wouldn't use it without modification. Are you sure you have the password correct? A % under host is a synonym for 'any host'. Regards John Guys, That's a great response. Thanks. I have copied /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnfto /etc/my.cnf and restarted. However I can no longer log on via the command line from the database box, I can still log via a remote client So I presume the problem is related to the host in the mysql.user table. mysql -h localhost -u martin -p Enter password: ERROR 1045 (28000): Access denied for user 'martin'@'localhost' (using password: YES) mysql select host from mysql.user where user = 'martin'; +--+ | host | +--+ | %| +--+ mysql select host from mysql.user where user = 'root'; +---+ | host | +---+ | % | | 127.0.0.1 | | localhost | | object01 | +---+ Sydney Puente schrieb: Hello, I want to log all sql queries made against a mysql db. Googled and found I should add a line to my.cnf. However I cannot find a my.cnf file [r...@radium init.d]# ps -ef | grep mysql root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid mysql13669 13614 0 Sep24 ?00:21:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid root 23050 22746 0 19:05 pts/000:00:00 grep mysql [r...@radium init.d]# locate cnf /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf /usr/share/man/man8/cnfsheadconf.8.gz /usr/share/man/man8/cnfsstat.8.gz /usr/share/ssl/openssl.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Any ideas? I might add i did not install mysql and I did not start it and the guy who did is in holiday! Systemwide config files are always in /etc/ (see: man hier). re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: cannot find my.cnf file
Yes I enter the password manually into the remote mysql client (actually Oracle's SQL developer) when I login. I thought I would restart mysql with the /etc/init.d/mysql script and go back to the original default settings without any my.cnf present. Just to check it was some setting in my.cnf that caused the log in problem. # ./mysql status MySQL is running but PID file could not be found [FAILED] # ./mysql stop MySQL manager or server PID file could not be found! [FAILED] In fact I cannot find a pid file anywhere on the box. # ps -ef | grep mysql root 6517 1 0 10:10 pts/000:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/radium01.pid mysql 6623 6517 0 10:10 pts/000:00:24 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid --socket=/var/lib/mysql/mysql.sock --port=3306 # locate pid | grep mysql /usr/share/man/man1/mysql_waitpid.1.gz /usr/bin/mysql_waitpid I have no idea why a pid file would be missing! any ideas Syd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: cannot find my.cnf file
Did you remove the my.cnf file and then run /etc/init.d/mysql stop? The my.cnf probably had non-default paths for the pid file, so if you remove the config file, now the startup script is looking in the wrong location. Also for your password issue, please show use the exact command you're using to try to log in, and the exact error message you get. Regards Gavin Towey -Original Message- From: Sydney Puente [mailto:sydneypue...@yahoo.com] Sent: Friday, November 13, 2009 5:31 AM To: mysql@lists.mysql.com Subject: Re: cannot find my.cnf file Yes I enter the password manually into the remote mysql client (actually Oracle's SQL developer) when I login. I thought I would restart mysql with the /etc/init.d/mysql script and go back to the original default settings without any my.cnf present. Just to check it was some setting in my.cnf that caused the log in problem. # ./mysql status MySQL is running but PID file could not be found [FAILED] # ./mysql stop MySQL manager or server PID file could not be found! [FAILED] In fact I cannot find a pid file anywhere on the box. # ps -ef | grep mysql root 6517 1 0 10:10 pts/000:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/radium01.pid mysql 6623 6517 0 10:10 pts/000:00:24 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid --socket=/var/lib/mysql/mysql.sock --port=3306 # locate pid | grep mysql /usr/share/man/man1/mysql_waitpid.1.gz /usr/bin/mysql_waitpid I have no idea why a pid file would be missing! any ideas Syd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
cannot find my.cnf file
Hello, I want to log all sql queries made against a mysql db. Googled and found I should add a line to my.cnf. However I cannot find a my.cnf file [r...@radium init.d]# ps -ef | grep mysql root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid mysql13669 13614 0 Sep24 ?00:21:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid root 23050 22746 0 19:05 pts/000:00:00 grep mysql [r...@radium init.d]# locate cnf /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf /usr/share/man/man8/cnfsheadconf.8.gz /usr/share/man/man8/cnfsstat.8.gz /usr/share/ssl/openssl.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Any ideas? I might add i did not install mysql and I did not start it and the guy who did is in holiday! TIA Syd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: cannot find my.cnf file
should be in /etc/my.cnf or try the following at the command line locate my.cnf That should give you the location On Thu, 2009-11-12 at 18:10 +, Sydney Puente wrote: Hello, I want to log all sql queries made against a mysql db. Googled and found I should add a line to my.cnf. However I cannot find a my.cnf file [r...@radium init.d]# ps -ef | grep mysql root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid mysql13669 13614 0 Sep24 ?00:21:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid root 23050 22746 0 19:05 pts/000:00:00 grep mysql [r...@radium init.d]# locate cnf /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf /usr/share/man/man8/cnfsheadconf.8.gz /usr/share/man/man8/cnfsstat.8.gz /usr/share/ssl/openssl.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Any ideas? I might add i did not install mysql and I did not start it and the guy who did is in holiday! TIA Syd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: cannot find my.cnf file
Also note that mysql doesn't need a my.cnf file and will happily run with default values. It's possible that there is none and you'll have to create it. To see where your mysqld is configured to check for the config file do: mysql --verbose --help | grep -C3 my.cnf This will give you a list of paths it checks in order. Regards, Gavin Towey -Original Message- From: John Daisley [mailto:john.dais...@butterflysystems.co.uk] Sent: Thursday, November 12, 2009 10:30 AM To: Sydney Puente Cc: mysql@lists.mysql.com Subject: Re: cannot find my.cnf file should be in /etc/my.cnf or try the following at the command line locate my.cnf That should give you the location On Thu, 2009-11-12 at 18:10 +, Sydney Puente wrote: Hello, I want to log all sql queries made against a mysql db. Googled and found I should add a line to my.cnf. However I cannot find a my.cnf file [r...@radium init.d]# ps -ef | grep mysql root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid mysql13669 13614 0 Sep24 ?00:21:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid root 23050 22746 0 19:05 pts/000:00:00 grep mysql [r...@radium init.d]# locate cnf /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf /usr/share/man/man8/cnfsheadconf.8.gz /usr/share/man/man8/cnfsstat.8.gz /usr/share/ssl/openssl.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Any ideas? I might add i did not install mysql and I did not start it and the guy who did is in holiday! TIA Syd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: cannot find my.cnf file
You must copy /usr/share/doc/MySQL-server-community-5.1.39/my-somefile.cnf file into /etc/my.cnf If no .cnf file in /etc MySQL use default config. if server has 2G RAM then use my-huge.cnf Good luck. - Original Message - From: Sydney Puente sydneypue...@yahoo.com To: mysql@lists.mysql.com Sent: Friday, November 13, 2009 3:10 AM Subject: cannot find my.cnf file Hello, I want to log all sql queries made against a mysql db. Googled and found I should add a line to my.cnf. However I cannot find a my.cnf file [r...@radium init.d]# ps -ef | grep mysql root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/object01.pid mysql13669 13614 0 Sep24 ?00:21:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err --pid-file=/var/lib/mysql/object01.pid root 23050 22746 0 19:05 pts/000:00:00 grep mysql [r...@radium init.d]# locate cnf /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf /usr/share/man/man8/cnfsheadconf.8.gz /usr/share/man/man8/cnfsstat.8.gz /usr/share/ssl/openssl.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf Any ideas? I might add i did not install mysql and I did not start it and the guy who did is in holiday! TIA Syd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=old...@posbank.co.kr
Re: my.cnf file
michel wrote: I set up mysql and can't start it because I need to hard code the IP address parameter (bind-address) into my.cnf ... but I have three of them in different sub directories of /mysql/mysql-test/suite Should there not be one basic one? http://dev.mysql.com/doc/refman/5.1/en/option-files.html It searches in order of locations, /etc/my.cnf being the first. -- Linux web infrastructure consulting, cr...@codenation.net Free live poker tournament listings, http://www.g5poker.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
my.cnf file
I set up mysql and can't start it because I need to hard code the IP address parameter (bind-address) into my.cnf ... but I have three of them in different sub directories of /mysql/mysql-test/suite Should there not be one basic one?
Re: missing my.cnf file?
Hello. The MySQL server can be started without a configuration file, only with command line options. You can manually specify the location of my.cnf file with --defaults-file=path command line option. See: http://dev.mysql.com/doc/mysql/en/program-options.html sol beach [EMAIL PROTECTED] wrote: I have inhertited this old Solaris x86 system with MYSQL installed on it. mdb:/tmp 15:38:08 [539]# uname -a SunOS mdb.hitbox.com 5.7 Generic_106542-24 i86pc i386 i86pc I would rate myself as an advanced novice WRT MYSQL To a large deree this system is running OK. However, it does seem to be smacking into the limit of 100 concurrent connections. AFAIK, no /etc/my.cnf file no $HOME/.my.cnf file exist. I've looked looked at the startup scripts do not see any --config-file qualifier be specified. datadir=/a/mysqldata/ and there is no *cnf file in this folder either # find / -name \*cnf -ls 941333 -rw-rw 1 root dba 2179 Apr 9 2002 /a/home/mysql/mysql-3.23.49/support-files/my-small.cnf 941343 -rw-rw 1 root dba 2464 Apr 9 2002 /a/home/mysql/mysql-3.23.49/support-files/my-medium.cnf 941353 -rw-rw 1 root dba 2480 Apr 9 2002 /a/home/mysql/mysql-3.23.49/support-files/my-large.cnf 941363 -rw-rw 1 root dba 2502 Apr 9 2002 /a/home/mysql/mysql-3.23.49/support-files/my-huge.cnf 3826293 -rw-r--r-- 1 root dba 2179 Nov 15 09:57 /a/home/mysql/mysql-3.23.49/share/mysql/my-small.cnf 3826303 -rw-r--r-- 1 root dba 2464 Nov 15 09:57 /a/home/mysql/mysql-3.23.49/share/mysql/my-medium.cnf 3826313 -rw-r--r-- 1 root dba 2480 Nov 15 09:57 /a/home/mysql/mysql-3.23.49/share/mysql/my-large.cnf 3826323 -rw-r--r-- 1 root dba 2502 Nov 15 09:57 /a/home/mysql/mysql-3.23.49/share/mysql/my-huge.cnf 6962157 -rw-r--r-- 1 root other7146 Jul 11 2002 /a/local/ssl/openssl.cnf I may be wrong but I am convinced that MYSQL is reading some file to acquire values for its varialbles. How do I identify which file it is using? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
missing my.cnf file?
I have inhertited this old Solaris x86 system with MYSQL installed on it. mdb:/tmp 15:38:08 [539]# uname -a SunOS mdb.hitbox.com 5.7 Generic_106542-24 i86pc i386 i86pc I would rate myself as an advanced novice WRT MYSQL To a large deree this system is running OK. However, it does seem to be smacking into the limit of 100 concurrent connections. AFAIK, no /etc/my.cnf file no $HOME/.my.cnf file exist. I've looked looked at the startup scripts do not see any --config-file qualifier be specified. datadir=/a/mysqldata/ and there is no *cnf file in this folder either # find / -name \*cnf -ls 941333 -rw-rw 1 root dba 2179 Apr 9 2002 /a/home/mysql/mysql-3.23.49/support-files/my-small.cnf 941343 -rw-rw 1 root dba 2464 Apr 9 2002 /a/home/mysql/mysql-3.23.49/support-files/my-medium.cnf 941353 -rw-rw 1 root dba 2480 Apr 9 2002 /a/home/mysql/mysql-3.23.49/support-files/my-large.cnf 941363 -rw-rw 1 root dba 2502 Apr 9 2002 /a/home/mysql/mysql-3.23.49/support-files/my-huge.cnf 3826293 -rw-r--r-- 1 root dba 2179 Nov 15 09:57 /a/home/mysql/mysql-3.23.49/share/mysql/my-small.cnf 3826303 -rw-r--r-- 1 root dba 2464 Nov 15 09:57 /a/home/mysql/mysql-3.23.49/share/mysql/my-medium.cnf 3826313 -rw-r--r-- 1 root dba 2480 Nov 15 09:57 /a/home/mysql/mysql-3.23.49/share/mysql/my-large.cnf 3826323 -rw-r--r-- 1 root dba 2502 Nov 15 09:57 /a/home/mysql/mysql-3.23.49/share/mysql/my-huge.cnf 6962157 -rw-r--r-- 1 root other7146 Jul 11 2002 /a/local/ssl/openssl.cnf I may be wrong but I am convinced that MYSQL is reading some file to acquire values for its varialbles. How do I identify which file it is using? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql backgroup process refers to nonexisting my.cnf file
Sql, query, Hi, all, I found on our clients mysql database machines, there is no my.cnf file by doing a global search, but when I did the following command, it seems that mysql process is referring to this file (--default-extra-file=/export/mysql/data/my.cnf ). Do you think it's normal? Thank you, Jannie bash-2.03$ ps -ef | grep mysql root 340 1 0 Jan 13 ?0:00 /bin/sh /export/mysql/bin/safe_mysqld --datadir=/export/mysql/data --pid-file=/ mysql 364 340 0 Jan 13 ?1:41 /export/mysql/bin/mysqld --defaults-extra-file=/export/mysql/data/my.cnf --base mysql 17102 17100 0 16:17:06 pts/00:00 -bash mysql 17239 17102 0 16:57:52 pts/00:00 -bash = _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Contain of my.cnf File
Unidux, Tuesday, November 05, 2002, 9:38:59 AM, you wrote: USHL Where can I find the complete sample configuration include the explanation USHL of my.cnf file? I tried mysql.com documentation, but only a bit there. Some info you can find in the manual: http://www.mysql.com/doc/en/SHOW_VARIABLES.html http://www.mysql.com/doc/en/Command-line_options.html Examples of my.cnf are come with distributive, like my-large.cnf, my-huge.cnf etc. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Missing my.cnf file
Having some other folks helping me out here with this MySQL problems that I am having. I have found out that I am missing the my.cnf from the /etc directory and I am trying to create the file from scratch, this is what I have so far and also MySQL is installed from .tgz in this directory. /usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686 Here is the what I have so far for my.cnf, please advise if this is right or not #missing this config. file for MySQL [mysql] datadir=/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin socket=/tmp/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysql] err-log=/var/log/mysql.log #I do not show this file in /var/log nor do I show a mysql.log in the MySQL directory pid-file=/var/run/mysqld/mysqld.pid #I also do not show this under /var/run * thanks again -Chris = * GAIM ID: cmmiller1973 * __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Contain of my.cnf File
Hi, Where can I find the complete sample configuration include the explanation of my.cnf file? I tried mysql.com documentation, but only a bit there. Please Advise. Thanks, Han Lin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: No my.cnf file on Linux?
Lindberg, Wednesday, September 25, 2002, 5:17:53 PM, you wrote: LP I use mysql 3.23.4 max on linux and it have worked just fine. LP Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. If you want to use transaction, you should use InnoDB or BDB table. In my.cnf file you can set up options for InnoDB or BDB. LP Trouble is there is no my.cnf file on my computer. LP Do I have to create the file myself ? Yup. LP or is the InnoDB settings configured right by default? If you use 3.23. you must specify at least innodb_data_file_path in my.cnf. For more info look at: http://www.mysql.com/doc/en/InnoDB_start.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
No my.cnf file on Linux?
I use mysql 3.23.4 max on linux and it have worked just fine. Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. Trouble is there is no my.cnf file on my computer. Do I have to create the file myself ? or is the InnoDB settings configured right by default? / Petrus Lindberg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: No my.cnf file on Linux?
I use mysql 3.23.4 max on linux and it have worked just fine. Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. Trouble is there is no my.cnf file on my computer. Do I have to create the file myself ? or is the InnoDB settings configured right by default? I had to create this file from scratch. The InnoDB section of the manual was a good starting point. I also want to say that I had to update my rc.d script as well to find the config file, not sure though Josh / Petrus Lindberg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: No my.cnf file on Linux?
At 16:17 +0200 9/25/02, Lindberg, Petrus wrote: I use mysql 3.23.4 max on linux and it have worked just fine. Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. Trouble is there is no my.cnf file on my computer. Do I have to create the file myself ? Yes, go ahead. or is the InnoDB settings configured right by default? / Petrus Lindberg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: No my.cnf file on Linux?
Hi, I use mysql 3.23.4 max on linux and it have worked just fine. Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. Trouble is there is no my.cnf file on my computer. Do I have to create the file myself ? or is the InnoDB settings configured right by default? have a look to the support_files sub-directory of you mysql directory. ( Something like /usr/local/mysql/support-files ) You'll find some examples of my.cnf ... David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: No my.cnf file on Linux?
Hi - they're located in the mysql support-files dir. Choose from small, medium, large or huge depending on how you're going to use mysql. Copy rename to /etc EG: cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf Cheers, Andrew -Original Message- From: Lindberg, Petrus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 25 September 2002 15:18 To: [EMAIL PROTECTED] Subject: No my.cnf file on Linux? I use mysql 3.23.4 max on linux and it have worked just fine. Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. Trouble is there is no my.cnf file on my computer. Do I have to create the file myself ? or is the InnoDB settings configured right by default? / Petrus Lindberg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my.cnf file
I'm trying to configure MySQL to run on my Mandrake 8.1 box. The Linux install automatically installed MySQL, albeit in some pretty strange places, but it's there and running upon startup. I would like to modify it so that it is not running as 'root' though on startup. I've read a lot of the documentation and from what I can tell it is being started via the /etc/init.d/mysql script (which looks exactly the same as the mysql.server script) but I cannot locate the my.cnf file that the docs talk about. Can I just create this file from scratch to start MySQL as a different user, or do I have to change the mysql startup script in /etc/init.d/ to use a my.cnf file? brent. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my.cnf file
I just looked into this myself since today was the first time I had to do anything with the configuration. The answer is, in the default installation, no conf file is created. (In my case, I mean from instllating from source rather than from binary.) So what you do is look for the unused-but-available my-example.cnf and then save it to my.cnf in the appropriate location. My locations are: /usr/share/mysql/my-example.cnf /var/lib/mysql/my.cnf In my case the cnf applies on a per-server basis (allowing multiple db servers on the one host, each with its own cnf file) rather than applying to everything mysql. At 03:22 PM 10/31/01 -0800, Brent Simpson wrote: I'm trying to configure MySQL to run on my Mandrake 8.1 box. The Linux install automatically installed MySQL, albeit in some pretty strange places, but it's there and running upon startup. I would like to modify it so that it is not running as 'root' though on startup. I've read a lot of the documentation and from what I can tell it is being started via the /etc/init.d/mysql script (which looks exactly the same as the mysql.server script) but I cannot locate the my.cnf file that the docs talk about. Can I just create this file from scratch to start MySQL as a different user, or do I have to change the mysql startup script in /etc/init.d/ to use a my.cnf file? brent. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Les Neste 678-778-0382 http://www.lesneste.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my.cnf file
Also note that a search for 'my.cnf' in the online documentation section of mysql.com returns exactly zero (0) results. Hint, hint ... Les Neste 678-778-0382 http://www.lesneste.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my.cnf file
I've done that, too... but that's because MySQL's doc search engine is interpreting the . as something special. If you search for other things relating to that, you'll actually find an index saying my.cnf configuration options or syntax.. something along those lines. Weird stuff. Mike Les Neste wrote: Also note that a search for 'my.cnf' in the online documentation section of mysql.com returns exactly zero (0) results. Hint, hint ... Les Neste 678-778-0382 http://www.lesneste.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my.cnf file
Hi all Is there a document available somewhere outlining some guidelines regarding what parameters should be set in the my.cnf files for the MySQL database and to what values? thanks = __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my.cnf file
FVFM (thats: From the Very Fine Manual ) http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Databa se_Administration.html#SHOW_VARIABLES You may have the above line split by your mail reader, just cut and paste the two havles in or go to: http://www.mysql.com/documentation/mysql/bychapter/ and Select chapter 4.5.5.4 Show Variables For example my.cnf files see your source code directory for mysql then change into 'cd ./support-files' adn looke for things like 'huge.cnf' etc. Ken - Original Message - From: Gene Gurevich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 2:45 PM Subject: Re: my.cnf file Hi all Is there a document available somewhere outlining some guidelines regarding what parameters should be set in the my.cnf files for the MySQL database and to what values? thanks = __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can't find my my.cnf file -- not there by default?
I'm still testing out MySQL and I'm trying to find the my.cnf file referred to at http://www.mysql.com/doc/O/p/Option_files.html The page says to look in: /etc/my.cnf DATADIR/my.cnf defaults-extra-file (The file specified with --defaults-extra-file=# ) ~/.my.cnf but none of these files seem to exist on my machine. (I assume my DATADIR is /var/lib/mysql/, since it contains subdirectories and subfiles like ./var/lib/mysql/menagerie ./var/lib/mysql/menagerie/pet.frm ./var/lib/mysql/menagerie/pet.MYI ./var/lib/mysql/menagerie/pet.MYD which I assume represent the data stored in the menagerie database that I created while going through the MySQL tutorial.) I searched the machine for files with mysql in the path and .cnf in the name (I had to look up how to do that, to give you an idea of my level of experience with UNIX) but found only: ./usr/doc/MySQL-3.23.36/my-huge.cnf ./usr/doc/MySQL-3.23.36/my-large.cnf ./usr/doc/MySQL-3.23.36/my-medium.cnf ./usr/doc/MySQL-3.23.36/my-small.cnf ./usr/share/mysql/my-huge.cnf ./usr/share/mysql/my-large.cnf ./usr/share/mysql/my-medium.cnf ./usr/share/mysql/my-small.cnf which are sample files. MySQL came pre-installed on that machine. Is it possible (or, indeed, normal) that the MySQL installation process didn't create a my.cnf file? (In that case I'd recommending adding that info to http://www.mysql.com/doc/O/p/Option_files.html , if the author of those pages is on the list. I'll submit a comment there anyway based on what the list replies.) -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: can't find my my.cnf file -- not there by default?
I'm still testing out MySQL and I'm trying to find the my.cnf file referred to at http://www.mysql.com/doc/O/p/Option_files.html ... but none of these files seem to exist on my machine. ... MySQL came pre-installed on that machine. Is it possible (or, indeed, normal) that the MySQL installation process didn't create a my.cnf file? It is normal. (In that case I'd recommending adding that info to http://www.mysql.com/doc/O/p/Option_files.html , if the author of those pages is on the list. I'll submit a comment there anyway based on what the list replies.) That's what the commenting feature is there for :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Performance and the my.cnf file
Hi, I have several problems to do with tuning mysql to run on a Sun E450. Firstly, I cannot get the mysql to read the my.cnf file. If it is installed in the data directory, mysql boots OK but ignores it, while if I copy it into the /etc directory I get the following error Starting mysqld daemon with databases from /home1/mysql/data mysqld daemon ended and mysql does not start up Also, how do you know what the current values of the variables are? Does the command mysqladmin variables outputs the global variables or the current settings of those variables and does the -O option eg mysqld -O key_buffer=32m change the variables on the fly or does the mysql process have to be restarted? Thanks for any help. I am presently struggling to get reasonable performance from our server. Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Performance and the my.cnf file
Make sure my.cnf is mode 744. David Allen wrote: Hi, I have several problems to do with tuning mysql to run on a Sun E450. Firstly, I cannot get the mysql to read the my.cnf file. If it is installed in the data directory, mysql boots OK but ignores it, while if I copy it into the /etc directory I get the following error Starting mysqld daemon with databases from /home1/mysql/data mysqld daemon ended and mysql does not start up Also, how do you know what the current values of the variables are? Does the command mysqladmin variables outputs the global variables or the current settings of those variables and does the -O option eg mysqld -O key_buffer=32m change the variables on the fly or does the mysql process have to be restarted? Thanks for any help. I am presently struggling to get reasonable performance from our server. Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php