3 messages in com.mysql.lists.win32RE: MySQL Server will not stay running.
FromSent OnAttachments
Jon Valentine27 Sep 2004 21:36 
Danny Willis28 Sep 2004 07:35 
rol...@MUZE.com28 Sep 2004 07:46 
Subject:RE: MySQL Server will not stay running.
From:rol...@MUZE.com (rol@MUZE.com)
Date:09/28/2004 07:46:24 AM
List:com.mysql.lists.win32

I am currently using MySQL 4.0.21-max-nt (using MySQL since 4.0.12) What I would usually do is to schedule a task that kicks off everyday at 6AM to run the following from a DOS batch file:

start /w mysqladmin -uroot -p<password> shutdown set delay=3200 :next_tick set /A delay=%delay%-1 if not %delay%==0 goto next_tick start mysqld-max-nt -h<data home> [other optional startup parameters]

For my PC running WinNT4.0 @ 600 MHz, MySQL would shutdown, wait 10 seconds, then restart. You would have to set the delay number higher for faster machines.

Thus, a fresh server startup, freshly reallocated memory. Starting off with connection #1.

I have gotten away from using WinMySQLAdmin as a startup service, many months ago which does exactly what you have been describing.

I hope this helps !!!

-----Original Message----- From: Jon Valentine [mailto:jonv@comcast.net] Sent: Tuesday, September 28, 2004 12:37 AM To: win@lists.mysql.com Subject: MySQL Server will not stay running.

Dear Mr. Widenius,

I have been using MySQL 4.0.18 since January 2004. I have never had a problem with it until recently. About a month ago I noticed that the MySQL service had become disabled and not running. I set the service to automatic and started the service. Everything was fine for about 24 hours, and then it became disabled again. I have searched the mysql website for an answer and can not find a solution. If you have any suggestions I would greatly appreciate it.

My system configuration is a follows:

Operating System: Microsoft Windows Server 2003 Standard Edition

DBMS: MySQL 4.0.18

MySQL Server Installed as: mysqld-nt

MySQL option file contains the following and is located at C:\my.cnf:

[mysqld]

basedire=f:/mysql

datadir=f:/mysql/data

If you can please give me some advice I would greatly appreciate it.

Sincerely,

Jon Valentine