首页 > 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. wanted
    2013年9月6日15:14 | #1

    3个月了,博主还记得当时干了什么吧,求分享。

  2. 2013年9月16日16:57 | #2

    不好意思·真的是越来越懒@wanted

  3. 2017年5月16日00:02 | #3

    Охотно принимаю. На мой взгляд, это интересный вопрос, буду принимать участие в обсуждении.

    інцест ремень или мама соблазнила сына рассказы

  4. 2017年5月19日18:50 | #4

    Hello there! Do you know if they make any plugins to help with SEO?
    I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains.
    If you know of any please share. Thanks!

  5. 2017年5月21日18:45 | #5

    А это надо брать!Спасибо!

    эротический рассказ отчим а также пизда сестры рассказ

  6. 2017年5月23日17:22 | #6

    Вы не правы. Давайте обсудим это. Пишите мне в PM.

    порно расказ про тетя или еро розкази мама и дочь

  7. 2017年5月28日15:35 | #7

    Sweet blog! I found it while surfing around on Yahoo News.
    Do you have any suggestions on how to get listed in Yahoo News?

    I’ve been trying for a while but I never seem to get there!

    Cheers

  8. 2017年6月16日04:22 | #8

    phone number information free how to get phone number for free reverse vlookup in excel
    white pages free results searching address by mobile number reverse directory phone numbers get phone numbers free

  9. 2017年6月27日09:59 | #9

    judicial public records is there a free background check site how to get
    a free background check online how to get a free background check how to
    get background check for free look up public records for free immigration background check

  10. 2017年6月27日16:51 | #10

    jail records texas how to get a personal background check jail records local crime reports free how to
    search public records free is a driving conviction a criminal conviction locate a person by phone number

  11. 2017年6月27日17:24 | #11

    instant people search juvenile criminal records how
    to locate an address for a person look up people for free how to run background check
    on someone look up peoples records free iowa department of public health vital records

  12. 2017年6月27日21:45 | #12

    how to obtain a criminal background check how to find someone s criminal history look up people iowa court records online how to obtain public records for free look up peoples criminal records lookup
    people

  13. 2017年6月28日00:35 | #13

    largest background screening companies locate a person for free instant criminal background check lookup people jacksonville florida criminal records
    international background check local criminal background check

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

    look up people free how to search for someone online how to
    get a free background check on someone los angeles public records how to locate a person lookup people com how to obtain arrest records

  15. 2017年6月28日16:16 | #15

    how to search for a person how to search public records for free illinois criminal court records how to obtain background check for free how to obtain criminal background check how to obtain arrest records i need a background check

  16. DorisTiems
    2017年7月15日03:30 | #16

    Absolutely NEW update of SEO/SMM package “XRumer 16.0 + XEvil”:
    captchas breaking of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
    and more than 8400 another size-types of captcha,
    with highest precision (80..100%) and highest speed (100 img per second).
    You can connect XEvil 3.0 to all most popular SEO/SMM software: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other programms.

    Interested? There are a lot of introducing videos about XEvil in YouTube.
    Good luck ;)

    XRumer201707

  17. DorisTiems
    2017年7月17日13:58 | #17

    Revolutional update of SEO/SMM software “XRumer 16.0 + XEvil”:
    captcha solution of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
    and more than 8400 another types of captcha,
    with highest precision (80..100%) and highest speed (100 img per second).
    You can connect XEvil 3.0 to all most popular SEO/SMM software: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.

    Interested? There are a lot of introducing videos about XEvil in YouTube.
    Good luck ;)

    XRumer201707

  18. DorothyRuirm
    2017年7月18日03:38 | #18

    Revolutional update of SEO/SMM software “XRumer 16.0 + XEvil 3.0″:
    captcha recognition of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
    and more than 8400 another categories of captchas,
    with highest precision (80..100%) and highest speed (100 img per second).
    You can connect XEvil 3.0 to all most popular SEO/SMM programms: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.

    Interested? You can find a lot of introducing videos about XEvil in YouTube.
    See you later!

    XRumer20170717

  19. DorothyRuirm
    2017年7月19日03:35 | #19

    Revolutional update of SEO/SMM package “XRumer 16.0 + XEvil”:
    captcha solving of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
    and more than 8400 another subtypes of captchas,
    with highest precision (80..100%) and highest speed (100 img per second).
    You can connect XEvil 3.0 to all most popular SEO/SMM programms: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.

    Interested? You can find a lot of demo videos about XEvil in YouTube.
    See you later ;)

    XRumer20170718

  20. DorothyRuirm
    2017年7月19日09:06 | #20

    Revolutional update of SEO/SMM package “XRumer 16.0 + XEvil 3.0″:
    captchas breaking of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
    and more than 8400 another subtypes of captchas,
    with highest precision (80..100%) and highest speed (100 img per second).
    You can connect XEvil 3.0 to all most popular SEO/SMM software: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.

    Interested? There are a lot of impessive videos about XEvil in YouTube.
    See you later!

    XRumer20170718

  21. ArleneBix
    2017年7月22日07:58 | #21

    Revolutional update of SEO/SMM package “XRumer 16.0 + XEvil”:
    captchas recognition of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
    and more than 8400 another categories of captchas,
    with highest precision (80..100%) and highest speed (100 img per second).
    You can connect XEvil 3.0 to all most popular SEO/SMM programms: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.

    Interested? There are a lot of demo videos about XEvil in YouTube.
    See you later!

    XRumer20170721

  22. ArleneBix
    2017年7月22日17:20 | #22

    Revolutional update of SEO/SMM package “XRumer 16.0 + XEvil”:
    captcha regignizing of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
    and more than 8400 another categories of captchas,
    with highest precision (80..100%) and highest speed (100 img per second).
    You can connect XEvil 3.0 to all most popular SEO/SMM programms: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other programms.

    Interested? You can find a lot of impessive videos about XEvil in YouTube.
    Good luck!

    XRumer20170721

  23. ArleneBix
    2017年7月22日22:44 | #23

    Revolutional update of SEO/SMM package “XRumer 16.0 + XEvil 3.0″:
    captcha recognition of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
    and more than 8400 another size-types of captcha,
    with highest precision (80..100%) and highest speed (100 img per second).
    You can connect XEvil 3.0 to all most popular SEO/SMM programms: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.

    Interested? There are a lot of introducing videos about XEvil in YouTube.
    See you later ;)

    XRumer20170721

  24. ArleneBix
    2017年7月23日03:55 | #24

    Revolutional update of SEO/SMM package “XRumer 16.0 + XEvil 3.0″:
    captchas recognition of Google, Facebook, Bing, Hotmail, SolveMedia, Yandex,
    and more than 8400 another types of captchas,
    with highest precision (80..100%) and highest speed (100 img per second).
    You can connect XEvil 3.0 to all most popular SEO/SMM software: XRumer, GSA SER, ZennoPoster, Srapebox, Senuke, and more than 100 of other software.

    Interested? There are a lot of introducing videos about XEvil in YouTube.
    See you later!

    XRumer20170721

  25. 2017年7月25日18:06 | #25

    Write My Paper – EssayErudite.com

    Looking for an expert to write my paper for you? You are at the right place.
    Providing superior writing service appears to be our main specialization and passion.
    Our website is the best destination for every English-speaking student who calls for assistance when handling his or her daily academic tasks.

  26. 2017年7月25日18:32 | #26

    Write My Essay – EssayErudite.com

    Fed up of typing “who can write my essay” in the search bar?
    Would you like to have a reliable helper always by your side?
    Our website will come as an excellent solution to write my essay

  27. 2017年7月25日21:15 | #27

    Dissertation Writing Service – EssayErudite.com

    Our https://essayerudite.com/dissertation-writing-service/ provides a full-scale writing assistance accessible online 24/7.
    Apart from many other writing companies, we are rather picky when forming a professional staff of experts.
    Moreover, we try to make our every customer feel safe and pleased with the service.

  28. 2017年7月26日17:39 | #28

    EssayErudite.com is the web’s leading provider of quality and professional academic writing.
    When it comes to essay writing, an in-depth research is a big deal. Our experienced writers are professional in many fields of knowledge so that they can assist you with virtually any academic task. We deliver papers of different types: essays, theses, book reviews, case studies, etc.
    We have thousands of satisfied customers who have already recommended us to their friends. Why not follow their example and place your order today?

  29. 2017年8月1日01:58 | #29

    Yesterday i got some interesting info about Omega 3 foods and now i really wanna buy it. But i need a quality, some premium omega 3 fish oil. I’ve found this carlson omega 3 . What do you think about this Carlson brand?

  30. 2017年8月1日11:06 | #30

    Right here is the perfect website for anyone who would like
    to find out about this topic. You realize so much its almost hard to argue with you (not that I actually would want to…HaHa).
    You definitely put a fresh spin on a subject that’s been discussed for
    decades. Wonderful stuff, just great!

  31. 2017年8月1日11:08 | #31

    Simply desire to say your article is as amazing.
    The clarity in your post is just spectacular and i could assume you’re an expert on this subject.
    Well with your permission let me to grab your feed to keep
    updated with forthcoming post. Thanks a million and
    please continue the gratifying work.

  32. 2017年8月1日17:55 | #32

    Yesterday i read some interesting info about Omega 3 stuff and now i really wanna get it. But i’m not really sure which pluses will i have. I’ve got this omega 3 info , and now i wanna get it with lowest price. Any idea?

  33. 2017年8月1日22:29 | #33

    Way cool! Some extremely valid points! I appreciate you penning this article plus
    the rest of the website is really good.

  34. 2017年8月2日00:53 | #34

    Thank you for another excellent article. The place else could anybody get that kind of information in such a perfect approach of writing?
    I have a presentation subsequent week, and I’m on the look for such information.

  35. 2017年8月2日02:21 | #35

    Hey would you mind letting me know which hosting company you’re working with?
    I’ve loaded your blog in 3 completely different web
    browsers and I must say this blog loads a lot quicker then most.

    Can you recommend a good web hosting provider at a fair price?
    Kudos, I appreciate it!

  36. 2017年8月2日05:38 | #36

    Hi there to every body, it’s my first pay a visit of this blog; this weblog contains remarkable and truly good stuff in favor
    of visitors.

  37. 2017年8月2日06:49 | #37

    Everyone loves what you guys are up too. This type of clever work and coverage!
    Keep up the good works guys I’ve added you guys to blogroll.

  38. 2017年8月2日07:46 | #38

    This post is truly a nice one it assists new the web viewers, who are wishing in favor of blogging.

  39. 2017年8月2日07:59 | #39

    Howdy! I know this is somewhat off topic but I was wondering which blog
    platform are you using for this site? I’m getting tired of WordPress because I’ve had issues with hackers
    and I’m looking at options for another platform. I would be fantastic
    if you could point me in the direction of a good platform.

  40. 2017年8月2日08:52 | #40

    Day ago i got some shocking info about Omega 3 stuff and now i very wanna get it. But i’m not really sure which benefits will i have. I’ve found this omega 3 info , and currently i wanna purchase it with good price. Any idea?

  41. 2017年8月2日12:25 | #41

    Howdy! I know this is sort of off-topic however I needed to
    ask. Does managing a well-established blog such as
    yours take a massive amount work? I’m brand new to operating a blog however I
    do write in my diary everyday. I’d like to start a blog so I will be able to share my personal experience and feelings online.
    Please let me know if you have any recommendations or
    tips for brand new aspiring blog owners. Thankyou!

  42. 2017年8月2日14:33 | #42

    Hi there this is somewhat of off topic but I was wondering if
    blogs use WYSIWYG editors or if you have to manually code with HTML.

    I’m starting a blog soon but have no coding skills so I wanted to get advice from someone with
    experience. Any help would be enormously appreciated!

  43. 2017年8月2日16:04 | #43

    Aw, this was a really good post. Taking a few minutes and actual effort to make a really good article… but what can I say… I hesitate a whole lot
    and never seem to get nearly anything done.

  44. 2017年8月2日16:57 | #44

    I like the helpful information you provide in your articles.
    I will bookmark your weblog and check again here regularly.
    I am quite certain I’ll learn plenty of new stuff right here!
    Best of luck for the next!

  45. 2017年8月2日17:44 | #45

    I’m really impressed with your writing skills as well
    as with the layout on your weblog. Is this a paid
    theme or did you customize it yourself? Anyway keep up the nice quality writing, it is rare to see a nice blog like this one nowadays.

  46. 2017年8月2日18:27 | #46

    Greetings! I’ve been reading your site for some time now and finally got the bravery to go ahead
    and give you a shout out from Kingwood Tx! Just wanted to mention keep up the good job!

  47. 2017年8月2日20:58 | #47

    My spouse and I stumbled over here coming from a different website and thought I should check things out.
    I like what I see so now i’m following you. Look forward to finding out about
    your web page again.

  48. 2017年8月2日21:50 | #48

    Hi, I do think this is a great site. I stumbledupon it ;)
    I will come back once again since I book marked it.

    Money and freedom is the best way to change, may you be rich and continue to guide others.

  49. 2017年8月2日23:00 | #49

    Have you ever thought about writing an e-book or guest authoring on other blogs?
    I have a blog based on the same subjects you discuss and would really like to have you share some stories/information. I know my readers would appreciate your work.
    If you are even remotely interested, feel free to
    send me an e-mail.

  50. 2017年8月2日23:36 | #50

    Day ago i got some interesting info about Omega 3 stuff and now i very wanna get it. But i’m not really sure which pluses will i have. I’ve got this omega 3 info , and currently i wanna buy it with best price. Any idea?

评论分页
1 2 3 ... 14 511
订阅评论
3+4= (必填)