Hi all,
Quick question.
I’ve raised innodb_lru_scan_depth variable value up to 8192 (don’t ask why, experiments) to see how it can impact multithreaded dump import performance.
But since I started this import, and done this command:
mysql -e "show engine innodb status\G" | grep 'Free buffers'
I see next values:
Free buffers 136889
Free buffers 138022
Free buffers 137668
Free buffers 137161
Free buffers 137576
Free buffers 137258
Free buffers 137462
Free buffers 138242
Free buffers 137385
Free buffers 137131
Free buffers 137923
Free buffers 138432
Free buffers 137883
Free buffers 137830
Free buffers 137752
Free buffers 137879
Free buffers 137419
Free buffers 137561
Free buffers 137180
Free buffers 137457
Free buffers 138534
Free buffers 137592
Free buffers 138085
Free buffers 137498
Free buffers 137072
Free buffers 138296
Free buffers 137379
Free buffers 137319
Free buffers 137459
Free buffers 137787
What is wrong? From what I understand it should be equal maximum to innodb_lru_scan_depth
value?