Starting from the control panel is the same. I'm not sure about WINS and DNS (I didn't set
up my office box myself), but as far as I can see WINS and DNS are not running here (I
would see it somewhere in the process list or the services control panel, wouldn't I?)
I tried upgrading the workstation to SP6a. This obviously didn't break anything, but with
regard to MySQL it didn't help either: I still get 99% CPU load. The sun is still not
shining for me.
Answering a previous question: I fail to run MySQL on two different computers. One is my
NT box at home: WinNT4 workstation SP3, running in a miniature network with a Linux box
and with a dialup internet connection. I set up this box myself.
The other is my office NT box: WinNT4 workstation, previously also SP3, now SP6a. This one
runs in a large corporate network, accessing the internet via a gateway. My IT guys set up
this box for me.
Both have in common almost all software that I'm using. Both are heavily "unixified" with
CygWin, NTEmacs, lynx, ncftp, TeX and friends. Both run only antivirus software as 3rd
party services (some old McAfee at home, Dr. Solomon in the office), but I can switch
them off with no effect on the MySQL problem. Both have the same versions of MS Office
that I rarely use and the same version of Netscape. Besides that there's a boatload of
tools like Acrobat reader, Ghostview/Ghostscript, jade, perl etc.
BTW I always run my MySQL CPU tests when no other applications are running. So if at all
other software interferes, it's either other servives or probably a library
incompatibility problem due to the installation of some software.
So I'm again pretty much clueless.
regards,
Markus
gretchenl writes:
> I know you tried to start the service with net start, what happens if you
> try to start it with the services control panel. Also, do you have anything
> running like WINS or DNS on these machines? Is this NT Server or
> Workstation?
>
> gl
>
> ----- Original Message -----
> From: "Markus Hoenicka" <Markus.Hoenicka@stripped>
> To: <sinisa@stripped>; <win32@stripped>
> Sent: Wednesday, 31 May, 2000 10:21 AM
> Subject: Re: Revisited: mysqld-shareware eats CPU time
>
>
> > [My apologies to all who get bored by this stuff and wish me to perish or
> otherwise get off the list. This problem is still a problem, and Sinisa
> suggested to write to this list again, so the MySQL Win32 guru has a chance
> to listen.]
> >
> > The short version:
> > mysqld-shareware.exe uses 99% CPU time when running either as a NT service
> or standalone. This is not induced by running queries or anything. Just
> starting the service lets the CPU usage soar up and remain high until the
> service is stopped again.
> >
> > The long version:
> > I tried to run mysqld-shareware.exe (3.22.34) on two different computers.
> Both are WinNT 4.0 with service pack 3. One is a PII 266 with 64Mb RAM, the
> other a PII 466 with 128Mb RAM. These computers were set up by different
> people (I set up my home box, the IT guys set up my office box), but most
> 3rd party software is installed on both computers. If one of the installed
> software packages interferes, it'll hit both computers.
> >
> > The installation runs smooth. I finally used the default configuration, so
> programs and data end up in c:\mysql. This is a FAT drive fwiw, but nothing
> changes if I install to d:\mysql which is a NTFS drive. I can run
> mysqld-shareware --install without problems. Mysql will then show up in the
> services module. As soon as I start mysqld with net start mysql, the CPU
> usage goes up to 99% for the mysqld process and stays there until I kill the
> process. mysqld does not hang, however. It will answer queries, but at a
> speed that mysql was not designed for. Running mysqld-shareware --standalone
> shows the same problem.
> >
> > As reported previously, I run a few tests to find out what's going on:
> > 1) I shut down all 3rd party services that might magically interfere, like
> anti-virus software. Didn't help.
> >
> > 2) I removed mysql completely and reinstalled with default settings, i.e.
> in c:\mysql. Didn't help.
> >
> > 3) I ran mysqld as standalone with all --no-something switches to exclude
> e.g. network problems. Didn't help.
> >
> > 4) I grabbed an older version (3.22.30). Didn't help.
> >
> > 5) I unplugged the network cable and rebooted. Didn't help.
> >
> > 6) I switched to a variety of ports other than 3306, just in case some app
> gone wild clogs this port with junk. Didn't help.
> >
> > 7) I tried a different database server (msql), just to make sure that my
> boxes don't hate database servers by nature. msql runs like a charm.
> >
> > MySQL is completely painless on Linux, but at work this is no option
> (unfortunately). I'd like to resolve this problem so I don't have to port
> everything to msql.
> >
> > Any help is greatly appreciated.
> >
> > Markus
> >
> > sinisa@stripped writes:
> > >
> > >
> > > OK, I have spoken to the guy.
> > >
> > > Please send your mail with detailed description of the problem to
> > > win32@stripped.
> > >
> > > Regards,
> > >
> > > Sinisa
> > >
> > >
> +----------------------------------------------------------------------+
> > > | TcX ____ __ _____ _____ ___ == mysql@stripped
> |
> > > | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> |
> > > | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped
> |
> > > | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
> |
> > > | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> |
> > > | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> |
> > > | /*/ \*\ Developers Team
> |
> > >
> +----------------------------------------------------------------------+
> >
> > --
> > Markus Hoenicka
> > UT Houston Medical School
> > Dept. of Integrative Biology and Pharmacology
> > 6431 Fannin MSB4.114
> > Houston, TX 77030
> > (713) 500-6313, -7477
> > (713) 500-7444 (fax)
> > Markus.Hoenicka@stripped
> > http://ourworld.compuserve.com/homepages/hoenicka_markus/
> >
> >
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> > posting. To request this thread, e-mail win32-thread2729@stripped
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail win32-unsubscribe@stripped instead.
> >
>
--
Markus Hoenicka
UT Houston Medical School
Dept. of Integrative Biology and Pharmacology
6431 Fannin MSB4.114
Houston, TX 77030
(713) 500-6313, -7477
(713) 500-7444 (fax)
Markus.Hoenicka@stripped
http://ourworld.compuserve.com/homepages/hoenicka_markus/
