位置: 编程技术 - 正文

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 性能)

  • 小规模纳税人没有税控盘怎么报税
  • 汽车运输企业付给车主的运费算成本吗
  • 公司股东分红要交哪些税
  • 超过规定标准的扣除项目金额怎么算
  • 公司交房租没有开票能记账?
  • 长期股权投资是金融资产还是非金融资产
  • 企业账号变更
  • 转给子公司发工资分录
  • 长期借款科目核算的是企业的长期借款本金和利息
  • 广告业与服务业哪个好
  • 冲减应付账款
  • 安全费用支出范围包括
  • 员工缴纳的工会会费可以税前扣除吗
  • 单独计价入账的土地是无形资产吗
  • 企业财务会计制度范本
  • 借入款项的来源包括哪三个
  • 试分析营改增的重大意义
  • 文体活动费用计入什么科目
  • 增值税专用发票可以开电子发票吗
  • 一般纳税人能否享受残保金优惠
  • 收到培训机构的电话骚扰该怎么办?
  • 结构化存款是什么
  • 发出商品确认收入的条件
  • 以前年度多做了收入怎样调账
  • 库存股股本属于什么科目,借贷方向
  • 公司组织的团建受伤算工伤吗
  • 企业收到留抵退税宣传报道
  • win11家庭版怎么激活
  • 商标注册费相关法律法规
  • 汇兑损益 纳税调整
  • 退税需要怎么操作
  • 可以关闭系统的快捷键
  • php代码封装成dll
  • phpadmin官网
  • pniopcac.exe是什么进程
  • PHP daddslashes 使用方法介绍
  • 个体户转企业怎么做账
  • 生产型企业出口退税计算案例
  • php中array怎么用
  • 职工教育经费能结转几年
  • 收据入帐
  • sql server 实例
  • 固定资产清理往报表哪列示
  • 公司销售的产品算固定资产吗
  • 开专票还是开发票
  • 小规模纳税人增值税计算公式
  • 特殊收入如何计税
  • 营改增试点行业顺序
  • 银行回单中包含哪些内容
  • 怎样在excel计算
  • 车辆理赔款如何入账
  • 国家退税计入什么科目
  • 转出未交增值税会计处理
  • 存货期末成本的计量
  • 非流动资产处置利得计入什么科目
  • 递延收益的影响
  • 咨询服务费开票税率
  • 转出投资款计入现金流量表的哪里
  • 招标场地费由谁支付
  • 建造合同收入
  • windows10右键菜单打开太慢
  • xp怎么隐藏运行的程序
  • mac的浏览记录在哪儿
  • centos7.7安装
  • centos sh
  • mini program是什么
  • win8开机界面
  • 在linux操作系统中,/etc/rc.d/init.d
  • js中dom的用法
  • ECMAScript5(ES5)中bind方法使用小结
  • 高性能javascript的内容简介
  • 时间戳的差值
  • python的urllib
  • Javascript Objects详解
  • Windows上使用PD虚拟机
  • 重庆税务登记证在哪里办理
  • 社保申报每月几号申报
  • 成品油消费税税率表
  • 2008土地管理办法
  • 山西省税务局网站系统维护公告
  • 免责声明:网站部分图片文字素材来源于网络,如有侵权,请及时告知,我们会第一时间删除,谢谢! 邮箱:opceo@qq.com

    鄂ICP备2023003026号

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

    友情链接: 武汉网站建设