位置: 编程技术 - 正文

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

  • 上年度已交房产税减免如何做账务处理
  • 小规模纳税人月收入多少免征增值税
  • 预算会计退回预付差旅费如何记账?
  • 非盈利组织企业所得税主表如何填列
  • 电子税务局如何变更财务负责人
  • 如何在电子税务局开具全电发票
  • 个税完税凭证在哪里打印出来
  • 现金股利什么时候发放
  • 房产税收取标准有哪些
  • 火车票补票报销流程
  • 留存收益筹资的优缺点
  • 农业合作社预付款怎么算
  • 送现金券活动方案
  • 其他综合收益是利润表项目吗
  • 开个人普发票需要什么资料?
  • 个人销售货物缴纳增值税吗
  • 软件维护费入什么科目
  • 房地产的出租行为属于土地增值税征收范围吗
  • 案例讲解:当年度未及时取得有效凭证的相关成本、费用涉税处理
  • 广告宣传费扣除标准30%是什么?
  • 个人缴纳工会费可以在工资里面扣交吗
  • 固定资产差额
  • 进口原材料的关税怎么算
  • word从一台电脑考到另一台电脑格式不一致怎么解决
  • 本月的应收账款,实际到下个月了会怎么样
  • 债券到期收回本息的会计分录
  • php创建二维数组
  • 贷款损失会计处理
  • 政府奖励怎么做账
  • 待摊费用和预提费用改为什么科目了
  • php教程视频
  • js设置input值
  • php生成图片验证怎么弄
  • 金蝶 账无忧 使用说明
  • 融资租赁业务增资扩股
  • 简单实现php留言功能
  • 增值税折扣发票有折扣字样
  • handsome主题破解
  • 施工企业的人工费占比
  • 公允价值怎么记账
  • 普通发票作废要做账吗
  • mybatis拦截器执行顺序
  • 股东清算收入是负债吗
  • 未开票收入缴纳增值税吗
  • 出口销售收入计算公式
  • 第四季度所得税跟汇算清缴是一样吗
  • 如何在Access中设置有效性规则必须大于等于0
  • 小规模增值税纳税人优惠政策
  • 厂房出租没有开发票属于违法吗?
  • 供应商货款支付流程
  • 财务报告分析主要内容
  • 工地的工人工资怎么入账
  • 存货报废的会计分录怎么做
  • 债权人接受债务怎么处理
  • 保险公司的业务分为
  • 设置mysql数据库字符集的语句
  • win8.1使用技巧
  • win xp系统安装
  • 苹果电脑重新安装macos失败
  • linux系统中常用的五种文件类型
  • player文件怎么打开
  • windows7出现错误恢复怎么办
  • linux三种用户权限
  • win8怎么用一键ghost
  • jquery示例
  • opengl环境配置
  • android view动画
  • Express作者TJ告别Node.js奔向Go
  • linux chmod s
  • Unity 中WWW加载 AssetBundle---中文路径
  • jquery.form
  • unity移动脚本代码
  • jquery实例
  • 原生js实现移动站点头部搜索栏背景色透明度变化
  • jquery找父级
  • js实现省份和市级联动
  • 广东国税局发票查询系统
  • 2016年小微企业所得税标准
  • 房产税纳税义务时间
  • 广州地税微信公众号
  • 免责声明:网站部分图片文字素材来源于网络,如有侵权,请及时告知,我们会第一时间删除,谢谢! 邮箱:opceo@qq.com

    鄂ICP备2023003026号

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

    友情链接: 武汉网站建设