…. Innodb Table Cache Leak – Innodb never shrinks its internal table cache (data dictionary) so by creating and accessing large amount of Innodb tables you… true for Partitioned tables in MySQL 5.1 Disk Space For MyISAM tables hosting providers used to use disk quotas for MyISAM tables. You can also…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read-only tables when things … the primary key, we can shrink the primary key’s width: create table ads_by_day_by_blueness ( … work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier,…
Comment: Choosing innodb_buffer_pool_size
January 20, 2011 By 39 Comments
… upgrade to mysql 5.5.8 @ freebsd 7.1. the main db is innodb, myisam is used for the mysql-system-tables(small-sized… 19GB big. i know that innodb – ibdata – files will never shrink, so i have to drop and import the data to… 16GB of RAM, most of this would be available to mysql because there is no other productive service running. so far…
