SpirirHost Support Centre: MySQL Reference Manual p.21

<< 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 1: General Information 21 appliances, public kiosks, turnkey hardware/software combination units, high performance internet servers, self-contained databases distributed on CD-ROM, etc. Many users of libmysqld will benet from the MySQL Dual Licensing. For those not wishing to be bound by the GPL, the software is also made available under a commercial license. The embedded MySQL library uses the same interface as the normal client library, so it is convenient and easy to use. See Section 8.4.9 [libmysqld], page 605. 1.5.4 Other Features Available From MySQL 4.0.0 Version 4.0 further increases the speed of MySQL Server in a number of areas, such as bulk INSERTs, searching on packed indexes, creation of FULLTEXT indexes, as well as COUNT(DISTINCT). The table handler InnoDB is now oered as a feature of the standard MySQL server, including full support for transactions and row-level locking. MySQL Server 4.0 will support secure trac between the client and the server, greatly increasing security against malicious intrusion and unauthorised access. Web applica- tions being a cornerstone of MySQL use, web developers have been able to use Secure Socket Layer (SSL) to secure the trac between the the end user browser and the web application, be it written in PHP, Perl, ASP or using any other web development tool. However, the trac between the development tool and the mysqld server process has been protected only by virtue of them being processes residing on computers within the same rewall. In MySQL Server 4.0, the mysqld server daemon process can itself use SSL, thus enabling secure trac to MySQL databases from, say, a Windows application residing outside the rewall. Our German, Austrian, and Swiss users will note that we have a new character set, latin_de, which corrects the German sorting order, placing German umlauts in the same order as German telephone books. Features to simplify migration from other database systems to MySQL Server include TRUNCATE TABLE (like in Oracle) and IDENTITY as a synonym for automatically incre- mented keys (like in Sybase). Many users will also be happy to learn that MySQL Server now supports the UNION statement, a long-awaited standard SQL feature. In the process of building features for new users, we have not forgotten requests by the community of loyal users. We have multi-table DELETE statements. By adding support for symbolic linking to MyISAM on the table level (and not just the database level as before), as well as by enabling symlink handling by default on Windows, we hope to show that we take enhancement requests seriously. Functions like SQL_CALC_FOUND_ ROWS and FOUND_ROWS() make it possible to know how many rows a query would have returned without a LIMIT clause. 1.5.5 Future MySQL 4.0 Features For the upcoming MySQL Server 4.x releases, expect the following features now still under development:

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