74 Star 358 Fork 217

GVPopenEuler / A-Tune

 / 详情

通过atune-adm profile 无法下发mysql配置

已完成
缺陷
创建于  
2023-11-08 17:53

【标题描述】能够简要描述问题:说明什么场景下,做了什么操作,出现什么问题(尽量使用正向表达方式)
通过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
内核信息:

缺陷归属组件:

缺陷归属的版本:

缺陷简述:

【环境信息】
硬件信息

  • 裸机场景请提供问题的硬件信息
  • 虚拟机场景请提供虚拟机的XML文件或配置信息
    软件信息
  • OS版本及分支信息
  • 内核信息
  • 发现问题的组件版本信息
    网络信息
  • 如果有特殊组网,请提供网络拓扑信息

【问题复现步骤】,请描述具体的操作步骤
【实际结果】,请描述出问题的结果和影响
【其他相关附件信息】
比如系统message日志/组件日志、dump信息、图片等

缺陷详情参考链接:

缺陷分析指导链接:
https:xxx

评论 (3)

dongchao 创建了缺陷

Hi dcderrick, welcome to the openEuler Community.
I'm the Bot here serving you. You can find the instructions on how to interact with me at Here.
If you have any questions, please contact the SIG: A-Tune, and any of the maintainers: @谢志鹏 , @Monday , @gaoruoshu , @HuBin95

openeuler-ci-bot 添加了
 
sig/A-Tune
标签
xieminmin 负责人设置为gaoruoshu

请将[mysqld]标签改成[mysql]再次尝试

xieminmin 负责人gaoruoshu 修改为ZhouPengcheng
ZhouPengcheng 任务状态待办的 修改为已完成

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(3)
5329419 openeuler ci bot 1632792936
Go
1
https://gitee.com/openeuler/A-Tune.git
git@gitee.com:openeuler/A-Tune.git
openeuler
A-Tune
A-Tune

搜索帮助

53164aa7 5694891 3bd8fe86 5694891