首页 > linux, mysql > ext4 mysql flush_log 相关

ext4 mysql flush_log 相关

2013年6月7日 eric 发表评论 阅读评论

最近有一些业务服务器开始使用6.3服务器,顾客开始说访问页面会卡,主要反映在切换页面,数据交互等,开始开始技术排查问题,同样的代码,同样的 apache mysql php 的配置,在 5.5 上运行很正常,在 6.3 运行就会卡。把问题转交到我手上,我开始对操作系统进行了排查。
发现 5.5 服务器内核是 2.6.18,6.3的服务器内核是 2.6.32。查看硬件配置也是一样的,查看两边的 mysql配置文件也一样,这时候我觉得是不是 6.3 与 5.5 开机挂载磁盘的参数不一样呢?

两边都执行 cat /proc/mounts 后发现6.3 多一个 barrier=1 参数 而 5.5 没有,经过 google 发现这个参数是 2.6.22 以上内核开始有的,barrier=1,可以保证文件系统在日志数据写入磁盘之后才写commit记录,但影响性能。但是我们的 mysql 有个参数是每次的操作都要flush日志,这样的话每次就要提交两次,一就是有序写入。我们之前都是无序写入,虽然提高了安全性能,但是降低了性能,权衡之后我还是把 mysql 的参数改为2,这样的话我最多能丢失上一秒的数据,在可控范围内innodb_flush_log_at_trx_commit = 2
这样 6.3 不会出现卡的情况了。

转载请注明:文章转载自:Eric's linux and nginx! (http://www.nginxs.com)
本文地址:http://www.nginxs.com/linux/511.html

分类: linux, mysql 标签: , ,
  1. 2017年12月23日11:10 | #1

    I for all time emailed this web site post page to all my friends, because if like to read it afterward my links will too.

  2. 2017年12月23日12:57 | #2

    We are a gaggle of volunteers and opening a new scheme in our community. Your website offered us with useful info to work on. You’ve done a formidable job and our whole community will probably be thankful to you.

  3. 2017年12月23日13:05 | #3

    360 Mac Cleaner 360 Mac Cleaner 360 Mac Cleaner 360 Mac Cleaner 360 Mac Cleaner 360 Mac Cleaner 360 Mac Cleaner

  4. 2017年12月23日14:34 | #4

    Advanced Mac Cleaner Avis Advanced Mac Cleaner Avis Advanced Mac Cleaner Avis Advanced Mac Cleaner Avis Advanced
    Mac Cleaner Avis Advanced Mac Cleaner Avis Advanced Mac Cleaner Avis

  5. 2017年12月23日14:38 | #5

    Adobe Cs Cleaner Tool Para Mac Os Adobe Cs Cleaner
    Tool Para Mac Os Adobe Cs Cleaner Tool Para Mac Os Adobe Cs Cleaner Tool Para Mac Os Adobe Cs Cleaner Tool Para Mac Os Adobe Cs Cleaner Tool
    Para Mac Os Adobe Cs Cleaner Tool Para Mac Os

  6. 2017年12月23日17:27 | #6

    New antivirus para mac Finally New antivirus para mac Finally New antivirus para mac Finally
    New antivirus para mac Finally New antivirus para mac Finally
    New antivirus para mac Finally New antivirus para mac Finally

  7. 2017年12月23日19:35 | #7

    If some one wants expert view regarding blogging then i suggest him/her to pay a visit this webpage, Keep up the good work.

  8. 2017年12月23日21:12 | #8

    Antivirus Live CD For Linux Windows And Mac New 2017 Antivirus Live CD For Linux Windows And Mac New
    2017 Antivirus Live CD For Linux Windows And
    Mac New 2017 Antivirus Live CD For Linux Windows And Mac New 2017 Antivirus Live
    CD For Linux Windows And Mac New 2017 Antivirus
    Live CD For Linux Windows And Mac New 2017 Antivirus Live CD For
    Linux Windows And Mac New 2017

  9. 2017年12月23日21:17 | #9

    Hello, after reading this awesome article i am too glad to share my experience here with friends.

  10. 2017年12月24日00:37 | #10

    Thanks for finally writing about > %blog_title% < Liked it!

  11. ElvaDcg
    2017年12月25日20:05 | #11

    апрапрапр

  12. 2017年12月27日22:24 | #12

    casino games
    casino online
    casino games list
    casino games
    casino games

  13. 2017年12月28日12:27 | #13

    Advanced Mac Cleaner Ad Advanced Mac Cleaner Ad Advanced Mac Cleaner Ad Advanced Mac Cleaner Ad Advanced Mac Cleaner Ad
    Advanced Mac Cleaner Ad Advanced Mac Cleaner Ad

  14. 2017年12月28日12:47 | #14

    Advanced Mac Cleaner 50 Discount Advanced Mac Cleaner 50 Discount Advanced Mac Cleaner
    50 Discount Advanced Mac Cleaner 50 Discount Advanced Mac Cleaner
    50 Discount Advanced Mac Cleaner 50 Discount Advanced
    Mac Cleaner 50 Discount

  15. 2017年12月28日12:51 | #15

    Finally 2017 Avez-vous besoin d’un antivirus sur
    Mac ? Important 2017 Finally 2017 Avez-vous besoin d’un antivirus
    sur Mac ? Important 2017 Finally 2017 Avez-vous besoin d’un antivirus
    sur Mac ? Important 2017 Finally 2017 Avez-vous besoin d’un antivirus sur Mac ?
    Important 2017 Finally 2017 Avez-vous besoin d’un antivirus
    sur Mac ? Important 2017 Finally 2017 Avez-vous besoin d’un antivirus sur Mac
    ? Important 2017 Finally 2017 Avez-vous besoin d’un antivirus sur Mac ?
    Important 2017

  16. 2017年12月28日12:53 | #16

    Adobe Cleaner Tool Mac Download Adobe Cleaner Tool Mac Download Adobe Cleaner Tool Mac Download Adobe Cleaner Tool Mac Download Adobe Cleaner Tool Mac Download Adobe Cleaner Tool Mac Download Adobe Cleaner
    Tool Mac Download

  17. 2017年12月28日13:25 | #17

    Braucht ein Mac Anti Virus Software?! New 2017 Braucht ein Mac Anti Virus
    Software?! New 2017 Braucht ein Mac Anti Virus Software?!
    New 2017 Braucht ein Mac Anti Virus Software?! New 2017 Braucht
    ein Mac Anti Virus Software?! New 2017 Braucht ein Mac Anti Virus Software?!

    New 2017 Braucht ein Mac Anti Virus Software?! New
    2017

  18. 2017年12月28日13:26 | #18

    Best 2017 Tech Tip 2 – Antivirus for Mac Finally Best 2017 Tech
    Tip 2 – Antivirus for Mac Finally Best 2017 Tech Tip 2 – Antivirus for Mac Finally Best 2017
    Tech Tip 2 – Antivirus for Mac Finally Best 2017
    Tech Tip 2 – Antivirus for Mac Finally Best 2017
    Tech Tip 2 – Antivirus for Mac Finally Best 2017 Tech Tip 2 – Antivirus
    for Mac Finally

  19. 2017年12月28日13:59 | #19

    mac cleaner mac cleaner mac cleaner mac cleaner mac cleaner mac cleaner mac
    cleaner

  20. 2017年12月28日14:01 | #20

    New 2017 Iantivirus Antivirus GRATUIT pour mac Best GRATUIT pour mac Best GRATUIT
    pour mac Best GRATUIT pour mac Best New 2017 Iantivirus Antivirus GRATUIT pour mac Best

  21. 2017年12月28日14:03 | #21

    Finally Mac Fake Antivirus Important Finally Mac Fake Antivirus Important Finally
    Mac Fake Antivirus Important Finally Mac Fake Antivirus Important Finally Mac Fake Antivirus Important Finally Mac Fake Antivirus Important Finally Mac
    Fake Antivirus Important

  22. 2017年12月28日14:06 | #22

    Adware Cleaner Mac Chip Adware Cleaner Mac Chip Adware Cleaner Mac Chip
    Adware Cleaner Mac Chip Adware Cleaner Mac Chip Adware Cleaner
    Mac Chip Adware Cleaner Mac Chip

  23. 2017年12月28日14:10 | #23

    Best My mac antivirus found a mac malware /trojan horse / virus !
    New 2017 Best My mac antivirus found a mac malware /trojan horse
    / virus ! New 2017 Best My mac antivirus found a mac malware /trojan horse / virus !
    New 2017 Best My mac antivirus found a mac malware /trojan horse / virus !
    New 2017 Best My mac antivirus found a mac malware /trojan horse / virus !
    New 2017 Best My mac antivirus found a mac
    malware /trojan horse / virus ! New 2017 Best My mac antivirus found a mac malware /trojan horse / virus !

    New 2017

  24. 2017年12月28日14:17 | #24

    Alternative To Mac Cleaner Alternative To Mac Cleaner Alternative To Mac Cleaner Alternative To Mac Cleaner Alternative To Mac Cleaner Alternative To Mac Cleaner Alternative To Mac Cleaner

  25. 2017年12月28日15:37 | #25

    FREE MAC ANTIVIRUS Sophos Anti-Virus for Mac Home Edition New FREE MAC ANTIVIRUS Sophos Anti-Virus for Mac Home Edition New FREE MAC ANTIVIRUS Sophos Anti-Virus for Mac Home Edition New FREE MAC ANTIVIRUS Sophos Anti-Virus for
    Mac Home Edition New FREE MAC ANTIVIRUS Sophos Anti-Virus for Mac Home
    Edition New FREE MAC ANTIVIRUS Sophos Anti-Virus for Mac Home Edition New FREE MAC
    ANTIVIRUS Sophos Anti-Virus for Mac Home Edition New

  26. 2017年12月28日15:45 | #26

    Adobe Cs Cleaner Tool For Mac Adobe Cs Cleaner Tool
    For Mac Adobe Cs Cleaner Tool For Mac Adobe Cs Cleaner Tool For Mac Adobe Cs Cleaner Tool For
    Mac Adobe Cs Cleaner Tool For Mac Adobe Cs Cleaner Tool For Mac

  27. 2017年12月28日16:06 | #27

    Erstes Tutorial: Auf Mac Antivirus Programm installieren New 2017 Erstes
    Tutorial: Auf Mac Antivirus Programm installieren New 2017 Erstes Tutorial: Auf Mac Antivirus Programm
    installieren New 2017 Erstes Tutorial: Auf Mac Antivirus Programm
    installieren New 2017 Erstes Tutorial: Auf Mac
    Antivirus Programm installieren New 2017 Erstes Tutorial: Auf Mac Antivirus
    Programm installieren New 2017 Erstes Tutorial: Auf Mac Antivirus Programm installieren New 2017

  28. 2017年12月28日16:20 | #28

    Finally Avast Free Antivirus for Mac – Protect your Mac OS
    - Download Video Preview Finally Finally Avast Free Antivirus for Mac –
    Protect your Mac OS – Download Video Preview Finally Finally
    Avast Free Antivirus for Mac – Protect your Mac OS – Download Video Preview
    Finally Finally Avast Free Antivirus for Mac – Protect your Mac OS – Download Video Preview
    Finally Finally Avast Free Antivirus for Mac – Protect your Mac OS – Download Video Preview
    Finally Finally Avast Free Antivirus for Mac – Protect your Mac OS –
    Download Video Preview Finally Finally Avast Free Antivirus for Mac – Protect your Mac
    OS – Download Video Preview Finally

  29. 2017年12月28日16:27 | #29

    Amazing 2017 Bitdefender Antivirus for Mac 2016 v4.1.2.18 + Crack 2017 MacOSX Important Amazing 2017 Bitdefender
    Antivirus for Mac 2016 v4.1.2.18 + Crack 2017 MacOSX Important Amazing 2017 Bitdefender Antivirus for Mac 2016 v4.1.2.18
    + Crack 2017 MacOSX Important Amazing 2017 Bitdefender Antivirus for Mac 2016 v4.1.2.18 +
    Crack 2017 MacOSX Important Amazing 2017 Bitdefender Antivirus for Mac 2016 v4.1.2.18 + Crack 2017 MacOSX Important Amazing 2017 Bitdefender Antivirus for Mac 2016 v4.1.2.18 + Crack 2017 MacOSX Important
    Amazing 2017 Bitdefender Antivirus for Mac 2016 v4.1.2.18 + Crack 2017 MacOSX Important

  30. 2017年12月28日16:34 | #30

    An Apple Mac An Apple Mac An Apple Mac An Apple Mac An Apple
    Mac An Apple Mac An Apple Mac

  31. 2017年12月28日16:41 | #31

    New EL MEJOR ANTIVIRUS PARA MAC Finally 2017 New
    EL MEJOR ANTIVIRUS PARA MAC Finally 2017 New EL MEJOR ANTIVIRUS PARA MAC Finally
    2017 New EL MEJOR ANTIVIRUS PARA MAC Finally 2017 New EL MEJOR ANTIVIRUS PARA MAC Finally 2017 New EL MEJOR ANTIVIRUS PARA MAC Finally 2017 New
    EL MEJOR ANTIVIRUS PARA MAC Finally 2017

  32. 2017年12月28日16:56 | #32

    Amazing 2017 Kaspersky antivirus for Mac Amazing 2017 Amazing 2017 Kaspersky antivirus for Mac Amazing 2017 Amazing 2017 Kaspersky antivirus
    for Mac Amazing 2017 Amazing 2017 Kaspersky antivirus for
    Mac Amazing 2017 Amazing 2017 Kaspersky antivirus for Mac Amazing 2017 Amazing 2017 Kaspersky antivirus for Mac Amazing 2017 Amazing 2017 Kaspersky antivirus
    for Mac Amazing 2017

  33. 2017年12月28日16:57 | #33

    Important How to Totally Uninstall Avira Free
    Antivirus for Mac (Osx Uninstaller) Finally 2017 Important
    How to Totally Uninstall Avira Free Antivirus for Mac (Osx Uninstaller) Finally 2017 Important How to Totally
    Uninstall Avira Free Antivirus for Mac (Osx Uninstaller) Finally 2017 Important How to Totally
    Uninstall Avira Free Antivirus for Mac (Osx Uninstaller) Finally 2017 Important How to Totally
    Uninstall Avira Free Antivirus for Mac (Osx Uninstaller) Finally 2017 Important How
    to Totally Uninstall Avira Free Antivirus for Mac (Osx Uninstaller) Finally 2017 Important How to Totally Uninstall Avira Free Antivirus for
    Mac (Osx Uninstaller) Finally 2017

  34. 2017年12月28日16:58 | #34

    Advanced Mac Cleaner Co To Jest Advanced Mac Cleaner
    Co To Jest Advanced Mac Cleaner Co To Jest Advanced Mac Cleaner Co To
    Jest Advanced Mac Cleaner Co To Jest Advanced Mac Cleaner Co To Jest Advanced Mac Cleaner Co To Jest

  35. 2017年12月28日17:06 | #35

    Important 2017 How Do You Disable Antivirus Software On A Mac?

    Amazing Important 2017 How Do You Disable Antivirus Software On A Mac?
    Amazing Important 2017 How Do You Disable Antivirus Software On A Mac?

    Amazing Important 2017 How Do You Disable Antivirus Software On A Mac?
    Amazing Important 2017 How Do You Disable Antivirus Software On A Mac?
    Amazing Important 2017 How Do You Disable Antivirus Software On A Mac?
    Amazing Important 2017 How Do You Disable Antivirus Software On A Mac?
    Amazing

  36. 2017年12月28日18:27 | #36

    Three simple steps to uninstall Avira Free Antivirus in Mac OS X Important Three simple steps to uninstall Avira Free Antivirus
    in Mac OS X Important Three simple steps to uninstall Avira Free
    Antivirus in Mac OS X Important Three simple steps to uninstall Avira Free Antivirus in Mac OS X
    Important Three simple steps to uninstall Avira Free Antivirus
    in Mac OS X Important Three simple steps to uninstall Avira Free Antivirus in Mac OS X Important Three simple steps
    to uninstall Avira Free Antivirus in Mac OS X Important

  37. 2017年12月28日18:32 | #37

    Advanced Mac Cleaner Any Good Advanced Mac Cleaner Any Good
    Advanced Mac Cleaner Any Good Advanced Mac Cleaner
    Any Good Advanced Mac Cleaner Any Good Advanced Mac Cleaner Any Good Advanced Mac Cleaner Any Good

  38. 2017年12月28日18:48 | #38

    C

  39. 2017年12月28日18:50 | #39

    New 2017 Bitdefender Antivirus 2016 v4 0 2 Mac OS X New 2017 New 2017
    Bitdefender Antivirus 2016 v4 0 2 Mac OS X New 2017 New 2017
    Bitdefender Antivirus 2016 v4 0 2 Mac OS X New 2017 New 2017 Bitdefender
    Antivirus 2016 v4 0 2 Mac OS X New 2017 New 2017 Bitdefender Antivirus 2016 v4 0 2 Mac OS X New 2017 New 2017 Bitdefender Antivirus 2016
    v4 0 2 Mac OS X New 2017 New 2017 Bitdefender Antivirus 2016 v4 0 2 Mac
    OS X New 2017

  40. 2017年12月28日19:02 | #40

    Important Avira Antivirus Pro 2017 Crack with Activation Code [Windows + Mac] Best 2017 Important Avira Antivirus Pro 2017 Crack with Activation Code [Windows + Mac]
    Best 2017 Important Avira Antivirus Pro 2017 Crack with Activation Code [Windows + Mac]
    Best 2017 Important Avira Antivirus Pro 2017 Crack with Activation Code [Windows + Mac] Best 2017 Important Avira Antivirus Pro 2017 Crack with Activation Code [Windows + Mac] Best 2017 Important Avira Antivirus Pro 2017 Crack
    with Activation Code [Windows + Mac] Best 2017 Important Avira Antivirus Pro 2017 Crack with Activation Code [Windows + Mac] Best 2017

  41. 2017年12月28日19:17 | #41

    Advanced Mac Cleaner Won’T Delete Advanced Mac Cleaner Won’T Delete Advanced Mac Cleaner Won’T Delete Advanced
    Mac Cleaner Won’T Delete Advanced Mac Cleaner Won’T Delete Advanced Mac Cleaner
    Won’T Delete Advanced Mac Cleaner Won’T Delete

  42. 2017年12月28日19:19 | #42

    Adobe Cs5 Cleaner Tool Mac Download Adobe Cs5 Cleaner Tool Mac Download Adobe Cs5 Cleaner Tool Mac Download Adobe
    Cs5 Cleaner Tool Mac Download Adobe Cs5 Cleaner Tool Mac Download Adobe Cs5 Cleaner Tool Mac Download Adobe Cs5 Cleaner Tool Mac
    Download

  43. 2017年12月28日19:59 | #43

    Amazing Tuto Amazing Tuto Amazing Tuto Amazing Tuto Amazing Tuto Amazing Tuto Amazing Tuto

  44. 2017年12月28日20:03 | #44

    Advanced Mac Cleaner Avinstallera Advanced Mac Cleaner Avinstallera Advanced Mac Cleaner Avinstallera Advanced Mac
    Cleaner Avinstallera Advanced Mac Cleaner Avinstallera
    Advanced Mac Cleaner Avinstallera Advanced Mac Cleaner Avinstallera

  45. 2017年12月28日20:40 | #45

    Advanced Mac Cleaner Activation Key Advanced Mac Cleaner Activation Key
    Advanced Mac Cleaner Activation Key Advanced Mac Cleaner Activation Key Advanced Mac Cleaner Activation Key Advanced Mac Cleaner Activation Key Advanced
    Mac Cleaner Activation Key

  46. 2017年12月28日20:43 | #46

    All Apple Macs All Apple Macs All Apple Macs All Apple Macs All Apple Macs All Apple Macs All Apple Macs

  47. 2017年12月28日21:42 | #47

    Best 2017 Sophos Antivirus for Mac – Get overall protection for your
    Mac – Download Video Previews Best 2017 Sophos Antivirus for Mac
    - Get overall protection for your Mac – Download Video Previews Best 2017 Sophos
    Antivirus for Mac – Get overall protection for your Mac – Download Video Previews Best 2017 Sophos Antivirus for Mac – Get
    overall protection for your Mac – Download Video Previews Best 2017
    Sophos Antivirus for Mac – Get overall protection for
    your Mac – Download Video Previews Best 2017 Sophos Antivirus for
    Mac – Get overall protection for your Mac – Download Video Previews Best 2017 Sophos Antivirus for Mac
    - Get overall protection for your Mac – Download Video
    Previews

  48. 2017年12月28日22:24 | #48

    3 Easy Steps to Remove AVG AntiVirus 2016 for Mac Finally 2017 3 Easy
    Steps to Remove AVG AntiVirus 2016 for Mac Finally 2017 3 Easy
    Steps to Remove AVG AntiVirus 2016 for Mac Finally 2017 3 Easy Steps to
    Remove AVG AntiVirus 2016 for Mac Finally 2017 3
    Easy Steps to Remove AVG AntiVirus 2016 for Mac Finally 2017 3 Easy
    Steps to Remove AVG AntiVirus 2016 for Mac Finally 2017 3 Easy Steps
    to Remove AVG AntiVirus 2016 for Mac Finally 2017

  49. 2017年12月29日00:46 | #49

    Advanced Mac Cleaner Apple Support Advanced Mac Cleaner Apple Support Advanced Mac Cleaner Apple Support Advanced Mac Cleaner
    Apple Support Advanced Mac Cleaner Apple Support Advanced
    Mac Cleaner Apple Support Advanced Mac Cleaner Apple Support

  50. 2017年12月29日01:12 | #50

    New 2017 Quick Way to Uninstall Bitdefender Antivirus for Mac Best New
    2017 Quick Way to Uninstall Bitdefender Antivirus for Mac Best New
    2017 Quick Way to Uninstall Bitdefender Antivirus for Mac Best New
    2017 Quick Way to Uninstall Bitdefender Antivirus for Mac Best New 2017 Quick Way to Uninstall Bitdefender Antivirus for Mac Best New 2017 Quick Way to
    Uninstall Bitdefender Antivirus for Mac Best New 2017 Quick Way to Uninstall Bitdefender Antivirus for
    Mac Best

评论分页
订阅评论
0+4= (必填)