… you close connection MySQL can clean them up. Killing connections (or stopping related applications) and observing whenever memory usage shrinks can be… Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database pages 3046376 Modified db pages 23419 I’m using…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… cool is it? After all database sizes tend to always grow and very rarely shrink. Which leads to a challenge… do. Using this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant… not cool is it? After all database sizes tend to always grow and very rarely shrink. Which leads to a challenge faced…
Comment: MySQL File System Fragmentation Benchmarks
October 10, 2008 By 28 Comments
… there is a “bug” in MySQL InnoDB which don’t shrink the file ibdata1 after a DROP Database without dropping the Table – If… here: http://bugs.mysql.com/bug.php?id=15748 http://bugs.mysql.com/bug.php?id=1287 http://bugs.mysql.com/bug.php… for a production enviroment…. http://crazytoon.com/2007/04/03/mysql-ibdata-files-do-not-shrink-on-database-deletion-innodb/ best regards gregor
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… those big fat log files out of the database. The database is usually the most expensive and hardest-to…are indexes other than the primary key, we can shrink the primary key’s width: create table ads_by…that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
…it often makes sense to keep it compressed. Unfortunately MySQL does not provide compressed BLOB/TEXT columns (I …about how many rows you will be able to shrink down so they fit back to the page …column compression is not for all workloads. When your database is small enough to mostly fit in the cache…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
… both Insert buffer and undo space will grow and shrink during the database operation and unless you can them on being large… can’t reclaim without reloading tour database. This is where Trending can help, for example MySQL CACTI Templates will have the graphs… measure. Having transaction in read only database open for weeks does no harm, however if database has very high update rate, say…
Comment: Choosing innodb_buffer_pool_size
January 20, 2011 By 39 Comments
… database. we recently upgrade to mysql 5.5.8 @ freebsd 7.1. the main db is innodb, myisam is used for the mysql-system-tables(small-sized). the production-innodb-database allocates now of about 50GB of filesystem… 19GB big. i know that innodb – ibdata – files will never shrink, so i have to drop and import the data to…
