【标题描述】能够简要描述问题:说明什么场景下,做了什么操作,出现什么问题(尽量使用正向表达方式)
通过atune-adm profile 无法下发mysql配置
一、缺陷信息
新建mysql.conf。里面加入
[mysqld]
user=root
port=3306
basedir=/usr/local/mysql
socket=/tmp/mysql.sock
tmpdir=/usr/local/mysql/tmp
datadir=/usr/local/mysql/data
default_authentication_plugin=mysql_native_password
sync_binlog=0
innodb_flush_log_at_trx_commit=2
innodb_io_capacity=20
innodb_write_io_threads=4
innodb_read_io_threads=4
innodb_spin_wait_delay=6
innodb_sync_spin_loops=78
innodb_log_file_size=48M
innodb_log_files_in_group=2
innodb_buffer_pool_instances=1
innodb_log_buffer_size=1014784
innodb_page_cleaners=1
innodb_lru_scan_depth=1101
innodb_thread_concurrency=241
通过atune-adm define test_mysql test_myqsl test_mysql_scenario mysql.conf
atune-adm profile test_mysql-test_myqsl-test_mysql_scenario
预期可以在others中看到mysql的配置项。但是没有看到。nginx可以正常下发
[root@localhost home]# atune-adm profile test_mysql-test_myqsl-test_mysql_scenario
[ SUGGEST] 0 and --sync-binlog=0 can extremely improve performance but lose data reliability = application set --innodb-flush-log-at-trx-commit
[ SUGGEST] Bios please change the BIOS configuration NUMA to Enable
[ SUGGEST] Bootloader Need reboot to make the config change of grub2 effect.
[ SUCCESS] memory memory num is 1, the memory slot is full
[ SUCCESS] Kernel CONFIG_NUMA_AWARE_SPINLOCKS
OTHERS
[ FAILED ] Script Command '['/usr/lib/python3.9/site-packages/atune_collector/scripts/prefetch/set.sh', 'off']' returned non-zero exit status 3.
[ SUCCESS] Sysctl vm.swappiness,vm.dirty_ratio,kernel.sched_cfs_bandwidth_slice_us,kernel.sched_migration_cost_ns,kernel.sched_latency_ns,kernel.sched_min_granularity_ns,kernel.sched_nr_migrate,kernel.sched_wakeup_granularity_ns,kernel.sched_autogroup_enabled,kernel.numa_balancing,net.core.rmem_default,net.core.rmem_max,net.core.wmem_default,net.core.wmem_max,net.ipv4.tcp_rmem,net.ipv4.tcp_wmem,net.core.dev_weight,net.ipv4.tcp_max_syn_backlog,net.core.somaxconn,net.ipv4.tcp_max_tw_buckets
[ FAILED ] Sysfs kernel/mm/transparent_hugepage/defrag,kernel/mm/transparent_hugepage/enabled,kernel/debug/sched_features,block/sda/queue/scheduler,block/sda/queue/read_ahead_kb,block/sda/queue/nr_requests,[Errno 22] Invalid argument
[ SUCCESS] Systemctl sysmonitor,irqbalance,firewalld
[ SUGGEST] Ulimit Need reboot to make the config change of limits effect.
[ SUGGEST] application set innodb_numa_interleave to ON
[ SUGGEST] application add -O3 compilation parameter in cmake
[ SUGGEST] application set --innodb-io-capacity, --innodb-write-io-threads, --innodb-read-io-threads, --innodb-spin-wait-delay, --innodb_sync-spin-loops, --innodb-log-file-size, --innodb-log-files-in-group, --innodb-buffer-pool-instances, --innodb-log-buffer-size, --innodb-page-cleaners, --innodb-lru-scan-depth, --innodb-thread-concurrency to an appropriate value
[ SUGGEST] filesystem
内核信息:
缺陷归属组件:
缺陷归属的版本:
缺陷简述:
【环境信息】
硬件信息
【问题复现步骤】,请描述具体的操作步骤
【实际结果】,请描述出问题的结果和影响
【其他相关附件信息】
比如系统message日志/组件日志、dump信息、图片等
缺陷详情参考链接:
缺陷分析指导链接:
https:xxx
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。
登录 后才可以发表评论