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 [at] m.gmane.org
RE: my.cnf file
Adam,
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 [at] orkash.com]
Sent: 30 December 2010 06:37
To: mysql [at] 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 [at] 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 [at] 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 <andrew.2.moore [at] 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.htm l#SECTION0001500000
> http://ronaldbradford.com/blog/tag/my-cnf/
>
> Andy
>
> ________________________________________
> From: ext Adarsh Sharma [adarsh.sharma [at] orkash.com]
> Sent: 30 December 2010 06:37
> To: mysql [at] 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 [at] nokia.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=wagnerbianchijr [at] 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 <andrew.2.moore [at] 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.htm l#SECTION0001500000
> > http://ronaldbradford.com/blog/tag/my-cnf/
> >
> > Andy
> >
> > ________________________________________
> > From: ext Adarsh Sharma [adarsh.sharma [at] orkash.com]
> > Sent: 30 December 2010 06:37
> > To: mysql [at] 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 [at] nokia.com
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=wagnerbianchijr [at] 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 [at] 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 <lydia [at] 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.moore [at] nokia.com>
>>
>> > 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 [at] orkash.com]
>> > Sent: 30 December 2010 06:37
>> > To: mysql [at] 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 [at] nokia.co m
>> >
>> >
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe:
>> > http://lists.mysql.com/mysql?unsub=3Dwagnerbianchijr [at] gmail.c om
>> >
>> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =C2=A0 =C2=A0http://lists.mysql.com/mysql?unsub=3Damoiz.s=
hine [at] 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 [at] 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 <amoiz.shine [at] gmail.com>
> rpm -qpi mysql*.rpm | grep my.cnf
>
> Best regards,
> Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
>
>
>
> 2010/12/30 Lydia Rowe <lydia [at] 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.moore [at] 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.htm l#SECTION0001500000
> >> > http://ronaldbradford.com/blog/tag/my-cnf/
> >> >
> >> > Andy
> >> >
> >> > ________________________________________
> >> > From: ext Adarsh Sharma [adarsh.sharma [at] orkash.com]
> >> > Sent: 30 December 2010 06:37
> >> > To: mysql [at] 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 [at] nokia.com
> >> >
> >> >
> >> > --
> >> > MySQL General Mailing List
> >> > For list archives: http://lists.mysql.com/mysql
> >> > To unsubscribe:
> >> > http://lists.mysql.com/mysql?unsub=wagnerbianchijr [at] gmail.com
> >> >
> >> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=amoiz.shine [at] 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 <wagnerbianchijr [at] gmail.com>
> Are you show about the non-outage operation with this command?
>
> Best regards.
> --
> Wagner Bianchi
>
>
> 2010/12/31 Sharl.Jimh.Tsin <amoiz.shine [at] gmail.com>
>
> rpm -qpi mysql*.rpm | grep my.cnf
>>
>> Best regards,
>> Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
>>
>>
>>
>> 2010/12/30 Lydia Rowe <lydia [at] 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.moore [at] 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.htm l#SECTION0001500000
>> >> > http://ronaldbradford.com/blog/tag/my-cnf/
>> >> >
>> >> > Andy
>> >> >
>> >> > ________________________________________
>> >> > From: ext Adarsh Sharma [adarsh.sharma [at] orkash.com]
>> >> > Sent: 30 December 2010 06:37
>> >> > To: mysql [at] 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 [at] nokia.com
>> >> >
>> >> >
>> >> > --
>> >> > MySQL General Mailing List
>> >> > For list archives: http://lists.mysql.com/mysql
>> >> > To unsubscribe:
>> >> > http://lists.mysql.com/mysql?unsub=wagnerbianchijr [at] gmail.com
>> >> >
>> >> >
>> >
>> >
>> >
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=amoiz.shine [at] gmail.com
>> >
>> >
>>
>
>
--001636c5b6bb0fc1d00498b95733--