Bug #17336 Large file support wanted for QNX
Submitted: 13 Feb 2006 2:24 Modified: 11 Apr 2006 17:25
Reporter: Robert Rutherford Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:4.1.16, 5.0 OS:Other (QNX)
Assigned to: Kent Boortz CPU Architecture:Any

[13 Feb 2006 2: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 12:44] Valeriy Kravchuk
Thank you for a reasonable feature request.
[21 Mar 2006 21: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 17: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>