A lot of problems with web site to DB connections come from 2 things. I assume you meant 12.5 mega"BITS" per second.
1) Over using a database when you don't need to, when you can just as well create semi-static pages that get updated by the db on a regular basis (as needed).
2) The database queries (or tables) are not optimized to return the data you are looking for in a timely manner.
Since you know your select queries - make sure you are using indexes. We have a site that averages about 50 to 60 queries per second during peak and they are mostly Updates. Just by optimizing the queries and the database tables, we were able to dramatically diminish the load and query times (nothing in the slow query log with a slow query being >5 seconds)
Hope this helps
Eric Lamendola
Slingo Inc.
At 08:10 AM 10/31/02 -0600, Benji Spencer wrote:
We are experiencing some issues with performance on a non-MySQL box and are looking for alternatives (and alternative methods). Once of the issues that we seem to be facing, is that the pure volume of data which needs to be pushed out. The other database is pushing out (at peak) 12.5 megabytes per second and is being hit with 30-45 queries per second. If we rework the application, we end up with one of two solutions:
1) move to MySQL for the database engine (it currently is MSSQL)
2) Rework the application, so that the application still talked to MSSQL, but we generate static pages (this is for a website) and store them in MySQL, which are then served. This will reduce both bandwidth and queries per second. Bandwidth is unknown, but the queries per second are estimated at 15-25 queries per second. The select statements would be very generic though (select * from table where ID='abc123')
This leaves one major question. How much data can MySQL push out? Can MySQL handle 12.5 megabytes (not megabits) per second of data? Will MySQL handle 20 queries per second?
I know a lot of this also determined by OS/hardware. MySQL would be running on a 2-CPU Sun box.
Any information with regards to this would be of use.
If anyone also has such information on MSSQL (what is the Application Limit of MSSQL) it would also be helpful.
thanks
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
--------------------------------------------------------------------- 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
