Date: Thu, 07 Jun 2012 01:26:12 +0200 From: Florian Smeets <flo@FreeBSD.org> To: Mark Felder <feld@feld.me> Cc: freebsd-hackers@FreeBSD.org Subject: Re: SuperPages utilization survey Message-ID: <4FCFE714.6070502@FreeBSD.org> In-Reply-To: <op.wffo7ogu34t2sn@tech304> 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%2BKsezMyrZuUL0w0AQCNweEGTaA@mail.gmail.com> <4FC9FDBE.6080401@FreeBSD.org> <op.wffo7ogu34t2sn@tech304>
next in thread | previous in thread | raw e-mail | index | archive | help
[-- Attachment #1 --] On 05.06.12 16:29, Mark Felder wrote: > On Sat, 02 Jun 2012 06:49:18 -0500, Florian Smeets <flo@freebsd.org> wrote: > >> 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 > > Wow, this is a nice find. If someone were to add a patch for FreeBSD's > superpages we might be able to get a nice little performance boost with > little effort. Even the increase to 4MB for now is a welcome improvement. > 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 [-- Attachment #2 --] -----BEGIN PGP SIGNATURE----- iEYEARECAAYFAk/P5xQACgkQapo8P8lCvwmoxACgijeaWkjFA7mQP4hbe0/MoUe6 vVgAoIgeo8s4SK1RobNTGZVcfjX4aeZQ =CiIp -----END PGP SIGNATURE-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4FCFE714.6070502>