Dyntex.net Support Centre: MySQL Reference Manual p.627

<< 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

Appendix A: Problems and Common Errors 627 Appendix A Problems and Common Errors This chapter lists some common problems and error messages that users have run into. You will learn how to gure out what the problem is, and what to do to solve it. You will also nd proper solutions to some common problems. A.1 How to Determine What Is Causing Problems When you run into problems, the rst thing you should do is to nd out which program / piece of equipment is causing problems: If you have one of the following symptoms, then it is probably a hardware (like memory, motherboard, CPU, or hard disk) or kernel problem: The keyboard doesn't work. This can normally be checked by pressing Caps Lock. If the Caps Lock light doesn't change you have to replace your keyboard. (Before doing this, you should try to reboot your computer and check all cables to the keyboard.) The mouse pointer doesn't move. The machine doesn't answer to a remote machine's pings. Dierent, unrelated programs don't behave correctly. If your system rebooted unexpectedly (a faulty user level program should never be able to take down your system). In this case you should start by checking all your cables and run some diagnostic tool to check your hardware! You should also check if there are any patches, updates, or service packs for your operating system that could likely solve your problems. Check also that all your libraries (like glibc) are up to date. It's always good to use a machine with ECC memory to discover memory problems early! If your keyboard is locked up, you may be able to x this by logging into your machine from another machine and execute kbd_mode -a on it. Please examine your system log le (/var/log/messages or similar) for reasons for your problems. If you think the problem is in MySQL then you should also examine MySQL's log les. See Section 4.9.3 [Update log], page 309. If you don't think you have hardware problems, you should try to nd out which program is causing problems. Try using top, ps, taskmanager, or some similar program, to check which program is taking all CPU or is locking the machine. Check with top, df, or a similar program if you are out of memory, disk space, open les, or some other critical resource. If the problem is some runaway process, you can always try to kill it. If it doesn't want to die, there is probably a bug in the operating system.

MySQL Reference Manual

Our Partners

SpiritHost - web hosting for spiritual and education sites
SpiritHit.com - Religious and Spiritual Portal

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