位置: 编程技术 - 正文

Slave memory leak and trigger oom-killer

编辑:rootadmin

推荐整理分享Slave memory leak and trigger oom-killer,希望有所帮助,仅作参考,欢迎阅读内容。

文章相关热门搜索词:,内容如对您有帮助,希望把文章链接给更多的朋友!

Bug Description

We have this problem:

we have set innodb_buffer_pool =GB on both master and slave , master offer usually workload,but slave with nothing workload except these slave threads, But with the memory consumption is increasing , after a few days , it uses about GB of memory(RES) and sometime the machine starts swapping out. and in the /var/log/message(loged :Out of memory: Kill process (mysqld) score or sacrifice childKilled process , UID , (mysqld) total-vm:kB, anon-rss:kB, file-rss:kB)

We have the exact version of PerconaServer on the master (with production workload) and it doesn't have this problem

This problem is the same for a few recent versions of Percona server, not just the last one.

we do not user MyISAM tables and just use Innodb Tables;TokuDB is not installed.

Other Information:

this one just OOM last night T-T:

xiean@(none) :> s--------------mysql Ver . Distrib 5.6.-.1, for Linux (x_) using EditLine wrapper

Connection id: Current database:Current user: xiean@localhostSSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server version: 5.6.-.1-log Source distributionProtocol version: Connection: Localhost via UNIX socketServer characterset: utf8Db characterset: utf8Client characterset: utf8Conn. characterset: utf8UNIX socket: /data/mysql//var/run/mysql.sockUptime: hours min 9 sec

Threads: 6 Questions: Slow queries: Opens: Flush tables: 1 Open tables: Queries per second avg: .--------------

CentOS release 6.5 (Final)Linux xxxxxxx 2.6.-.el6.x_ #1 SMP Fri Nov :: UTC x_ x_ x_ GNU/Linux

Slave memory leak and trigger oom-killer

my.cnf-----------------------------------------------------[mysqld]

skip-external-lockingskip-name-resolvedefault-storage-engine = InnoDBcharacter-set-client-handshake = FALSEcharacter-set-server = utf8collation-server = utf8_unicode_ciinit_connect='set names utf8'connect_timeout = back_log = log_bin_trust_function_creators = 1

binlog_format = rowmax_binlog_size = Mbinlog_cache_size = 2Mexpire-logs-days = 7

slave-net-timeout = log_slave_updates = 1relay_log_recovery = 1sync_master_info = 1sync_relay_log_info = 1master_info_repository = TABLErelay_log_info_repository = TABLE

slow_query_log = 1long_query_time = 1

max_connections = max_user_connections = max_connect_errors = key_buffer_size = Mmax_allowed_packet = Mtable_open_cache = table_definition_cache = sort_buffer_size = Kread_buffer_size = Kread_rnd_buffer_size = kjoin_buffer_size = Ktmp_table_size = Mmax_heap_table_size = Mquery_cache_type = 0query_cache_size = 0bulk_insert_buffer_size = Mthread_cache_size = thread_stack = K

innodb_data_file_path = ibdata1:M:autoextendinnodb_buffer_pool_size = Ginnodb_buffer_pool_instances = 8innodb_additional_mem_pool_size = Minnodb_use_sys_malloc = 0innodb_log_file_size = Minnodb_log_buffer_size = Minnodb_log_files_in_group = 3innodb_lock_wait_timeout = innodb_spin_wait_delay = innodb_thread_concurrency = 0innodb_max_dirty_pages_pct = innodb_support_xa = 0innodb_flush_log_at_trx_commit = 2innodb_flush_method = O_DIRECTinnodb_read_io_threads = innodb_write_io_threads = innodb_io_capacity = innodb_flush_neighbors = 0innodb_page_size = 4Kinnodb_log_block_size = innodb_file_per_table = 1innodb_file_format = Barracudainnodb_file_format_max = Barracudainnodb_strict_mode = 1innodb_purge_threads = 2innodb_purge_batch_size = innodb_old_blocks_pct = innodb_old_blocks_time = innodb_change_buffering = allinnodb_stats_on_metadata = off

sync_binlog = 0

innodb_buffer_pool_dump_at_shutdown = 1innodb_buffer_pool_load_at_startup = 1

show engine innodb statusG

=====================================-- :: 7faf INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 3 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread loops: srv_active, 0 srv_shutdown, srv_idlesrv_master_thread log flush and writes: ----------SEMAPHORES----------OS WAIT ARRAY INFO: reservation count OS WAIT ARRAY INFO: signal count Mutex spin waits , rounds , OS waits RW-shared spins , rounds , OS waits RW-excl spins , rounds , OS waits Spin rounds per wait: 1. mutex, 4. RW-shared, 2. RW-excl

....................................................

----------------------BUFFER POOL AND MEMORY----------------------Total memory allocated ; in additional pool allocated Total memory allocated by read views Internal hash tables (constant factor + variable factor) Adaptive hash index ( + ) Page hash (buffer pool 0 only) Dictionary cache ( + ) File system ( + ) Lock system ( + ) Recovery system 0 (0 + 0)Dictionary memory allocated Buffer pool size Buffer pool size, bytes Free buffers Database pages Old database pages Modified db pages Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young , not young . youngs/s, 3. non-youngs/sPages read , created , written . reads/s, 9. creates/s, . writes/sBuffer pool hit rate / , young-making rate 0 / not 0 / Pages read ahead 0./s, evicted without access 0./s, Random read ahead 0./sLRU len: , unzip_LRU len: 0I/O sum[]:cur[], unzip sum[0]:cur[0]----------------------INDIVIDUAL BUFFER POOL INFO-------------------------BUFFER POOL 0Buffer pool size Buffer pool size, bytes Free buffers Database pages Old database pages Modified db pages Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young , not young . youngs/s, 3. non-youngs/sPages read , created , written . reads/s, 0. creates/s, . writes/sBuffer pool hit rate / , young-making rate 0 / not 0 / Pages read ahead 0./s, evicted without access 0./s, Random read ahead 0./sLRU len: , unzip_LRU len: 0I/O sum[]:cur[], unzip sum[0]:cur[0]---BUFFER POOL 1Buffer pool size Buffer pool size, bytes Free buffers Database pages Old database pages Modified db pages Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young , not young . youngs/s, 0. non-youngs/sPages read , created , written . reads/s, 3. creates/s, . writes/sBuffer pool hit rate / , young-making rate 0 / not 0 / Pages read ahead 0./s, evicted without access 0./s, Random read ahead 0./sLRU len: , unzip_LRU len: 0I/O sum[]:cur[], unzip sum[0]:cur[0]---BUFFER POOL 2Buffer pool size Buffer pool size, bytes Free buffers Database pages Old database pages Modified db pages Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young , not young . youngs/s, 0. non-youngs/sPages read , created , written . reads/s, 0. creates/s, . writes/sBuffer pool hit rate / , young-making rate 0 / not 0 / Pages read ahead 0./s, evicted without access 0./s, Random read ahead 0./sLRU len: , unzip_LRU len: 0I/O sum[]:cur[], unzip sum[0]:cur[0]---BUFFER POOL 3Buffer pool size Buffer pool size, bytes Free buffers Database pages Old database pages Modified db pages Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young , not young . youngs/s, 0. non-youngs/sPages read , created , written . reads/s, 0. creates/s, . writes/sBuffer pool hit rate / , young-making rate 0 / not 0 / Pages read ahead 0./s, evicted without access 0./s, Random read ahead 0./sLRU len: , unzip_LRU len: 0I/O sum[]:cur[], unzip sum[0]:cur[0]---BUFFER POOL 4Buffer pool size Buffer pool size, bytes Free buffers Database pages Old database pages Modified db pages Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young , not young . youngs/s, 0. non-youngs/sPages read , created , written . reads/s, 1. creates/s, . writes/sBuffer pool hit rate / , young-making rate 0 / not 0 / Pages read ahead 0./s, evicted without access 0./s, Random read ahead 0./sLRU len: , unzip_LRU len: 0I/O sum[]:cur[], unzip sum[0]:cur[0]---BUFFER POOL 5Buffer pool size Buffer pool size, bytes Free buffers Database pages Old database pages Modified db pages Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young , not young . youngs/s, 0. non-youngs/sPages read , created , written . reads/s, 3. creates/s, . writes/sBuffer pool hit rate / , young-making rate 0 / not 0 / Pages read ahead 0./s, evicted without access 0./s, Random read ahead 0./sLRU len: , unzip_LRU len: 0I/O sum[]:cur[], unzip sum[0]:cur[0]---BUFFER POOL 6Buffer pool size Buffer pool size, bytes Free buffers Database pages Old database pages Modified db pages Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young , not young . youngs/s, 0. non-youngs/sPages read , created , written . reads/s, 0. creates/s, . writes/sBuffer pool hit rate / , young-making rate 0 / not 0 / Pages read ahead 0./s, evicted without access 0./s, Random read ahead 0./sLRU len: , unzip_LRU len: 0I/O sum[]:cur[], unzip sum[0]:cur[0]---BUFFER POOL 7Buffer pool size Buffer pool size, bytes Free buffers Database pages Old database pages Modified db pages Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young , not young . youngs/s, 0. non-youngs/sPages read , created , written . reads/s, 0. creates/s, . writes/sBuffer pool hit rate / , young-making rate 0 / not 0 / Pages read ahead 0./s, evicted without access 0./s, Random read ahead 0./sLRU len: , unzip_LRU len: 0I/O sum[]:cur[], unzip sum[0]:cur[0]--------------ROW OPERATIONS--------------0 queries inside InnoDB, 0 queries in queue1 read views open inside InnoDB0 RW transactions active inside InnoDB0 RO transactions active inside InnoDB0 out of descriptors used---OLDEST VIEW---Normal read viewRead view low limit trx n:o Read view up limit trx id Read view low limit trx id Read view individually stored trx ids:-----------------Main thread process no. , id , state: sleepingNumber of rows inserted , updated , deleted , read . inserts/s, . updates/s, 0. deletes/s, . reads/s----------------------------END OF INNODB MONITOR OUTPUT============================

MySQL 5.6 & 5.7最优配置文件模板(my.ini) Inside君整理了一份最新基于MySQL5.6和5.7的配置文件模板,基本上可以说覆盖%的调优选项,用户只需根据自己的服务器配置稍作修改即可,如InnoDB缓冲池

MYSQL神秘的HANDLER命令与实现方法 MySQL自古以来都有一个神秘的HANDLER命令,而此命令非SQL标准语法,可以降低优化器对于SQL语句的解析与优化开销,从而提升查询性能。看到这里,可能

全面解析Windows下安装 mysql5.7的方法 关于在windows下安装mysql5.7要注意的新坑:5.7版本安装后ROOT账号是有默认的密码的,这个密码在windows下可以在mysql.ini配置文件指定的data文件夹下面,那

标签: Slave memory leak and trigger oom-killer

本文链接地址:https://www.jiuchutong.com/biancheng/347924.html 转载请保留说明!

上一篇:MySQL Slave 触发 oom-killer解决方法(mysql触发事件)

下一篇:MySQL 5.6 & 5.7最优配置文件模板(my.ini)(mysql 5.6 5.7 性能)

  • 已提折旧
  • 房产税与土地使用税如何申报
  • 员工餐补是放入福利费吗?
  • 分公司法人必须是总公司法人吗
  • 备用金三栏式明细账图片
  • 预算外收入计入什么科目
  • 安装设备领用自产产品按成本还是计税价格
  • 借款合同法律规定的表述
  • 预计退货的会计分录 东奥
  • 给员工发结婚礼金怎么说
  • 法院的申请执行费用什么时候收取
  • 自然灾害造成库存商品毁损
  • 非公益性捐赠支出是永久性差异吗
  • 奖励积分换取商品会计处理
  • 增值税普通发票可以抵扣吗
  • 信用证和银行承兑汇票的区别如何做分录
  • 收到测试费几分钱如何做账
  • 固定资产划转要交增值税吗
  • 物流公司货车报废款怎么做账
  • 携程只有电子发票吗
  • 将捐赠收入计入资本公积转增增值税
  • 英雄联盟符文推荐怎么不弹出来
  • win10重置此电脑的密码是什么
  • 如何办理存款证明
  • 自主研发全流程
  • php快递查询系统
  • 适用于初学者的美得理电子琴
  • 收到保险公司的车赔款会计分录怎么写
  • 固定资产原值,净值,价值的区别
  • php中md5函数
  • 应付职工薪酬的借方和贷方
  • 何为前端后端
  • wordpress添加css
  • uniapp和vue混合开发
  • br命令怎么用
  • 合宪性审查程序
  • 印花税怎么从账上取数
  • 凭证过账后发现了错误,如何处理
  • 送货运输费用税率
  • 什么是增值税举个例子
  • 固定资金是什么科目
  • 固定资产处置怎么计算
  • springboot怎么配置拦截器
  • rust 前端开发
  • mongodb管道操作符
  • mongodb视频教程
  • 待抵扣进项税的限额是什么
  • 代扣和代缴的区别
  • 用友t3建账行业性质怎么选
  • 为取得固定资产而发生的什么支出可计入固定资产成本
  • 混凝土增值税发票税率
  • 简易计税方法缴纳城建税和教育税
  • 补付预付账款账务处理分录
  • 物流辅助服务属于
  • 一般纳税人购买汽车会计分录
  • 样品定义是什么
  • 什么叫系统服务
  • 在企业中的应用
  • 开红字发票后再开蓝字发票如何入账
  • SQL Server Alwayson创建代理作业的注意事项详解
  • 防御sql注入的方法有哪几种
  • sql server 错误
  • sql语句分号
  • windowsserver2008r2版本区别
  • CentOS7的hostnamectl命令使用详解
  • centos安装后配置
  • win+tab键
  • Linux /bin, /sbin, /usr/bin, /usr/sbin 区别
  • win10 win8.1双系统
  • win10极限精简版 200m
  • win10系统打开文件夹就不停的闪
  • unity serial number
  • js写贪吃蛇什么水平
  • 批处理列出文件名
  • node.js中http模块和url模块的简单介绍
  • js获取节点值
  • jquery one
  • js随机生成一个整数
  • javascript要学到什么程度
  • 基层税收工作的建议意见
  • 免责声明:网站部分图片文字素材来源于网络,如有侵权,请及时告知,我们会第一时间删除,谢谢! 邮箱:opceo@qq.com

    鄂ICP备2023003026号

    网站地图: 企业信息 工商信息 财税知识 网络常识 编程技术

    友情链接: 武汉网站建设