… fits in main memory (and would have fit even with only a few GB of main memory). The cost of querying this database will be 10 times higher with this partitioning, however since you’ll have to look in… because the entire table fits in main memory. Each row is on the order of 30 bytes in the primary table, and so…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… 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…
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: 5.4 in-memory tpcc-like load
May 1, 2009 By 11 Comments
…/ on 5.4 I tried in-memory load (basically changed buffer pool from 3GB to 15GB, and database size is 10GB). The results… how different versions go through warmup stage. The graph is In default mode I would say XtraDB performs almost the same… that basically causes stall for some period of time in all user processes. In XtraDB we have special mode adaptive_checkpoint, you…
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…
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 9 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…
