…: 10 Row_format: Compact Rows: 1638757 Avg_row_length: 61 Data_length: 100253696 Max_data_length: 0 Index_length: 128974848 Data_free: 0 Auto_increment: 1638401 Create_time… other hand it still consumes exactly same amount of memory: History list length 5 Total number of lock structs in row lock…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… (filter) data using it current architecture ? I decided to test the most simple case – what if we take the in memory table… *************************** Name: m4 Engine: MEMORY Version: 10 Row_format: Fixed Rows: 5000000 Avg_row_length: 129 Data_length: 685609952 Max_data_length: 948528873 Index_length: 0 Data_free: 0 Auto…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…, huge network buffer (can grow up to max_packet_size per connection) are all connection…memory is being used by current MEMORY tables: mysql> select sum(data_length+index_length) from information_schema.tables where engine=’memory‘; +——————————-+ | sum(data_length+index_length…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…: 10 Row_format: Compact Rows: 6697533 Avg_row_length: 241 Data_length: 1616904192 Max_data_length: 0 Index_length: 539279360 Data_free: 4194304 Auto_increment: NULL Create_time… the need for fewer nodes in order to keep data entirely in memory. This frees disk to use on-disk temporary storage…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… 10 Row_format: Compact Rows: 10000060 Avg_row_length: 224 Data_length: 2247098368 Max_data_length: 0 Index_length: 1460322304 Data_free: 7340032 Auto_increment: 10000001 Create_time… On this box with 8GB of memory allocating 6GB to buffer pool made very little memory available for OS cache, so index…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
…: 9 Row_format: Dynamic Rows: 8048913 Avg_row_length: 252 Data_length: 2030206088 Max_data_length: 4294967295 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time… information about size on disk and compression buffer stage in memory should be readily available. So we have to go and…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… with 6GB allocated for innodb_buffer_pool which with other memory needs leaves roughly 1GB for OS Cache. Here is pt…: 10 Row_format: Compact Rows: 278987416 Avg_row_length: 75 Data_length: 20975714304 Max_data_length: 0 Index_length: 9047113728 Data_free: 6291456 Auto_increment: NULL Create_time…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… counting time spent on files transformation) I put summary data into on load data time, datasize and query time to Google Spreadsheet…: 10 Row_format: Dynamic Rows: 2000 Avg_row_length: 0 Data_length: 0 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time…_Worker1 fg which cooperate each with other using IPC shared memory and semaphores. To clean system I rebooted server, and only…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…max_connectionsblogpercona.commanual max_delayed_threadsblogpercona.commanual max_error_countblogpercona.commanual max_heap_table_sizeblogpercona.commanual max_insert_delayed_threadsblogpercona.commanual max_join_sizeblogpercona.commanual max_length…memory…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… very large systems. # # # This is for a large system with memory of 1G-2G where the system runs mainly # MySQL. # # You…_buffer_size = 100M myisam_sort_buffer_size = 100M max_length_for_sort_data=2048 max_sort_length=2048 long-query-time=5 log-slow-queries… #bdb_max_lock = 100000 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /usr/local/mysql/data/ #innodb_data_file…
