[Asterisk-Users] 2 4-port T1 cards

Joshua M. Thompson funaho at jurai.org
Wed May 28 12:14:49 MST 2003


On Wed, 2003-05-28 at 14: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.

What table type? The default MyISAM tables don't support row-level
locking and thus are horrible if you do a lot of inserts or updates.
InnoDB tables however are much, much better. Hell SlashDot runs on MySQL
with InnoDB. :)

-- 
Joshua M. Thompson <funaho at jurai.org>
Planet Jurai




More information about the asterisk-users mailing list