mysql on pii3 and brat

From: Hironori Ito (hito@students.phsx.ukans.edu)
Date: Tue May 28 2002 - 10:58:55 EDT

  • Next message: Marco Germinario: "Re: Libtool problems"

    	Hello.  I have noticed today (not anymore) that pii3 was very
    slow. (It took about 3-5 minutes to simply copy a small
    file(20MB) ) Looking more carefully. "top" indicates that several mysql is
    taking cpu power.  In fact, each mysql (about 6 or so) is using about
    20-40% of cpu.  "processlist" command of mysql shows that the command
    mysql executing is "SELECT * FROM ConditionsKeithley WHERE Unit=1 and
    Channel=2 and Time>1004138043 and Time<1004142409" from several rcas
    machines.  I assumed that this is getting the magnet setting from
    database.  But, I never noticed that pii3 is slow.  ( Maybe it was
    accident that many people tried to use it at the same time.)  If this
    contiuously occurs, it might be necessary to move mysql to somewhere
    else. (or /home to somewhere other than pii3)
    
    	Hiro     
    



    This archive was generated by hypermail 2b30 : Tue May 28 2002 - 10:40:13 EDT