Saying your up to 768 courses doesn't give us much information. How many
queries/second is the server handling right now? My machine, which is
considerably slower than yours handles 10 queries/second without blinking an
eye.
When we were experiences an extreme slow down before, we found three issues.
One was that we didn't have enough RAM (1 Gig of RAM should be fine). The
second thing was that our configuration was not optimized for our system in
the least (you HAVE tweaked /etc/my.cnf right?). And the last was that we
had 1 bad query.
To give you a feel for what 1 single badly written query can do to your
performance. When we had this problem, we were doing on average 2
queries/second. 1 out of every 200 or so queries would be the one single
bad one. But it turned our load average from the 0.00 - 0.06 range to the
20 - 50 range.
Just proof that you really need to see if a single query is to blame. Use a
util like MyTop to watch the queries as they happen. If you see one
appearing more often than others, take a look at that query. There might be
a better way to write it (or use keys more effeciently).
----- Original Message -----
From: "Jesse Santana" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 09, 2001 9:08 AM
Subject: Load question
> We are currently running Blackboard 5 level 1 (an online course management
> package) which utilizes MySQL v3.22.32. Our previous semesters saw a
course
> load of approximately 85 courses under which, MySQL performed extremely
> well. This semester, we have skyrocketed to 768 courses. Now, our server
> (a Sun Enterprise 450 with 2 400MHz Sparc's, 1 GB of RAM, and 30GB of
> storage in a RAID 5 configuration) is performing extremely slow. Using
top
> to monitor system performance, we are regularly seeing our load factor
rise
> to double digits and MySQL run away with up to 98% (peak) of the CPU time.
> Blackboard's response to this is that MySQL does not scale upwards very
well
> and, to fix our problem, we will have to switch to an Oracle database (at
an
> increased price).
>
> My question is, is Blackboard pulling our leg or does MySQL truly have a
> problem scaling upwards?
>
> Jesse
>
>
>
>
>
>
>
----------------------------------------------------------------------------
----
> ---------------------------------------------------------------------
> 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
