MySQL Bugs: #52911: Docs: please create a page that lists differences between icc / non-icc versions

Bug #52911	Docs: please create a page that lists differences between icc / non-icc versions
Submitted:	17 Apr 2010 3:57	Modified:	14 May 2010 14:13
Reporter:	Roel Van de Paar	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
A customer requested:
> What's the difference between icc versions and other versions (other than SSL)?

We do not have a clear page showing the differences.

Looking at the build options I can see there are significant differences:
- No SSL for icc builds
- No InnoDB plugin for icc builds
- Icc compiler used for icc builds

And there may be others. Could we create a page for this that lists the differences so that we can point customers to it?

How to repeat:
N/A

Suggested fix:
Create a non-icc <> icc page.

Compared the options and --without-plugin-innodb_plugin (icc build) and --with-ssl (non-icc build) were the only differences I could see there.

Differences in parameters:
non-icc build:
have_openssl	YES
have_ssl	YES
open_files_limit	16384

icc build:
have_openssl	NO
have_ssl	NO
open_files_limit	1024  < interesting!

Also, ICC build may be faster on some hardware.

Also see bug #52912

Could we also have some current benchmarks in the docs?

I know benchmarks can be misleading, but the only ones I can find are all >5 years old. Hopefully both compilers have advanced since then.

Closing this bug based on a request in bug #53358 to remove icc builds altogether.

Re-opening this bug based on some discussion about this. For the moment, icc and non-icc builds continue to exist. And, even if icc builds are removed, if customers want to do icc buidls themselves, they need to know that some things will not be included or will not work.

"open_files_limit	1024  < interesting!"

Is this the default? The maximum? Both?
Any idea why this occurs?

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.

Under http://dev.mysql.com/doc/refman/5.1/en/general-installation-issues.html I have created a new subsection:

http://dev.mysql.com/doc/refman/5.1/en/compiler-characteristics.html
(Compiler-Specific Build Characteristics)

The section title does not name "icc" so that it is more general and should more easily enable us to allow other related observations to be added in the future.

I have noted the SSL/InnoDB Plugin characteristics for icc listed in the bug report, and will extend it with other information as it is provided.