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

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

22 MySQL Technical Reference for Version 4.0.3 Mission-critical, heavy-load users of MySQL Server will appreciate the additions to our replication system and our online hot backup. Later versions of 4.0 will include fail- safe replication; already existing in 4.0.0, the LOAD DATA FROM MASTER command will soon automate slave setup. The online backup will make it easy to add a new replication slave without taking down the master, and have a very low performance penalty on update-heavy systems. A convenience feature for Database Administrators is that mysqld parameters (startup options) can soon be set without taking down the servers. The new FULLTEXT search properties of MySQL Server 4.0 enable the use of FULLTEXT indexing of large text masses with both binary and natural-language searching logic. Users can customise minimal word length and dene their own stop word lists in any human language, enabling a new set of applications to be built on MySQL Server. Many read-heavy applications will benet from further increased speed through the rewritten key cache. Many developers will also be happy to see the MySQL command help in the client. 1.5.6 MySQL 4.1, The Following Development Release Internally, through a new .frm le format for table denitions, MySQL Server 4.0 lays the foundation for the new features of MySQL Server 4.1 and onward, such as nested subqueries, stored procedures, and foreign key integrity rules, which form the top of the wish list for many of our customers. Along with those, we will also include simpler additions, such as multi-table UPDATE statements. After those additions, critics of the MySQL Database Server have to be more imaginative than ever in pointing out deciencies in the MySQL Database Management System. For long already known for its stability, speed, and ease of use, MySQL Server will then match the requirement checklist of very demanding buyers. 1.6 MySQL Information Sources 1.6.1 MySQL Portals The MySQL Portals (http://www.mysql.com/portal/) represent the ultimate resource to nd MySQL AB Partners, as well as books, or other MySQL-related solutions that you may be looking for. Items are categorised and rated in order to make it easy for you to locate information. By registering as a user, you will have the ability to comment on and rate items presented in portals. You will also receive relevant newsletters according to your user prole that you may update at any time. Some of the current MySQL Portal categories include: Partners Find MySQL AB partners worldwide.

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