SpirirHost Support Centre: MySQL Reference Manual p.115

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

Chapter 2: MySQL Installation 115 Once running, mysqld-max-nt can be stopped using mysqladmin, from the Services utility or by using the command NET STOP MySQL. When running as a service, the operating system will automatically stop the MySQL service on computer shutdown. In MySQL versions < 3.23.47, Windows only waited for a few seconds for the shutdown to complete, and killed the database server process if the time limit was exceeded (potentially causing problems). For instance, at the next startup the InnoDB table handler had to do crash recovery. Starting from MySQL version 3.23.48, the Windows will wait longer for the MySQL server shutdown to complete. If you notice this is not enough for your intallation, it is safest to run the MySQL server not as a service, but from the Command prompt, and shut it down with mysqladmin shutdown. There is a problem that Windows NT (but not Windows 2000/XP) by default only waits 20 seconds for a service to shut down, and after that kills the service process. You can increase this default by opening the Registry Editor `\winnt\system32\regedt32.exe' and editing the value of WaitToKillServiceTimeout at `HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control in the Registry tree. Specify the new larger value in milliseconds, for example 120000 to have Windows NT wait upto 120 seconds. Please note that when run as a service, mysqld-max-nt has no access to a console and so no messages can be seen. Errors can be checked in `c:\mysql\data\mysql.err'. If you have problems installing mysqld-max-nt as a service, try starting it with the full path: C:\> C:\mysql\bin\mysqld-max-nt --install If this doesn't work, you can get mysqld-max-nt to start properly by xing the path in the registry! If you don't want to start mysqld-max-nt as a service, you can start it as follows: C:\> C:\mysql\bin\mysqld-max-nt --standalone or C:\> C:\mysql\bin\mysqld --standalone --debug The last method gives you a debug trace in `C:\mysqld.trace'. See Section E.1.2 [Making trace les], page 759. 2.6.2.3 Running MySQL on Windows MySQL supports TCP/IP on all Windows platforms and named pipes on NT/2000/XP. The default is to use named pipes for local connections on NT/2000/XP and TCP/IP for all other cases if the client has TCP/IP installed. The host name species which protocol is used: Host name Protocol NULL (none) On NT/2000/XP, try named pipes rst; if that doesn't work, use TCP/IP. On 9x/Me, TCP/IP is used. . Named pipes localhost TCP/IP to current host hostname TCP/IP

MySQL Reference Manual

Home
Hosting Plans \| Domain Registration \| About Us \| Contact Us \| Site Map Terms of Use \| Privacy Policy \| Guarantees Merchant Accounts

SpiritHost - web hosting for spiritual and education sites SpiritHit.com - Religious and Spiritual Portal Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide