I have a database that is hosted on AWS Aurora. Now let's say it has been assigned particular memory, RAM, buffer pool size, etc.
I also have
my.ini file on my local machine. What happens if I change the pool size to
my.ini? Would that affect the performance of my query when I run on my machine? Or will it still use the buffer size set up in aurora?
My current variables are like this:
show variables; innodb_buffer_pool_size 20915945472
Is this number from the aurora? My local
my.ini file reads like this: