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

2004-02-17 Thread Lancashire, Pete
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 helpful. Also what

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

Update = DEMO TIME: Need best options for source/smp/raid/x86 need to do a demo

2002-12-14 Thread Lancashire, Pete
the RAID arrays were built at RAID-0 90% of the time the db's will be doing only selects, the db's will be updated nightly. -pete Well I opened my big mouth and now have to do a demo of MySQL on an old server that was destined for the dumpster. It has 4 Pentium III, 512 MB of memory (bus

DEMO TIME: Need best options for source/smp/raid/x86 need to do a demo

2002-12-14 Thread Lancashire, Pete
Well I opened my big mouth and now have to do a demo of MySQL on an old server that was destined for the dumpster. It has 4 Pentium III, 512 MB of memory (bus unknown), an HP 3 channel RAID controller (Megatrends?), and 8 SCSI disks in an external array. I've configured the disks to have 4 disks

My error or bug ?? 4.0.3 RPM Initial Passwords

2002-09-09 Thread Lancashire, Pete
Hi, Did the usual RPM install, got the usual message [root@us-penguin MYSQL]# rpm -Uvh MySQL-4.0.3-0.i386.rpm Preparing...### [100%] 1:MySQL

Thougths on getting MySQL into the enterprise vs MSSQL Oracle

2001-08-25 Thread Lancashire, Pete
This is kind of an open letter and request for help. Also would apply to our pgSQL friends as well. What would be a major benefit is Guides/FAQs etc on converting from Oracle or MSSQL to MySQL and pgSQL Easy data conversion and export from Oracle MSSQL to MySQL and pgSQL And so on .. Today

(anonther) user permission problem

2001-06-21 Thread Lancashire, Pete
Hi fellow mysql'ers Here my simple problem I can connect to the mysql server host from any other host, but I cannot from the host with the mysql server. More detail Mysql 3.23.30-gamma (yea I know I need to update it) Example user is foo, password is bar Columns_priv, func, and host are

RE: (anonther) user permission problem -- hit send to fast

2001-06-21 Thread Lancashire, Pete
Forgot to add Can connect from a different host by using both the hostname and FQN, For example the name of the host with the mysql server is sparky. From sparky -h localhost -h sparky -h [EMAIL PROTECTED] All fail From another host both sparky and [EMAIL PROTECTED] let me in, and Of