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 woul
by mysqld has
so far 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 perf
i have a table this is 50 Million, has 10 indexs, some are on varchar's
disk space is 34 GB for the MYD, and 6.5 GB for the MYI. Granted I have
a pretty old box, 2x660 Mhz P3's, and a RAID array good for about 25-30
MBs, it took me when the DB as at 42 million records about 28 hours to
reindex
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 unkno
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
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,
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 #
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 em
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 cours
