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