- Original Message -
From: "Mysql List" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 24, 2003 11:15 AM
Subject: Re: Huge Server configuration
> I have RAID 5 with 5 hardisks, so usuable number of spindle will only be 4.
Unless you've d
X-Original-To: [EMAIL PROTECTED]
X-Original-To: [EMAIL PROTECTED]
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]>
Date: Thu, 24 Jul 2003 10:42:31 -0700
RAID-5 is cool, RAID-1+0 (10) is better for writes.
Raid5 is slow and
-->-Original Message-
-->From: Mysql List [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 10:47 AM
-->To: Dathan Vance Pattishall
-->Cc: [EMAIL PROTECTED]
-->Subject: Re: Huge Server configuration
-->
-->Dathan Vance Pattishall wrote:
-->
--
Dathan Vance Pattishall wrote:
RAID-5 is cool, RAID-1+0 (10) is better for writes.
Your defiantly are going to be IO bound. I would go with many smaller
disks >= 20 disk, in multiple RAID-1+0 configurations on different
channels or better yet different RAID controllers.
Well I do not have the l
BEGIN my.cnf
[mysqld]
port = 3306
socket= /tmp/mysql.sock
basedir = /usr/local/mysql
log = /var/log/mysql/mysql.log
log-slow-queries = /var/log/mysql/mysql-slow.log
log-err = /var/log/mysql/mysql.err
log-bi
IO bound with a read heavy 2 Gb where most of
the data is in memory. I'm transferring 15Mb a second of read traffic.
-->-Original Message-
-->From: Mysql List [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 10:16 AM
-->To: [EMAIL PROTECTED]
-->Subject: R
t;Subject: Huge Server configuration
-->
-->Hello all,
-->
-->I have a server like 8way Intel Pentium 4 Xeon processor with 12GB
RAM
-->and 1TB harddisk space.
-->All the tables size are over 10GB and they have over 100mm records.
-->
-->Could some one help me get an appropria
Christopher Knight wrote:
what table types? Innodb.etc...
It is mainly innodb.
about how many tables?
there are around 200 tables
do you do alot of sorting?
Lots of sorting and fltering is done
are the exact same queries repeated alot?
Not likely
is the machine doing anything else or is ma
-
From: Mysql List [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 11:38 AM
To: [EMAIL PROTECTED]
Subject: Huge Server configuration
Hello all,
I have a server like 8way Intel Pentium 4 Xeon processor with 12GB RAM
and 1TB harddisk space.
All the tables size are over 10GB and they have over
-variable = max_allowed_packet=16M
-->-Original Message-
-->From: Mysql List [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 24, 2003 9:38 AM
-->To: [EMAIL PROTECTED]
-->Subject: Huge Server configuration
-->
-->Hello all,
-->
-->I have a server like 8way Intel Pe
Hello all,
I have a server like 8way Intel Pentium 4 Xeon processor with 12GB RAM
and 1TB harddisk space.
All the tables size are over 10GB and they have over 100mm records.
Could some one help me get an appropriate mysql configuration(my.conf)
file for the machine.
I understand ther are lots
11 matches
Mail list logo
