Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Windows INI Optimization

Robert KoernkeJan 17 2025

I have two servers, one is an older 2008R2 and the specs are much junkier, but it does seem to feel much snappier. Both are running 8.0.30 version of mysql. I must find fault with my configuration… I've tried a few times to find the right balance of specifications. But have failed. Is there anything I'm just over-looking here as I post this INI contents:

The server is has 192gb… 2.6ghz 12core 2016 server.

[MySQLD]
port=3306
basedir=xxxxxxxxxx
datadir=xxxxxxxxxx
character-set-server=utf8
default-storage-engine=INNODB
read_buffer_size=1M
read_rnd_buffer_size=256K
join_buffer_size=256K
sort_buffer_size=512K
innodb_log_buffer_size=2M
innodb_buffer_pool_size=10G I had this as much larger, but I have tried different values… But there has to be a limit
innodb_redo_log_capacity=50M
innodb_io_capacity = 200
innodb_read_io_threads = 64
innodb_thread_concurrency = 0
innodb_write_io_threads = 64
innodb_buffer_pool_instances=8
innodb_lru_scan_depth=256
key_buffer_size=512M
max_connections=500
max_allowed_packet=500M
max_user_connections=0
thread_cache_size=35
thread_stack=196608
binlog_cache_size=32768
net_read_timeout=40
net_retry_count=15
net_write_timeout=40
open_files_limit=4161
table_definition_cache=400
event_scheduler=ON
sql_mode="TRADITIONAL"
explicit_defaults_for_timestamp
tmp_table_size=4G
log_bin_trust_function_creators=1
[client]
port=3306

Comments

Answer

Yes. Async, semi-sync, and InnoDB Cluster.

Marked as Answer by 3602098 · Sep 27 2020
Basharat Hussain Oct 16 2024

Dear @dave-stokes-mysql-community-team-oracle

I am facing a problem please Guide me.

I have deployed two MySQL Nodes version 8. I am trying to async MySQL nodes, the replication complete successful as long as a user create or some action performed from the application. When an action is perform from the Application . On the slave node the following error occur.

Before an action perform from the Application everything working fine replication from master to slave working as expected.

Please Guide me.

Thank You in Advance.
Basharat Hussain.

L. Fernigrini Oct 16 2024

You are replying to a 5 year old “solved” thread with a new problem…Please do not hijack existing threads, open a new one with the appropriate details. I'm closing this one.

1 - 3

Post Details

Added on Jan 17 2025
0 comments
58 views