Comments on: InnoDB Buffer Pool Resizing: Chunk Change https://www.percona.com/blog/chunk-change-innodb-buffer-pool-resizing/ Fri, 02 Feb 2024 22:31:33 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Aaron Mader https://www.percona.com/blog/chunk-change-innodb-buffer-pool-resizing/#comment-10970253 Mon, 04 Feb 2019 16:47:56 +0000 https://www.percona.com/blog/?p=49351#comment-10970253 This post starts out so promising, and then just leaves me with more questions then answers.

You demonstrate how I’m unable to resize my pool_size to 1.5G. Then you explain a bunch of internal logic, and after trying to wrap my head around this for 20 minutes, I’m still UNCLEAR whether or not its possible for me to set my pool_size to 1.5G, and if so; how.

A simple example of how to actually set the pool_size to my desired value would complete these article.

]]> By: David Gundlach https://www.percona.com/blog/chunk-change-innodb-buffer-pool-resizing/#comment-10969941 Sat, 10 Nov 2018 02:05:16 +0000 https://www.percona.com/blog/?p=49351#comment-10969941 I have ibm thinkpad notebook T400 with 8GB RAM and 40GB free on harddrive. I am trying to load MIMIC III MIT health db cvs files of which there are 26. 24 I can load with success. One of the csv files is for table chartevents/when I try to load this csv file to mysql 5.7, it runs for about an hour then says ‘table full’ error. I have tried to set innodb_buffer_pool_size from current value of 1342177280 (I found current value by running ‘show variables like ‘%innodb_buffer_pool_size%’) to 6GB which in online mode is 6442450944. However when I run set global innodb_buffer_pool_size = 6442450944, I get 1292 truncated incorrect innodb_butter_pool_size value: ‘6442450944’. And when I rerun the show variables like above, I see the pool size has not changed and is still 1342177280. If in my.ini i put the innodb_buffer_pool_size = 6G and at c prompt run mysqld, it returns to command prompt (meaning the dameon won’t run. Only if I comment out the innodb_buffer_pool_size = 6G will at the c prompt running mysqld stay and not return to the c prompt (the behavior of running mysqld and it returning to c prompt means mysqld would not start.) Since I need to load this csv file into mysql (30MM row csv) and I get table full error, my thought is getting the pool size up to 6GB of RAM would possibly solve the table full error; but I can’t seem to change the pool size to get to 6GB and the 1242177280 byte current setting is not sufficient. Thoughts?

]]>