Re: what can i change in my.cnf/mysqld to get better perfomance

2004-02-17 Thread walt
Pete, I was just glancing at this and it looks like you have about 13.5GB of memory allocated on a 8GB machine (4096+4096+512+4096+1024). Are you swapping badly?? walt Lancashire, Pete wrote: I'm doing some tests on a small Sun server, a 280R to demo MySQL vs. Oracle. For the demo I using a

RE: what can i change in my.cnf/mysqld to get better perfomance

2004-02-17 Thread Lancashire, Pete
not gone above 1 GB (both resident, and requested). -pete -Original Message- From: walt [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 10:47 AM To: Lancashire, Pete Cc: [EMAIL PROTECTED] Subject: Re: what can i change in my.cnf/mysqld to get better perfomance Pete, I was just

Re: what can i change in my.cnf/mysqld to get better perfomance

2004-02-17 Thread Sasha Pachev
Lancashire, Pete wrote: I'm doing some tests on a small Sun server, a 280R to demo MySQL vs. Oracle. For the demo I using a subset of a test table. The destination server will be a Sun 880 with 8 1.2 GHz CPU's, 16 GB RAM, Sun T3+ RAID Array. Any suggestions on settings or other changes would be

RE: what can i change in my.cnf/mysqld to get better perfomance

2004-02-17 Thread Donny Simonton
: Tuesday, February 17, 2004 1:12 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: what can i change in my.cnf/mysqld to get better perfomance no swapping so far I can see where I'm 'asking for' more then 8 GB, but for testing, I gambling that the total amount of test data is less