Description:
Installed 5.0.37 on Windows XP from ZIP (no installer) and noted that no mysqld-max.exe was present:
C:\mysql-5.0.37-win32\bin>ls mysqld*exe
mysqld-debug.exe mysqld-nt.exe mysqld.exe mysqldump.exe
According to the documentation (http://dev.mysql.com/doc/refman/5.0/en/mysqld-max.html), this should be present:
"For Windows, MySQL binary distributions include both the standard server (mysqld.exe) and the MySQL-Max server (mysqld-max.exe), so no special distribution is needed. Just use a regular Windows distribution. See Section 2.4.8, “Installing MySQL on Windows”."
According to the documentation, the Max version is required in order to use the FEDERATED storage engine (http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html):
"The FEDERATED storage engine is included in MySQL-Max binary distributions."
Indeed, running SHOW ENGINES on mysqld-nt.exe shows that FEDERATED is not enabled:
Your MySQL connection id is 1 to server version: 5.0.37-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show engines;
+------------+---------+--------------------------------------------------------
--------+
| Engine | Support | Comment
|
+------------+---------+--------------------------------------------------------
--------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance
|
| MEMORY | YES | Hash based, stored in memory, useful for temporary tabl
es |
| InnoDB | YES | Supports transactions, row-level locking, and foreign k
eys |
| BerkeleyDB | NO | Supports transactions and page-level locking
|
| BLACKHOLE | NO | /dev/null storage engine (anything you write to it disa
ppears) |
| EXAMPLE | NO | Example storage engine
|
| ARCHIVE | YES | Archive storage engine
|
| CSV | NO | CSV storage engine
|
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables
|
| FEDERATED | NO | Federated MySQL storage engine
|
| MRG_MYISAM | YES | Collection of identical MyISAM tables
|
| ISAM | NO | Obsolete storage engine
|
+------------+---------+--------------------------------------------------------
--------+
12 rows in set (0.00 sec)
mysql> select version();
+---------------------+
| version() |
+---------------------+
| 5.0.37-community-nt |
+---------------------+
1 row in set (0.00 sec)
How to repeat:
Install MySQL 5.0.37 on Windows. Try to find mysqld-max.exe or create FEDERATED tables.
Suggested fix:
Include mysqld-max.exe (or correct documentation). Correct build scripts to include FEDERATED, if it should be in mysqld-nt.exe.
