… row in set (0.00 sec) You can even go deeper to check which sessions have created which temporary tables (both in memory…) Dictionary memory allocated 2623331 Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database pages 3046376… to global memory allocation and will result in increased memory allocation until server is restarted. I would suspect memory leak when you see memory usage…
Post: Mail clients and Databases
March 13, 2007 By 14 Comments
… them will fit in memory. At this point for example I got tired of Thunderbird handling my 1GB inbox (In fact my Inbox… of recovery and memory consumptions as databases usually are designed to handle large data sizes with limited amount of memory. MySQL in its embedded… solutions. Seriously the only part you really need to have in memory to be able to quickly show list of messages sort…
Comment: Disaster: MySQL 5.5 Flushing
September 19, 2011 By 27 Comments
… pool in memory. NDB writes REDO log. InnoDB does too. NDB has a background thread that periodically dumps contents of full in-memory database to… dump contents of the in-memory database to disk is constant, or rather it depends only on size of in-memory database and things like throughput…
Post: Looking at Redis
August 27, 2009 By 27 Comments
… take a look at Redis project, which is semi-persistent in memory database with idea somethat similar to memcache but richer feature set… it does not affect read/write performance to the database which is in memory. In the tests I’ve done I’ve seen Redis… the database or as cache (it supports data expiration too) I have not benchmarked it against memcache in terms of performance and memory…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… a lot of memory (and this is not rare nowadays, for example Cisco UCS C250), your database fits into memory, and your write… up with changes in memory, we need to have a throttling mechanism that will limit the rate of changes in memory. Optimize the flushing of sequential neighbor pages in a way that makes sense. We…
Comment: Alternatives of PHP ?
April 11, 2012 By 28 Comments
… than php and mysql and is also much faster (resilient in-memory database). It is 100% compatible with any browser (does not need… server send to the browser. I run it with heavy in-memory databases but you can use MySQL if you want to.
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… can still take hours especially if database is already loaded. So operating wit such large databases you need to be patient and learn to have bunch of tasks running in the background while… not. Many operations require certain size of table to fit in memory for decent performance. Typically it would be some portion of…
Post: Maatkit Now Supports Memcached
July 24, 2009 By 11 Comments
… not true. If your setup is inefficient, you could: Burn Memory Waste Network Round-Trips Store Keys That Never Get Retrieved… everything else we do. memcached is basically a key-value in-memory database, so it works well to analyze its traffic with Maatkit… not authoritative documentation. The most current documentation is always embedded in the tool itself, and is readable with perldoc! Let us…
Comment: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 5, 2008 By 15 Comments
… anyway with an in-memory database, since compression is a way to trade off using a little more CPU (and memory possibly) to reduce… does not require Barracuda format), there should be no difference in the density of the index vs. the traditional way indexes… to do some instruction tracing/monitoring, so we could see in which routines the code is spending its time, that would…
Post: Getting around optimizer limitations with an IN() list
January 9, 2010 By 9 Comments
… discussion on LinkedIn one month ago that caught my eye: Database search by “within x number of miles” radius? Anyone out there created a zipcode database and created a “search within x numer of miles” function… in set (0.00 sec) Conclusion: My examples were only on a small amount of data (16 000 rows) that fitted in memory…
