Wrong benchmark code, do not run several benchmarks at once!
-
Wrong benchmark code, do not run several benchmarks at once!
I installed benchmark on one of our websites which runs on the same physical server (And IP) as our production but with a lot less plugins and tools etc. I ran it and can continue to run it fine on this small website.
I want to migrate it to main website but I keep getting an error as follows. I was able to run it once before installing on the small website (which I did to see if there was much of a difference in results)
Wrong benchmark code, do not run several benchmarks at once!I have tried to deactivate the plugin, uninstall it and reinstall. same thing.
Secondly, I get result on both websites as “Importing large amount of data to database 0.98”, my big site uses ludicrousDB and reads from 2 and writes to 1 DB server. The servers are physically connected with 10Gb so wondered why this result. I get an overall result of 8, its just the DB I wondered if this was real bad, or was possible due to the DB server off the host adding a 0.2ms latency.
Wonder if you can make any recommendations, running on ZFS with small byte size block
# Memory and buffer settings
innodb_buffer_pool_size = 24G
innodb_log_file_size = 1G
innodb_log_buffer_size = 64M
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
# Thread settings
innodb_thread_concurrency = 16
innodb_read_io_threads = 16
innodb_write_io_threads = 16
innodb_io_capacity = 2000
innodb_io_capacity_max = 4000
# AIO settings
innodb_use_native_aio = 1
# Other settings
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 2
# Timezone
default_time_zone = 'Pacific/Auckland'
max_binlog_size = 100M
expire_logs_days = 7
relay_log_space_limit = 1G
# Allow infile for IPMS
local-infile=1
[mysqld]
disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY"
gtid_mode = ON
enforce_gtid_consistency = ON
master_info_repository = TABLE
relay_log_info_repository = TABLE
binlog_checksum = NONE
log_replica_updates = ON
log_bin = binlog
binlog_format = ROW
sync_binlog = 1
binlog_expire_logs_seconds = 3600 # Purge binlogs after 1 hour (adjust as needed)
binlog_row_image = MINIMAL
transaction_write_set_extraction = XXHASH64
- You must be logged in to reply to this topic.