…a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of…a lot of “bad file descriptor” errors. I was able to get the server up with –skip-grant-tables and insert a…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… significantly larger than the InnoDB buffer pool (thus leading to a lot of buffer pool disk reads) but still small enough to fit… building a separate kernel module in addition to whatever flash memory driver you’ve already had to install, and then further configuration requires… give a slight edge to FlashCache due to configuration flexibility, but if the GA release of vCache added some of FlashCache’s additional configuration options…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… phase and hence its rather complex configuration. Probably most readers of this blog know (or should …In summary, you need to interleave the allocation of memory for the MySQL process using the numactl utility…:03:36. Also, the server is reading a lot (~150MB/s) but doing very little physical writes…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… whether someone installed a 32-bit OS on 64-bit hardware, which is important if you want to allocate a lot of memory to mysqld. Next I look at a couple of all-in-one commands. For example… /usr/libexec/mysqld is a 64-bit build, if I’m on a 64-bit OS. Examining MySQL configuration Then I’ll look…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… to worry about memory usage are quite understandable. If you configure MySQL Server so it uses too small amount of memory it will likey… have very large memory requrement for this step, especially specially crafted ones. Stored Procedures. Compex stored procedures may require a lot of memory Prepared statements… something (drop me a note if you have something to add). But the main point is – there are a lot of memory consumers out where…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… thing to note with memory allocation is it is rather volatile – a lot of memory might be allocated for very short period of time and hence… functionality is implemented not only it can help DBA to configure memory allocation a lot more successful but I also believe similar to Performance…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
One of the most painful troubleshooting tasks with MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL… Cache Related Allocations There are cases when MySQL will allocate a lot of memory for table cache, especially if you’re using large blobs…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…, is a dual core machine with the following CPU configuration: 2xIntel(R) Core(TM)2 CPU 6600 @ 2.40GHz. The amount of memory installed is 8G and the MySQL datadir is on a… table with a where clause on a ‘non-indexed’ column In this test we can clearly see that Hash Join gives a lot of reduction…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… an external user of Innodb point of view) is that performance bugs don’t receive very hi priority. Yet, a lot of us are using… you may need to increase size of your Innodb log files to be able to use a lot of memory for write buffering efficiently. Q30… ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory…
Post: Speedup your LAMP stack with LigHTTPD
May 21, 2006 By 14 Comments
… amount of processes if you have many clients. As processes service all requests they can get you end up having a lot of memory allocated… itself. The tiny but annoying with such configuration could be logging. Instead of real IP of your clients you would see 10.0… serve a lot of static content – music, videos, file download I guess it is good idea anyway as such servers might be configured differently…
