MySQL Forums
Forum List  »  Newbie

innodb_buffer_pool_size=128M
Posted by: Donald Dahlman
Date: October 23, 2023 06:21AM

If I change this in the INI file directly, MySql will not restart
I have read where the operation is performed in chunks
Buffer pool size must always be equal to or a multiple of innodb_buffer_pool_chunk_size
I cant figure out what the setting need to be
I also tried Workbench 8.0 but dont see the innodb_buffer_pool_size
listed in the options file

Below is my INI file minus the comments, Maybe someone can explain what I need to do

Thanks

[client]
# pipe=
# socket=MYSQL
port=3306
[mysql]
no-beep
[mysqld]
port=3306
datadir = "F:/ProgramData/MySQL/MySQL Server 8.0/Data"
authentication_policy=*,,
default-storage-engine=INNODB
sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
log-output=FILE
general-log=0
general_log_file="CONIGNDB1.log"
slow-query-log=1
slow_query_log_file="IGS-MYSQL-slow.log"
long_query_time=10
log-error="IGS-MYSQL.err"
log-bin="IGS-MYSQL-bin"
server-id=1
lower_case_table_names=1
secure-file-priv="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads"
max_connections=151
table_open_cache=4000
temptable_max_ram = 1G
tmp_table_size=1G
internal_tmp_mem_storage_engine=TempTable
myisam_max_sort_file_size=2146435072
myisam_sort_buffer_size=17G
key_buffer_size=16M
read_buffer_size = 1024K
read_rnd_buffer_size = 2048K
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=16M
innodb_buffer_pool_size=128M
innodb_redo_log_capacity=100M
innodb_thread_concurrency=65
innodb_autoextend_increment=64
innodb_buffer_pool_instances=8
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
flush_time=0
join_buffer_size=256K
max_allowed_packet=64M
max_connect_errors=100
open_files_limit=8161
sort_buffer_size = 1000K
binlog_row_event_max_size=8K
sync_source_info=10000
sync_relay_log=10000
sync_relay_log_info=10000
loose_mysqlx_port=33060

Options: ReplyQuote


Subject
Written By
Posted
innodb_buffer_pool_size=128M
October 23, 2023 06:21AM
October 23, 2023 11:58AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.