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,
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 /proc/cpuinfo
Hi,
On Wed, Apr 23, 2008 at 11:07 PM, JW [EMAIL PROTECTED] 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)
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
I think what we need to know is more stuff about the database itself.
How big is it? I assume if you were able to serve it from a Mac Mini it
can't be all that big.
16GB should be big enough to contain all the data and serve it up quickly.
And while 4-disk RAID 5 isn't all that great, it's
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
I am trying to figure out the best innodb paramaters in the my.cnf
file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with
2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am
running on default params.
Does anyone out there have a suggested innodb parameters or
Kieran Kelleher wrote:
Does anyone out there have a suggested innodb parameters or even a
working set of params that I could start with.
The InnoDB manual gives good suggestion. Some minor comments (none
particularly OS X specific, but InnoDB works fine on it)
innodb_buffer_pool_size is very
: InnoDB my.cnf settings on OS X 10.3 Server?
I am trying to figure out the best innodb paramaters in the my.cnf
file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with
2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am
running on default params.
Does anyone out
[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
I was wondering if someone could shed some light on setting parameters in
my.cnf. When I set params such as user and password in my my.cnf file I
dont need to then pass these parameters to commands such as mysqldump or
mysqladmin? Is this True? Can someone please send me an example of their
Which group(s) would the following options be put under to enable in the my.cnf.
safe_show_database
skip_show_database
Thx's
mysql sql database
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
15 matches
Mail list logo