Bug #55572 Incorrect info in "Windows vs Unix"
Submitted: 26 Jul 2010 23:49 Modified: 2 Aug 2010 16:06
Reporter: Vladislav Vaintroub Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[26 Jul 2010 23:49] Vladislav Vaintroub
Description:
http://dev.mysql.com/doc/refman/5.5/en/windows-vs-unix.html 
lists number of facts that are not true anymore on Windows.

- The section "Concurrent reads" talks about the limitation that was fixed in 5.5  in course of Bug#24509 fix

- the behavior described in "Blocking read" was fixed in Bug#31621

- The ALTER TABLE and DROP TABLE sections are incorrect, we open files with FILE_SHARE_DELETE so it is possible to delete files that are in use.

- DATA DIRECTORY and INDEX DIRECTORY section says windows does not support symbolic links. It should say instead: MySQL on does not yet support  Windows symbolic links (Windows does support symbolic links actually, and directory symlinks known as junctions have been there since Windows 2000)

- Access denied for user error 
is misleading, windows resolved "localhost" and 127.0.0.1 correctly, I have not seen any reports stating otherwise.

- Add macros to use the faster thread-safe increment/decrement methods provided by Windows. 

This is not a limitation and this is already done.

I'm not sure whether "Limited number of ports" is correct (citation needed? bug#?)m, same about "Problems with pipes"

I'd also propose to change wording in "DROP DATABASE" section from

You cannot drop a database that is in use by some thread. 
to 
You cannot drop a database that is in use by some connection.

(users think in terms of connections, not in terms of threads)

How to repeat:
Read http://dev.mysql.com/doc/refman/5.5/en/windows-vs-unix.html
[27 Jul 2010 0:28] MySQL Verification Team
Thank you for the bug report.
[2 Aug 2010 16:06] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.