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

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

120 MySQL Technical Reference for Version 4.0.3 DROP TABLE on a table that is in use by a MERGE table will not work on Windows because MERGE handler does the table mapping hidden from the upper layer of MySQL. Because Windows doesn't allow you to drop les that are open, you rst must ush all MERGE tables (with FLUSH TABLES) or drop the MERGE table before dropping the table. We will x this at the same time we introduce VIEWs. DATA DIRECTORY and INDEX DIRECTORY directives in CREATE TABLE is ignored on Windows, because Windows doesn't support symbolic links. Here are some open issues for anyone who might want to help us with the Windows release: Make a single-user MYSQL.DLL server. This should include everything in a standard MySQL server, except thread creation. This will make MySQL much easier to use in applications that don't need a true client/server and don't need to access the server from other hosts. Add some nice start and shutdown icons to the MySQL installation. When registering mysqld as a service with --install (on NT) it would be nice if you could also add default options on the command-line. For the moment, the workaround is to list the parameters in the `C:\my.cnf' le instead. It would be really nice to be able to kill mysqld from the task manager. For the moment, you must use mysqladmin shutdown. Port readline to Windows for use in the mysql command-line tool. GUI versions of the standard MySQL clients (mysql, mysqlshow, mysqladmin, and mysqldump) would be nice. It would be nice if the socket read and write functions in `net.c' were interruptible. This would make it possible to kill open threads with mysqladmin kill on Windows. mysqld always starts in the "C" locale and not in the default locale. We would like to have mysqld use the current locale for the sort order. Add macros to use the faster thread-safe increment/decrement methods provided by Windows. Other Windows-specic issues are described in the `README' le that comes with the MySQL- Windows distribution. 2.6.3 Solaris Notes On Solaris, you may run into trouble even before you get the MySQL distribution unpacked! Solaris tar can't handle long le names, so you may see an error like this when you unpack MySQL: x mysql-3.22.12-beta/bench/Results/ATIS-mysql_odbc-NT_4.0-cmp-db2,\ informix,ms-sql,mysql,oracle,solid,sybase, 0 bytes, 0 tape blocks tar: directory checksum error In this case, you must use GNU tar (gtar) to unpack the distribution. You can nd a precompiled copy for Solaris at http://www.mysql.com/Downloads/. Sun native threads work only on Solaris 2.5 and higher. For Version 2.4 and earlier, MySQL will automatically use MIT-pthreads. See Section 2.3.6 [MIT-pthreads], page 89. If you get the following error from congure:

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