Professional Web Applications Themes

CPU usage of mysql on windows 2000. - MySQL

Hi, I'd like to know about mysql... I have a web application that use windows mysql on Windows2000. When I query something from Web application, CPU usage of mysql daemon goes up to 90% and go down when query has done. (it's normal state... ) Sometimes it goes up to 90% and nerver go down again...it stay at 90%.. even if querey had done. I'd like to heare about CPU usage of mysql daemon. Is there any bug reporting about cpu usage of mysql? A.there is problem with mysql itself? B.there is problem with Windows 2000 between mysql? Any opinion ...

  1. #1

    Default CPU usage of mysql on windows 2000.

    Hi,
    I'd like to know about mysql...

    I have a web application that use windows mysql on Windows2000.
    When I query something from Web application, CPU usage of mysql daemon
    goes up to 90% and go down when query has done.
    (it's normal state... )

    Sometimes it goes up to 90% and nerver go down again...it stay at 90%..
    even if querey had done.


    I'd like to heare about CPU usage of mysql daemon.
    Is there any bug reporting about cpu usage of mysql?

    A.there is problem with mysql itself?
    B.there is problem with Windows 2000 between mysql?

    Any opinion will help me!!!

    Have a day.


    somez72 Guest

  2. #2

    Default Re: CPU usage of mysql on windows 2000.

    somez72 wrote:
    > Hi,
    > I'd like to know about mysql...
    >
    > I have a web application that use windows mysql on Windows2000.
    > When I query something from Web application, CPU usage of mysql daemon
    > goes up to 90% and go down when query has done.
    > (it's normal state... )
    >
    > Sometimes it goes up to 90% and nerver go down again...it stay at 90%..
    > even if querey had done.
    >
    >
    > I'd like to heare about CPU usage of mysql daemon.
    > Is there any bug reporting about cpu usage of mysql?
    >
    > A.there is problem with mysql itself?
    > B.there is problem with Windows 2000 between mysql?
    >
    > Any opinion will help me!!!
    >
    > Have a day.
    >
    >
    1. Did you check the bugs list on [url]www.mysql.com?[/url]
    2. Not here.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    [email]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

  3. #3

    Default Re: CPU usage of mysql on windows 2000.

    somez72 wrote:
    > Hi,
    > I'd like to know about mysql...
    >
    > I have a web application that use windows mysql on Windows2000.
    > When I query something from Web application, CPU usage of mysql daemon
    > goes up to 90% and go down when query has done.
    > (it's normal state... )
    >
    > Sometimes it goes up to 90% and nerver go down again...it stay at 90%..
    > even if querey had done.
    >
    >
    > I'd like to heare about CPU usage of mysql daemon.
    > Is there any bug reporting about cpu usage of mysql?
    >
    > A.there is problem with mysql itself?
    > B.there is problem with Windows 2000 between mysql?
    >
    > Any opinion will help me!!!
    >
    > Have a day.
    Some of the following questions would help to diagnose this problem.

    What version of MySQL are you using?
    What is the SQL query executing at the time of high CPU load?
    What is the DDL of tables used in that SQL query? Indexes?
    What does EXPLAIN tell you about the SQL query?
    If you are using MySQL 5.0+, do you have any triggers executing because
    of the query?
    What does SHOW PROCESSLIST and SHOW INNODB STATUS tell you during the
    time of high CPU load?
    What information can you get from the MySQL error log, or the Windows
    Event viewer?
    Is the MySQL system tray application running?
    Is the MySQL instance manager application running?
    What web application technology are you using (PHP/ASP/Java/etc.)
    Does this CPU usage behavior happen when running the same query against
    the same data on other operating systems?

    Regards,
    Bill K.
    Bill Karwin Guest

  4. #4

    Default Re: CPU usage of mysql on windows 2000.

    What do expect - after all it is "windows". :)

    onedbguru@firstdbasource.com Guest

Similar Threads

  1. CF5 / MySQL 4.1 / Windows 2000 ODBC Setup
    By poger67 in forum Coldfusion Database Access
    Replies: 1
    Last Post: September 27th, 04:17 PM
  2. authenticating users using their windows login with cf 4and windows server 2000
    By hisaku in forum Coldfusion Server Administration
    Replies: 0
    Last Post: June 16th, 09:22 PM
  3. CF5 vs MySQL on windows 2000
    By disch in forum Coldfusion Database Access
    Replies: 7
    Last Post: March 31st, 02:54 PM
  4. Replies: 3
    Last Post: October 28th, 03:24 PM
  5. CDO for Windows 2000 vs CDO for Exchange 2000
    By in forum ASP.NET General
    Replies: 2
    Last Post: July 11th, 12:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139