Wired Intelligent Edge

 View Only
last person joined: 19 hours ago 

Bring performance and reliability to your network with the HPE Aruba Networking Core, Aggregation, and Access layer switches. Discuss the latest features and functionality of your switching devices, and find ways to improve security across your network to bring together a mobile-first solution
Back to discussions
Expand all | Collapse all

Procurve Manager MYSQL problem

This thread has been viewed 0 times

  • 1.  Procurve Manager MYSQL problem

    Posted Jan 21, 2009 03:51 AM

    Hello

    Facts:
    Ver : 2.321
    Devices : 182
    Users : 3
    Server : IBM xSeries 335, Xeon 3 GHz, 1 Gb ram.
    OS : Windows XP, SP3, latest updates, FW disabled.
    Netspeed : 1 Gbit

    Suddenly PCM became very very slow responding both at the client and on the server, making it impossible to use.

    The disk is not fragmentet.
    The avarage CPU usage is below 10%.
    The server it self responds normally.

    Possible cause :
    The activity on the harddisk is very high and the taksmanager shows mysqld-max-nt.exe producing 8-15 MB disk I/O (reads).

    We think it's a MySQL issue, but how do we fix it and what causes the problems ??


    Regards

     

    P.S. This thread has been moved from Switches, Hubs, Modems (Legacy ITRC forum) to  PCM. -HP Forum Moderator


    #mysql


  • 2.  RE: Procurve Manager MYSQL problem

    Posted Jan 22, 2009 08:45 AM
    My solution (in danish) here :

    http://sites.google.com/site/boxxit/special/tweaks




  • 3.  RE: Procurve Manager MYSQL problem

    Posted Mar 30, 2014 07:24 AM

    the page cannot be found



  • 4.  RE: Procurve Manager MYSQL problem

    Posted Jan 22, 2009 10:07 AM
    hi Boxx

    please take a look task manager under processes (javaw.exe)

    if javaw.exe use high cpu close java update on server



  • 5.  RE: Procurve Manager MYSQL problem

    Posted Jan 23, 2009 04:33 AM
    @Cenk

    Are you familiar with Procurve Manager ?

    PCM uses it's own buil-in JRE, not the "normal" JRE installed by e.g. Internet Explorer.


    regards


  • 6.  RE: Procurve Manager MYSQL problem

    Posted Jan 23, 2009 08:05 AM
    Correct. Boxx, I like the MySQL optimisations you made, hopefully ProCurve will take note of them for future releases.