- 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:
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 <har...@eyequestion.nl>
Cc: MySql <mysql@lists.mysql.com>
Subject: Re: my.cnf authencication
- Original Message
Are you show about the non-outage operation with this command?
Best regards.
--
Wagner Bianchi
2010/12/31 Sharl.Jimh.Tsin amoiz.sh...@gmail.com
rpm -qpi mysql*.rpm | grep my.cnf
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
2010/12/30 Lydia Rowe
Please, forget my last note, I answered in a wrong thread!
Sorry.
Best regards.
--
Wagner Bianchi
2010/12/31 Wagner Bianchi wagnerbianch...@gmail.com
Are you show about the non-outage operation with this command?
Best regards.
--
Wagner Bianchi
2010/12/31 Sharl.Jimh.Tsin
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...
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,
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.
rpm -qpi mysql*.rpm | grep my.cnf
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
2010/12/30 Lydia Rowe ly...@lydiarowe.com:
find / -name my.cnf
--
Lydia
On Thu, 2010-12-30 at 11:09 -0200, Wagner Bianchi wrote:
I am seeing you're using an operate system based on
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?
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:
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
Ryan Schwartz wrote
mysql show variables like '%buffer%'\G
*** 1. row ***
*** 3. row ***
Variable_name: innodb_buffer_pool_size
Value: 8388608
*** 4. row
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
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
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
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
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
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 hostname.err
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
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
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
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
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,
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
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 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
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
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
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
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
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
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
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
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...
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
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
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
-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
-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
[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
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
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
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
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
-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
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
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,
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,
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
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
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
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
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
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
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
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,
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
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
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:
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
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
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
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
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 =
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.
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
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.
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
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
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
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
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
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
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
* 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
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
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
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:
---
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
[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
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
, 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
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
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
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
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
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
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
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
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
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
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
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
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'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
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
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
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
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
: 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
1 - 100 of 112 matches
Mail list logo