From owner-freebsd-hackers@FreeBSD.ORG Wed Jun 6 23:26:14 2012 Return-Path: Delivered-To: freebsd-hackers@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 06E0F106566C for ; Wed, 6 Jun 2012 23:26:14 +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 C173D8FC0A; Wed, 6 Jun 2012 23:26:13 +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 q56NQC8o024611; Wed, 6 Jun 2012 23:26:12 GMT (envelope-from flo@FreeBSD.org) Message-ID: <4FCFE714.6070502@FreeBSD.org> Date: Thu, 07 Jun 2012 01:26:12 +0200 From: Florian Smeets User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:14.0) Gecko/20120604 Thunderbird/14.0a2 MIME-Version: 1.0 To: Mark Felder References: <1073159468.20120602121458@serebryakov.spb.ru> <4FC9D420.6010203@FreeBSD.org> <4FC9D68D.60405@FreeBSD.org> <4FC9FDBE.6080401@FreeBSD.org> In-Reply-To: X-Enigmail-Version: 1.5a1pre Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig1DE882128519AB31F794ADD5" Cc: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 06 Jun 2012 23:26:14 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig1DE882128519AB31F794ADD5 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On 05.06.12 16:29, Mark Felder wrote: > On Sat, 02 Jun 2012 06:49:18 -0500, Florian Smeets wr= ote: >=20 >> As far as i understand it does at least enable usage of pages up to 4M= B, >> 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 >=20 > Wow, this is a nice find. If someone were to add a patch for FreeBSD's = =20 > superpages we might be able to get a nice little performance boost with= =20 > little effort. Even the increase to 4MB for now is a welcome improvemen= t. =20 > I'll make sure to put this in my toolbox.... I played with this some more. MySQL does not seem to use superpages. After a mysqld restart Ivan's script and procstat showed superpage mappings for mysqld, but it seems once MySQL "touches" the memory it's not in superpages anymore. I looked at the MySQL code a bit and one would need to add FreeBSD support in a couple of places. Perhaps I'll find some time to try this, but i cannot make any promises. Florian --------------enig1DE882128519AB31F794ADD5 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iEYEARECAAYFAk/P5xQACgkQapo8P8lCvwmoxACgijeaWkjFA7mQP4hbe0/MoUe6 vVgAoIgeo8s4SK1RobNTGZVcfjX4aeZQ =CiIp -----END PGP SIGNATURE----- --------------enig1DE882128519AB31F794ADD5--