Skip to main content

Joel Liu's Library tagged memory   View Popular

09 Jul 09

Choosing innodb_buffer_pool_size | MySQL Performance Blog

  • My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description.


    Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set correctly. I’ve seen a lot of clients which came through extreme sufferings leaving it at default value (8M). So if you have dedicated MySQL Box and you’re only using Innodb tables you will want to give all memory you do not need for other needs for Innodb Buffer Pool.


    This of course assumes your database is large so you need large buffer pool, if not – setting buffer pool a bit larger than your database size will be enough. You also should account for growth of course. You need buffer pool a bit (say 10%) larger than your data (total size of Innodb TableSpaces) because it does not only contain data pages – it also contain adaptive hash indexes, insert buffer, locks which also take some time. Though it is not as critical – for most workloads if you will have your Innodb Buffer Pool 10% less than your database size you would not loose much anyway.


    You also may choose to set buffer pool as if your database size is already larger than amount of memory you have – so you do not forget to readjust it later. This is also valid approach as if it is Dedicated MySQL Server you may not have a good use for that memory anyway.

  • The next step would be to decide How Much Memory do you need for other needs. This needs would be OS needs – your system processes, page tables, socket buffers etc all need memory. I would put this to 256M for small sized boxes to 5% of memory size on the big boxes, though it can be even less than that. Besides Operating System needs you also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which can be allocated. There are also things like innodb additional memory pool (which can grow more than memory you allocated for it, especially in case you have large amount of tables).
07 Aug 08

Want to Remember Everything You'll Ever Learn? Surrender to This Algorithm

  • Piotr Wozniak's quest for anonymity has been successful. Nobody along this string of little beach resorts recognizes him as the inventor of a technique to turn people into geniuses. A portion of this technique, embodied in a software program called SuperMemo, has enthusiastic users around the world. They apply it mainly to learning languages, and it's popular among people for whom fluency is a necessity — students from Poland or other poor countries aiming to score well enough on English-language exams to study abroad. A substantial number of them do not pay for it, and pirated copies are ubiquitous on software bulletin boards in China, where it competes with knockoffs like SugarMemo.
  • SuperMemo is based on the insight that there is an ideal moment to practice what you've learned. Practice too soon and you waste your time. Practice too late and you've forgotten the material and have to relearn it. The right time to practice is just at the moment you're about to forget. Unfortunately, this moment is different for every person and each bit of information. Imagine a pile of thousands of flash cards. Somewhere in this pile are the ones you should be practicing right now. Which are they?
  • 10 more annotations...
03 Oct 06

Jack Slocum’s Blog » 3 Easy Steps to Avoid JavaScript Memory Leaks

  • You may not know it, but almost every site you visit that uses JavaScript is leaking memory. That may sound like an exaggeration, but it’s true. Don’t believe me?


    Leak Monitor

    With this handy extension for FireFox, any time you leave a page and it leaves code pointing to JavaScript objects - it displays a popup with details about the leak. It even gives you details about the function or object that created the leak.

02 Mar 06

Simple Memorizing Techniques

  • First, memory works by association. Our mind is a complex web of interconnected
    thoughts and when one thing is called to mind, related concepts are
    automatically triggered. We can’t hear the name ‘Romeo’ without thinking
    ‘Juliet’. Drinking café au lait with a croissant immediately reminds us of
    Paris.

BrainConnection.com - How We Remember, and Why We Forget - Page 1

  • I remember my mother's vegetable garden when I was a child, corn plants tall
    like skyscrapers. I remember when I fell out of a tree and everyone from the
    neighbor's barbecue rushed over to see if I'd broken a bone.
  • subconscious. Modern descriptions are dominated by analogies to computers, in
    which the human brain is a hard disk that stores experience in electronic files
    and folders. Typical of biology, the truth is at once more complicated and more
    beautiful than any of these descriptions.
1 - 8 of 8
Showing 20 items per page

Diigo is about better ways to research, share and collaborate on information. Learn more »

Join Diigo