…= O_DIRECT innodb_max_dirty_pages_pct = 50 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…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…tables you can create both as permanent and temporary. There is a max_heap_table_size variable which allows you to limit size of MEMORY tables…
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… Avg_row_length: 11 Data_length: 23068672 Max_data_length: 3096224743817215 Index_length: 1024 Data… optimal structure both for MyISAM and Innodb tables, however it is not as convenient to…
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
…size for table with one row: mysql> show table status like “test_innodb” \G *************************** 1. row *************************** Name: test_innodb Engine: InnoDB…Innodb tables will take more space on disk than one may anticipate. Using innodb_file_per_table…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… create or drop Innodb tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text … mysql> select max(id) from test2; +———+ | max(id) | +———+ | 220 | +———+…data as possible. Row size can be good help…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 1 Comment
… your main Innodb Tablespace. Insert Buffer size is also restricted to half of the buffer pool size (can be changed via innodb_ibuf_max_size option) which can be significant size… is why Master and Slave may get so much different table space size in the end. The answer is of course their…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read_io_threads = 16 join_buffer_size=1M max_allowed_packet=1M max_connections=3000 max_heap_table_size=64M max_prepared…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=128M innodb_thread_concurrency=0 innodb_extra_rsegments=16 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…_page_cache_size=1500M –max-connections=1500 –table-cache=512 –net_read_timeout=30 –net_write_timeout=30 –backlog=128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max-connections=1500 –table…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… Innodb maintains its own (called data dictionary) which keeps all tables ever accessed since table start – there is no variable to control its size… total size on disk was 12GB in .ibd files plus some space allocated in system tablespace. So if you create Innodb tables you… maximum InnoDB: allowed value would be 64. InnoDB: You may need to raise the value of innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil…
