{"id":502,"date":"2005-10-28T16:09:25","date_gmt":"2005-10-28T06:09:25","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=502"},"modified":"2005-10-28T16:09:25","modified_gmt":"2005-10-28T06:09:25","slug":"arjen_lentz-mysql-thread-cache","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2005\/10\/28\/arjen_lentz-mysql-thread-cache\/","title":{"rendered":"arjen_lentz: MySQL thread cache"},"content":{"rendered":"

arjen_lentz: MySQL thread cache<\/a><\/p>\n

It should be noted however that creating and destroying threads on some platforms is a very very cheap operation. Linux with NPTL (esp on x86) is one such platform.<\/p>\n

(even without NPTL on x86 it’s stil pretty cheap).<\/p>\n

On PPC with LinuxThreads it’s quite expensive.<\/p>\n

On PPC with MacOS X it’s also very expensive.<\/p>\n

I think i’ve blogged about this previously.<\/p>\n

But users on MacOS X, Windows and Linux without NPTL should certainly consider using the thread cache. Otherwise, if you’re on x86 with NPTL you probably don’t have to bother – or at least you notice a very small benefit.<\/p>\n","protected":false},"excerpt":{"rendered":"

arjen_lentz: MySQL thread cache It should be noted however that creating and destroying threads on some platforms is a very very cheap operation. Linux with NPTL (esp on x86) is one such platform. (even without NPTL on x86 it’s stil … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[14],"tags":[],"class_list":["post-502","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-86","jetpack-related-posts":[{"id":417,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/06\/02\/gdb-bugs\/","url_meta":{"origin":502,"position":0},"title":"GDB bugs","author":"Stewart Smith","date":"2005-06-02","format":false,"excerpt":"Well, there's a GDB bug (in the known-problems list) that I am regularly hitting. It makes it go \"gdb internal error, would you like a core of GDB\". I'm running 6.3, what comes with Ubuntu. However, I'm now rebuilding gdb 6.1.1 in the hope that this will be more stable\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":463,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/09\/04\/memberdb-election-results-performance-on-new-laptop\/","url_meta":{"origin":502,"position":1},"title":"MemberDB election-results performance on new laptop","author":"Stewart Smith","date":"2005-09-04","format":false,"excerpt":"So I picked up my new laptop on friday. It's an ASUS V6V - nice and fast, light, good resolution screen and lots of disk and RAM (it came with 1GB, I've got 2GB). Anyway, the transfer of data from my PowerBook went fine. I waited for xfsdump to dump\u2026","rel":"","context":"In "cool gadgets"","block_context":{"text":"cool gadgets","link":"https:\/\/www.flamingspork.com\/blog\/category\/cool-gadgets\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3884,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/10\/14\/mysql-5-7-5-on-power-thread-priority\/","url_meta":{"origin":502,"position":2},"title":"MySQL 5.7.5 on POWER – thread priority","author":"Stewart Smith","date":"2014-10-14","format":false,"excerpt":"Good news everyone! MySQL 5.7.5 is out with a bunch more patches for running well on POWER in the tree. I haven't yet gone and tried it all out, but since I'm me, I look at bugs database and git\/bzr history first. On Intel CPUs, when you're spinning on a\u2026","rel":"","context":"In "IBM"","block_context":{"text":"IBM","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/ibm-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3758,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/06\/03\/mysql-5-7-on-power\/","url_meta":{"origin":502,"position":3},"title":"MySQL 5.7 on POWER","author":"Stewart Smith","date":"2014-06-03","format":false,"excerpt":"In a previous post, I covered porting MySQL 5.6 to POWER and subsequently, some new record performance numbers with MySQL 5.6.17 on POWER8. Well, those following at home will be aware that not only is the next sentence sponsored by IBM Legal, but that MySQL 5.7 alleviates a bunch of\u2026","rel":"","context":"In "code"","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3989,"url":"https:\/\/www.flamingspork.com\/blog\/2015\/08\/28\/doing-nothing-on-modern-cpus\/","url_meta":{"origin":502,"position":4},"title":"doing nothing on modern CPUs","author":"Stewart Smith","date":"2015-08-28","format":false,"excerpt":"Sometimes you don't want to do anything. This is understandably human, and probably a sign you should either relax or get up and do something. For processors, you sometimes do actually want to do absolutely nothing. Often this will be while waiting for a lock. You want to do nothing\u2026","rel":"","context":"In "code"","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3752,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/06\/03\/mysql-5-6-on-power-patch-available\/","url_meta":{"origin":502,"position":5},"title":"MySQL 5.6 on POWER (patch available)","author":"Stewart Smith","date":"2014-06-03","format":false,"excerpt":"The following sentence is brought to you by IBM Legal. The postings on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. Okay, now that is out of the way.... If you're the kind of person who follows the MySQL bugs database closely or subscribes\u2026","rel":"","context":"In "code"","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=502"}],"version-history":[{"count":0,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/502\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}