RE: my.cnf authencication

[Harrie Robins]

Thanks for the reply - that was indeed a typo. I resolved this buy making these 
changes:

mysqldump --defaults-extra-file="c:\sql\dump.cnf" dname > c:\loc

with my cnf containing:

[client]
user = user
password = pass

Looks like I misplaced "" and or [client] / [mysqldump] in the cnf

Thanks



-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be] 
Sent: vrijdag 29 januari 2016 15:06
To: Harrie Robins 
Cc: MySql 
Subject: Re: my.cnf authencication

- Original Message -
> From: "Harrie Robins" 
> Subject: my.cnf authencication
> 
> mysqldump --defaults-file  dbase > c:\sql\dbase.sql 2>> c:\log.tct

Might just be a typo in your mail, but you'll need to actually pass the 
defaults-file, too: --defaults-file=c:\sql\dump.cnf .

I think there may be another typo somewhere, too, as it seems to think that 
lts-file is the user you're passing. I'm wondering if you haven't accidentally 
put only a single - in front of defaults-file.


> 
> 
> My log shows:
> 
> mysqldump: Got error: 1045: Access denied for user 
> 'lts-file=c:\sql\dump.cnf'@'localhost' (using password: NO) when 
> trying to connect
> 
> It looks like credentials are not filled in!?
> 
> Regards,
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql

--
Unhappiness is discouraged and will be corrected with kitten pictures.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: my.cnf authencication

[Johan De Meersman]

- Original Message -
> From: "Harrie Robins" 
> Subject: my.cnf authencication
> 
> mysqldump --defaults-file  dbase > c:\sql\dbase.sql 2>> c:\log.tct

Might just be a typo in your mail, but you'll need to actually pass the 
defaults-file, too: --defaults-file=c:\sql\dump.cnf .

I think there may be another typo somewhere, too, as it seems to think that 
lts-file is the user you're passing. I'm wondering if you haven't accidentally 
put only a single - in front of defaults-file.


> 
> 
> My log shows:
> 
> mysqldump: Got error: 1045: Access denied for user
> 'lts-file=c:\sql\dump.cnf'@'localhost' (using password: NO) when trying to
> connect
> 
> It looks like credentials are not filled in!?
> 
> Regards,
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql

-- 
Unhappiness is discouraged and will be corrected with kitten pictures.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: my.cnf file

[Wagner Bianchi]

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

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

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

Re: my.cnf file

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

[Wagner Bianchi]

I am seeing you're using an operate system based on Red Hat distro. Well,
after install MySQL via yum or via rpm packages, the location of MySQL
samples configuration file usually is /usr/share/mysql.

After to check the existence of sample configuration files (my-huge.cnf,
my-large.cnf, 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.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

[andrew.2.moore]

Adam, 

you should look upon this as an opportunity to write a my.cnf that suits your 
application and hardware. Understanding the options in this configuration can 
be paramount to a well tuned server.

a few resources to kick it all off...
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

[Craig Dunn]

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

Re: my.cnf optimization

[Perrin Harkins]

On Thu, Sep 4, 2008 at 3:23 PM, Ryan Schwartz <[EMAIL PROTECTED]> wrote:
> I'll have to crack open my copy - haven't read through it in a while

If you have the first edition, I recommend getting the newer one.  It
has a lot more tuning info.

- Perrin

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf optimization

[Ryan Schwartz]

On Sep 4, 2008, at 1:48 PM, Ranjeet Walunj wrote:


Hi ryan.

As pointed by Johnny, it is difficult to give optimization advise  
without exactly knowing the performance of your machine.


I'm assuming you are using the machine as Database Server and not  
running application (Web/other) on the same.

(And you are using InnoDB as engine)

I would suggest keeping innodb_buffer_pool_size pretty high (+20G)


This is a dedicated MySQL server - nothing else running on it at all,  
so all that RAM is up for grabs. Mysqld is running in 64 bits, and  
after bumping innodb_buffer_pool_size to 4G our performance concerns  
are completely gone - I'll ramp that up after doing a bit more  
research on InnoDB tuning.



Please read up here :
http://www.mysqlperformanceblog.com/2007/11/03/choosing-innodb_buffer_pool_size/

Also if possible get a copy of "High performance MySQL" and go  
through it as it covers many good techniques for high performance  
MySQL setup.


I'll have to crack open my copy - haven't read through it in a while,  
and quite honestly I had forgot to make any adjustments on the InnoDB  
side of things because when I inherited the old MySQL server we were  
on the devs were mostly using MyISAM tables.


Some of the default InnoDB settings are horribly wrong from high  
performance point of view. Can you post your complete my.cnf on  
pastebin or somewhere ?


http://pastebin.com/m2ebec4f6 includes everything in my.cnf but  
comments and blank lines, SHOW STATUS\G, SHOW INNODB STATUS\G, AND  
SHOW VARIABLES\G


All your help is much appreciated - I just wonder if there's not been  
a simple script set up by someone to autogen my.cnf based on system  
variables like available RAM, etc? Surely there's some general  
recommendations depending on those specific system things, rather than  
"just copy my-huge.cnf and modify"...

--
Ryan Schwartz



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf optimization

[Ranjeet Walunj]

Ryan Schwartz wrote



mysql> show variables like '%buffer%'\G
*** 1. row ***

*** 3. row ***
Variable_name: innodb_buffer_pool_size
Value: 8388608
*** 4. row ***
Variable_name: innodb_log_buffer_size
Value: 1048576


I'll bump innodb_buffer_pool_size to 2G and see how that goes. Thanks 
for the tips, if there's additional innodb tuning parameters folks 
tend to hit first I'd be glad to try them as well.

--
Ryan Schwartz



Hi ryan.

As pointed by Johnny, it is difficult to give optimization advise 
without exactly knowing the performance of your machine.


I'm assuming you are using the machine as Database Server and not 
running application (Web/other) on the same.

(And you are using InnoDB as engine)

I would suggest keeping innodb_buffer_pool_size pretty high (+20G)

Please read up here :
http://www.mysqlperformanceblog.com/2007/11/03/choosing-innodb_buffer_pool_size/

Also if possible get a copy of "High performance MySQL" and go through 
it as it covers many good techniques for high performance MySQL setup.


Some of the default InnoDB settings are horribly wrong from high 
performance point of view. Can you post your complete my.cnf on pastebin 
or somewhere ?




Regards,
Ranjeet Walunj

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf optimization

[Perrin Harkins]

On Thu, Sep 4, 2008 at 12:15 AM, Ryan Schwartz <[EMAIL PROTECTED]> wrote:
> We're seeing a huge surge in our qps and I'd like to make sure we're tuned
> as well as we can be. I'm wondering if I've got some variables maybe set too
> large (is that even possible?) ? We do have a fair bit of innodb, so perhaps
> I should add some non-defaults there, but I'm not so sure where to start
> with that.

It's not really possible to give good tuning advice without knowing
about how you use the database and how your machine is currently
responding.  However, you can get some good started advice from the
sample my.cnf files that come with MySQL and you can get a copy of the
"High Performance MySQL" book for a good primer on what to look for.
You can also find conference presentations by Peter Zaitsev that
summarize some of the advice in the book.

- Perrin

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf optimization

[Ryan Schwartz]

Here's all the buffer variables:

mysql> show variables like '%buffer%'\G
*** 1. row ***
Variable_name: bulk_insert_buffer_size
Value: 8388608
*** 2. row ***
Variable_name: innodb_buffer_pool_awe_mem_mb
Value: 0
*** 3. row ***
Variable_name: innodb_buffer_pool_size
Value: 8388608
*** 4. row ***
Variable_name: innodb_log_buffer_size
Value: 1048576
*** 5. row ***
Variable_name: join_buffer_size
Value: 131072
*** 6. row ***
Variable_name: key_buffer_size
Value: 402653184
*** 7. row ***
Variable_name: myisam_sort_buffer_size
Value: 67108864
*** 8. row ***
Variable_name: net_buffer_length
Value: 16384
*** 9. row ***
Variable_name: preload_buffer_size
Value: 32768
*** 10. row ***
Variable_name: read_buffer_size
Value: 67104768
*** 11. row ***
Variable_name: read_rnd_buffer_size
Value: 67104768
*** 12. row ***
Variable_name: sort_buffer_size
Value: 67108856
12 rows in set (0.00 sec)

I'll bump innodb_buffer_pool_size to 2G and see how that goes. Thanks  
for the tips, if there's additional innodb tuning parameters folks  
tend to hit first I'd be glad to try them as well.

--
Ryan Schwartz


On Sep 4, 2008, at 8:16 AM, Johnny Withers wrote:

If you do have a fair about of innodb tables you can increase  
performance by increasing the size of innodb_buffer_pool_size.  
According to your status output, you are currently using the entire  
buffer pool:


*** 137. row ***
Variable_name: Innodb_buffer_pool_pages_free
  Value: 0

It seems to be set small anyway:

Variable_name: Innodb_buffer_pool_pages_data
  Value: 501

It also seems that you do have alot of innodb data:

*** 151. row ***
Variable_name: Innodb_data_read
  Value: 27743085907968


Again, i don't know what you have innodb_buffer_pool_size set to,  
but you have plenty of RAM, I'd set it to about 4.5GB and see if  
that helps. I also don't know mucha bout OS X and your hardware.. is  
it 64bit? If it is not 64bit, you probably can't use 4.5GB as the  
size of your buffer pool.


-johnny

On 9/3/08, Ryan Schwartz <[EMAIL PROTECTED]> wrote: All,

We're seeing a huge surge in our qps and I'd like to make sure we're  
tuned as well as we can be. I'm wondering if I've got some variables  
maybe set too large (is that even possible?) ? We do have a fair bit  
of innodb, so perhaps I should add some non-defaults there, but I'm  
not so sure where to start with that.


Hardware is an Apple Xserve, 2x Quad-Core Intel @ 3Ghz, 32GB RAM, 3x  
280 GB SAS drives in Raid-5 config, OS is Mac OS X 10.5.4 and here's  
my my.cnf:


[billie:~] admin$ egrep -v '^$|^#' /etc/my.cnf
[client]
port= 3306
socket  = /var/mysql/mysql.sock
[mysqld]
port= 3306
socket  = /var/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 50M
table_cache = 2048
sort_buffer_size = 64M
read_buffer_size = 64M
read_rnd_buffer_size = 64M
myisam_sort_buffer_size = 64M
thread_cache_size = 100
query_cache_size = 64M
thread_concurrency = 16
skip-thread-priority
max_connections = 750
old-passwords
innodb_file_per_table
innodb_flush_log_at_trx_commit=1
sync_binlog=1
log-slow-queries
long_query_time=2
log_queries_not_using_indexes
log-bin=mysql-bin
server-id   = 4
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout

SHOW STATUS\G output follows my sig below...

My devs are adding indexes where the slow query log is pointing  
them, but any suggestions on how better to tune things up would be  
much appreciated. I'm not sure what else to tune here but we're  
getting bursts of 1200+ queries per second regularly and seeing  
things slow down significantly.


Best,
--
Ryan Schwartz

mysql> SHOW STATUS\G
*** 1. row ***
Variable_name: Aborted_clients
  Value: 1656
*** 2. row ***
Variable_name: Aborted_connects
  Value: 3
*** 3. row ***
Variable_name: Binlog_cache_disk_use
  Value: 276
*** 4. 

Re: my.cnf / mysqld logging

[Dan Buettner]

Hi Tom -

In your my.cnf file, you need to specify that the setting you put in is 
for mysqld, the server process.  Your file should look like so:



[mysqld]
log = /var/log/mysqld.log


MySQL generally logs high-level info to files in the data directory: 
look for a file called .err


Question: are you sure you want to log *everything* ?  MySQL does have a 
general log feature, but bear in mind that it is a log of every query 
(insert update select delete etc) that happens, including any inserted 
data, so it can become very large very quickly. I had this happen on a 
production server, and it wasn't really that fun.  See 
http://dev.mysql.com/doc/refman/5.0/en/query-log.html for more info


MySQL also offers a slow query log, which can be helpful in starting a 
performance/optimization process.  To enable, put this in your my.cnf 
file under the [mysqld] section:

log-slow-queries=/path/to/logfile
See http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html

HTH,
Dan


Tom Ray [Lists] wrote:
Hey there, I inherited a couple of servers that are in production but I 
noticed that there's not active logging for mysql on any of them. I 
looked and they don't have an active my.cnf file any where on the 
machines. One machine is running mysql 4.1.5 and the other is running 
mysql 5.0.18


When I ran a ps -ef on the machines I saw this for both 
/usr/local/mysql/bin/mysqld 
defaults-extra-file=/usr/local/mysql/data/my.cnf so I went and I put 
a my.cnf right where it was looking for it. Stopped/Started the mysql 
server and I'm still not seeing any logging happening for the mysql 
servers. Perhaps I'm messing this up? I want them to log everything to 
/var/log/mysqld.log and in the my.cnf I have the line:


log = /var/log/mysqld.log

Can anyone tell me where I'm messing this up or what is wrong?



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf / mysqld logging

[Dilipkumar]

Hi,

log-queries=/path/



Tom Ray [Lists] wrote:

How would I do that? I'm still a novice when it comes to many aspects 
of mysql.


[EMAIL PROTECTED] wrote:


Hi,

Try to enable query log.


Thanks & Regards
Dilipkumar

 [EMAIL PROTECTED]:

 


Hey there, I inherited a couple of servers that are in production but I

noticed that there\'s not active logging for mysql on any of them. I 
looked and they don\'t have an active my.cnf file any where on the 
machines. One machine is running mysql 4.1.5 and the other is 
running mysql 5.0.18


When I ran a ps -ef on the machines I saw this for both 
/usr/local/mysql/bin/mysqld 
defaults-extra-file=/usr/local/mysql/data/my.cnf so I went and I 
put


a my.cnf right where it was looking for it. Stopped/Started the 
mysql server and I\'m still not seeing any logging happening for the 
mysql servers. Perhaps I\'m messing this up? I want them to log 
everything to /var/log/mysqld.log and in the my.cnf I have the line:


log = /var/log/mysqld.log

Can anyone tell me where I\'m messing this up or what is wrong?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:   
http://lists.mysql.com/[EMAIL PROTECTED]







  






--
Thanks & Regards,
Dilipkumar
DBA Support

** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to 
Sify Limited and is intended for use only by the individual or entity to 
which it is addressed, and may contain information that is privileged, 
confidential or exempt from disclosure under applicable law. If this is a 
forwarded message, the content of this E-MAIL may not have been sent with 
the authority of the Company. If you are not the intended recipient, an 
agent of the intended recipient or a  person responsible for delivering the 
information to the named recipient,  you are notified that any use, 
distribution, transmission, printing, copying or dissemination of this 
information in any way or in any manner is strictly prohibited. If you have 
received this communication in error, please delete this mail & notify us 
immediately at [EMAIL PROTECTED]


Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. 
www.sifymax.com

Get to see what's happening in your favourite City on Bangalore Live! 
www.bangalorelive.in


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf / mysqld logging

[Tom Ray [Lists]]

How would I do that? I'm still a novice when it comes to many aspects of 
mysql.


[EMAIL PROTECTED] wrote:

Hi,

Try to enable query log.


Thanks & Regards
Dilipkumar

 [EMAIL PROTECTED]:

  

Hey there, I inherited a couple of servers that are in production but I

noticed that there\'s not active logging for mysql on any of them. I 
looked and they don\'t have an active my.cnf file any where on the 
machines. One machine is running mysql 4.1.5 and the other is running 
mysql 5.0.18


When I ran a ps -ef on the machines I saw this for both 
/usr/local/mysql/bin/mysqld 
defaults-extra-file=/usr/local/mysql/data/my.cnf so I went and I put


a my.cnf right where it was looking for it. Stopped/Started the mysql 
server and I\'m still not seeing any logging happening for the mysql 
servers. Perhaps I\'m messing this up? I want them to log everything to 
/var/log/mysqld.log and in the my.cnf I have the line:


log = /var/log/mysqld.log

Can anyone tell me where I\'m messing this up or what is wrong?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:   
http://lists.mysql.com/[EMAIL PROTECTED]






  


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf / mysqld logging

[dilipkumar_parikh]

Hi,

Try to enable query log.


Thanks & Regards
Dilipkumar

 [EMAIL PROTECTED]:

> Hey there, I inherited a couple of servers that are in production but I
> 
> noticed that there\'s not active logging for mysql on any of them. I 
> looked and they don\'t have an active my.cnf file any where on the 
> machines. One machine is running mysql 4.1.5 and the other is running 
> mysql 5.0.18
> 
> When I ran a ps -ef on the machines I saw this for both 
> /usr/local/mysql/bin/mysqld 
> defaults-extra-file=/usr/local/mysql/data/my.cnf so I went and I put
> 
> a my.cnf right where it was looking for it. Stopped/Started the mysql 
> server and I\'m still not seeing any logging happening for the mysql 
> servers. Perhaps I\'m messing this up? I want them to log everything to 
> /var/log/mysqld.log and in the my.cnf I have the line:
> 
> log = /var/log/mysqld.log
> 
> Can anyone tell me where I\'m messing this up or what is wrong?
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
> http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf not being found?

[Marcus Bointon]

On 5 Jun 2006, at 03:12, Marcus Bointon wrote:


Any other ideas?


D'oh! I just fixed the my.cnf problems. Because of the slightly  
peculiar route that the my.cnf file got onto my MacBook, it had  
somehow had its line breaks translated to Mac format, and it seems  
MySQL doesn't like that. I guess I'll report that as a minor bug. It  
didn't fix the prefpane problem though.


Marcus
--
Marcus Bointon
Synchromedia Limited: Putting you in the picture
[EMAIL PROTECTED] | http://www.synchromedia.co.uk


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf not being found?

[Marcus Bointon]

On 5 Jun 2006, at 01:52, Petr Chardin wrote:


"mysqld --print-defaults".


That produces:

> mysqld would have been started with the following arguments:

i.e., it's got no options at all. It is a completely default install.

Any other ideas?

Marcus
--
Marcus Bointon
Synchromedia Limited: Putting you in the picture
[EMAIL PROTECTED] | http://www.synchromedia.co.uk


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf not being found?

[Petr Chardin]

On Sun, 2006-06-04 at 23:28 +0100, Marcus Bointon wrote:
> On the same OS X machine that's having prefpanel trouble with 5.0.22,  
> I find that mysql is not loading the values set in /etc/my.cnf. The  
> contents of the file is from another Mac that works just fine with  
> it. The file is world-readable. Should it be somewhere else?

The location is correct. However mysqld looks for options in several
files. For instance, it traverses the datadir, for my.cnf and home
directory for .my.cnf. Then it merges defaults from all files read
and attempts to start the server. So, it might be that you have
another my.cnf, which is also processed.

Try checking the option, which are actually read by the server with
"mysqld --print-defaults".

Petr


> Marcus
> -- 
> Marcus Bointon
> Synchromedia Limited: Putting you in the picture
> [EMAIL PROTECTED] | http://www.synchromedia.co.uk
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf files

[Gleb Paharenko]

Hello.

Example files are usually shipped with MySQL distribution. Check
the support-files directory for my-*.cnf examples. Search in archives
at http://list.mysql.com/mysql as well.


Philip R. Thompson wrote:
> Hi all.
> 
> I am having some troubles with what should be contained within my 
> my.cnf file. Would a few of you be willing to show me what yours 
> consists of?
> 
> Thanks,
> ~Philip
> 


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

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

[s. keeling]

Incoming from Paul DuBois:
> At 18:50 -0600 10/2/05, s. keeling wrote:
> >
> >Groan.  More stuff to learn, configure, maintain, and memorize.  I'm
> >trying to replicate Unix's "root vs. mere user" security paradigm in
> 
> I think your analogy is flawed.  If you really want the root vs mere
> user distinction, the analogy would be that you su to the appropriate
> user before running MySQL programs.  If you did that, the .my.cnf

I am the appropriate user.  It's my database, and no other user has
access.  The root mysql user has given my login ID two roles:
administrator and user of the db.  I don't want to add the complexity
of multiple login accounts, nor should I have to.  MySQL is an app,
which I as a user should be able to use as my OS's security regime
allows.

> >How about if I submit a feature request?  Parse the command line.  If
> 
> If you submit a feature request, I hope that it would be more detailed

No need, since this:

> Because you're not using the mysql_read_default_group or
> mysql_read_default_file option in your connect string, most likely.

works perfectly.  Just what I was looking for for the perl programs.
Thanks.  Now I just need to futz with ~/.my.cnf, dependent on whether
I want keeling or sbk to have passwordless access.  This is workable.


-- 
Any technology distinguishable from magic is insufficiently advanced.
(*)http://www.spots.ab.ca/~keeling  Please don't Cc: me.
- -
For the ChiComms: democracy human rights Taiwan Independence

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

[Paul DuBois]

At 18:50 -0600 10/2/05, s. keeling wrote:

Incoming from Paul DuBois:


 At 16:39 -0600 10/2/05, s. keeling wrote:
 >
 >The admin account, with no password, doesn't function at all.  perl
 >programs appear to ignore ~/.my.cnf forcing me to open() them and
 >slurp username and password that way.
 >
 >How is this supposed to work?  Surely, you're not all embedding
 >passwords in your source, are you?  How can I have separate user and
 >admin accounts working via ~/.my.cnf from the same login account?

 I think I'd probably set up aliases that invoke mysql or mysqladmin
 with a --defaults-extra-file option that contains the username/password
 for the appropriate account.


Groan.  More stuff to learn, configure, maintain, and memorize.  I'm
trying to replicate Unix's "root vs. mere user" security paradigm in
MySQL.  I can do "drop table" as sbk without hurting myself.  Doing it
as keeling risks data loss.


I think your analogy is flawed.  If you really want the root vs mere
user distinction, the anolgy would be that you su to the appropriate
user before running MySQL programs.  If you did that, the .my.cnf
for each user would be read correctly.



How about if I submit a feature request?  Parse the command line.  If
command == bar and MySQL user == foo, find foo's password stanza for
bar in ~/.my.cnf, and use that password.  That shouldn't be difficult.


If you submit a feature request, I hope that it would be more detailed
than that.  I suspect it's not so easy as you think.



Why does a perl program run by my login username ignore MySQL's
~/.my.cnf?  Are MySQL users really embedding passwords in their code?


Because you're not using the mysql_read_default_group or
mysql_read_default_file option in your connect string, most likely.

This is what I do after parsing command line arguments:

# construct data source
my $dsn = "DBI:mysql:sampdb";
$dsn .= ";host=$host_name" if $host_name;
$dsn .= ";port=$port_num" if $port_num;
$dsn .= ";mysql_socket=$socket_name" if $socket_name;
$dsn .= ";mysql_read_default_group=client";

# connect to server
my $dbh = DBI->connect ($dsn, $user_name, $password,
{ RaiseError => 1, PrintError => 0, AutoCommit => 1 });


--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

[s. keeling]

Incoming from Paul DuBois:
> 
> At 16:39 -0600 10/2/05, s. keeling wrote:
> >
> >The admin account, with no password, doesn't function at all.  perl
> >programs appear to ignore ~/.my.cnf forcing me to open() them and
> >slurp username and password that way.
> >
> >How is this supposed to work?  Surely, you're not all embedding
> >passwords in your source, are you?  How can I have separate user and
> >admin accounts working via ~/.my.cnf from the same login account?
> 
> I think I'd probably set up aliases that invoke mysql or mysqladmin
> with a --defaults-extra-file option that contains the username/password
> for the appropriate account.

Groan.  More stuff to learn, configure, maintain, and memorize.  I'm
trying to replicate Unix's "root vs. mere user" security paradigm in
MySQL.  I can do "drop table" as sbk without hurting myself.  Doing it
as keeling risks data loss.

How about if I submit a feature request?  Parse the command line.  If
command == bar and MySQL user == foo, find foo's password stanza for
bar in ~/.my.cnf, and use that password.  That shouldn't be difficult.

Why does a perl program run by my login username ignore MySQL's
~/.my.cnf?  Are MySQL users really embedding passwords in their code?

How do I use the passwordless admin account?  Should that stanza just
be deleted from .my.cnf? 

How do other db's handle this, or do they?


-- 
Any technology distinguishable from magic is insufficiently advanced.
(*)   http://www.spots.ab.ca/~keeling 
- -

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

[Paul DuBois]

I think I'd probably set up aliases that invoke mysql or mysqladmin
with a --defaults-extra-file option that contains the username/password
for the appropriate account.



At 16:39 -0600 10/2/05, s. keeling wrote:

I've checked everywhere I can find (Paul DuBois' MySQL, ML archives,
dev.mysql.com, my local User Group) for this, but everything I find
either describes a simplistic or far more complex case.  This is all
on my local box, no networking required, and I'm the only one
accessing the data.  I've four MySQL related accounts: root, admin,
keeling, and sbk.  root is the root mysql user (which I'd prefer to
leave alone once the rest is working, which it mostly is).  admin is
just for trivial mysqladmin stuff.  keeling is a full blown admin
account able to create and drop db's.  sbk is a user account intended
for entering/changing/querying data.

So, I'd like (ie.) this ~/.my.cnf to control my login account access
to the db:

  ---
[client]
user= sbk   # <-- user use of mysql related clients
password= ...

[mysql]
user= keeling   # <-- admin use of mysql-client
password= ...

user= sbk   # <-- user use of mysql-client
password= ...

[mysqladmin]
user= keeling
password= ...

[mysqladmin]
user= admin
password=
  ---

Of course, it's been chmodded 600.

Infuriatingly, no matter how many iterations of massaging this, when
it works for sbk it's broken for keeling, and vice versa:

(0) infidel /home/keeling/devl/perl/cuug_ mysql -u keeling
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)

The admin account, with no password, doesn't function at all.  perl
programs appear to ignore ~/.my.cnf forcing me to open() them and
slurp username and password that way.

How is this supposed to work?  Surely, you're not all embedding
passwords in your source, are you?  How can I have separate user and
admin accounts working via ~/.my.cnf from the same login account?

This is MySQL 4.0 on Debian/Gnu Linux (Testing/Etch) (note the
"anonymous user" accounts have had their passwords changed, if they
exist at all; I'm not sure about that latter bit).  Yes, there are
more recent MySQL versions available in the repositories, but I don't
need bleeding edge features.  I just need base functionality.

Please point me at FAQs or websites that explain this better than
those I've seen so far.  Thanks.  Much appreciated.


--
Any technology distinguishable from magic is insufficiently advanced.
(*)   http://www.spots.ab.ca/~keeling
- -

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: my.cnf not found

[Sujay Koduri]

Thanks a lot stassen :)

sujay 

-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 10, 2005 9:50 PM
To: Sujay Koduri
Cc: MySQL mailing list
Subject: Re: my.cnf not found

Sujay Koduri wrote:

> hi,
>  
> I tried installing MySQL4.1.13 and in the process I installed the 
> following packages
> 
> * MySQL-client-4.1.13-0.i386.rpm
> * MySQL-server-4.1.13-0.i386.rpm
> * MySQL-shared-standard-4.1.13-0.rhel3.i386.rpm
> 
> I am able to make connections to mysql and able to do 
> update,insert,select and everything over the database.
> But i need to turnoff the auto commit option as i am planning to use 
> INNOdb tables, which needs to be edited in the my.cnf file (i donnow 
> if i can change this information anywhere else!!)
>  
> I looked for this file in the following locations.
>  
> /etc/
> /var/lib/mysql/  but i am not able to find it.
> please help me if i can do anything for this
>  
> Thank you
> sujay

my.cnf doesn't exist till you create it.  See the manual for more
<http://dev.mysql.com/doc/mysql/en/option-files.html>.

You don't need my.cnf to turn off autocommit, though.  In fact, you don't
even need to turn it off.  See the manual for details
<http://dev.mysql.com/doc/mysql/en/innodb-and-autocommit.html>.

Michael

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf not found

[Michael Stassen]

Sujay Koduri wrote:


hi,
 
I tried installing MySQL4.1.13 and in the process I installed the following

packages

*   MySQL-client-4.1.13-0.i386.rpm
*   MySQL-server-4.1.13-0.i386.rpm
*   MySQL-shared-standard-4.1.13-0.rhel3.i386.rpm

I am able to make connections to mysql and able to do update,insert,select
and everything over the database.
But i need to turnoff the auto commit option as i am planning to use INNOdb
tables, which needs to be edited in the my.cnf file (i donnow if i can
change this information anywhere else!!)
 
I looked for this file in the following locations.
 
/etc/

/var/lib/mysql/  but i am not able to find it.
please help me if i can do anything for this
 
Thank you

sujay


my.cnf doesn't exist till you create it.  See the manual for more 
.


You don't need my.cnf to turn off autocommit, though.  In fact, you don't even 
need to turn it off.  See the manual for details 
.


Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf parameter settings for 4 GB RAM

[Gleb Paharenko]

Hi.



Tune key_buffer_size for it. And you may want to order commercial support to receive 
finetune of your server: go to https://order.mysql.com/?ref=ensita



"Anil Doppalapudi" <[EMAIL PROTECTED]> wrote:

> please provide me listof my.cnf parameter values for 4 GB RAM . from support

> files i can list out only upto 2 GB RAM

> 

> my database is mysql 4.0.20 binary installation on linux and along with

> database apache, tomcat and one more application is running on the server.

> 

> 

> Thanks in advance

> Anil

> 

> 

> 



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

Re: .my.cnf

[SGreen]

Yong, 

If that is the full contents of your my.cnf file, the message is self 
explanatory: you have not specified a [mysql] section header before you 
specify a recognized option.  There is typically only one my.cnf file on 
any machine (exceptions do exist). Each my.cnf file can contain both 
server settings and client settings. The only way the client software 
knows which settings belong to it is by the section headers.

Try this:

[mysql]
user=yong
password=
host=sg1p.net.tamu.edu
socket=/tmp/mysql.sock

The section header I added should make a difference.  For more details on 
how to launch the mysql client, please refer to: 
http://dev.mysql.com/doc/mysql/en/mysql.html

Yours,

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


"Yong Wang" <[EMAIL PROTECTED]> wrote on 08/18/2004 04:19:47 PM:

> Hi, Shawn:
>  Actually I did exactly as you emailed me. I use
> mysql -h netinfo.tamu.edu -u username -p to access 
> a different host in .my.cnf file. I got the following error
> msg to complain .my.cnf:
> ./mysql -h netinfo.tamu.edu -u hello -p 
> error: Found option without preceding group in config file:
> /home/yong/.my.cnf at line: 1
> Fatal error in defaults handling. Program aborted
> My whole .my.cnffile contents are as follow:
>user=yong
> password=
> host=sg1p.net.tamu.edu
> socket=/tmp/mysql.sock
> The command line complains the default username is different from the
> other mysql server (one in sg1 , the other is in netinfo)
> How may I fix it ?
>   Thank you very much for your help.
> 
>  Yong
> 
> >>> <[EMAIL PROTECTED]> 2004-8-18 14:57:50 >>>
> The setting in the my.cnf is just a default setting. It's impossible to
> 
> have more than one default value. Whichever value you specify last is
> what 
> the setting will be.
> 
> When you need to connect to a second server, you need to open another 
> client and specify the hostname you want it to connect to. 2 servers =
> 2 
> clients , 3 servers = 3 clients, and so on. If you are programming and
> 
> need to read data from multiple servers you will have to create
> multiple 
> connections, one for each server you need to work with (exactly how
> would 
> depend on the language you are developing with and the database access
> 
> library you are using)
> 
> mysql -h address.goes.here -u the_user_account_to_login_with -p
> 
> That is the no-frills way to initiate a command line MySQL client
> session 
> with any non-default MySQL server. 
> The -h parameter indicates that you are specifying a particular
> 
> host. The host name can either be an IP addresss or a FQDN 
> (fully-qualified domain name).
> The -u identifies what login you want to use on the server you
> 
> specified in -h
> The -p makes the client prompt you for a password.
> 
> These are all optional parameters. If you don't specify a parameter 
> explicitly , like I did in the example, the default values read from 
> my.cnf are what get used.
> 
> Yours,
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
> 
> "Yong Wang" <[EMAIL PROTECTED]> wrote on 08/18/2004 03:22:13
> PM:
> 
> > Hi, all:
> > In my solaris account, there is a .my.cnf file for me to access
> > mysql in remote machine. 
> > In the current file, it is configured as:
> > host=sg1p.net.tamu.edu
> > socket=/tmp/mysql.socka
> > 
> > If I want to add other remote machine name as netinfo.tamu.edu with
> > mysql in the .my.cnf file,
> > How can i add multiple remote machines with mysql in the .my.cnf ?
> >   Thanks a lot.
> > 
> >  Yong
> > 
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql 
> > To unsubscribe: 
> http://lists.mysql.com/[EMAIL PROTECTED] 
> > 

Re: .my.cnf

[SGreen]

The setting in the my.cnf is just a default setting. It's impossible to 
have more than one default value. Whichever value you specify last is what 
the setting will be.

When you need to connect to a second server, you need to open another 
client and specify the hostname you want it to connect to. 2 servers = 2 
clients , 3 servers = 3 clients, and so on. If you are programming and 
need to read data from multiple servers you will have to create multiple 
connections, one for each server you need to work with (exactly how would 
depend on the language you are developing with and the database access 
library you are using)

mysql -h address.goes.here -u the_user_account_to_login_with -p

That is the no-frills way to initiate a command line MySQL client session 
with any non-default MySQL server. 
The -h parameter indicates that you are specifying a particular 
host. The host name can either be an IP addresss or a FQDN 
(fully-qualified domain name).
The -u identifies what login you want to use on the server you 
specified in -h
The -p makes the client prompt you for a password.

These are all optional parameters. If you don't specify a parameter 
explicitly , like I did in the example, the default values read from 
my.cnf are what get used.

Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

"Yong Wang" <[EMAIL PROTECTED]> wrote on 08/18/2004 03:22:13 PM:

> Hi, all:
> In my solaris account, there is a .my.cnf file for me to access
> mysql in remote machine. 
> In the current file, it is configured as:
> host=sg1p.net.tamu.edu
> socket=/tmp/mysql.socka
> 
> If I want to add other remote machine name as netinfo.tamu.edu with
> mysql in the .my.cnf file,
> How can i add multiple remote machines with mysql in the .my.cnf ?
>   Thanks a lot.
> 
>  Yong
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 

Re: my.cnf not read in 4.1.3

[V. M. Brasseur]

What else is in the my.cnf file?  For instance, when I run `mysqld 
--print-defaults` on my system I see this:

mysqld would have been started with the following arguments:
--basedir=/path/to/mysql-4.0 --datadir=/path/to/mysql-4.0/data 
--port=1032 --socket=/path/to/mysql-4.0/mysql.sock --user=username 
--log=/path/to/mysql-4.0/logs/this.log 
--log-slow-queries=/path/to/mysql-4.0/logs/this-slow.log 
--log-error=/path/to/mysql-4.0/logs/this-err.log --log-long-format 
--tmpdir=/path/to/mysql-4.0/tmp

Each of those parameters is an option set in the my.cnf file.  So I'd 
imagine that if you have anything at all in the [mysqld] group in the 
file you'd be seeing them in the --print-defaults output.

If there are no objections from your sysadmin, I suggest moving your 
my.cnf file from /etc/mysql straight into /etc.  Either that or into the 
default datadir for your installation.  Both should work better for you 
(but the /etc/my.cnf location would be a sure-thing).

Cheers,
--V
[EMAIL PROTECTED] wrote:
The output of mysqld --print-defaults is blank, so that means it should be
looking for my.cnf in the default location, which is /etc/mysql/my.cnf,
right?  I am indeed editing the file in that location.
Ryan

Are you sure that the server is using the my.cnf file which you are
changing?  After making the change, what is the output of
--print-defaults for mysqld?  If it's not as expected, odds are good
that the server is getting its defaults from a different location.
--V
[EMAIL PROTECTED] wrote:
Hi all:
  I am running MySQL 4.1.3 under Debian.  I have the problem that my
options in my.cnf are not going into effect.  I want to increase
max_heap_table_size from the default of 16M to 400M (I have 4GB of
memory), but putting that line into my.cnf doesn't do anything.  (Yes
it is in the mysqld section of the file.)  Also I have tried doing a
set global max_heap_table_size=4;
in the mysql command line but it doesn't change the value either,
according to SHOW VARIABLES.
What am I doing wrong?
Regards,
Ryan




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf not read in 4.1.3

[V. M. Brasseur]

Are you sure that the server is using the my.cnf file which you are 
changing?  After making the change, what is the output of 
--print-defaults for mysqld?  If it's not as expected, odds are good 
that the server is getting its defaults from a different location.

--V
[EMAIL PROTECTED] wrote:
Hi all:
   I am running MySQL 4.1.3 under Debian.  I have the problem that my
options in my.cnf are not going into effect.  I want to increase
max_heap_table_size from the default of 16M to 400M (I have 4GB of
memory), but putting that line into my.cnf doesn't do anything.  (Yes
it is in the mysqld section of the file.)  Also I have tried doing a
set global max_heap_table_size=4;
in the mysql command line but it doesn't change the value either,
according to SHOW VARIABLES.
What am I doing wrong?
Regards,
Ryan

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf - do we need it or not?

[Michael Stassen]

You'll get better results if you keep threads on the list.
Server settings are described in the manual:
<http://dev.mysql.com/doc/mysql/en/Server_options.html>
<http://dev.mysql.com/doc/mysql/en/Server_system_variables.html>
Tuning server settings is also described:
<http://dev.mysql.com/doc/mysql/en/Server_parameters.html>.
You can check current settings with SHOW VARIABLES:
<http://dev.mysql.com/doc/mysql/en/SHOW_VARIABLES.html>.
You can change settings with my.cnf:
<http://dev.mysql.com/doc/mysql/en/Option_files.html>.
Michael
Scott Fletcher wrote:
How do I know what is the default setting by looking at it?  (without
my.cnf)
Scott
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 11, 2004 9:12 AM
To: [EMAIL PROTECTED]
Cc: Scott Fletcher; [EMAIL PROTECTED]
Subject: Re: my.cnf - do we need it or not?

But only if you need to change settings from the defaults.
[EMAIL PROTECTED] wrote:

Not if you are are on a Win32 platform, all you need is my.ini.
Otherwize 

with the *nix versions, you do need it.
"Scott Fletcher" <[EMAIL PROTECTED]> wrote on 08/11/2004 09:35:22
AM:

Hi!  Do we really need the my.cnf file to tweak MySQL?  Mine doesn't
have it and it just work fine... 


Thanks,
Scott

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf - do we need it or not?

[Michael Stassen]

But only if you need to change settings from the defaults.
[EMAIL PROTECTED] wrote:
Not if you are are on a Win32 platform, all you need is my.ini. Otherwize 
with the *nix versions, you do need it.

"Scott Fletcher" <[EMAIL PROTECTED]> wrote on 08/11/2004 09:35:22 AM:

Hi!  Do we really need the my.cnf file to tweak MySQL?  Mine doesn't
have it and it just work fine... 


Thanks,
Scott


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf - do we need it or not?

[SGreen]

Not if you are are on a Win32 platform, all you need is my.ini. Otherwize 
with the *nix versions, you do need it.

"Scott Fletcher" <[EMAIL PROTECTED]> wrote on 08/11/2004 09:35:22 AM:

> Hi!  Do we really need the my.cnf file to tweak MySQL?  Mine doesn't
> have it and it just work fine... 
> 
> 
> 
> Thanks,
> 
>  Scott
> 

Re: my.cnf Error

[gerald_clark]

Mack Richardson wrote:
I'm running MySQL 4.0.20 on Mac OS X 10.3.4.  I've added the my.cnf to the
etc directory,
Which one, and why?
Did you restart the server after changing my.cnf?
but mySQL server returns the following error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
What is the socket supposed to be now?
Is the server running?
Did you check the error logs?
Removing my.cnf does not solve the problem.
You have to stop and start the server to affect any changes.
 I have had to reinstall MySQL
to get it working again.
No you didn't.
Restarting the server would have sufficed.
Any help?
 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: my.cnf setup

[Dathan Vance Pattishall]

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 11, 2004 7:42 AM
> To: Dathan Vance Pattishall
> Subject: RE: my.cnf setup
> 
> Thanks for the feedback!
> 
> I have made the changes you suggested.  I do have a question about the
> slow query log though.  I added it to my my.cnf file as
> 
> =
> [mysqld]
> 
> port= 3306
> log-slow-queries = /usr/local/mysql/slowlog
> socket  = /tmp/mysql.sock
> skip-locking
> key_buffer = 384M
> max_allowed_packet = 1M
> table_cache = 512
> sort_buffer_size = 2M
> read_buffer_size = 2M
> read_rnd_buffer_size = 2M
> myisam_sort_buffer_size = 64M
> thread_cache = 8
> query_cache_size = 32M
> # Try number of CPU's*2 for thread_concurrency
> thread_concurrency = 4

Increase your tmp_table_size to 32M

Additionally ensure that your indexes on your tables are correct. If you
need some help with that send the query + table structure to the list.




> 
> =
> 
> Is this correct?  Will it just make the file called slowlog?  So far it
> hasnt done anything.  And i did restart the server fyi.
> 
> Anything you can clear up?
> 
> Conner
> >
> >
> >> -Original Message-
> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> >> Sent: Monday, May 10, 2004 2:23 PM
> >> To: [EMAIL PROTECTED]
> >> Subject: my.cnf setup
> >>
> >> I am running a mysql server off a Dell 2650.
> >> Dual 2.8Ghz Intel Xeon processors
> >> 1 Gig of RAM
> >>
> >> The MySQL data comes up rather slowly.  Would like some suggestions on
> >> my
> >> my.cnf file if you had a minute.
> >>
> >> here is what I have
> >> | Handler_read_first | 2|
> >> | Handler_read_key   | 9080 |
> >> | Handler_read_next  | 35   |
> >> | Handler_read_prev  | 1764 |
> >> | Handler_read_rnd   | 723  |
> >> | Handler_read_rnd_next  | 63575|
> >
> > You are not indexing your table right. The read random next is to high.
> > Turn
> > on the slow query log to find out what query is the problem.
> >
> >
> >
> >> | Handler_rollback   | |
> >> | Handler_update | |
> >> | Handler_write  | 154  |
> >> | Key_blocks_used| 51   |
> >> | Key_read_requests  | 13370|
> >> | Key_reads  | 41   |
> >> | Key_write_requests | 67   |
> >> | Key_writes | |
> >> | Max_used_connections   | 4|
> >> | Not_flushed_key_blocks | |
> >> | Not_flushed_delayed_rows   | |
> >> | Open_tables| 18   |
> >> | Open_files | 38   |
> >> | Open_streams   | |
> >> | Opened_tables  | 24   |
> >> | Questions  | 9971 |
> >> | Qcache_queries_in_cache| 173  |
> >> | Qcache_inserts | 173  |
> >> | Qcache_hits| 9665 |
> >> | Qcache_lowmem_prunes   | |
> >> | Qcache_not_cached  | 8|
> >> | Qcache_free_memory | 32908680 |
> >> | Qcache_free_blocks | 1|
> >> | Qcache_total_blocks| 365  |
> >> | Rpl_status | NULL |
> >> | Select_full_join   | 8|
> >> | Select_full_range_join | |
> >> | Select_range   | 66   |
> >> | Select_range_check | |
> >> | Select_scan| 84   |
> >> | Slave_open_temp_tables | |
> >> | Slave_running  | OFF  |
> >> | Slow_launch_threads| |
> >> | Slow_queries   | |
> >> | Sort_merge_passes  | |
> >> | Sort_range | |
> >> | Sort_rows  | 723  |
> >> | Sort_scan  | 16   |
> >> | Ssl_accepts| |
> >> | Ssl_finished_accepts   | |
> >> | Ssl_finished_connects  | |
> >> | Ssl_accept_renegotiates

Re: my.cnf setup

[Sasha Pachev]

[EMAIL PROTECTED] wrote:
I am running a mysql server off a Dell 2650.
Dual 2.8Ghz Intel Xeon processors
1 Gig of RAM
The MySQL data comes up rather slowly.  Would like some suggestions on my
my.cnf file if you had a minute.
Conner:

The problem is very unlikely your my.cnf, and very likely your application. 
You've done 184 selects and scanned 63575 rows. So your average select scans 345 
rows, and you do have some good ones (66 in Select_range, and probably not all 
84 of Select_scan are scanning large tables). It seems that you also have some 
really bad ones ( 8 in Select_full_join).

Enable log-slow-queries and log-long-format in my.cnf, then police the slow log 
fixing the queries/table schema as you go along. Start with the ones that 
examine most rows.

--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: my.cnf setup

[Dathan Vance Pattishall]

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 10, 2004 2:23 PM
> To: [EMAIL PROTECTED]
> Subject: my.cnf setup
> 
> I am running a mysql server off a Dell 2650.
> Dual 2.8Ghz Intel Xeon processors
> 1 Gig of RAM
> 
> The MySQL data comes up rather slowly.  Would like some suggestions on my
> my.cnf file if you had a minute.
> 
> here is what I have
> | Handler_read_first | 2|
> | Handler_read_key   | 9080 |
> | Handler_read_next  | 35   |
> | Handler_read_prev  | 1764 |
> | Handler_read_rnd   | 723  |
> | Handler_read_rnd_next  | 63575|

You are not indexing your table right. The read random next is to high. Turn
on the slow query log to find out what query is the problem.



> | Handler_rollback   | 0|
> | Handler_update | 0|
> | Handler_write  | 154  |
> | Key_blocks_used| 51   |
> | Key_read_requests  | 13370|
> | Key_reads  | 41   |
> | Key_write_requests | 67   |
> | Key_writes | 0|
> | Max_used_connections   | 4|
> | Not_flushed_key_blocks | 0|
> | Not_flushed_delayed_rows   | 0|
> | Open_tables| 18   |
> | Open_files | 38   |
> | Open_streams   | 0|
> | Opened_tables  | 24   |
> | Questions  | 9971 |
> | Qcache_queries_in_cache| 173  |
> | Qcache_inserts | 173  |
> | Qcache_hits| 9665 |
> | Qcache_lowmem_prunes   | 0|
> | Qcache_not_cached  | 8|
> | Qcache_free_memory | 32908680 |
> | Qcache_free_blocks | 1|
> | Qcache_total_blocks| 365  |
> | Rpl_status | NULL |
> | Select_full_join   | 8|
> | Select_full_range_join | 0|
> | Select_range   | 66   |
> | Select_range_check | 0|
> | Select_scan| 84   |
> | Slave_open_temp_tables | 0|
> | Slave_running  | OFF  |
> | Slow_launch_threads| 0|
> | Slow_queries   | 0|
> | Sort_merge_passes  | 0|
> | Sort_range | 0|
> | Sort_rows  | 723  |
> | Sort_scan  | 16   |
> | Ssl_accepts| 0|
> | Ssl_finished_accepts   | 0|
> | Ssl_finished_connects  | 0|
> | Ssl_accept_renegotiates| 0|
> | Ssl_connect_renegotiates   | 0|
> | Ssl_callback_cache_hits| 0|
> | Ssl_session_cache_hits | 0|
> | Ssl_session_cache_misses   | 0|
> | Ssl_session_cache_timeouts | 0|
> | Ssl_used_session_cache_entries | 0|
> | Ssl_client_connects| 0|
> | Ssl_session_cache_overflows| 0|
> | Ssl_session_cache_size | 0|
> | Ssl_session_cache_mode | NONE |
> | Ssl_sessions_reused| 0|
> | Ssl_ctx_verify_mode| 0|
> | Ssl_ctx_verify_depth   | 0|
> | Ssl_verify_mode| 0|
> | Ssl_verify_depth   | 0|
> | Ssl_version|  |
> | Ssl_cipher |  |
> | Ssl_cipher_list|  |
> | Ssl_default_timeout| 0|
> | Table_locks_immediate  | 239  |
> | Table_locks_waited | 0|
> | Threads_cached | 1|
> | Threads_created| 5|
> | Threads_connected  | 4|
> | Threads_running| 1|
> | Uptime | 1444 |
> ++--+
> 
> 
> my.cnf as follows:
> 
> 
> [client]
> password= password
> port= 3306
> socket  = /tmp/mysql.sock
> 
> # Here follows entries for some specific programs
> 
> [EMAIL PROTECTED] bin]# cat /etc/my.cnf
> 
> [client]
> password= guest
> port= 3306
> socket  = /tmp/mysql.sock
> 
> 
> 
> # The MySQL server
> [mysqld]
> port= 3306
> socket  = /tmp/mysql.sock
> skip-locking
> key_buffer = 384M
> max_allowed_packet = 1M


Raise higher if your replicating blobs.


> table_cache = 512
> sort_buffer_size = 8M
This is too high, you might run out of memory. This is a per thread
allocation. Set it to 2M.

> read_buffer_size = 2M

add read_rnd_buffer_size = 2M

since your indexes are bad.


> myisam_sort_buffer_size = 64M
> thread_cache = 8
> query_cache_size = 32M
> # Tr

Re: my.cnf Setup!!

[Michael Stassen]

Kirti S. Bajwa wrote:

Hello List:

I have setup MySQL and it is working fine. I tested connection to MySQL. 

Now I have gone one step futher and added a password for mysql, as follows:

shell> ./mysqladmin -u root password mysqlpw

Now I want to setup myc.cnf. Our SQL server is a standalone server (RH9,
Dual CPU, 1.5GB Memory, RAID1, etc.), so I copied the "my-large.cnf" to
"/etc/my.cnf". After looking into "my.cnf", I decided to leave it as it is
(no change). I do want to add the (1) name of the server and (2) password to
the my.cnf. Here I am struck for last couple of days.
For this, you want the .my.cnf file in your home directory.  See 
 for details.

Finally, here is my question; I want to execute the command:

  shell> mysql -h data -u mysql password=mysqlpw

Where (from above command), mysql server is "data" and password is
"mysqlpw". What lines do I need to enter in my.cnf for the above command to
work? I have tried everything I know! HELP!!
This should work without anything special in an option file, assuming that

* mysqld server is running on the machine named "data".

* your hostname lookup will properly resolve "data".

* user [EMAIL PROTECTED], where "client.machine" is the name of the 
computer on which you are running the mysql client, has permission to 
access the mysqld server on data.

If you could provide the exact error message you get when you try this, 
someone should be aable to diagnose the problem.

Finally, I should point out that putting the password on the command 
line is insecure.  It would be better to use

  shell> mysql -h data -u mysql -p

in which case you'll be prompted for the password.

KIrti
Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: my.cnf Setup!!

[Kirti S. Bajwa]

Hello List:

I have setup MySQL and it is working fine. I tested connection to MySQL. 

Now I have gone one step futher and added a password for mysql, as follows:

shell> ./mysqladmin -u root password mysqlpw

Now I want to setup myc.cnf. Our SQL server is a standalone server (RH9,
Dual CPU, 1.5GB Memory, RAID1, etc.), so I copied the "my-large.cnf" to
"/etc/my.cnf". After looking into "my.cnf", I decided to leave it as it is
(no change). I do want to add the (1) name of the server and (2) password to
the my.cnf. Here I am struck for last couple of days.

Finally, here is my question; I want to execute the command:

  shell> mysql -h data -u mysql password=mysqlpw

Where (from above command), mysql server is "data" and password is
"mysqlpw". What lines do I need to enter in my.cnf for the above command to
work? I have tried everything I know! HELP!!

KIrti

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf in MySQL-Server-4.0.17

[Ken Menzel]

Hi Ronan,
   Did you perhaps set MAXDSIZ is your kernel configuration above
"(2047UL*1024*1024)"  ?

Ken
- Original Message - 
From: "Ronan Lucio" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 3:06 PM
Subject: my.cnf in MySQL-Server-4.0.17


> Hi All,
>
> I´m trying to do some customization in a MySQL-Server-4.0.17
> to gain a better performance.
>
> We have a Intel P4-2.4 Ghz with 1 Gb RAM and 40 Gb HD
> on a FreeBSD-5.2.1 box dedicated for MySQL.
>
> My trouble is when I create the my.cnf file and start MySQL.
> MySQL don´t stat.
>
> the /usr/local/mysql/aguia.err file shows:
> -
> 040219 16:34:46  mysqld started
> mysqld in malloc(): error: allocation failed
> mysqld got signal 6;
> This could be because you hit a bug. It is also possible that this
binary
> or one of the libraries it was linked against is corrupt, improperly
built,
> or misconfigured. This error can also be caused by malfunctioning
hardware.
> We will try our best to scrape up some info that will hopefully help
> diagnose
> the problem, but since we have already crashed, something is
definitely
> wrong
> and this may fail.
>
> key_buffer_size=134217728
> read_buffer_size=1044480
> max_used_connections=0
> max_connections=100
> threads_connected=0
> It is possible that mysqld could use up to
> key_buffer_size + (read_buffer_size +
sort_buffer_size)*max_connections =
> 335471 K
> bytes of memory
> Hope that's ok; if not, decrease some variables in the equation.
>
> mysqld in free(): error: recursive call
> Fatal signal 6 while backtracing
> 040219 16:34:46  mysqld ended
> -
>
> My my.cnf file is:
> -
> [client]
> port= 3306
> socket  = /tmp/mysql.sock
>
> [mysqld]
> port= 3306
> socket  = /tmp/mysql.sock
> skip-locking
> key_buffer = 128M
> max_allowed_packet = 1M
> table_cache = 512
> sort_buffer_size = 1M
> read_buffer_size = 1M
> myisam_sort_buffer_size = 64M
> thread_cache = 8
> query_cache_size = 32M
> thread_concurrency = 8
>
> log-bin
>
> server-id   = 1
>
> innodb_data_home_dir = /usr/local/mysql/
> innodb_data_file_path = ibdata1:1000M:autoextend
> innodb_log_group_home_dir = /usr/local/mysql/
> innodb_log_arch_dir = /usr/local/mysql/
> innodb_buffer_pool_size = 512M
> innodb_additional_mem_pool_size = 20M
> innodb_log_file_size = 128M
> innodb_log_buffer_size = 8M
> innodb_flush_log_at_trx_commit = 1
> innodb_lock_wait_timeout = 50
>
> [mysqldump]
> quick
> max_allowed_packet = 16M
>
> [mysql]
> no-auto-rehash
>
> [isamchk]
> key_buffer = 256M
> sort_buffer_size = 256M
> read_buffer = 2M
> write_buffer = 2M
>
> [myisamchk]
> key_buffer = 256M
> sort_buffer_size = 256M
> read_buffer = 2M
> write_buffer = 2M
>
> [mysqlhotcopy]
> interactive-timeout
> -
>
> Without the /etc/my.cnf file the MySQL works fine, except in
> some moments that it get slow.
>
> Does anyone knows what could be wrong?
> Any help would be Appreciated.
>
> Thank´s
> Ronan
>
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf on MySQL-Server-4.0.17

[Sasha Pachev]

Ronan Lucio wrote:
Hi All,

I´m trying to do some customization in a MySQL-Server-4.0.17
to gain a better performance.
We have a Intel P4-2.4 Ghz with 1 Gb RAM and 40 Gb HD
on a FreeBSD-5.2.1 box dedicated for MySQL.
The diagnostic error messages are a fairly strong indication that you could have 
bad RAM. If you can take the machine down for a day, run memtest86 on it. If 
not, try different memory modules or underclock your RAM in BIOS.

This could also be a bug in FreeBSD kernel or libc.

--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: My.cnf

[Joshua Thomas]

> -Original Message-
> From: Scott Haneda [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 02, 2004 6:13 PM
> To: MySql
> Subject: My.cnf
> 
> 
> I have copied my-large.cnf to /etc/my.conf
> Mysql 4 on OS X server
> 
> How can I tell these new settings are in effect?
> What settings were run prior to this file being in place as 
> there was no
> my.cnf?
> 
-- 
1) Run 'SHOW VARIABLES'
2) Restart your mySQL server.
3) Run 'SHOW VARIABLES' again to see the changes.

4) Read The Fine Manual: http://www.mysql.com/doc/en/index.html

Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED] 

---
Ninety percent of this game is half mental. 
- Yogi Berra 
---




> -
> Scott HanedaTel: 415.898.2602
> http://www.newgeo.com   Fax: 313.557.5052
> [EMAIL PROTECTED]Novato, CA U.S.A.
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf on Shared Hosting

[Egor Egorov]

"Hassan Shaikh" <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I want "--ansi" option for MySQL setting to ensure ANSI compatibility. Most shared 
> hosting providers don't allow access to my.cnf. Is there anyway to do this on the 
> fly in my script, PHP/Perl sample would be appreciated.

You can do it only from version 4.1 with SET statement:
http://www.mysql.com/doc/en/ANSI_mode.html
http://www.mysql.com/doc/en/Server_SQL_mode.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




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf

[robert_rowe]

The "correct" entries for your my.cnf will vary depending on which features that you 
want to support. There is no standard contents. See the manual for the chapters on 
installation, configuration and optimization. Most distributions come with sample cnf 
files called: my-huge.cnf, my-large.cnf, my-medium.cnf and my-small.cnf. Where they 
will be located will vary depending on the distribution but they shouldn't be too hard 
to find.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf

[Mikhail Entaltsev]

Hi,

Look at /usr/local/mysql/support-files directory.
There are several examples of my.cnf files for different configurations
there (my-huge.cnf, my-large.cnf, ...).

Best regards,
Mikhail.


- Original Message - 
From: "Kirti S. Bajwa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 02, 2004 8:52 PM
Subject: my.cnf


> Hello:
>
> I am installing MySQL 5.0.0 (on a fresh install RH9). I am following
binary
> installation as outlined in official MySQL documentation with default
> location /usr/local. I sure appreciate if somebody on this list is kind
> enough to email or list contents of "my.cnf" file.
>
> Thanks.
>
> Kirti
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: My.cnf

[Paul DuBois]

At 16:33 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I wanna deploy two different Mysql versions 3.23 and 4.0



As far as I understand this is not possible am I correct??
No, it's perfectly possible.  I have dozens of versions installed
on my main machine.  See the manual here:
http://www.mysql.com/doc/en/Multiple_servers.html


Since both version have different needs in case of my.cnf
The easiest way to provide server-specific options is to compile
each version yourself, each with a different compiled-in data directory
location.  Then put a my.cnf file in the data directory and only the
corresponding server will read it.
You can also arrange to start each server with --defaults-file, and
specify a different file for each server.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: My.cnf

[Dan Greene]

don't forget to change the port number that the server is listening on if you plan on 
running them simultaneously



> -Original Message-
> From: Peter Sap [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 24, 2003 4:59 PM
> To: [EMAIL PROTECTED]
> Subject: Re: My.cnf
> 
> 
> You could install version 3.23 under a different username 
> (like mysql323)
> than the 4.0 version (like username mysql40).
> Then put each .my.cnf in the ~ directory.
> 
> Regards,
> 
> Peter Sap
> 
> - Original Message -
> From: "Arnoldus Th.J. Koeleman" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, November 24, 2003 10:33 PM
> Subject: My.cnf
> 
> 
> > I wanna deploy two different Mysql versions 3.23 and 4.0
> >
> >
> >
> > As far as I understand this is not possible am I correct??
> >
> > Since both version have different needs in case of my.cnf
> >
> >
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: My.cnf

[gerald_clark]

Not correct.
The manual explains how.
Use separate data directories, and put the my.cnf files in the data 
directories.

Arnoldus Th.J. Koeleman wrote:

I wanna deploy two different Mysql versions 3.23 and 4.0



As far as I understand this is not possible am I correct??

Since both version have different needs in case of my.cnf

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: My.cnf

[Peter Sap]

You could install version 3.23 under a different username (like mysql323)
than the 4.0 version (like username mysql40).
Then put each .my.cnf in the ~ directory.

Regards,

Peter Sap

- Original Message -
From: "Arnoldus Th.J. Koeleman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 24, 2003 10:33 PM
Subject: My.cnf


> I wanna deploy two different Mysql versions 3.23 and 4.0
>
>
>
> As far as I understand this is not possible am I correct??
>
> Since both version have different needs in case of my.cnf
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: My.cnf

[Peter Sap]

When you do a mysqld -? it will say:

Default options are read from the following files in the given order:
/etc/my.cnf /var/lib/mysql/my.cnf~/.my.cnf 

So that's the reason you can not start it anymore. (I'm using 4.1.0-alpha.)

Hope this helps.

Peter Sap.

- Original Message - 
From: "Arnoldus Th.J. Koeleman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 24, 2003 8:17 PM
Subject: My.cnf


> I like to install the my.cnf in another directory and not the default
> /etc/my.cnf
> 
>  
> 
> When I move this file to another directory it can't start anymore.
> 
>  
> 
> Is there a way to install my.cnf in a different location and which file
> need to be updated to look into the new
> 
> Location for the my.cnf file
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: My.cnf

[John Nichel]

Paul DuBois wrote:

At 14:37 -0600 11/24/03, John Nichel wrote:

Paul DuBois wrote:

Paul DuBois wrote:

At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:

I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.

Is there a way to install my.cnf in a different location and which 
file
need to be updated to look into the new




No official way. You can make a symbolic link at /etc/my.cnf that 
points
to your new location.


I don't even have a my.cnf on any of my *nix boxes, and MySQL runs 
fine.  Does this only come into play with precompiled binaries?


No.

Option files are, er, optional.


Why would the OP not be able to start MySQL when moving the config 
file then?


I suppose he changed some other aspect of his installation that requires
options to be specified, e.g., if you change the location of the data 
directory.

This makes the *option* required, though it could be specified on the 
command
line *or* in an option file.
Ah, okay.  Thanks for the info.

--
By-Tor.com
It's all about the Rush
http://www.by-tor.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: My.cnf

[Paul DuBois]

At 14:37 -0600 11/24/03, John Nichel wrote:
Paul DuBois wrote:

Paul DuBois wrote:

At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:

I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.

Is there a way to install my.cnf in a different location and which file
need to be updated to look into the new


No official way. You can make a symbolic link at /etc/my.cnf that points
to your new location.


I don't even have a my.cnf on any of my *nix boxes, and MySQL runs 
fine.  Does this only come into play with precompiled binaries?


No.

Option files are, er, optional.
Why would the OP not be able to start MySQL when moving the config file then?
I suppose he changed some other aspect of his installation that requires
options to be specified, e.g., if you change the location of the data 
directory.

This makes the *option* required, though it could be specified on the command
line *or* in an option file.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: My.cnf

[John Nichel]

Paul DuBois wrote:

Paul DuBois wrote:

At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:

I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.

Is there a way to install my.cnf in a different location and which file
need to be updated to look into the new


No official way. You can make a symbolic link at /etc/my.cnf that points
to your new location.


I don't even have a my.cnf on any of my *nix boxes, and MySQL runs 
fine.  Does this only come into play with precompiled binaries?


No.

Option files are, er, optional.
Why would the OP not be able to start MySQL when moving the config file 
then?


Not trying to be a smartassjust want to know in case I run into the 
same problem sometime in the future.


--
By-Tor.com
It's all about the Rush
http://www.by-tor.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: My.cnf

[Paul DuBois]

Paul DuBois wrote:
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:

I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.

Is there a way to install my.cnf in a different location and which file
need to be updated to look into the new


No official way. You can make a symbolic link at /etc/my.cnf that points
to your new location.
I don't even have a my.cnf on any of my *nix boxes, and MySQL runs 
fine.  Does this only come into play with precompiled binaries?
No.

Option files are, er, optional.

--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: My.cnf

[John Nichel]

Paul DuBois wrote:
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:

I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.

Is there a way to install my.cnf in a different location and which file
need to be updated to look into the new


No official way. You can make a symbolic link at /etc/my.cnf that points
to your new location.
I don't even have a my.cnf on any of my *nix boxes, and MySQL runs fine. 
 Does this only come into play with precompiled binaries?

--
By-Tor.com
It's all about the Rush
http://www.by-tor.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: My.cnf

[Paul DuBois]

At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I like to install the my.cnf in another directory and not the default
/etc/my.cnf


When I move this file to another directory it can't start anymore.



Is there a way to install my.cnf in a different location and which file
need to be updated to look into the new
No official way. You can make a symbolic link at /etc/my.cnf that points
to your new location.
Location for the my.cnf file


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf and binary distributions

[Paul DuBois]

At 11:30 AM -0700 9/19/03, Jon Drukman wrote:
At 11:13 AM 9/19/2003, Paul DuBois wrote:
At 10:42 AM -0700 9/19/03, Jon Drukman wrote:
is there any way to get mysqld 4.0.15a from the linux binary 
distribution to use another path for my.cnf apart from /etc/my.cnf 
/usr/local/mysql/data/my.cnf ~/.my.cnf
No, but if you have control over how the server gets started, you can
invoke it with a --defaults-file option to tell it to ignore the standard
option files and specify a file of your own choosing.
thank you very much.  that's exactly what i've been looking for!  i 
tried grepping for "config file" and "my.cnf" all over the place. 
you might want to somehow indicate that in the help message. 
there's no indication that defaults file = my.cnf anywhere.
mysqld --help


-jsd-


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf and binary distributions

[Jon Drukman]

At 11:13 AM 9/19/2003, Paul DuBois wrote:
At 10:42 AM -0700 9/19/03, Jon Drukman wrote:
is there any way to get mysqld 4.0.15a from the linux binary distribution 
to use another path for my.cnf apart from /etc/my.cnf 
/usr/local/mysql/data/my.cnf ~/.my.cnf
No, but if you have control over how the server gets started, you can
invoke it with a --defaults-file option to tell it to ignore the standard
option files and specify a file of your own choosing.
thank you very much.  that's exactly what i've been looking for!  i tried 
grepping for "config file" and "my.cnf" all over the place.  you might want 
to somehow indicate that in the help message.  there's no indication that 
defaults file = my.cnf anywhere.

-jsd-

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf and binary distributions

[Paul DuBois]

At 10:42 AM -0700 9/19/03, Jon Drukman wrote:
is there any way to get mysqld 4.0.15a from the linux binary 
distribution to use another path for my.cnf apart from /etc/my.cnf 
/usr/local/mysql/data/my.cnf ~/.my.cnf
No, but if you have control over how the server gets started, you can
invoke it with a --defaults-file option to tell it to ignore the standard
option files and specify a file of your own choosing.
the problem is at my company i am not allowed to install things as 
root, so i can't put files in /etc or /usr/local/mysql/data.  the 
problem with the home directory option is the mysql user is a role 
account with no home directory.  also the server is usually started 
via sudo which doesn't necessarily set the home directory properly. 
i could write a shell script that sets $HOME and calls mysqld but 
then that's another thing to maintain.

the company likes to build their own rpm's of mysql but their track 
record hasn't been so good lately (the 4.0.14 rpm crashed and burned 
instantly.)  i've got an app which is suffering from random table 
corruption, which is supposedly fixed in 4.0.15a.  i'd like to stick 
with the official binaries (that seems like a really good idea to me 
in general anyway) but this my.cnf issue is kind of a drag.

suggestions?

-jsd-


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf memory specifications

[Jeremy Zawodny]

On Thu, Sep 11, 2003 at 11:30:20AM -0700, Mark Kaufer wrote:
> > By the way, Jeremy's original answer was more correct than mine, because
> > he noted where I did not that the sort buffer is a per-client resource
> > and is allocated once for each client -- or at least for each client that
> > issues queries requiringn sorting, such as those with ORDER BY clauses.
> 
> Thanks Paul and Jeremy for the replies.  That helped out a great deal and
> I very well may recompile the MySQL installs on my FreeBSD boxes using
> LinuxThreads.

You'll probably find (as we have) that LinuxThreads/MySQL on FreeBSD
easily outperforms FreeBSD's native threads.

> Now I'm wondering just how optimised (or non-optimised as the case may be)
> my configurations are.  Below are some settings specified in the my.cnf of
> a linux box with 2Gb of memory that I'd say roughly 75%-80% of its purpose
> in life is dedicated to MySQL:
> 
> set-variable= key_buffer=256M
> set-variable= max_allowed_packet=1M
> set-variable= table_cache=64
> set-variable= sort_buffer=2M
> set-variable= net_buffer_length=8K
> set-variable= myisam_sort_buffer_size=2M
> set-variable= max_connections=1000
> set-variable= thread_concurrency=10
> innodb_data_file_path = ibdata1:10M:autoextend
> set-variable= innodb_buffer_pool_size=40M
> set-variable= innodb_additional_mem_pool_size=40M
> set-variable= innodb_log_file_size=5M
> set-variabl   e = innodb_log_buffer_size=5M
> innodb_flush_log_at_trx_commit=1
> set-variable= innodb_lock_wait_timeout=50
> 
> Am I allocating too little memory to table_cache, sort_buffer_size, and
> innodb_buffer_pool_size given the 2Gb of memory?

That depends...

How much data do you have in InnoDB and MyISAM tables?  How many
tables do you have in each?

> So I can also adjust these settings on other boxes, is there a way to
> mathematically determine what percentage of totally memory to set these
> variables to?

Sort of, but it's not as scientific as you'd probably like.  Take,
for example, the InnoDB Buffer Pool.  That's the chunk of memory that
InnoDB reserves for caching data and indexes.  You'd generally want to
make it as big as you can without adversely affecting system
performance overall.  But if you only have 100MB of InnoDB data,
there's little point in a 1GB buffer pool.  Also, you find that even
if you have 100GB in InnoDB, the buffer pool never gets very utilized
because the actual working set of data is quite small.

For adjusting the table_cache, I tend to look at the SHOW STATUS
output to see how often MySQL is opening and closing tables.  If it's
happening a lot, then I'd think about increasing the value.  What's "a
lot"?  Well, that also depends.  On a low volume system 10,000 might
be "a lot" but on a really busy system that's been up for half a year,
maybe 100,000 is a lot.

There's no magic formula with this stuff.  It's more often a case of
making simple, careful changes and watching how they affect system
performance, queries per second, etc.

You might also look at an interactive tool that can give you a
slightly different view of what's going on.  I wrote mytop partly for
that purpose.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 164,286,296 queries (451/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: my.cnf memory specifications

[Misaochankun]

>From what I understand about InnoDB, you want to make that InnoDB buffer
pool as big as 60-80% of your allowable RAM. If you use only InnoDB,
then the other settings won't help you to give much ram. If you use no
InnoDB, then don't bother giving InnoDB buffer pool any real ram.

If it works correctly, the InnoDB buffer pool should take the big chunk
of ram and use that and therefore speed up your queries and such because
it goes to disk less.
I can't get my 4G machine to take any more than .5G of ram which is
really annoying me.

-Original Message-
From: Mark Kaufer [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 11, 2003 11:30 AM
To: [EMAIL PROTECTED]
Subject: Re: my.cnf memory specifications

> By the way, Jeremy's original answer was more correct than mine,
because
> he noted where I did not that the sort buffer is a per-client resource
> and is allocated once for each client -- or at least for each client
that
> issues queries requiringn sorting, such as those with ORDER BY
clauses.

Thanks Paul and Jeremy for the replies.  That helped out a great deal
and
I very well may recompile the MySQL installs on my FreeBSD boxes using
LinuxThreads.

Now I'm wondering just how optimised (or non-optimised as the case may
be)
my configurations are.  Below are some settings specified in the my.cnf
of
a linux box with 2Gb of memory that I'd say roughly 75%-80% of its
purpose
in life is dedicated to MySQL:

set-variable= key_buffer=256M
set-variable= max_allowed_packet=1M
set-variable= table_cache=64
set-variable= sort_buffer=2M
set-variable= net_buffer_length=8K
set-variable= myisam_sort_buffer_size=2M
set-variable= max_connections=1000
set-variable= thread_concurrency=10
innodb_data_file_path = ibdata1:10M:autoextend
set-variable= innodb_buffer_pool_size=40M
set-variable= innodb_additional_mem_pool_size=40M
set-variable= innodb_log_file_size=5M
set-variabl   e = innodb_log_buffer_size=5M
innodb_flush_log_at_trx_commit=1
set-variable= innodb_lock_wait_timeout=50

Am I allocating too little memory to table_cache, sort_buffer_size, and
innodb_buffer_pool_size given the 2Gb of memory?

So I can also adjust these settings on other boxes, is there a way to
mathematically determine what percentage of totally memory to set these
variables to?

Thanks again.

Cheers,

Mark

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf memory specifications

[Mark Kaufer]

> By the way, Jeremy's original answer was more correct than mine, because
> he noted where I did not that the sort buffer is a per-client resource
> and is allocated once for each client -- or at least for each client that
> issues queries requiringn sorting, such as those with ORDER BY clauses.

Thanks Paul and Jeremy for the replies.  That helped out a great deal and
I very well may recompile the MySQL installs on my FreeBSD boxes using
LinuxThreads.

Now I'm wondering just how optimised (or non-optimised as the case may be)
my configurations are.  Below are some settings specified in the my.cnf of
a linux box with 2Gb of memory that I'd say roughly 75%-80% of its purpose
in life is dedicated to MySQL:

set-variable= key_buffer=256M
set-variable= max_allowed_packet=1M
set-variable= table_cache=64
set-variable= sort_buffer=2M
set-variable= net_buffer_length=8K
set-variable= myisam_sort_buffer_size=2M
set-variable= max_connections=1000
set-variable= thread_concurrency=10
innodb_data_file_path = ibdata1:10M:autoextend
set-variable= innodb_buffer_pool_size=40M
set-variable= innodb_additional_mem_pool_size=40M
set-variable= innodb_log_file_size=5M
set-variabl   e = innodb_log_buffer_size=5M
innodb_flush_log_at_trx_commit=1
set-variable= innodb_lock_wait_timeout=50

Am I allocating too little memory to table_cache, sort_buffer_size, and
innodb_buffer_pool_size given the 2Gb of memory?

So I can also adjust these settings on other boxes, is there a way to
mathematically determine what percentage of totally memory to set these
variables to?

Thanks again.

Cheers,

Mark

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf memory specifications

[Paul DuBois]

At 10:17 AM -0700 9/11/03, Jeremy Zawodny wrote:
On Thu, Sep 11, 2003 at 12:06:23PM -0500, Paul DuBois wrote:
 Linux reports the threads of a process as processes.  You really only
 have one process, with 31 threads.  (Probably because a bunch of clients
 have connected.)  So your resources are shared among the threads of
 the server process.
Some versions of Linux act more like Solaris now.  When I tested MySQL
on RH9 using NPTL, I found that it reported a single process in
top/ps/etc.  That was a bit of a surprise...
A pleasant surprise!  Thanks.

By the way, Jeremy's original answer was more correct than mine, because
he noted where I did not that the sort buffer is a per-client resource
and is allocated once for each client -- or at least for each client that
issues queries requiringn sorting, such as those with ORDER BY clauses.

Jeremy
--
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 156,290,200 queries 
(450/sec. avg)


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf memory specifications

[Jeremy Zawodny]

On Thu, Sep 11, 2003 at 12:06:23PM -0500, Paul DuBois wrote:
> 
> Linux reports the threads of a process as processes.  You really only
> have one process, with 31 threads.  (Probably because a bunch of clients
> have connected.)  So your resources are shared among the threads of
> the server process.

Some versions of Linux act more like Solaris now.  When I tested MySQL
on RH9 using NPTL, I found that it reported a single process in
top/ps/etc.  That was a bit of a surprise...

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 156,290,200 queries (450/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf memory specifications

[Jeremy Zawodny]

On Thu, Sep 11, 2003 at 09:29:27AM -0700, Mark Kaufer wrote:
> I've looked and looked but really can't find an answer to this question.
> In my my.cnf file, these are some of the things that are specified in
> [mysqld]:
> 
> set-variable = key_buffer=256M
> set-variable = table_cache=64
> set-variable = sort_buffer=512K
> set-variable = max_connections=1000
> set-variable = thread_concurrency=10
> set-variable = innodb_buffer_pool_size=40M
> set-variable = innodb_additional_mem_pool_size=40M
> 
> On FreeBSD, I only have one process running which makes this information
> pretty straight forward.  On my linux boxes, there are many different
> processes running (on one box, there is 31).

No, it's the same on all boxes.  You have many threads.  The
difference is in how each OS presents them.  As an interesting
exercise, build your MySQL using LinuxThreads and notice the
difference.

> Does this mean that *each* of those 31 processes attempts to allocate the
> above amount of resources, or that the above resources are being shared
> between the 31 processes?

The sort buffer is per-connection, all the others you list are global
(shared) chunks of memory.

There's a section in the MySQL manual that describes how MySQL uses
memory.

  http://www.mysql.com/doc/en/Memory_use.html

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 156,095,869 queries (450/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf memory specifications

[Paul DuBois]

At 9:29 AM -0700 9/11/03, Mark Kaufer wrote:
I've looked and looked but really can't find an answer to this question.
In my my.cnf file, these are some of the things that are specified in
[mysqld]:
set-variable = key_buffer=256M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = max_connections=1000
set-variable = thread_concurrency=10
set-variable = innodb_buffer_pool_size=40M
set-variable = innodb_additional_mem_pool_size=40M
On FreeBSD, I only have one process running which makes this information
pretty straight forward.  On my linux boxes, there are many different
processes running (on one box, there is 31).
Does this mean that *each* of those 31 processes attempts to allocate the
above amount of resources, or that the above resources are being shared
between the 31 processes?
Linux reports the threads of a process as processes.  You really only
have one process, with 31 threads.  (Probably because a bunch of clients
have connected.)  So your resources are shared among the threads of
the server process.
If anyone could straighten me out here, I would truly appreciate it!

Cheers,

Mark


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: my.cnf is not available under windows 2000

[Andy Eastham]

Morten ,

The file used is my.cnf on unix and my.ini on windows.

You should only have one file.

Andy

> -Original Message-
> From: Morten Gulbrandsen [mailto:[EMAIL PROTECTED]
> Sent: 01 August 2003 14:23
> To: [EMAIL PROTECTED]
> Subject: my.cnf is not available under windows 2000
> 
> 
> Hi programmers,
> 
> according to the manual,
> 
> There are two option files with the same function: 
> `C:\my.cnf', and the `my.ini' file in the Windows directory.
> 
> Is it sufficient with only one of the files ?
> 
> I have only my.ini  
> 
> For which purpose is my.cnf , please?
> 
> Yours Sincerely
> 
> Morten Gulbrandsen
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf is not available under windows 2000

[Scott Pippin]

>>> "Morten Gulbrandsen" <[EMAIL PROTECTED]> 08/01/03 07:22AM >>>
Hi programmers,

>according to the manual,
>There are two option files with the same function: 
>`C:\my.cnf', and the `my.ini' file in the Windows directory.
>Is it sufficient with only one of the files ?
>I have only my.ini  
>For which purpose is my.cnf , please?
 
It is my understanding that it looks for either file.  As long as you have one file 
you should be ok.

Scott Pippin
[EMAIL PROTECTED] 

Re: my.cnf not existing - Thx :)

[Bernd Tannenbaum]

Thx for the answer, found it myself too:

Am Montag, 28. Juli 2003 14:22 schrieben Sie:
> Build the file and put it in your C:\>..  You are not given a my.cnf
> file if you build from source, if you had used the binary file, it came
> with about 4 of the files and you just pick one and modify it and then
> save it in your C drive

Ok, i work on Linux, so there is no C:\.
But i found a my-sample.cnf in the mysql-directory/share/.
Modified it and copied to /etc, works fine.

thx,

Bernd







-- 

One OS to rule them all, one OS to find them.
One OS to bring them all, and in the darkness bind them
In the land of Redmond, where the shadows lie.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf and passwords

[Nils Valentin]

No, no yu are welcome ;-)

Best regards

Nils Valentin
Tokyo/Japan


2003年 6月 24日 火曜日 02:29、あなたは書きました:
> Ahh thank you for the clarification.   It is most appreciated!
>
>
> Cheers,
>
> Chris
>
> -Original Message-
> From: Nils Valentin [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 20, 2003 5:42 PM
> To: Chris Hutchison; MySQL list
> Subject: Re: my.cnf and passwords
>
>
> Hi Chris,
>
> I believe you are looking in the wrong place. The my.cnf is used to set
> startup options for the mysql server or the mysql clients - refering to the
> client tools that come with the RDBMS.
>
> You want to look into /etc/php.ini
>
> or  the config.inc.php file from phpmyadmin.
>
> Best regards
>
> Nils Valentin
> Tokyo/Japan
>
> 2003年 6月 21日 土曜日 05:36、Chris Hutchison さんは書きました:
> > Hello all,
> >
> > I'm pretty new to MySQL, but have managed to create a database that is
> > accessed via PHP which then creates tables from the MySQL data.
> >
> > Currently, I am using the root user/password combo to grab the info
> > (which means the password is plaintext in the PHP).   I wanted to use the
> > my.cnf to define the password, but no matter where I put the file
> > (/etc/my.cnf, /var/lib/mysql/, /var/lib/mysql/[databasename], /root,
> > /home/mysql/.my.cnf) my query won't seem to hit the my.cnf file which has
> > the following in it: (note:  it doesn't have a username defined.)
> >
> > [client]
> > password=mypassword
> >
> > my database is called 'assets' and it's located in:
> > /var/lib/mysql/assets
> >
> > I have a mysql user defined:
> > mysql:x:100:101:MySQL server:/var/lib/mysql:/bin/bash
> >
> > The php stuff is located in a single directory:
> > /var/www/html/assets
> >
> > Yet when I try to access the page (which works when the password is
> > passed in the php), I get:
> >
> > Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in
> > /var/www/html/assets/fetch-new.php on line 6
> >
> > Warning: MySQL Connection Failed: Access denied for user:
> > '[EMAIL PROTECTED]' (Using password: NO) in
> > /var/www/html/assets/fetch-new.php on line 6
> >
> > fetch-new.php's line 6 (and 7) looks like this:
> >
> > $db = mysql_connect("localhost", "root");
> > mysql_select_db("assets",$db);
> >
> >
> > I've checked out the mysql.com's documentation, and I've tried putting
> > the my.cnf file in every place they reference, but it doesn't seem to
> > work via this PHP.   When I connect from the command line (on the Linux
> > box), it *does* work, so it seems that the /etc/my.cnf file is being
> > checked at that point, but isn't being checked in the php.
> >
> > Does anyone see/know a fix?   I'm out of ideas.
> >
> > Thanks in advance,
> >
> > Chris

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf and passwords

[Nils Valentin]

Hi Chris,

I believe you are looking in the wrong place. The my.cnf is used to set 
startup options for the mysql server or the mysql clients - refering to the 
client tools that come with the RDBMS.

You want to look into /etc/php.ini

or  the config.inc.php file from phpmyadmin.

Best regards

Nils Valentin
Tokyo/Japan


2003年 6月 21日 土曜日 05:36、Chris Hutchison さんは書きました:
> Hello all,
>
> I'm pretty new to MySQL, but have managed to create a database that is
> accessed via PHP which then creates tables from the MySQL data.
>
> Currently, I am using the root user/password combo to grab the info (which
> means the password is plaintext in the PHP).   I wanted to use the my.cnf
> to define the password, but no matter where I put the file (/etc/my.cnf,
> /var/lib/mysql/, /var/lib/mysql/[databasename], /root, /home/mysql/.my.cnf)
> my query won't seem to hit the my.cnf file which has the following in it:
> (note:  it doesn't have a username defined.)
>
> [client]
> password=mypassword
>
> my database is called 'assets' and it's located in:
> /var/lib/mysql/assets
>
> I have a mysql user defined:
> mysql:x:100:101:MySQL server:/var/lib/mysql:/bin/bash
>
> The php stuff is located in a single directory:
> /var/www/html/assets
>
> Yet when I try to access the page (which works when the password is passed
> in the php), I get:
>
> Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in
> /var/www/html/assets/fetch-new.php on line 6
>
> Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]'
> (Using password: NO) in /var/www/html/assets/fetch-new.php on line 6
>
> fetch-new.php's line 6 (and 7) looks like this:
>
> $db = mysql_connect("localhost", "root");
> mysql_select_db("assets",$db);
>
>
> I've checked out the mysql.com's documentation, and I've tried putting the
> my.cnf file in every place they reference, but it doesn't seem to work via
> this PHP.   When I connect from the command line (on the Linux box), it
> *does* work, so it seems that the /etc/my.cnf file is being checked at that
> point, but isn't being checked in the php.
>
> Does anyone see/know a fix?   I'm out of ideas.
>
> Thanks in advance,
>
> Chris

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf

[Paul DuBois]

At 10:22 +0200 6/12/03, Jon Haugsand wrote:
* Paul DuBois
 You can relocate the data directory at server startup time with a --datadir
 option.
 But when looking for my.cnf files, the server will continue to look
 in the hardwired directory, if it exists.  That's what that sentence
 means.
 (The server still looks in /etc/my.cnf; that doesn't change even if you
 use --datadir.)
However, can't you start the mysqld daemon with
'--basedir=/mysuperdrive' and mount the separate disk drive on
/mysuperdrive.  Then all /var, /etc, /tmp files will be resolved
relative to /mysuperdrive?
Yes, but that does not affect where the server looks for option files.
In other words, what you say is true, but it is unrelated to what I
said above. :-)
(Haven't tried though.)

--
 Jon Haugsand, [EMAIL PROTECTED]
 http://www.norges-bank.no


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf

[Jon Haugsand]

* Paul DuBois
> You can relocate the data directory at server startup time with a --datadir
> option.
>
> But when looking for my.cnf files, the server will continue to look
> in the hardwired directory, if it exists.  That's what that sentence
> means.
>
> (The server still looks in /etc/my.cnf; that doesn't change even if you
> use --datadir.)

However, can't you start the mysqld daemon with
'--basedir=/mysuperdrive' and mount the separate disk drive on
/mysuperdrive.  Then all /var, /etc, /tmp files will be resolved
relative to /mysuperdrive?

(Haven't tried though.)

-- 
 Jon Haugsand, [EMAIL PROTECTED]
 http://www.norges-bank.no


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf

[Paul DuBois]

At 10:34 -0500 6/11/03, Chris McKeever wrote:
I have been plowing through the mysql.com resources for something regarding
the run-time
configuration options as well as the my.cnf.  In particular, I am trying to
move the entire information store to a separate hard-drive.
This line confuses me:

---> Note that this is the directory that was specified at configuration
time, not the one specified with --datadir when mysqld starts up!
The directory that is specified at configuration time is the one that
is hardwired into the server binary.
You can relocate the data directory at server startup time with a --datadir
option.
But when looking for my.cnf files, the server will continue to look
in the hardwired directory, if it exists.  That's what that sentence
means.
(The server still looks in /etc/my.cnf; that doesn't change even if you
use --datadir.)
It is from:

http://www.mysql.com/doc/en/Option_files.html

DATADIR is the MySQL data directory (typically `/usr/local/mysql/data' for a
binary installation or `/usr/local/var' for a source installation). Note
that this is the directory that was specified at configuration time, not the
one specified with --datadir when mysqld starts up! (--datadir has no effect
on where the server looks for option files, because it looks for them before
it processes any command-line arguments.)
If anyone can explain that line, possibly point me to a good reference to
the my.cnf and runtime options, I would be most appreciative.
Thanks


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: my.cnf

[Victor Pendleton]

Are you wanting to physically relocate the myd, myi and frm files to a new
location? If so specify datadir in the cnf file or --datadir on the command
line for mysqld.

-Original Message-
From: Chris McKeever [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 10:35 AM
To: [EMAIL PROTECTED]
Subject: my.cnf


I have been plowing through the mysql.com resources for something regarding
the run-time
configuration options as well as the my.cnf.  In particular, I am trying to
move the entire information store to a separate hard-drive.

This line confuses me:

---> Note that this is the directory that was specified at configuration
time, not the one specified with --datadir when mysqld starts up! 

It is from:

http://www.mysql.com/doc/en/Option_files.html

DATADIR is the MySQL data directory (typically `/usr/local/mysql/data' for a
binary installation or `/usr/local/var' for a source installation). Note
that this is the directory that was specified at configuration time, not the
one specified with --datadir when mysqld starts up! (--datadir has no effect
on where the server looks for option files, because it looks for them before
it processes any command-line arguments.)

If anyone can explain that line, possibly point me to a good reference to
the my.cnf and runtime options, I would be most appreciative.

Thanks

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my.cnf optimized for InnoDB

[Dyego Souza do Carmo]

Dobrý den,
quinta-feira, 21 de novembro de 2002, 09:58:47, napsal jste:

IS> Hi all.

IS> The example mysql configuration files included in support-files directory of
IS> MySQL distribution are optimized for MyISAM table type.

IS> I want to tunnig the server optimized for InnoDB because I won't use MyISAM
IS> table type except for mysql database and *.frm files.

IS> I want to know which variables from my.cnf are only related for MyISAM table
IS> type (and not for InnoDB) and which are the minimal values for these
IS> variables.

IS> I'm using MySQL 3.23.53a-max in a dual Pentimum III 1000GHz Linux box with
IS> 1GB of memory.

IS> Thanks in advance.

IS> Iago Sineiro.

no exists a "magic" formula for the optimize the InnoDB on MySQL ,
only see the manual and change the lines :


innodb_data_home_dir = /usr/local/mysql4/var/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql4/var/
innodb_log_arch_dir = /usr/local/mysql4/var/

-
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
-
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=5M
-
# Set .._log_file_size to 25 % of buffer pool size
-
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M

innodb_flush_log_at_trx_commit=2
set-variable = innodb_lock_wait_timeout=50



bye,


-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
-
 E S C R I B A   I N F O R M A T I C A
-
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- 
$ look into "my eyes"
look: cannot open my eyes
-
   Reply: [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

re: RE: my.cnf settings and running admin commands such as mysqldump

[Victoria Reznichenko]

David,
Wednesday, October 23, 2002, 7:48:25 PM, you wrote:

DK> Is it a save assumption that I need to create a section for every admin
DK> command that I want to use?  i.e., create another section for mysqladmin and
DK> so on???  

Yes and no.
Common options like user, password you can put in the [client] section of my.cnf

Specific option, like all-databases for mysqldump, you can put into
[client] section and it will work for mysqldump, but it's "unrecognized option" for 
other
clients. So, you will get errors ...

DK> -Original Message-
DK> From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net]
DK> Sent: Wednesday, October 23, 2002 5:28 AM
DK> To: [EMAIL PROTECTED]
DK> Subject: re: my.cnf settings and running admin commands such as
DK> mysqldump or m


DK> David,
DK> Wednesday, October 23, 2002, 12:23:36 AM, you wrote:

DK>> I was wondering if someone could shed some light on setting parameters
DK> in
DK>> my.cnf.  When I set params such as user and password in my my.cnf file I
DK>> dont need to then pass these parameters to commands such as mysqldump or
DK>> mysqladmin?  Is this True?  Can someone please send me an example of
DK> their
DK>> my.cnf file, Im just curious what a real example would look like.  I
DK> have
DK>> already read through the my.cnf documentation on the website, but if
DK> someone
DK>> has a better place for online doc on the config file please let me know.
DK>> Any other insight is more than welcome and appreciated.

DK> For mysqldump you create a section [mysqldump] in the my.cnf where you
DK> can specify mysqldump options like

DK> [mysqld]
DK> .

DK> [mysqldump]
DK> user=Victoria
DK> password=mypassword
DK> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [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

RE: my.cnf settings and running admin commands such as mysqldump or m

[David Kramer]

Is it a save assumption that I need to create a section for every admin
command that I want to use?  i.e., create another section for mysqladmin and
so on???  

Thx,

dK

-Original Message-
From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net]
Sent: Wednesday, October 23, 2002 5:28 AM
To: [EMAIL PROTECTED]
Subject: re: my.cnf settings and running admin commands such as
mysqldump or m


David,
Wednesday, October 23, 2002, 12:23:36 AM, you wrote:

DK> I was wondering if someone could shed some light on setting parameters
in
DK> my.cnf.  When I set params such as user and password in my my.cnf file I
DK> dont need to then pass these parameters to commands such as mysqldump or
DK> mysqladmin?  Is this True?  Can someone please send me an example of
their
DK> my.cnf file, Im just curious what a real example would look like.  I
have
DK> already read through the my.cnf documentation on the website, but if
someone
DK> has a better place for online doc on the config file please let me know.
DK> Any other insight is more than welcome and appreciated.

For mysqldump you create a section [mysqldump] in the my.cnf where you
can specify mysqldump options like

[mysqld]
.

[mysqldump]
user=Victoria
password=mypassword



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [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

-
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 settings and running admin commands such as mysqldump or m

[Victoria Reznichenko]

David,
Wednesday, October 23, 2002, 12:23:36 AM, you wrote:

DK> I was wondering if someone could shed some light on setting parameters in
DK> my.cnf.  When I set params such as user and password in my my.cnf file I
DK> dont need to then pass these parameters to commands such as mysqldump or
DK> mysqladmin?  Is this True?  Can someone please send me an example of their
DK> my.cnf file, Im just curious what a real example would look like.  I have
DK> already read through the my.cnf documentation on the website, but if someone
DK> has a better place for online doc on the config file please let me know.
DK> Any other insight is more than welcome and appreciated.

For mysqldump you create a section [mysqldump] in the my.cnf where you
can specify mysqldump options like

[mysqld]
.

[mysqldump]
user=Victoria
password=mypassword



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [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

Re: My.cnf problem when upgrade from 4.01 to 4.02

[Heikki Tuuri]

Michael,

thank you for noticing this. I tested the mysqld binary which is in the
4.0.2 rpm distribution, and it did not recognize InnoDB startup options.
Obviously the MySQL AB build master has made an error in the building of the
4.0.2 rpm distribution.


heikki@hundin:~/usr/sbin> ls -l
total 4845
-rwxr-xr-x1 heikki   users 4952476 Jul 14 02:57 mysqld
heikki@hundin:~/usr/sbin> mysqld
mysqld: ERROR: unknown variable 'innodb_data_home_dir=/home/heikki'


Good that you noticed a workaround. The MySQL-Max-4.0.2 rpm distribution
contains also InnoDB.

The .tar.gz binary distribution of MySQL-4.0.2 also works right. It
recognizes InnoDB startup options.

I am forwarding this email to the build master of the 4.0.2 release. He will
build a new fixed MySQL-4.0.2 rpm.

Best regards,

Heikki Tuuri
Innobase Oy

- Original Message -
From: "Michael Ivanyo" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, July 14, 2002 1:26 AM
Subject: Re: My.cnf problem when upgrade from 4.01 to 4.02


> Heikki,
>
> I actually upgraded from Max-3.23.51 to the 4.0.2
> server.  The only way I could get it to start was to
> comment out all of the innodb variables in the my.cnf
> file.  After it started I noticed that InnoDB was
> disabled when I typed:
> show variables like "have_%".
>
> The contents of the my.cnf file:
> [mysqld]
> innodb_data_home_dir = /
> innodb_data_file_path = ibdata/ibdata1:500M
>
> set-variable = innodb_buffer_pool_size=32M
> set-variable = innodb_additional_mem_pool_size=20M
> innodb_log_group_home_dir = /var/lib/mysql
>
> innodb_log_arch_dir = /var/lib/mysql
> innodb_log_archive=0
> set-variable = innodb_log_files_in_group=3
> set-variable = innodb_log_file_size=16M
> set-variable = innodb_log_buffer_size=2M
>
> innodb_flush_log_at_trx_commit=1
>
> set-variable = max_connections=20
> set-variable = innodb_file_io_threads=4
> set-variable = innodb_lock_wait_timeout=50
> set-variable = record_buffer=1M
> set-variable = sort_buffer=1M
>
> default-table-type=InnoDB
>
> # Do not load support for Berkley DB tables
> skip-bdb
>
> Regards,
> Michael
>
>
> --- Heikki Tuuri <[EMAIL PROTECTED]> wrote:
> > Michael,
> >
> > what is your my.cnf like? Which my.cnf options did
> > not work in the plain
> > 4.0.2 rpm?
> >
> > The difference between 4.0 and Max-4.0 is that Max
> > supports also BDB tables.
> >
> > Regards,
> >
> > Heikki
> >
> > - Original Message -
> > From: "Michael Ivanyo" <[EMAIL PROTECTED]>
> > Newsgroups: mailing.database.mysql
> > Sent: Saturday, July 13, 2002 7:23 AM
> > Subject: Re: My.cnf problem when upgrade from 4.01
> > to 4.02
> >
> >
> > > Hello,
> > >
> > > I've experienced what seems to be the same problem
> > on
> > > Redhat 7.2. I eventually realized that in addition
> > to
> > > the regular 4.0.2 server RPM, I had to also
> > install
> > > the  MySql-Max 4.0.2 server RPM.  After that,
> > > everything worked fine.
> > >
> > > I was under the impression that there would only
> > be
> > > one server that supported all table types
> > beginning
> > > with version 4.0, and that the Max server would no
> > > longer be needed.  That doesn't seem to be the
> > case.
> > >
> > > --Michael
> > >
> > > --- zlab1 <[EMAIL PROTECTED]> wrote:
> > > > Hi,
> > > > I'm a new user of mysql, I was upgrade from
> > > > mysql 4.01 to 4.02 in
> > > > mandrake 8.2.
> > > >
> > > > The following options in current running my.cnf
> > > > suddently not work:
> > > >
> > > > innodb_data_file_path = ibdata1:100M
> > > > innodb_data_home_dir = /data/mysql/
> > > > innodb_log_group_home_dir = /data/mysql/
> > > > innodb_log_arch_dir = /data/mysql/
> > > > innodb_flush_log_at_trx_commit = 1
> > > > innodb_log_archive = 0
> > > > set-variable = innodb_mirrored_log_groups=1
> > > > set-variable = innodb_log_files_in_group=3
> > > > set-variable = innodb_log_file_size=4M
> > > > set-variable = innodb_log_buffer_size=4M
> > > > set-variable = innodb_buffer_pool_size=64M
> > > > set-variable =
> > innodb_additional_mem_pool_size=4M
> > > > set-variable = innodb_file_io_threads=4
> > > > set-variable = innodb_lock_wait_timeout=50
> > > 

Re: My.cnf problem when upgrade from 4.01 to 4.02

[Michael Ivanyo]

Heikki,

I actually upgraded from Max-3.23.51 to the 4.0.2
server.  The only way I could get it to start was to
comment out all of the innodb variables in the my.cnf
file.  After it started I noticed that InnoDB was
disabled when I typed:
show variables like "have_%".

The contents of the my.cnf file:
[mysqld]
innodb_data_home_dir = /
innodb_data_file_path = ibdata/ibdata1:500M

set-variable = innodb_buffer_pool_size=32M
set-variable = innodb_additional_mem_pool_size=20M
innodb_log_group_home_dir = /var/lib/mysql

innodb_log_arch_dir = /var/lib/mysql
innodb_log_archive=0
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=16M
set-variable = innodb_log_buffer_size=2M

innodb_flush_log_at_trx_commit=1

set-variable = max_connections=20
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
set-variable = record_buffer=1M
set-variable = sort_buffer=1M

default-table-type=InnoDB

# Do not load support for Berkley DB tables
skip-bdb

Regards,
Michael


--- Heikki Tuuri <[EMAIL PROTECTED]> wrote:
> Michael,
> 
> what is your my.cnf like? Which my.cnf options did
> not work in the plain
> 4.0.2 rpm?
> 
> The difference between 4.0 and Max-4.0 is that Max
> supports also BDB tables.
> 
> Regards,
> 
> Heikki
> 
> - Original Message -
> From: "Michael Ivanyo" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Saturday, July 13, 2002 7:23 AM
> Subject: Re: My.cnf problem when upgrade from 4.01
> to 4.02
> 
> 
> > Hello,
> >
> > I've experienced what seems to be the same problem
> on
> > Redhat 7.2. I eventually realized that in addition
> to
> > the regular 4.0.2 server RPM, I had to also
> install
> > the  MySql-Max 4.0.2 server RPM.  After that,
> > everything worked fine.
> >
> > I was under the impression that there would only
> be
> > one server that supported all table types
> beginning
> > with version 4.0, and that the Max server would no
> > longer be needed.  That doesn't seem to be the
> case.
> >
> > --Michael
> >
> > --- zlab1 <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > > I'm a new user of mysql, I was upgrade from
> > > mysql 4.01 to 4.02 in
> > > mandrake 8.2.
> > >
> > > The following options in current running my.cnf
> > > suddently not work:
> > >
> > > innodb_data_file_path = ibdata1:100M
> > > innodb_data_home_dir = /data/mysql/
> > > innodb_log_group_home_dir = /data/mysql/
> > > innodb_log_arch_dir = /data/mysql/
> > > innodb_flush_log_at_trx_commit = 1
> > > innodb_log_archive = 0
> > > set-variable = innodb_mirrored_log_groups=1
> > > set-variable = innodb_log_files_in_group=3
> > > set-variable = innodb_log_file_size=4M
> > > set-variable = innodb_log_buffer_size=4M
> > > set-variable = innodb_buffer_pool_size=64M
> > > set-variable =
> innodb_additional_mem_pool_size=4M
> > > set-variable = innodb_file_io_threads=4
> > > set-variable = innodb_lock_wait_timeout=50
> > > set-variable = innodb_thread_concurrency=8
> > >
> > > I change the 1st:
> > > innodb_data_file_path = ibdata1:100M
> > > To
> > > innodb_data_file_path =
> > > /data/mysql/ibdata1:100M:autoextend
> > >
> > > I have to remark rest options in order to make
> it
> > > working and also
> > > "set-variable = " seen not needed?? The err log
> > > show:
> > >
> > > ERROR: unknown variable '..'
> > > whenever I keep any options
> > > other than the 1st line,
> > > All previous section section is working when
> remove
> > > 'set-variable = '.
> > >
> > > So the problem isolated to innodb options
> > > sections and seen no doc
> > > refer this change, would u kind enough to give
> me a
> > > hand.
> > >
> > > Most of the options is copy from example config
> file
> > > with minor
> > > changesIt is working in 4.0 4.01 and
> suddently
> > > not work now. Thanks.
> > >
> > > If possible,
> > > Please reply to [EMAIL PROTECTED]
> > >
> > >
> > >
> >
>
-
> > > Before posting, please check:
> > >http://www.mysql.com/manual.php   (the
> manual)
> > >http://lists.mysql.com/

Re: My.cnf problem when upgrade from 4.01 to 4.02

[Heikki Tuuri]

Michael,

what is your my.cnf like? Which my.cnf options did not work in the plain
4.0.2 rpm?

The difference between 4.0 and Max-4.0 is that Max supports also BDB tables.

Regards,

Heikki

- Original Message -
From: "Michael Ivanyo" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, July 13, 2002 7:23 AM
Subject: Re: My.cnf problem when upgrade from 4.01 to 4.02


> Hello,
>
> I've experienced what seems to be the same problem on
> Redhat 7.2. I eventually realized that in addition to
> the regular 4.0.2 server RPM, I had to also install
> the  MySql-Max 4.0.2 server RPM.  After that,
> everything worked fine.
>
> I was under the impression that there would only be
> one server that supported all table types beginning
> with version 4.0, and that the Max server would no
> longer be needed.  That doesn't seem to be the case.
>
> --Michael
>
> --- zlab1 <[EMAIL PROTECTED]> wrote:
> > Hi,
> > I'm a new user of mysql, I was upgrade from
> > mysql 4.01 to 4.02 in
> > mandrake 8.2.
> >
> > The following options in current running my.cnf
> > suddently not work:
> >
> > innodb_data_file_path = ibdata1:100M
> > innodb_data_home_dir = /data/mysql/
> > innodb_log_group_home_dir = /data/mysql/
> > innodb_log_arch_dir = /data/mysql/
> > innodb_flush_log_at_trx_commit = 1
> > innodb_log_archive = 0
> > set-variable = innodb_mirrored_log_groups=1
> > set-variable = innodb_log_files_in_group=3
> > set-variable = innodb_log_file_size=4M
> > set-variable = innodb_log_buffer_size=4M
> > set-variable = innodb_buffer_pool_size=64M
> > set-variable = innodb_additional_mem_pool_size=4M
> > set-variable = innodb_file_io_threads=4
> > set-variable = innodb_lock_wait_timeout=50
> > set-variable = innodb_thread_concurrency=8
> >
> > I change the 1st:
> > innodb_data_file_path = ibdata1:100M
> > To
> > innodb_data_file_path =
> > /data/mysql/ibdata1:100M:autoextend
> >
> > I have to remark rest options in order to make it
> > working and also
> > "set-variable = " seen not needed?? The err log
> > show:
> >
> > ERROR: unknown variable '..'
> > whenever I keep any options
> > other than the 1st line,
> > All previous section section is working when remove
> > 'set-variable = '.
> >
> > So the problem isolated to innodb options
> > sections and seen no doc
> > refer this change, would u kind enough to give me a
> > hand.
> >
> > Most of the options is copy from example config file
> > with minor
> > changesIt is working in 4.0 4.01 and suddently
> > not work now. Thanks.
> >
> > If possible,
> > Please reply to [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
> >
>
>
> __
> Do You Yahoo!?
> Yahoo! Autos - Get free new car price quotes
> http://autos.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

Re: My.cnf problem when upgrade from 4.01 to 4.02

[Michael Ivanyo]

Hello,

I've experienced what seems to be the same problem on
Redhat 7.2. I eventually realized that in addition to
the regular 4.0.2 server RPM, I had to also install
the  MySql-Max 4.0.2 server RPM.  After that,
everything worked fine.

I was under the impression that there would only be
one server that supported all table types beginning
with version 4.0, and that the Max server would no
longer be needed.  That doesn't seem to be the case.

--Michael

--- zlab1 <[EMAIL PROTECTED]> wrote:
> Hi,
> I'm a new user of mysql, I was upgrade from
> mysql 4.01 to 4.02 in
> mandrake 8.2.
> 
> The following options in current running my.cnf
> suddently not work:
> 
> innodb_data_file_path = ibdata1:100M
> innodb_data_home_dir  = /data/mysql/
> innodb_log_group_home_dir = /data/mysql/
> innodb_log_arch_dir   = /data/mysql/
> innodb_flush_log_at_trx_commit= 1
> innodb_log_archive= 0
> set-variable = innodb_mirrored_log_groups=1
> set-variable = innodb_log_files_in_group=3
> set-variable = innodb_log_file_size=4M
> set-variable = innodb_log_buffer_size=4M
> set-variable = innodb_buffer_pool_size=64M
> set-variable = innodb_additional_mem_pool_size=4M
> set-variable = innodb_file_io_threads=4
> set-variable = innodb_lock_wait_timeout=50
> set-variable = innodb_thread_concurrency=8
> 
> I change the 1st:
> innodb_data_file_path = ibdata1:100M
> To
> innodb_data_file_path =
> /data/mysql/ibdata1:100M:autoextend
> 
> I have to remark rest options in order to make it
> working and also
> "set-variable = " seen not needed?? The err log
> show: 
> 
> ERROR: unknown variable '..'
> whenever I keep any options
> other than the 1st line, 
> All previous section section is working when remove
> 'set-variable = '.
> 
> So the problem isolated to innodb options
> sections and seen no doc
> refer this change, would u kind enough to give me a
> hand.
> 
> Most of the options is copy from example config file
> with minor
> changesIt is working in 4.0 4.01 and suddently
> not work now. Thanks.
> 
> If possible,
> Please reply to [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
> 


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.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 necessity

[Dan Nelson]

In the last episode (May 31), [EMAIL PROTECTED] said:
> 
> I currently am a MySQL dba and am having issues from a security/linux
> administrator that doesn't want me to have access to the /etc/my.cnf. 
> What can't I do with local database .cnf files that I can only do with
> my.cnf?

There are no database-level .cnf files.   There is /etc/my.cnf,
DATADIR/my.cnf, and ~/my.cnf.  They are all parsed the same way.

-- 
Dan Nelson
[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

RE: my.cnf

[Luc Foisy]

You have to create it yourself.
The base mysql install comes with example .cnf files ( 3 I think )

-Original Message-
From: Amy Zediak [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 1:12 PM
To: [EMAIL PROTECTED]
Subject: my.cnf


According to the MySQL manual, the my.cnf option files are located in
/etc but mine are not there.  Any ideas?

-
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

[Harrison C. Fisk]

On UNIX and Linux machines, there are a few places that MySQL will look for
your my.cnf.
The are detailed at: http://www.mysql.com/doc/O/p/Option_files.html
However if none of these files exist, then MySQL will use the default values
assigned for all neccesary settings.  You can then just create the option
files using your preferred text editor and next time you restart mysqld it
will use those new values you specified.

Harrison

- Original Message -
From: "Amy Zediak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 21, 2002 1:12 PM
Subject: my.cnf


> According to the MySQL manual, the my.cnf option files are located in
> /etc but mine are not there.  Any ideas?
>
> -
> 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 question

[Victoria Reznichenko]

Taylor,
Monday, May 13, 2002, 5:04:20 PM, you wrote:

TL> I have created a .my.cnf file in my home directory.  When I start mysql as that 
user, it should read that file automatically correct?

Yeah, MySQL reads user-specific options from that file. If you
want to specify some global options in my.cnf you should put it in /etc dir.
Take a look at:
 http://www.mysql.com/doc/O/p/Option_files.html

TL> Thanks,
TL> Taylor




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [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

RE: .my.cnf question

[Gurhan Ozen]

Yes, but that file would only have user specific information such as your
password in addition to the gloabl variables read from the gloab options
file ...
If you want to have server specific global variables in your my.cnf file in
your directory, than you need to start mysqld with --defults-file option
pointing to the my.cnf file in your home dir...
See: http://www.mysql.com/doc/O/p/Option_files.html

Gurhan

-Original Message-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 10:04 AM
To: [EMAIL PROTECTED]
Subject: .my.cnf question


I have created a .my.cnf file in my home directory.  When I start mysql as
that user, it should read that file automatically correct?

Thanks,
Taylor

Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073

"Help Wanted.  Seeking Telepath..."
"You Know where to apply."


Please Note
The information in this E-mail message is legally privileged
and confidential information intended only for the use of the
individual(s) named above. If you, the reader of this message,
are not the intended recipient, you are hereby notified that
you should not further disseminate, distribute, or forward this
E-mail message. If you have received this E-mail in error,
please notify the sender. Thank you
*

-
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 and large packet size..

[David Bouw]

Hi Pete,

Thanks for the answer, I will search a bit better in the MySQL manual for
info about the .cnf files.. (Already did, but couldn't 123 found the
information you gave me.)

What I understand is that changing the packet size doesn't have a very
negative impact, sounds that it works as a protection against faulty query
strings..

Thanks for the tip, I am going to play a bit with the configuration file.
On the moment I don't have any cnf file, someone pointed me to the
directory it should be in, but I already did a 'locate my.cnf' on my unix
box, and there wasn't any file on the whole disc...

The values used now are in between the my-medium and my-small files.. Maybe
it wouldn't be bad to try the my-medium.
The memory on my machine allows it, and MySQL is used very intensively.
I do thought like to leave things that work well alone, but I will try and
see what happens..

Thanks for the help and info..

With kind regards,
David Bouw





> If your default settings are working fine I suggest you only include
> the "max_allowed_packet" variable in your my.cnf
>
> [mysqld]
> set-variable = max_allowed_packet=2M
>
>
>>>My question is what is the disadvantage when I change the
>>>max-packet-size
> (to a higher value)?<<
>
> From the manual
>
> a.. max_allowed_packet The maximum size of one packet. The message
> buffer is initialised to net_buffer_length bytes, but can grow up to
> max_allowed_packet bytes when needed. This value by default is small,
> to catch big (possibly wrong) packets. You must increase this value if
> you are using big BLOB columns. It should be as big as the biggest BLOB
> you want to use. The protocol limits for max_allowed_packet is 16M in
> MySQL 3.23 and 2G in MySQL 4.0.
>
>
>
> Pete Kelly
> TrafficG.com
>
>
>
>
>
> - Original Message -
> From: "David Bouw" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, May 09, 2002 9:55 AM
> Subject: My.cnf and large packet size..
>
>
>> Hi,
>>
>> I am not sure on the following question and hope someone can spare
>> some time to answer it: Due to the fact that I had problems storing a
> relatively
>> huge text string (> 1 Megabyte) with PHP I found out that (by
>> default???) MySQL has a packet size limitation which prevented me from
>> doing this..
>>
>> Searching through some mailling lists, I found out you can alter the
>> max packet size in my.cnf.
>>
>> Problem is that I don't have a my.cnf file, I did see that there are
>> some ready-to-use files for various kinds of 'machines'. I also looked
>> at these files. My question is what is the disadvantage when I change
>> the
> max-packet-
>> size (to a higher value)?
>>
>> Also, will there be a lot of changes when I copy a configuration file
>> to my.cnf. We use MySQL very intensively. (I now have 10 million
>> queries in 8 days!). The database runs on a pentium III - 700 with 128
>> Megabyte (if meminfo is right - I thought it was a 256 Megabyte
>> machine).
>>
>> I will probably use my-medium.cnf, Mysql (3.23.43) runs with Apache +
>> PHP on the same machine..
>>
>> Thanks for any help or pointers..
>>
>> With kind regards,
>> 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




-
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

[Mike]

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

[Les Neste]

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

[Les Neste]

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

[Jeremy Zawodny]

On Tue, Sep 11, 2001 at 03:17:47PM -0500, Weslee Bilodeau wrote:
> > > They average around 500 connections/second at any given time, two
> > > have a master/slave setup.
> >
> > Connections/sec or Queries/sec?  That's a lot of connections per
> > second?  Can you use persistent connections?  It would save a lot of
> > overhead.
> 
> Half and half, at the moment .. We had a problem that when we
> connected to multiple database servers from PHP using persistant
> connections, it would get confused. By confused I meant 1.) It would
> 'leak' MySQL connections.  Somehow it 'forgot' it had an open
> connection. 2.) It would pick the wrong server. Each server has
> specific information on it, in seperate database/tables. The
> persistant connection code would actually hand back the wrong
> database handle and the queries would fail. We had to disable
> persistant connections because of this.

Ouch.  I hadn't heard about those problems before.

It's probably worth testing again, 'cause it will give you a nice
boost--especially at that connection rate.

> Our current my.cnf file:
> 
> [mysqld]
> skip-locking
> set-variable= key_buffer=384M
> set-variable= max_allowed_packet=1M
> set-variable= table_cache=400
> set-variable= sort_buffer=10M
> set-variable= record_buffer=10M
> set-variable= thread_cache=8

You might increase the thread_cache quite a bit.  It'll bypass the
need to create/destroy threads all the time.  It may not give you a
big improvement, but it can't hurt.

> The reason I'm asking is because of the MySQL page on Linux-specific
> notes.  Which basically said you can have lots of threads, providing
> your key-cache is low.

Wonder what that really means... or at least what the rationale behind
it is.

Have you experimented much with they key_buffer?  Any noticeable
difference if you double it or cut it in half?

> I'm trying to get as many threads as I can , and get MySQL to be
> ram-happy for speed as well.

A good plan. ;-)

> > > Any changes for this many connections/ram that would be suggested?
> >
> > How are things looking in SHOW STATUS?  Any red flags that you've
> > noticed?  Any slow queries?
> 
> Slow queries are actually watched with a fine-tooth comb.  I catch
> anything slow, I first smack the programmer along side the head,
> then throw Paul's book at them. I attempt to optimize it where
> possible, or just drop thier table and force them to do it over
> again.

Hahhahahah...  Well, that's good to hear, I suppose.

> The queries themselves seem to be pretty well optimized, I just
> wanna make sure the config I've got can scale. :)

I know the feeling.

> I'm used to servers with a few hundered connections, with 512 MB of
> ram ..  Not what they want, which is a few thousand, with 2gb of
> ram.

Having not broken the 1,000 mark myself, I don't have a lot else here
to say.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 7 days, processed 146,377,980 queries (241/sec. avg)

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

[Weslee Bilodeau]

> > They average around 500 connections/second at any given time, two
> > have a master/slave setup.
>
> Connections/sec or Queries/sec?  That's a lot of connections per
> second?  Can you use persistent connections?  It would save a lot of
> overhead.

Half and half, at the moment .. We had a problem that when we connected to
multiple database servers from PHP using persistant connections, it would
get confused. By confused I meant 1.) It would 'leak' MySQL connections.
Somehow it 'forgot' it had an open connection. 2.) It would pick the wrong
server. Each server has specific information on it, in seperate
database/tables. The persistant connection code would actually hand back the
wrong database handle and the queries would fail. We had to disable
persistant connections because of this.

We last tested about 5 months ago, so the problem could very well be gone.
It was however a true pain in the rear to replicate.

Right now, persistant connections are "I really hope", but unsure.

> Care to share the config file?  With that much RAM, there are probably
> some things you can tweak to make optimal use of the 2GB RAM.  But if
> you've done a lot of that, I won't bother pointing them out
> (obviously).

Our current my.cnf file:

[mysqld]
skip-locking
set-variable= key_buffer=384M
set-variable= max_allowed_packet=1M
set-variable= table_cache=400
set-variable= sort_buffer=10M
set-variable= record_buffer=10M
set-variable= thread_cache=8
set-variable= thread_concurrency=4
set-variable= myisam_sort_buffer_size=64M
set-variable= max_connections=3072
set-variable= open_files_limit=6144
set-variable= long_query_time=4
tmpdir=/data/tmp
log-bin
user=mysql
binlog-do-db=blahblahblah
binlog-do-db=blahblahblahblah
server-id=1
log=/usr/local/var/mysqld.log
log-slow-queries=/usr/local/var/slow-queries.log
pid-file=/usr/local/var/mysqld.pid

[mysql]
no-auto-rehash

[isamchk]
set-variable= key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=2M
set-variable= write_buffer=2M

[myisamchk]
set-variable= key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=2M
set-variable= write_buffer=2M

[mysqlhotcopy]
interactive-timeout

[safe_mysqld]
err-log=/usr/local/var/mysqld.err


The reason I'm asking is because of the MySQL page on Linux-specific notes.
Which basically said you can have lots of threads, providing your key-cache
is low.

I'm trying to get as many threads as I can , and get MySQL to be ram-happy
for speed as well.

> > Any changes for this many connections/ram that would be suggested?
>
> How are things looking in SHOW STATUS?  Any red flags that you've
> noticed?  Any slow queries?

Slow queries are actually watched with a fine-tooth comb.
I catch anything slow, I first smack the programmer along side the head,
then throw Paul's book at them. I attempt to optimize it where possible, or
just drop thier table and force them to do it over again.

The queries themselves seem to be pretty well optimized, I just wanna make
sure the config I've got can scale. :)

I'm used to servers with a few hundered connections, with 512 MB of ram ..
Not what they want, which is a few thousand, with 2gb of ram.

> Jeremy

Thanks for any help,

Weslee



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

[Jeremy Zawodny]

On Mon, Sep 10, 2001 at 04:54:57PM -0500, Weslee Bilodeau wrote:
>
> Basic (maybe?) question on some optimal variables for MySQLd's my.cnf
> configuration ..
> 
> Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU
> P3 1ghz.

Nice. :-)

> They average around 500 connections/second at any given time, two
> have a master/slave setup.

Connections/sec or Queries/sec?  That's a lot of connections per
second?  Can you use persistent connections?  It would save a lot of
overhead.

> MySQL is prettty much the only thing running, nice'd at -20 on a
> Patched Linux 2.4.9 along w/patched glibc 2.2.4 (LinuxThreads
> patches).
> 
> Its run smoothly when I tested it w/~4000 connections and didn't
> skip a beat. The question basically goes with, I'm expecting to get
> around 1-2,000 connections/second on average on the systems, using a
> modified 'my-huge.cnf' from the distribution.

Care to share the config file?  With that much RAM, there are probably
some things you can tweak to make optimal use of the 2GB RAM.  But if
you've done a lot of that, I won't bother pointing them out
(obviously).

> On average each query joins w/about 4 tables on primary/unique
> indexes where possible.
> 
> Any changes for this many connections/ram that would be suggested?

How are things looking in SHOW STATUS?  Any red flags that you've
noticed?  Any slow queries?

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 4 days, processed 103,895,494 queries (249/sec. avg)

-
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

[Ken Menzel]

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

Re: my.cnf file

[Gene Gurevich]

 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