… tables. It seemed to prefer an index-scan of 7 rows in the `kind_type` table to be first, then look up matching rows in `title` by a secondary index. But the result was that it created a temporary table to count the movies per…’t you have used a SUBQUERY to fetch and compare MAX(episode_id) as an option there? Yes, I think what…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… this benchmarks round, since reportedly Dimitri was using 8 tables with 1M rows each (about 2.1GB) for his tests, while in… innodb_file_per_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open…_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-interval=1 –rand-type=uniform –forced-shutdown=1 –max-time=120 –max-requests…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…approximately 78GiB of data (32 tables, 10M rows each) and a 4GiB…_pool_size = 4G innodb_file_per_table = true innodb_data_file_path …max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
…: /* Hack to avoid bugs with small static rows in MySQL */ reclength=max(file->min_record_length(table_options),reclength); if (info_length+(ulong… your FRM file, you instead get some bunch of bytes per 19 columns). create_fields.elements*FCOMP is just number of… should be REC_MAX_N_FIELDS – 3 = 1020, but we play safe here */ DBUG_RETURN(HA_ERR_TO_BIG_ROW); } Which is…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…can easily fill TokuDB tables with 1bln of rows on this SSD…_method = keep_average innodb_file_per_table = true innodb_data_file_path …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…
Comment: Why MySQL could be slow with large tables ?
May 15, 2012 By 141 Comments
i have 90GB db, my selects are pretty slow with tables over 500,000 rows. guess i will have to partition as i used up the maximum 40 indexes and its not speeding things up. i think max rows per table should be 50-100k rows
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
…: 0 kB 1 row in set (0.00 sec) Free Space for tables created in innodb_file_per_table mode is interesting …\G *************************** 1. row *************************** Name: test_innodb Engine: InnoDB Version: 10 Row_format: Compact Rows: 1069 Avg_row_length: 199 Data_length: 212992 Max_data_…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… in the table and we need to somehow skip over it. To do it we would need to find max PK which…. Row size can be good help to you. In this case we have about 280 bytes per row so we get about 50 rows per page so not a big surprise 30 rows was not enough – typically…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
… load in 16 tables in 16 parallel threads, 25,000,000 rows in each tables. That gives about 6GB of data per table (uncompressed) and… 16 parallel threads with limiting dataset to 3,000,000 rows per table, that is in total about 11GB of working set. Using…-tables-count=16 –oltp-table-size=5000000 –oltp-read-only=on –rand-init=on –num-threads=16 –max-requests=0 –rand-type=uniform –max…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
…per_table. Implementation Before going into showing how Lazy Drop Table and the new DROP Table…rows table: sysbench –test=oltp –oltp-table-size=20000000 –mysql-table-engine=innodb –mysql-socket=/tmp/mysql_sandbox5524.sock –mysql-db=test –oltp-table…
