[Asterisk-Users] 2 4-port T1 cards

Ryan Butler rbutler at adiis.net
Wed May 28 12:11:38 MST 2003


On Wed, 2003-05-28 at 13:30, Steven Critchfield wrote:

> Don't use Mysql. if you ever have had to deal with it in a production
> environment that works it over, you will know that as it reaches it's
> limits, it starts a death spiral that is very difficult to recover from.
> For our software on a dual P3 866 with a gig of ram, the limit was
> around 1.5 queries a second fairly mixed update, inserts, and selects.
> Total file size of the database was under 200meg, and was fully cached
> so even though we had hardware raid 5 across 4 10K rpm ultra160 drives,
> it shouldn't have mattered for the selects.
> 

I'd check what configuration problem you have with mysql then.

Uptime:                 48 days 1 hour 42 min 6 sec
 
Threads: 15  Questions: 376005206  Slow queries: 22  Opens: 214  Flush
tables: 1  Open tables: 64 Queries per second avg: 90.531


This is a mixture of inserts updates and selects as well.


slashdot.org runs mysql at loads way over this, and it continues to run,
although its very select heavy most likely.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20030528/52373348/attachment.pgp


More information about the asterisk-users mailing list