Windows Packages
Contents |
[edit] MySQL Packages for Windows
One question that people often ask is, "what is the difference between MySQL Server Essentials and Max packages for Windows?" Neither the download web page nor the documentation are very clear on this point.
Based on MySQL Server 5.0.26, I installed both packages and examined the differences.
File bin\mysqld.exe is identical in both editions.
[edit] Files included in Essentials but not in Max
Paths are relative to the MySQL Server installation directory, e.g. C:\Program Files\MySQL\MySQL Server 5.0\.
- scripts/fill_help_tables.sql
- scripts/mysql_fix_privilege_tables.sql
[edit] Files included in Max but not in Essentials
Paths are relative to the MySQL Server installation directory, e.g. C:\Program Files\MySQL\MySQL Server 5.0\.
- bin/comp-err.exe
- bin/mysql_client_test.exe
- bin/mysqld-debug.exe
- bin/mysqld-max-nt.exe
- bin/mysqld-max.exe
- bin/mysqlmanager.exe
- bin/mysqltest.exe
- bin/replace.exe
- Docs/ChangeLog
- Docs/COPYING
- Docs/INSTALL-BINARY
- Docs/manual.chm
I ran the various binaries, with "--help --verbose" options" and compared the output. From this I inferred the difference in the binaries.
[edit] Features enabled in mysqld-max and mysqld-max-nt
These features are not enabled in mysqld or mysqld-nt.
- BDB storage engine. See The BDB (BerkeleyDB) Storage Engine. Note that starting in MySQL 5.1.12, BDB will not be included and will be supported only as a plugin; see Brian Aker's blog "BDB Engine Removal"
[edit] Features enabled in mysqld-nt and mysqld-max-nt
These features are not enabled in mysqld and mysqld-max.
- --enable-named-pipe option (default value: FALSE).
[edit] Features enabled in mysqld-debug
Comparing mysqld-debug to mysqld-max releals these differences:
- --debug option (default value: "d:t:i:O,\mysqld.trace"); see Creating Trace Files
- --one-thread option; see Debugging mysqld under gdb
- --skip-safemalloc option; see Compiling MySQL for Debugging
- bdb_cache_size is 8388572 in mysqld-debug, 8388600 in mysqld-max
- sort_buffer_size is 262108 in mysqld-debug, 262136 in mysqld-max
[edit] See also
[Category:Windows]