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

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

644 MySQL Technical Reference for Version 4.0.3 (length of what is sorted + sizeof(database pointer)) * number of matched rows * 2 sizeof(database pointer) is usually 4, but may grow in the future for really big tables. For some SELECT queries, MySQL also creates temporary SQL tables. These are not hidden and have names of the form `SQL_*'. ALTER TABLE creates a temporary table in the same directory as the original table. A.4.5 How to Protect or Change the MySQL Socket File `/tmp/mysql.sock' If you have problems with the fact that anyone can delete the MySQL communication socket `/tmp/mysql.sock', you can, on most versions of Unix, protect your `/tmp' lesystem by setting the sticky bit on it. Log in as root and do the following: shell> chmod +t /tmp This will protect your `/tmp' lesystem so that les can be deleted only by their owners or the superuser (root). You can check if the sticky bit is set by executing ls -ld /tmp. If the last permission bit is t, the bit is set. You can change the place where MySQL uses / puts the socket le the following ways: Specify the path in a global or local option le. For example, put in /etc/my.cnf: [client] socket=path-for-socket-file [mysqld] socket=path-for-socket-file See Section 4.1.2 [Option les], page 186. Specifying this on the command-line to safe_mysqld and most clients with the -- socket=path-for-socket-file option. Specify the path to the socket in the MYSQL_UNIX_PORT environment variable. Dening the path with the configure option --with-unix-socket-path=path-for- socket-file. See Section 2.3.3 [congure options], page 83. You can test that the socket works with this command: shell> mysqladmin --socket=/path/to/socket version A.4.6 Time Zone Problems If you have a problem with SELECT NOW() returning values in GMT and not your local time, you have to set the TZ environment variable to your current time zone. This should be done for the environment in which the server runs, for example, in safe_mysqld or mysql.server. See Appendix F [Environment variables], page 770.

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