Bug #17336 Large file support wanted for QNX
Submitted: 13 Feb 2006 3:24 Modified: 11 Apr 2006 19:25
Reporter: Robert Rutherford
Status: Closed
Category:Server Severity:S4 (Feature request)
Version:4.1.16, 5.0 OS:Other (QNX)
Assigned to: Kent Boortz Target Version:
Triage: D5 (Feature request)

[13 Feb 2006 3:24] Robert Rutherford 
Description:
We request that large file support be enabled in the standard binaries for QNX.

While QNX does not support large files in their current native filesystem implementation,
large file support is present within the OS itself and is also offered by various third
party filesystems.

In addition, the lack of large file support means that InnoDB "raw" partition support is
limited to 2GB.

As a result of this lack of support, we have been forced to build our own binaries from
source rather than being able to rely on the official MySQL versions. This has obvious
negative implications for support etc.

We are members of MySQL Network but cannot use the certified versions.

How to repeat:
Not applicable.

Suggested fix:
We built a version from the source distribution which supports large files simply by
adding -D_FILE_OFFSET_BITS=64 to the configure command.

FYI the full command-line we used with configure was something like:

CC=qcc CFLAGS="-D_FILE_OFFSET_BITS=64 -O3 -fno-omit-frame-pointer" CXX=qcc CXXFLAGS="-O3
-fno-omit-frame-pointer -fno-exceptions -felide-constructors -fno-rtti" ./configure
--prefix=/usr/local/mysql --enable-local-infile --with-extra-charsets=complex

We have tested this version extensively using InnoDB "raw" disk partitions of over 100GB
and have experienced no problems or concerns.
[6 Mar 2006 13:44] Valeriy Kravchuk 
Thank you for a reasonable feature request.
[21 Mar 2006 22:54] Kent Boortz 
Changed build script to define large file support for build
of MySQL server on QNX. Will be in 5.0.20 and 5.1.8.
[11 Apr 2006 19:25] Mike Hillyer 
Documented in 5.0.20 and 5.1.8 changelogs:

      <listitem>
        <para>
          Large file support added to build for <literal>QNX</literal>
          platform. (Bug #17336)
        </para>
      </listitem>