…MySQL to use reasonable global buffers, such as innodb_buffer_size, key… regularly or reducing table cache reduces memory consumption to…mysql> select sum(data_length+index_length) from information_schema.tables where engine=’memory’; +——————————-+ | sum(data_length+index_length) |…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… use multiple Key Caches to reduce or virtually eliminate key cache contention. Too bad you can only map single table to single key cache… surely use different formula if you like. mysql> select t.table_name,index_length/(select sum(index_length) from information_schema.tables where table_schema…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
…length columns (BLOB, VARCHAR, TEXT) in the index record, and the remainder stored in overflow pages. COMPACT became the default after MySQL… is table specific, ROW_FORMAT and KEY_BLOCK_SIZE directives are passed via…bytes of the blob on field, and reduce the table down to 30GB. Happy customer…
