… rows with textual data and about 60M lines (as I recall). When InnoDB loads the file, it creates one big transaction with… a lot of costs. To name a few: the big LOAD DATA INFILE clogs the binary log and slows replication down. If… mk-fifo-split infile.txt –fifo /tmp/my-fifo –lines 1000000 And this in the other terminal: while [ -e /tmp/my…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… 10000 | 100 | | PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES | 1000000 | 1724 | | PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES | 100000 | 2223… | | DATADIR | /mnt/data/sandboxes/msb_5_5_30/data/ | /mnt/data/sandboxes/msb_5_6_10/data/ | | OPTIMIZER_SWITCH… ON by default. This is very big change and is good one. We…
