… Version: 10 Row_format: Fixed Rows: 2097152 Avg_row_length: 7 Data_length: 14680064 Max_data_length: 1970324836974591 Index_length: 1024 Data_free: 0 Auto… Version: 10 Row_format: Fixed Rows: 2097152 Avg_row_length: 11 Data_length: 23068672 Max_data_length: 3096224743817215 Index_length: 1024 Data_free: 0 Auto…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…select sum(data_length+index_length) from information_schema.tables where engine=’memory’; +——————————-+ | sum(data_length+index_length) | +——————————-+ | 126984 | …and when it can be found and fixed. This is where your MySQL Support …
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… of MySQL history you may think Key Cache scalability was fixed with new Key Cache in MySQL 4.1, and indeed… you like. mysql> select t.table_name,index_length/(select sum(index_length) from information_schema.tables where table_schema=’test’ and….table_name,”.key_buffer_size=”,round(least(index_length,(index_length/(select sum(index_length) from information_schema.tables where table_schema=”test…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… cause the disk to fill up with logs. You can fix this by modifying shard-query/run_worker to contain the… Row_format: Compact Rows: 6697533 Avg_row_length: 241 Data_length: 1616904192 Max_data_length: 0 Index_length: 539279360 Data_free: 4194304 Auto_increment…/log/mysqld-innodb.log max-allowed-packet=1M net-buffer-length=16K #we value throughput over response time, get a good…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… data lengths). In case sort with row pointer storage is used and the fields which are being length can be converted to fixed… of cases – if you retrieve few fields (less than max_length_for_sort_data) data should be stored in sort buffer… selected columns are long so they are longer than max_length_for_sort_data it would frequently mean there are some…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… Row_format: Dynamic Rows: 2000 Avg_row_length: 0 Data_length: 0 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment… is significant drawback for me, I hope it will be fixed
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… 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: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… to this in the future – for transactions there is obvious fix to use two phase commit for transactions spawning multiple databases… row pointer each rows has fixed data part and dynamic data parts stored in separate files. Dynamic length part is stored in… – for many queries you will not need to touch dynamic length part and row pointer file should be cached in most…
Post: Building Indexes by Sorting In Innodb (AKA Fast Index Creation)
June 19, 2012 By 2 Comments
… down index built process. Mark Callaghan and Facebook Team has fixed this in their tree back in early 2011 adding innodb… (courtesy of Alexey Kopytov), using 1Mil rows Sysbench table. Buffer Length | alter table sbtest add key(c) 1MB 34 sec 8MB… building index on long character field with very short length, Innodb would use fixed size records for sort space which results in…
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… high and queue will get full and benchmark essentially fail. Fixing number of variables is another interesting question. It is one… of threads or fixed number of threads would make sense. I would see benchmark to set maximum queue length and maximum amount… injection rate and run time. When we have maximum queue length reached the transactions are “failed”. Our guidance for “pass” for…
