SpirirHost Support Centre: MySQL Reference Manual p.372

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

372 MySQL Technical Reference for Version 4.0.3 changed the limit, the default value can be restored by using a SQL_SELECT_ LIMIT value of DEFAULT. SQL_LOG_OFF = 0 | 1 If set to 1, no logging will be done to the standard log for this client, if the client has the SUPER privilege. This does not aect the update log! SQL_LOG_UPDATE = 0 | 1 If set to 0, no logging will be done to the update log for the client, if the client has the SUPER privilege. This does not aect the standard log! SQL_QUOTE_SHOW_CREATE = 0 | 1 If set to 1, SHOW CREATE TABLE will quote table and column names. This is on by default, for replication of tables with fancy column names to work. Sec- tion 4.5.6.8 [SHOW CREATE TABLE], page 267. TIMESTAMP = timestamp_value | DEFAULT Set the time for this client. This is used to get the original timestamp if you use the update log to restore rows. timestamp_value should be a Unix epoch timestamp, not a MySQL timestamp. LAST_INSERT_ID = # Set the value to be returned from LAST_INSERT_ID(). This is stored in the update log when you use LAST_INSERT_ID() in a command that updates a table. INSERT_ID = # Set the value to be used by the following INSERT or ALTER TABLE command when inserting an AUTO_INCREMENT value. This is mainly used with the update log. 5.6 Disk Issues As mentioned before, disks seeks are a big performance bottleneck. This problems gets more and more apparent when the data starts to grow so large that eective caching becomes impossible. For large databases, where you access data more or less randomly, you can be sure that you will need at least one disk seek to read and a couple of disk seeks to write things. To minimise this problem, use disks with low seek times. Increase the number of available disk spindles (and thereby reduce the seek overhead) by either symlink les to dierent disks or striping the disks. Using symbolic links This means that you symlink the index and/or datale(s) from the normal data directory to another disk (that may also be striped). This makes both the seek and read times better (if the disks are not used for other things). See Section 5.6.1 [Symbolic links], page 373. Striping Striping means that you have many disks and put the rst block on the rst disk, the second block on the second disk, and the Nth on the (N mod number of disks) disk, and so on. This means if your normal data

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