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: --defa
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 dbase
2014-02-12 12:32 GMT+01:00 Lukas Lehner :
> 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 MySQL).
If it is goin
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
Hi
it's also a Tomcat application server. Not dedicated MySQL instance.
On Wed, Feb 12, 2014 at 11:28 AM, Adarsh Sharma wrote:
> 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 )
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 param
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 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 optimal.
.conf
$ 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.
ssage-
>> 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?
>>
>&g
t; 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 RAID 10 -
> running Ubuntu 12.04 with MySQL 5.5.28 . Doing random imports to large
>
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 wrote:
>
>
> Am 04.06.2012 14:45, schrieb Joey L:
> > Can you explain this further ?
> > Sorry a
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
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: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 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 error
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.
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 multip
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&#x
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
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 anoth
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. An
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.
the
ros 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 directory.
>>>
sr/sbin/mysqld: 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 sett
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 &
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_upg
I think the default location on Centos is /etc/my.cnf
Regards
John
On 1 June 2011 10:24, Adarsh Sharma 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 c
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
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 as
Hello All,
I have a new install of CentOS 5.5. 64bit running MySQL 5.5. This box
has 8GB of memory and is running nothing else other than mysql.
Shortly, I will be copying over a 80GB database from a Mysql 4.1.x server,
and need to repair/upgrade most of the tables. I'm using myisamchk to d
>
> 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
>> >
&g
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 :
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 op
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 /u
f, 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
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
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
messes up 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 wrote:
> Hello MySQL Community,
>
> Last Friday I changed /etc/mysql/my.cnf file (at server) accidental
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
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
at my 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 ***
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 with
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&#x
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
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
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 t
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-
Fro
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:0
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"
To:
Sent: Friday, November
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 giv
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
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
@gmail.com]
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,
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 wrote:
> I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore
>
On Mon, Oct 5, 2009 at 6:12 PM, sangprabv 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.
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
>-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] Actua
ubjective, 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
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
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
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
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?
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 ther
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.
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 o
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 post
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 t
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 runn
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 Sunf
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
L 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
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://li
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 advi
ndering 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
28
s 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
when the AT&T 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 cam
Skip Evans wrote:
Chaim Rieger wrote:
Skip Evans wrote:
can you post the output of ifconfig please
bge0: flags=8843 mtu 1500
options=1a
inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1
inet 192.168.1.100 netmask 0xff00 broadcast 192.168.1.255
bge1: flags
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
http://bigskypengu
Chaim Rieger wrote:
Skip Evans wrote:
can you post the output of ifconfig please
bge0:
flags=8843
mtu 1500
options=1a
inet6 fe80::230:48ff:fe88:2b8a%bge0
prefixlen 64 scopeid 0x1
inet 192.168.1.100 netmask 0xff00
broadcast 192.168.1.255
ether 00:30:48:88
ull
2>&1 &
-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 c
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 deve
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 ne
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.co
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 configurat
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 =
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 /p
or a 6650 would 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
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" -
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 cer
copied 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 th
this try was _exactly_ the same: 0.35
I copied 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
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.c
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 f
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
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.r
1 - 100 of 537 matches
Mail list logo
