ump] 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 authen
- 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 the
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
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
>
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 dis
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.
>
>
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.
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-tabl
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/opt
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 archi
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 sa
Ryan Schwartz wrote
mysql> show variables like '%buffer%'\G
*** 1. row ***
*** 3. row ***
Variable_name: innodb_buffer_pool_size
Value: 8388608
*** 4. row *
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, s
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_aw
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: a
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
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 activ
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
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 gu
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: Puttin
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-r
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.c
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
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.
>
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? Su
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,
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 a
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
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
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
ser
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
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=user
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 a
:
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 n
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 m
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...
>
>
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/
> -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 ques
[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 app
> -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 r
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 ser
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
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
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
> -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
"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 on
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,
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: Fri
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.m
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.c
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 hav
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: Mond
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
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 sta
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
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 loca
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
n
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
n
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 update
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.
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 s
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
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
> > issu
fer [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
>
> 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.
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 sha
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 proce
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-varia
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-vari
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
>
>
>>> "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
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 an
ED]
> 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 t
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
Ni
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 se
* 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; t
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:
--->
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 PROTE
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 us
gt; 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, y
, 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 us
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> my
chael 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
&
>
> 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, J
g.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
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 ser
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
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 fi
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 t
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
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
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 prot
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
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
--
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-av
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 wo
> > 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 pro
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
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 fi
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
1 - 100 of 113 matches
Mail list logo
