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=gcdmg-mysql-2@m.gmane.org

RE: my.cnf file

Adam,=20

you should look upon this as an opportunity to write a my.cnf that suits yo=
ur application and hardware. Understanding the options in this configuratio=
n 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.htm l#SECTION000150=
0000
http://ronaldbradford.com/blog/tag/my-cnf/

Andy

________________________________________
From: ext Adarsh Sharma [adarsh.sharma@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=3Dandrew.2.moore@noki=
a.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: my.cnf file

--0016e6d976529b39790498a066fe
Content-Type: text/plain; charset=ISO-8859-1

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

> 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.htm l#SECTION0001500000
> http://ronaldbradford.com/blog/tag/my-cnf/
>
> Andy
>
> ________________________________________
> From: ext Adarsh Sharma [adarsh.sharma@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.moore@nokia.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=wagnerbianchijr@gmail.com
>
>

--0016e6d976529b39790498a066fe--

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
>
> > 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.htm l#SECTION0001500000
> > http://ronaldbradford.com/blog/tag/my-cnf/
> >
> > Andy
> >
> > ________________________________________
> > From: ext Adarsh Sharma [adarsh.sharma@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.moore@nokia.com
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=wagnerbianchijr@gmail.com
> >
> >



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.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 :
> 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
>>
>> > Adam,
>> >
>> > you should look upon this as an opportunity to write a my.cnf that sui=
ts
>> > 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.htm l#SECTION0=
001500000
>> > http://ronaldbradford.com/blog/tag/my-cnf/
>> >
>> > Andy
>> >
>> > ________________________________________
>> > From: ext Adarsh Sharma [adarsh.sharma@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 i=
n
>> > mysql but cannot able to find it.
>> >
>> > I install mysql by yum install mysql-server and yum install mysql-clie=
nt
>> > commands.
>> >
>> > I find only a folder in /var/lib/ i.e mysql folder that contains ibdat=
a
>> > 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=3Dandrew.2.moore@nokia.co m
>> >
>> >
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe:
>> > http://lists.mysql.com/mysql?unsub=3Dwagnerbianchijr@gmail.c om
>> >
>> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Damoiz.s=
hine@gmail.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: my.cnf file

--001636e1ecff7403270498b95363
Content-Type: text/plain; charset=ISO-8859-1

Are you show about the non-outage operation with this command?

Best regards.
--
Wagner Bianchi


2010/12/31 Sharl.Jimh.Tsin

> rpm -qpi mysql*.rpm | grep my.cnf
>
> Best regards,
> Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
>
>
>
> 2010/12/30 Lydia Rowe :
> > find / -name my.cnf
> >
> > --
> > Lydia
> >
> > On Thu, 2010-12-30 at 11:09 -0200, Wagner Bianchi wrote:
> >> I am seeing you're using an operate system based on Red Hat 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
> >>
> >> > 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.htm l#SECTION0001500000
> >> > http://ronaldbradford.com/blog/tag/my-cnf/
> >> >
> >> > Andy
> >> >
> >> > ________________________________________
> >> > From: ext Adarsh Sharma [adarsh.sharma@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.moore@nokia.com
> >> >
> >> >
> >> > --
> >> > MySQL General Mailing List
> >> > For list archives: http://lists.mysql.com/mysql
> >> > To unsubscribe:
> >> > http://lists.mysql.com/mysql?unsub=wagnerbianchijr@gmail.com
> >> >
> >> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=amoiz.shine@gmail.com
> >
> >
>

--001636e1ecff7403270498b95363--

Re: my.cnf file

--001636c5b6bb0fc1d00498b95733
Content-Type: text/plain; charset=ISO-8859-1

Please, forget my last note, I answered in a wrong thread!

Sorry.

Best regards.
--
Wagner Bianchi


2010/12/31 Wagner Bianchi

> Are you show about the non-outage operation with this command?
>
> Best regards.
> --
> Wagner Bianchi
>
>
> 2010/12/31 Sharl.Jimh.Tsin
>
> rpm -qpi mysql*.rpm | grep my.cnf
>>
>> Best regards,
>> Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
>>
>>
>>
>> 2010/12/30 Lydia Rowe :
>> > find / -name my.cnf
>> >
>> > --
>> > Lydia
>> >
>> > On Thu, 2010-12-30 at 11:09 -0200, Wagner Bianchi wrote:
>> >> I am seeing you're using an operate system based on Red Hat 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
>> >>
>> >> > 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.htm l#SECTION0001500000
>> >> > http://ronaldbradford.com/blog/tag/my-cnf/
>> >> >
>> >> > Andy
>> >> >
>> >> > ________________________________________
>> >> > From: ext Adarsh Sharma [adarsh.sharma@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.moore@nokia.com
>> >> >
>> >> >
>> >> > --
>> >> > MySQL General Mailing List
>> >> > For list archives: http://lists.mysql.com/mysql
>> >> > To unsubscribe:
>> >> > http://lists.mysql.com/mysql?unsub=wagnerbianchijr@gmail.com
>> >> >
>> >> >
>> >
>> >
>> >
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=amoiz.shine@gmail.com
>> >
>> >
>>
>
>

--001636c5b6bb0fc1d00498b95733--