I'm sure you've already specified this, but here's a few questions:
Probably not a bad idea to recap
What size of machine (CPU, RAM, # and type of drives) are you using for each server? (MySQL vs. MS SQL)MSSQL (Current setup) - 2-1.2 GHZ CPUs, 4 gig of mem, and a RAID5 SCSI array, Server 2000
MySQL-UNIX (perspective option) - 2-450 MHZ, 2 gig of memory, an EMC Disk array, Solaris 2.8
queries per second or requests per second? (web server vs database server)How many queries per second are you getting to the web server?
Web Server: 5-15 requests per second
Database Server: 15-25 transactions per second (queries per second) with peaks slightly higher
How big are the tables (in rows) that the queries are made against?
Table A: roughly 16K rows (about 25 fields) Table B: roughly 15K rows (4 fields, of which 1 is a text field) Table C: 700 rows Table D: 75 rows Data from those tables make up 99.999% of the queries
Do you have indexes on all the fields that are used in JOINs in the queries? If any are VARCHARs or long CHARs, are the indexes against subsets of the data ("ADD INDEX data_idx(data(10))" for example)?We indexed any field which might have a condition run against it as well as any field which does a join (which happens to be the same ones which usually have a condition run against it)
benji
---
Ben Spencer
Web Support
[EMAIL PROTECTED]
x 2288
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
