- Original Message -
> From: "Harrie Robins" <har...@eyequestion.nl>
> 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
defau
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
I'm running a mysqldump in windows and I'm mailing 2>> output, right now I get
this annoying 'insecure' error that pollutes my log. So I figured I use
--defaults-file and set:
In c:\sql\dump.cnf
[mysqldump]
user = myuser
password = pass
my line looks like this
mysqldump --defaults-file
$ cat /etc/my.cnf
[mysqld]
datadir=/opt/pprd/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
max_allowed_packet=10M
query_cache_size = 8388608
table_open_cache=256
tmp_table_size=67108864
log_bin = /opt/pprd/log/mysql-bin.log
log_bin_index = /opt/pprd/log/mysql-bin.index
Hi Lukas,
What is your default engine? In MySQL there are a lot of parameters that
configure the engine behaviour. Depends on the engine, I suggest you to add
some parameters or others.
Also it's important to know the size of your data. Your configuration is
minimal and by default is not
Is it a standalone DB server or Application is also hosted on top of it.
You can give 50-70% of RAM to memory parameters like
Innodb_buffer_pool_size ( Innodb ) and key_cache ( Myisam ) for mysql
tables.
Below link : http://mysql.rjweb.org/doc.php/memory will give you a brief
idea.
Thanks
Hi Antonio
all tables use InnoDB. The size is 27 GB (not yet in prod). I guess in prod
it will be fast 80GB.
thanks
On Wed, Feb 12, 2014 at 10:28 AM, Antonio Fernández Pérez
antoniofernan...@fabergames.com wrote:
Hi Lukas,
What is your default engine? In MySQL there are a lot of
Hi
it's also a Tomcat application server. Not dedicated MySQL instance.
On Wed, Feb 12, 2014 at 11:28 AM, Adarsh Sharma eddy.ada...@gmail.comwrote:
Is it a standalone DB server or Application is also hosted on top of it.
You can give 50-70% of RAM to memory parameters like
Hi Lukas,
In that case, such as Adarsh has said, you can configure until 70% of your
RAM for innodb_buffer_pool_size.
In your case, with 3GB RAM, I suggest you to configure until 2GB for MySQL:
Minimal for MyISAM (Maybe 32MB), and the rest for InnoDB. Your problem will
be loading data. Maybe your
2014-02-12 12:32 GMT+01:00 Lukas Lehner webleh...@gmail.com:
Hi Antonio
all tables use InnoDB. The size is 27 GB (not yet in prod). I guess in prod
it will be fast 80GB.
Depending on how your application is going to use MySQL resources you will
need to tweak some things (and not only
@lists.mysql.com
Subject: Innodb, MySQL 5.5.28 - Would an incorrect setting in my.cnf
cause mysqld to randomly crash on high load?
We have a high-end server, 128GB RAM, 32 Core , Xeon, SSD RAID 10 -
running Ubuntu 12.04 with MySQL 5.5.28 . Doing random imports to large
InnoDB tables, over 50+ gigs, randomly
-
From: Tom [mailto:livefortheda...@gmail.com]
Sent: Wednesday, November 21, 2012 5:17 PM
To: mysql@lists.mysql.com
Subject: Innodb, MySQL 5.5.28 - Would an incorrect setting in my.cnf
cause mysqld to randomly crash on high load?
We have a high-end server, 128GB RAM, 32 Core , Xeon, SSD
i am getting this wierd error in the mysql log:
120604 8:31:32 [Warning] option 'table_cache': unsigned value
536870912 adjusted to 524288
I have 28G of ram in my server, can anyone tell me what this value
should be set to ?
what is the syntax - i have tried different syntax -- get the same
Am 04.06.2012 14:39, schrieb Joey L:
i am getting this wierd error in the mysql log:
120604 8:31:32 [Warning] option 'table_cache': unsigned value
536870912 adjusted to 524288
I have 28G of ram in my server, can anyone tell me what this value
should be set to ?
what is the syntax - i
Can you explain this further ?
Sorry a little slow ?
table count * expected connections
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Am 04.06.2012 14:45, schrieb Joey L:
Can you explain this further ?
Sorry a little slow ?
table count * expected connections
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_table_cache
signature.asc
Description: OpenPGP digital signature
Joey, you've over allocated the cache. MySQL is telling you that it has
corrected the allocation.
Check out the docs for the meaning behind the numbers.
On Mon, Jun 4, 2012 at 2:01 PM, Reindl Harald h.rei...@thelounge.netwrote:
Am 04.06.2012 14:45, schrieb Joey L:
Can you explain this
On 04/27/2012 03:26 PM, Shawn Green wrote:
I frequently need to have multiple versions ready to operate on my
machine at any time. I solved the configuration file problems by only
setting them up in the basedir of the installed version.
For those special occasions when I need to configure
I think you need deal with only these:
* Diff my.cnf (set as a parameter to mysqld)
* Diff tree for all the data (and reflect this in my.cnf)
* Diff port (3306 can't be shared between the instances)
-Original Message-
From: Andrés Tello [mailto:mr.crip...@gmail.com]
Sent
Thanks for your opinion.
You're right, it doesn't make too much sense regarding system-wide
configuration files, such as /etc/my.cnf. A real use case I see is when
we speak about users' config files, like ~/.my.cnf.
Let's say we have two different MySQL versions on one hardware, then
it's
and specific
files for each instance/version of the database
Thanks for your opinion.
You're right, it doesn't make too much sense regarding system-wide
configuration files, such as /etc/my.cnf. A real use case I see is when
we speak about users' config files, like ~/.my.cnf.
Let's say we have two
Hi,
PostgreSQL allows to use version-specific configuration files, which
allows to change some settings only for particular version of DB.
I think a similar enhancement would be nice and usable for
administrators of MySQL as well.
Please, consider the attached patch as a simple proposal.
Reads interesting, but...
Why would you need that?
I mean... If I run several databases in the same hardware, I use completely
diferent paths for evertying, so I can have atomic, clean and specific
files for each instance/version of the database
I think is much more easy to migrato to
Am 20.02.2012 06:57, schrieb Nayan Darekar:
hi members,
I want install, configure my 8GB Ram 4 core CPU hardware server for
dedicated MySQL DB Server with stable version of MySQL. So which version i
should use and can anyone help me for best my.cnf Configuration.
there does no best exist
Dear all,
I install mysql in CentOS -5.4 through 2 commands :
yum install mysql-server
yum install mysql-client
And I can see directories created in /var/lib/mysql directory.
But now i want to change it to my /hdd1-1 diretcory and alse set logging
directories.
So , I search my.cnf file
You need to provide a my.cnf for your server. There are some sample files
included with the server binaries that you can start with. These won't be
tailored for your application/server so will need to be changed as per your
requirements.
Note that several of the options are static values so
I think the default location on Centos is /etc/my.cnf
Regards
John
On 1 June 2011 10:24, Adarsh Sharma adarsh.sha...@orkash.com wrote:
Dear all,
I install mysql in CentOS -5.4 through 2 commands :
yum install mysql-server
yum install mysql-client
And I can see directories created
I got the error after setting my.cnf file in /etc directory.
110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
After some research i found the cause of this error : the new my.cnf is
very old and mysql_upgrade is needed
So , Can
Hi,
You probably didn't run mysql_install_db.
Peter Boros
On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote:
I got the error after setting my.cnf file in /etc directory.
110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
: Shutdown complete
I checked /hdd2-1/myisam_data/mysql-bin.index file is there , how to comes
Thanks
Peter Boros wrote:
Hi,
You probably didn't run mysql_install_db.
Peter Boros
On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote:
I got the error after setting my.cnf file in /etc
.
Peter Boros
On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote:
I got the error after setting my.cnf file in /etc directory.
110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
After some research i found the cause of this error
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 ly
...@gmail.com
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
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
-medium.cnf ...), use linux command line cp to copy it to
/etc or /etc/mysql and restart mysqld.
Could you check it?
Best regards.
--
Wagner Bianchi
2010/12/30 andrew.2.mo...@nokia.com
Adam,
you should look upon this as an opportunity to write a my.cnf that suits
your application and hardware
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
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
Hello MySQL Community,
Last Friday I changed /etc/mysql/my.cnf file (at server) accidentally.
I set the variable innodb_data_file_path to ibdata1:100M
Then I realized that I changed the server copy. Then to get the original value
I issued the query :
SHOW VARIABLES LIKE
your MySQL server at the next restart, however; but that's pretty
much the case for any other daemon, too.
On Mon, Nov 8, 2010 at 11:06 AM, AHMET ARSLAN aarsl...@anadolu.edu.trwrote:
Hello MySQL Community,
Last Friday I changed /etc/mysql/my.cnf file (at server) accidentally.
I set
I currently have a dedicated database server with 8 GBs of RAM and 8 1.60
GHz processors. The tables on my databases are almost exclusively InnoDB,
except for 2-3 tables that are MyISAM and used for logging purposes (lots of
INSERT DELAYED statements). I have the following settings in my my.cnf
software run better, its
my.cnf HOW i Can improve this :D
Thanks !!
HERE:
[client]
#password = [your_password]
port= 3306
socket = /tmp/mysql.sock
# *** Application-specific options follow here ***
#
# The MySQL server
#
[mysqld]
# generic configuration
I'm looking to optimize the myisamchk settings for some table rebuilds
I need to do.
I'm running CentOS 5 and MySQL 5.1 in a VMWare VM with 4 vCPUs and 4GB
of memory.
All the examples I can find online look like they are several years
old, and just copied from someone else's config. I think
Sydney Puente schrieb:
Hello,
I want to log all sql queries made against a mysql db.
Googled and found I should add a line to my.cnf.
However I cannot find a my.cnf file
[r...@radium init.d]# ps -ef | grep mysql
root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe
Please look in /etc/my.cnf
If not found create one. Of cause, MySQL can start and run without a 'my.cnf'
file that’s why you couldn't find one. In the absence of the my.cnf file,
MySQL will use default for every parameter .
Charles,
-Original Message-
From: walter harms
Guys,
That's a great response. Thanks.
I have copied /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnfto
/etc/my.cnf and restarted.
However I can no longer log on via the command line from the database box,
I can still log via a remote client
So I presume the problem is related
response. Thanks.
I have copied /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnfto
/etc/my.cnf and restarted.
However I can no longer log on via the command line from the database box,
I can still log via a remote client
So I presume the problem is related to the host in the mysql.user table
Yes I enter the password manually into the remote mysql client (actually
Oracle's SQL developer) when I login.
I thought I would restart mysql with the /etc/init.d/mysql script and go back
to the original default settings without any my.cnf present. Just to check it
was some setting in my.cnf
Did you remove the my.cnf file and then run /etc/init.d/mysql stop? The my.cnf
probably had non-default paths for the pid file, so if you remove the config
file, now the startup script is looking in the wrong location.
Also for your password issue, please show use the exact command you're
Hello,
I want to log all sql queries made against a mysql db.
Googled and found I should add a line to my.cnf.
However I cannot find a my.cnf file
[r...@radium init.d]# ps -ef | grep mysql
root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe
--datadir=/var/lib/mysql --pid
should be in
/etc/my.cnf
or try the following at the command line
locate my.cnf
That should give you the location
On Thu, 2009-11-12 at 18:10 +, Sydney Puente wrote:
Hello,
I want to log all sql queries made against a mysql db.
Googled and found I should add a line to my.cnf
Also note that mysql doesn't need a my.cnf file and will happily run with
default values. It's possible that there is none and you'll have to create it.
To see where your mysqld is configured to check for the config file do:
mysql --verbose --help | grep -C3 my.cnf
This will give you a list
You must copy /usr/share/doc/MySQL-server-community-5.1.39/my-somefile.cnf
file into /etc/my.cnf
If no .cnf file in /etc
MySQL use default config.
if server has 2G RAM
then use my-huge.cnf
Good luck.
- Original Message -
From: Sydney Puente sydneypue...@yahoo.com
To: mysql
]
Sent: 06 October 2009 04:57
To: Rob Wultsch
Cc: mysql@lists.mysql.com
Subject: Re: Optimizing my.cnf
As you see on my my.cnf I skip innodb and federated. So I just use
myisam in this case. TIA.
Willy
On Mon, 2009-10-05 at 20:47 -0700, Rob Wultsch wrote:
On Mon, Oct 5, 2009 at 6:12 PM
I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore processor @2.00G.
Installed with MySQL 5.075 on 64bit Ubuntu Jaunty. I have these
parameters in my.cnf:
[mysqld]
key_buffer = 512M
max_allowed_packet = 512M
thread_stack= 4096K
thread_cache_size = 256
On Mon, Oct 5, 2009 at 6:12 PM, sangprabv sangpr...@gmail.com wrote:
I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore processor @2.00G.
Installed with MySQL 5.075 on 64bit Ubuntu Jaunty. I have these
parameters in my.cnf:
blah blah blah...
This heavily depends on workload. Are you
As you see on my my.cnf I skip innodb and federated. So I just use
myisam in this case. TIA.
Willy
On Mon, 2009-10-05 at 20:47 -0700, Rob Wultsch wrote:
On Mon, Oct 5, 2009 at 6:12 PM, sangprabv sangpr...@gmail.com wrote:
I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore
Hi,
can you please send me some optimization examples for my.cnf ?
I use mysql 5.1.37
The server run just 2 very busy forums.
It is quad core cpu and 8 giga ram so we have lot of run (run debian)
Can you please give me some examples?
Thanks
--
MySQL General Mailing List
For list archives: http
Hi Christos,
Performance optimization is very subjective, and if you are experiencing low
performance it can be a million different things. The description you
provided didn't mention any of your current my.cnf settings, nor did it
mention what kind of tables your database contains, size of data
is very subjective, and if you are experiencing
low
performance it can be a million different things. The description you
provided didn't mention any of your current my.cnf settings, nor did it
mention what kind of tables your database contains, size of data, types of
indexes, engines used
-Original Message-
From: prabhat kumar [mailto:aim.prab...@gmail.com]
Sent: Thursday, September 03, 2009 1:44 PM
To: Darren Cassar
Cc: Christos Pelekis; mysql@lists.mysql.com
Subject: Re: optimize my.cnf
Well said Darren. Its not magic :)
[JS] Actually, its voodoo :)
Regards,
Jerry
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
Hi All,
We're setting up a group of servers using MySQL Enterprise 5.1 - Rather
than starting with a blank canvas I wondered if there was a suitable
my.cnf that is tuned to the kind of environment I'm running where I can
tweak it from there.
We're running on RHEL, on Sunfire X4140's - 8
Craig Dunn wrote:
Hi All,
We're setting up a group of servers using MySQL Enterprise 5.1 - Rather
than starting with a blank canvas I wondered if there was a suitable
my.cnf that is tuned to the kind of environment I'm running where I can
tweak it from there.
We're running on RHEL
There's no such thing as a generic my.cnf for high performance MySQL
servers, you will need to provide more information..
Some questions: Are you going to run InnoDB or MyISAM or both (if both,
what's the split?)
Is there anything else running on that server? i.e. how much of the
16GB
Andrew Braithwaite wrote:
There's no such thing as a generic my.cnf for high performance MySQL
servers, you will need to provide more information..
Well, I was more after something a bit more up to date than my-huge.cnf
that I could use as a starting point, I see a few example ones posted
Your disk config is good and you'll need all the nessesary my.cnf
entries to point all the logs and data to the correct place. Slaves
should have the relay-logs going to the OS disk too. I assume you've
set up the master slave config in the my.cnf too.
Here's my brain dump on what you need
Andrew Braithwaite wrote:
Your disk config is good and you'll need all the nessesary my.cnf
entries to point all the logs and data to the correct place. Slaves
should have the relay-logs going to the OS disk too. I assume you've
set up the master slave config in the my.cnf too.
Yeah
At 07:56 AM 5/6/2009, you wrote:
Hi All,
We're setting up a group of servers using MySQL Enterprise 5.1 - Rather
than starting with a blank canvas I wondered if there was a suitable
my.cnf that is tuned to the kind of environment I'm running where I can
tweak it from there.
We're
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?
?) ? 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
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
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
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
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
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
Hey all,
I'm trying to get my MySQL server configured so
outside connections can access it with
OpenOffice.org 2.4.
My server is running on FreeBSD 6.0 and the my.cnf
file looks like this currently.
[mysqld]
user = mysql
pid-file = /usr/local/mysql/bigskypenguin.com.pid
socket = /tmp
Hey Chaim,
I'm sorry, I don't know what you mean by default
route. I am only familiar with the current
contents of my.cnf, and mods were made according
to instructions I found via Google.
I don't see this noted in MySQL anywhere. Is this
a network-wide configuration?
Skip
Chaim Rieger
Skip Evans wrote:
Hey all,
I'm trying to get my MySQL server configured so outside connections can
access it with OpenOffice.org 2.4.
My server is running on FreeBSD 6.0 and the my.cnf file looks like this
currently.
[mysqld]
user = mysql
pid-file = /usr/local/mysql/bigskypenguin.com.pid
Skip Evans wrote:
Hey Chaim,
I'm sorry, I don't know what you mean by default route. I am only
familiar with the current contents of my.cnf, and mods were made
according to instructions I found via Google.
I don't see this noted in MySQL anywhere. Is this a network-wide
configuration?
can
Gerald L. Clark wrote:
Does that IP address resolve to your hostname?
Yes, it does.
--
Skip Evans
Big Sky Penguin, LLC
503 S Baldwin St, #1
Madison, WI 53703
608-250-2720
http://bigskypenguin.com
=-=-=-=-=-=-=-=-=-=
Check out PHPenguin, a lightweight and versatile
PHP/MySQL, AJAX DHTML
-Original Message-
From: Skip Evans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2008 10:38 AM
To: mysql@lists.mysql.com
Subject: MySQL won't start with external bind-adress in my.cnf
Hey all,
I'm trying to get my MySQL server configured so
outside connections can access
Chaim Rieger wrote:
Skip Evans wrote:
can you post the output of ifconfig please
bge0:
flags=8843UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST
mtu 1500
options=1aTXCSUM,VLAN_MTU,VLAN_HWTAGGING
inet6 fe80::230:48ff:fe88:2b8a%bge0
prefixlen 64 scopeid 0x1
inet 192.168.1.100
Chaim Rieger wrote:
can you post the output of ifconfig please
I should have noted that
192.168.1.250
on bge1 is configured for port forwarding to the
public IP address of the server.
--
Skip Evans
Big Sky Penguin, LLC
503 S Baldwin St, #1
Madison, WI 53703
608-250-2720
Skip Evans wrote:
Chaim Rieger wrote:
Skip Evans wrote:
can you post the output of ifconfig please
bge0: flags=8843UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST mtu 1500
options=1aTXCSUM,VLAN_MTU,VLAN_HWTAGGING
inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1
inet
the ATT tech helped me configure
my LAN and public IPs through the Netopia DSL
modem, we ended up doing that to make it work
properly. I think it has something to do with a
requirement in the Netopia modem.
So next I changed the bind-address in my.cnf to
the 192.168.1.250 mysql came up fine
the my-huge.cnf from the examples directory and changed the
thread_concurrency setting to 8 (because it said to set it to No. of CPUs*2).
I also set the tmpdir, basedir, datadir and language, which were set in the
original my.cnf
I ran sql-bench again and the performance was even worse
and language, which were set in the
original my.cnf
I ran sql-bench again and the performance was even worse this time: 0.36
Someone suggested I try the -amd64 kernels which provide 64 bit but when I
try
to boot it I get various errors about this CPU does not support long
(something) please
Hi,
Someone suggested I try the -amd64 kernels which provide 64 bit but when I try
to boot it I get various errors about this CPU does not support long
(something) please use a 32-bit OS - the 64 bit install CD says the same
message. So I assume these are not 64 bit CPUs.
They almost
Hi,
On Thu, Apr 24, 2008 at 12:20 PM, Jeremy Cole [EMAIL PROTECTED] wrote:
Hi,
Someone suggested I try the -amd64 kernels which provide 64 bit but
when I try
to boot it I get various errors about this CPU does not support long
(something) please use a 32-bit OS - the 64 bit
not make
a huge difference since it's I/O bound.
Were you testing with something like production data or just some test
data? Have you modified my.cnf to reflect the new hardware config?
Like Baron Schwartz asked, does your test reflect real-life workload?
And yes, the 3.0Ghz Xeon processors you
JW wrote:
Hello,
We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast
server.
Specs are:
OS: Linux Debian 4.0/Etch
RAID 5 on 4x U320 15k rpm drives
(uses a perc-raid 3/DC hardware raid controller)
16GB of RAM
4 3.0 Ghz Xeon processors - I think they're dual core, in
hi all...
i have a 5.0.33 build from source on a freebsd 4.10 machine...
i'm looking for a my.cnf file.
ps tells me that the base dir is /usr/local but there is no my.cnf
there. and i cant find one anywhere.
i can get all the variables set up from the cli but i need to change
some of them
I had the same problem. I found the distribution contains some prototypes,
with slightly more elaborate names.
Regards,
Mike
kalin m [EMAIL PROTECTED]
03/18/08 01:06 PM
To
mysql@lists.mysql.com
cc
Subject
default my.cnf?
hi all...
i have a 5.0.33 build from source on a freebsd 4.10
Hi,
On Tue, Mar 18, 2008 at 1:06 PM, kalin m [EMAIL PROTECTED] wrote:
hi all...
i have a 5.0.33 build from source on a freebsd 4.10 machine...
i'm looking for a my.cnf file.
ps tells me that the base dir is /usr/local but there is no my.cnf
there. and i cant find one anywhere.
i can
On Dec 22, 2007 10:55 AM, Moon's Father [EMAIL PROTECTED] wrote:
how big your mysql connections's users.
How big users? don't know what you said.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Everybody,
I am working on the tweaking of my.cnf and i am not able to understand that
which component should get the maximun ram usage. for example
max_allowed_packet, innodb_buffer_pool_size component how much of memory
should be alloted to them. How the memory division should be done
Hi All,
I have a pentium box 3.0 GHz processor and 2 GB ram. I want to configure
my.cnf in such a way that it should give the best performance. So, how
should I configure the my.cnf parameter. What are the components on which
the most attention should be paid. I am using innodb parameters
Hi,
I have noticed in the man page for mysql from
MySQL-client-community-5.0.37-0.sles9.i586.rpm there is a repetition in
the my.cnf files read by mysql. I am wondering if this is at all
significant.
This is what man mysql shows for the
MySQL-client-community-5.0.37-0.sles9.i586.rpm install
Description:
The /etc/my.cnf that is included with RHEL4 5.0.27 RPMS is
incompatibel with the /etc/init.d/mysql start scripts!
[EMAIL PROTECTED] rhel4]$ sudo rpm -Uveh MySQL*.rpm
Password:
warning: MySQL-client-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA
signature: NOKEY, key ID 5072e1f5
1 - 100 of 528 matches
Mail list logo
