Hey There,
Our MySQL database server is:
1. Sun Ultra Enterprise 4500 System Chassis with SBus I/O
4. 6 System Boards, each with 2 UltraSPARC II 400 mhz CPU's and 2 GB's of memory (12 CPU, 12 GB memory)
2. 1 SBus I/O board, with SCSI-2 and dual fibre channel interfaces on it.
3. The SCSI-2 interfaces are connected to an on-board SCSI disk board that has 2 9GB SCSI disks that are mirrored. This is the boot disk for the system.
4. The fibre channel interfaces are attached to an external Sun A5000 enterprise network chassis, which as 14 * 9GB discs setup in RAID10.
5. Solaris is Solaris 8, latest patches.
6. We're running MySQL using the alternative LWP threading library that ships with Solaris 9 as standard and is backported to Solaris 8. We find that thread creation time is a lot faster with this version.
Altogether, cost for this machine was -about- $15,000 USD from Solar Systems (refurbished). I highly recommend dealing with Solar as it's easily the cheapest way to get big iron.
http://www.solarsys.com
MySQL itself is the 64-bit Solaris MAX version, pre-compiled from MySQL.com. We're using InnoDB tables, with an 8GB InnoDB buffer cache. Right now (3:00pm on Monday), we're doing -about- 1500 queries per second, so by the evening, we'll be pushing 2500 or so.
Anything else you want to know, let me know.
Dylan
On Monday, August 4, 2003, at 01:33 PM, Joe Shear wrote:
Hi,
Sorry to bring up something unrelated to your post, but I was curious about the hardware you have MySQL running on. Could you tell me about your setup?
thanks, joe
On Fri, 2003-08-01 at 23:46, Dylan Neild wrote:Hi everyone,
I've been looking everywhere for an answer to this, so please excuse me
if it should have been obvious.
I have a very big MySQL server, under load, serving in the 1500 QPS
range. Under times of high concurrenncy (many threads connected issuing
queries), I start to see a lot of the threads with "NULL" as their
state (rather then Sending data, sorting, etc). These threads seem to
be blocked for some reason, as they eventually do get executed.
Am I running into a locking issue?
MySQL seems like it -should- scale to 12 CPU's... so I must be missing something.
Up until this point, it's just grown and grown along with us (using InnoDB table system), so I'm hoping to continue. :)
Thanks in advance,
Dylan-- Joe Shear <[EMAIL PROTECTED]>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
