…do not fit into the buffer pool, then worst case you could be reading the same page multiple times into the buffer…would like to quickly explain here, and …5.5. You can read more about these variables… let’s see how effective are …memory workload. BKA makes a huge …6. Next interesting thing are the last…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL takes much more memory than you…how much memory Innodb has allocated. In fact this is often one of the first things I do…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
…how you make InnoDB behave like PostgreSQL 
If the undo log space grows really big, it won’t fit in the buffer…was done, I ran a quick Perl script on the… at all. Some interesting things to note: the load …do something like this I’ll try smaller chunks, such as 10k rows; and I’ll try to collect more…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
…you use the buffer only once. What can be done to speed things up here ? Of course you can tune you malloc settings so more buffers…makes sense. If you would keep say 20*2MB read buffers in the pool you could just grab one having allocation very quick…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
…do not understand what LVM could be doing to make things… how Innodb would do buffer …quickly reduce. Though still it takes some time and I would expect any system doing…do more benchmarks – for example I’m very curios how good is read speed from snapshot (in particular sequential file reads). If you…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…you a full rundown over every option in the file. But again, you learn quickly…thing, all the values are in big units, so it’s hard to read. If the InnoDB buffer…making your overall architecture more scalable.” And the client said “that’s all? Didn’t you do…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…quickly by MySQL. The moment you give someone access to MySQL Server, all MySQL Security guarantees is you…buffers such data until you…things. As you can see from these points it does not looks like MySQL tries to make…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…you through the installation and configuration because things changed along the way. Installation In order to use the patch first you…make it fairly easy even for those of you, who do…buffer…quickly when logging all the queries. This parameter allows you to get the full sessions logged while doing…
Post: Living with backups
November 6, 2008 By 28 Comments
… have dedicated buffers only to …quick enough. What can be done about it? Nothing really when you are using mysqldump. You… not something you can do with …allows to affect how I/O…you can enjoy experimenting with ionice. It could be also possible to make… also be more sphisticated or include things like…
