I am coming across an annoying problem with a new InnoDB installation.
On a 4Gig RAM box, Mysql doesn't seem to want to grab the RAM I am
telling it to take.
I would like for it to try and use around 3 Gigs for its
innodb_buffer_pool_size, but it refuses to startup with anything greater
than 512M.
>From what I understand about InnoDB, you want to make that InnoDB buffer
pool as big as 60-80% of your allowable RAM. If you use only InnoDB,
then the other settings won't help you to give much ram. If you use no
InnoDB, then don't bother giving InnoDB buffer pool any real ram.
If it works correc
Hmm, as I feared, this problem is so major that no one wants to touch
it. Not that I blame anyone.
-Original Message-
From: Misao [mailto:[EMAIL PROTECTED]
Sent: Monday, September 22, 2003 6:09 PM
To: [EMAIL PROTECTED]
Subject: InnoDB, Replication, and Data warehouse: Oil, Water, and litt
MySQL tells me at startup that it can not allocate more than 512MB of
RAM.
It will fail to start the server if I specify any further.
As far as separate instances, we have not looked into doing that for the
masters, but we may use that for the data warehouse copy. The idea of
multiple MySQL maste
48972K
cached
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 3:28 PM
To: Misaochankun
Cc: [EMAIL PROTECTED]
Subject: Re: InnoDB, Replication, and Data warehouse: Oil, Water, and
little floating plastic men
On Wed, S
Most likely your mysql database is still MyISAM, right?
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:35 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Key_buffer_size
On Tue, Sep 30, 2003 at 08:17:20PM +0100, [EMAIL P
Can this be done?
No, I do not mean running multiple MySQL servers.
I need to have MySQL listen on two separate ports at the same time.
Reason being, the new port is needed for a routing issue, and the
default port 3306 needs to stay up to respond to normal traffic.
--
MySQL General Mailing List
We will most likely be using that method.
We have to translate our ipchains to iptables first.
-Original Message-
From: Kevin Carlson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 2:56 PM
To: Misaochankun
Cc: [EMAIL PROTECTED]
Subject: Re: Having MySQL listen on multiple(2
