[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-developer
Subject:    Re: Mysql Problem
From:       "HAMEL Nicolas" <gouky () joystick ! fr>
Date:       2000-09-30 15:39:14
[Download RAW message or body]

For information , my mysqld is at 98 % of CPU usage and there's a lot of
theses queries stuck :

| 71105 | sqlmaster | web2.grolier.fr | joystick | Query   | 2930 | Sending
data   | SELECT USER_ID FROM serveurs_joueurs_classement WHERE GAME_ID = 3
AND USER_ID = 49212 LIMIT 1

Its not a very complex select , no ?

Regards,
Nicolas

----- Original Message -----
From: <sinisa@mysql.com>
To: <gouky@joystick.fr>
Cc: <developer@lists.mysql.com>
Sent: Saturday, September 30, 2000 1:12 PM
Subject: Re: Mysql Problem


> HAMEL Nicolas writes:
>  > Hi folks,
>  >
>  > i've got a lot of trouble with mysql on my sit web  (www.joystick.fr)
>  > we have about 20 tables and the bigger got around 350 000 lines of data
>  >
>  > The big problem that we have is that mysql hang very often ( the CPU
>  > hit 98% of use ! ) i have check the queries but there's nothing
>  > strange.... I've got a a slow queries logs but all the queries are
>  > small and work very fine ( they dont take a sec ) but sometimes
>  > mysql answer in more than 20 secs !
>  >
>  > The Mysql is running on an Alpha FreeBSD - 3.23.20... 1 gigs of Ram :)
>  > Its a very powerful computer (too much, and it cost :P ) .
>  >
>  > Pleeassee heelpp me ;)
>  > Nicolas
>
> HI!
>
> There are several possible issues. If you have not used gcc 2.95.2 to
> build MySQL, then it could be caused by compiler bug.
>
> On the other hand, FreeBSD should be the latest 4.x stable version and
> MySQL should use their native threads.
>
> Regards,
>
> Sinisa
>
> +----------------------------------------------------------------------+
> |      ____  __     _____   _____  ___     ==  MySQL AB                |
> |     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
> |    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@mysql.com     |
> |   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
> |  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
> |  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
> |             /*/             \*\                Developers Team       |
> +----------------------------------------------------------------------+
>


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail developer-thread1671@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail developer-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]