From owner-freebsd-hackers@FreeBSD.ORG  Sat Jun  2 11:49:22 2012
Return-Path: <owner-freebsd-hackers@FreeBSD.ORG>
Delivered-To: freebsd-hackers@FreeBSD.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 1EE091065672;
	Sat,  2 Jun 2012 11:49:21 +0000 (UTC) (envelope-from flo@FreeBSD.org)
Received: from freefall.freebsd.org (freefall.freebsd.org
	[IPv6:2001:4f8:fff6::28])
	by mx1.freebsd.org (Postfix) with ESMTP id 9EB5C8FC0C;
	Sat,  2 Jun 2012 11:49:21 +0000 (UTC)
Received: from nibbler-wlan.fritz.box (localhost [127.0.0.1])
	by freefall.freebsd.org (8.14.5/8.14.5) with ESMTP id q52BnIm9046724;
	Sat, 2 Jun 2012 11:49:20 GMT (envelope-from flo@FreeBSD.org)
Message-ID: <4FC9FDBE.6080401@FreeBSD.org>
Date: Sat, 02 Jun 2012 13:49:18 +0200
From: Florian Smeets <flo@FreeBSD.org>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7;
	rv:14.0) Gecko/20120601 Thunderbird/14.0a2
MIME-Version: 1.0
To: Ivan Voras <ivoras@FreeBSD.org>
References: <jqac8f$6mn$1@dough.gmane.org>
	<1073159468.20120602121458@serebryakov.spb.ru>
	<4FC9D420.6010203@FreeBSD.org>
	<alpine.BSF.2.00.1206021054120.40882@wojtek.tensor.gdynia.pl>
	<4FC9D68D.60405@FreeBSD.org>
	<alpine.BSF.2.00.1206021228320.43360@wojtek.tensor.gdynia.pl>
	<CAF-QHFUhOF=aW5Y2LRByH5wi+KsezMyrZuUL0w0AQCNweEGTaA@mail.gmail.com>
In-Reply-To: <CAF-QHFUhOF=aW5Y2LRByH5wi+KsezMyrZuUL0w0AQCNweEGTaA@mail.gmail.com>
X-Enigmail-Version: 1.5a1pre
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enig66878B3AE858439F8C24EAC8"
Cc: Wojciech Puchar <wojtek@wojtek.tensor.gdynia.pl>, lev@FreeBSD.org,
	freebsd-hackers@FreeBSD.org
Subject: Re: SuperPages utilization survey
X-BeenThere: freebsd-hackers@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Technical Discussions relating to FreeBSD
	<freebsd-hackers.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>, 
	<mailto:freebsd-hackers-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-hackers>
List-Post: <mailto:freebsd-hackers@freebsd.org>
List-Help: <mailto:freebsd-hackers-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>,
	<mailto:freebsd-hackers-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 02 Jun 2012 11:49:22 -0000

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig66878B3AE858439F8C24EAC8
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On 02.06.12 12:48, Ivan Voras wrote:
> On 2 June 2012 12:29, Wojciech Puchar <wojtek@wojtek.tensor.gdynia.pl> =
wrote:
>>>>
>>>
>>> In my words i would say "It enables mysql to use super-pages/large-pa=
ges".
>>
>> i asked the question wrong. the right should be "how does it do". Beca=
use i
>> am not aware about any user level interface in FreeBSD to explicitly r=
equest
>> superpage mapping.
>=20
> You are right, there isn't any.
>=20
> The code in mysqld.cc only works if HAVE_SOLARIS_LARGE_PAGES is defined=
:
>=20
> 3229 #endif /* HAVE_LARGE_PAGES */
> 3230 #ifdef HAVE_SOLARIS_LARGE_PAGES
> 3231 #define LARGE_PAGESIZE (4*1024*1024)  /* 4MB */
> 3232 #define SUPER_LARGE_PAGESIZE (256*1024*1024)  /* 256MB */
> 3233   if (opt_large_pages)
> 3234   {
>=20
> ...
>=20
> 3278   }
> 3279 #endif /* HAVE_SOLARIS_LARGE_PAGES */
>=20

As far as i understand it does at least enable usage of pages up to 4MB,
perhaps someone should teach mysql about the FreeBSD's limits?

If you look at the output i sent, it certainly changes from using no
superpage mappings at all to using them to some degree, if you script
can be trusted :)

Florian


--------------enig66878B3AE858439F8C24EAC8
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----

iEYEARECAAYFAk/J/b4ACgkQapo8P8lCvwmWPACfWQh4jQ+1YxjrI+gnlxPz4gHf
BKYAniiyuZ6mSLFSEPKhAarxyZxhafNo
=K5bJ
-----END PGP SIGNATURE-----

--------------enig66878B3AE858439F8C24EAC8--