…2.8x better throughput, and on data size: InnoDB table: 58GB and 244.980.192 records TokuDB table: 15GB and 232.927.460 … 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
…converted databases from MyISAM to InnoDB, mysql tunning script gives below results for temp table , server has 4G ram, …max_heap_table_size & tmp_table_size) , what values you experts are recomended ? TEMP TABLES Current max_heap_table_size = 128 M Current tmp_table_size = 128 M Of 21559 temp tables…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb_log_buffer_size = 128M 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… 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 22 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 2 Comments
… 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…
