my.cnf settings specifically for myisamchk

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

my.cnf settings

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,

Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?

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

Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?

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 cert

Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?

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" -

Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?

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

Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?

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 control

Dismal performance on a 16G memory/8 core server - my.cnf settings?

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 i

RE: InnoDB my.cnf settings on OS X 10.3 Server?

bject: 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 anyon

Re: InnoDB my.cnf settings on OS X 10.3 Server?

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 there have a suggested innodb parameters or e

re: RE: my.cnf settings and running admin commands such as mysqldump

gt; From: Victoria Reznichenko [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, y

RE: my.cnf settings and running admin commands such as mysqldump or m

, 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 us

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 and password in my my.cnf file I DK> dont need to then pass these parameters to commands such as mysqldump or DK> my

my.cnf settings and running admin commands such as mysqldump or mysqladmin

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 my.c

my.cnf settings

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! http://www.thu