…innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size…in the above graph, we have “millions of rows…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: my ENGINE: InnoDB…
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
…tables which contain couple of rows which can take a lot of space in Innodb. Tables showing as using 1MB of Innodb…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…table – myisam_data_pointer_size is 6 default plus we need space for delete flag which makes 7 minimum row size MyISAM can have in…table format look in Innodb (I’ve populated each with some 2M rows so difference is more visible) CREATE TABLE…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…TABLE says table is OK. This means You Can’t Trust CHECK TABLE in Innodb to be sure your tables are good. In…Row size can be good help to you. In this case we have about 280 bytes per row so we get about 50 rows…
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
… your row has variable length columns and the complete row size exceeds this limit, InnoDB chooses variable length columns for off-page storage. In these… evaluated at table definition, but at row insertion. You may just have a table with 50 variable length columns, but if their max length…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…in case table it fully in Innodb data dictionary the operation is slower than MyISAM tables. Though the difference can be related to the size…InnoDB: allowed value would be 64. InnoDB: You may need to raise the value of innodb_max_files_open in InnoDB: my.cnf. InnoDB…
Post: Innodb undo segment size and transaction isolation
January 12, 2011 By 2 Comments
…row in Innodb table at that point in time. If you use READ-COMMITTED mode Innodb does NOT need to maintain row…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 1 Comment
…Innodb Tablespace. Insert Buffer size is also restricted to half of the buffer pool size (can be changed via innodb_ibuf_max_size…row in set (0.00 sec) curr_size will display the current size of RSEG which defines undo segment size in… may get so much different table space size in the end. The answer …
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
…table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb_thread_concurrency=16 innodb…
