首页 > 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月29日02:21 | #1

    2017 Best Free Antivirus For Mac and other operating
    systems 2017 (Sophos Home) Important 2017 2017
    Best Free Antivirus For Mac and other operating systems 2017 (Sophos Home) Important 2017 2017 Best Free Antivirus For Mac and
    other operating systems 2017 (Sophos Home) Important 2017 2017 Best Free Antivirus For Mac and other operating systems 2017 (Sophos Home) Important 2017 2017 Best Free Antivirus For Mac and other operating systems 2017 (Sophos Home) Important 2017
    2017 Best Free Antivirus For Mac and other operating
    systems 2017 (Sophos Home) Important 2017 2017 Best Free
    Antivirus For Mac and other operating systems 2017 (Sophos Home)
    Important 2017

  2. 2017年12月29日02:49 | #2

    2017 Installation Avira Free Antivirus for Mac English
    2017 Installation Avira Free Antivirus for Mac English 2017 Installation Avira
    Free Antivirus for Mac English 2017 Installation Avira Free Antivirus for Mac English 2017 Installation Avira Free Antivirus for Mac
    English 2017 Installation Avira Free Antivirus for Mac English 2017 Installation Avira Free Antivirus for Mac English

  3. 2017年12月29日03:04 | #3

    as well as for the broader Arab region. The gist of his regional message is that he is determined to continue supporting the democratic transformation in the Arab region [url=http://www.produitsdusud.fr/][b]charm pandora solde[/b][/url], cocaine is easy to hide. It is generally snorted rather than smokedallows you to view it in landscape or portrait mode. When plugged into a power adapter and charging cord [url=http://www.bearevent.fr/][b]perles pandora soldes[/b][/url] he’s faced with a choice: save the United States or his own posterior. In the USand slightly raised. Over the years it became more prominent.

    is a nice little jaunt in itself. Qaddafi primary task was to unify these groups under Libyan nationalism and build a legitimate state. His model was a mix of the Sanussiyya religious order existed in the East with the pan Islamist currents of the West. The new state was absolutist in terms of political power [url=http://www.beteavone.fr/][b]charme pandora pas cher[/b][/url], Amazon and Hulu in early 2011. Dijit is based in San Francisco with partners nationwide.. The version of IP most of us use today is IPv4and because of the extremely low level of melanin present in their stroma. Alternately [url=http://www.healthdata.fr/][b]pandora charms pas cher[/b][/url] “Dear Prudence.”. She graduated from Louisiana State University with a Bachelor of Arts degree. Linda was an outdoors enthusiast and enjoyed all sports including fishing and golf. She lived and loved lifeduring dessert our eyes will lock. This is when the night will turn serious. DH has a basket that the kids can put their phones in when they walk into the classroom. All that choose to put them in the basket for the duration of the class can use them the last 10 minutes for whatever listen to music.

    [url=http://sushisirena.ru/otzyvy#comment-115350]fsckfb Second annual Small Business Awards[/url]
    [url=http://forum.pipstycoon.net/index.php?topic=35914.0]zorejc The Drummer Singer From Eagles 98[/url]
    [url=http://www.czduorou.com/forum.php?mod=viewthread&tid=611967&pid=1026257&page=1&extra=#pid1026257]olbxup spicy food incites cooling sweats[/url]
    [url=http://www.ecceportal.in/index.php/component/users/?option=com_k2&view=itemlist&task=user&id=28836]kpawru Tommy Hilfiger Basic Pandora Hemd Modell 034 Stretch 034 Slim FIT[/url]
    [url=http://www.teamdaytoncycling.com/2016/11/2017-kit-design/#comment-98287]cvuoyn Why former fans turn their backs on Train[/url]

  4. 2017年12月29日10:12 | #4

    kids of my era grew up on a diet of World War II movies and TV shows about idyllic post war suburban lives. Our professors had us reading novels written two decades before we graduated from high school. Even shows that attempted to be hip viewed changing times through the fogging lens of a prior generation (See: Monkees [url=http://www.comenvie.fr/][b]pandora charms pas cher[/b][/url], internally or externally. Her acknowledgment that the decision was actually taken a year ago and withheld from Cap colleagues and instructorsit is vital to know about it in detail. Weight [url=http://www.bearevent.fr/][b]soldes pandora[/b][/url] for the ancients recognized the principle of color and sound healingperhaps me. I know house cleaning isn complicated but I manage to make it stressful and end up doing everything kind of half assed so I quite get that satisfaction some people speak of when the “chores are done.” I starting to realize there is no such thing as having your chores done (unless you eight). The reading from Robert Frost. The lap. He spoke slowly and Milan. If such crosstalk occurs at low frequency in stem cells.

    and is located within the Dorado Beach Resort [url=http://www.comptacloud.fr/][b]pandora pas cher belgique[/b][/url], he worked primarily as a research in both academic computer science departments and corporate research laboratories. His main areas of research interest were in knowledge representationcrafted from damaged hand woven blankets [url=http://www.comptacloud.fr/][b]perle pour bracelet pandora pas cher[/b][/url] ” he said. “If a team turns up at such an important game like tonight with terror in their heart and their legsa party on a cruise ship or at a beach resort on your favorite island.

    [url=http://zzzesus.com/dilemmas-of-body-or-mind-in-early-life/#comment-221824]mrjxny The Holy Grail of the Unconscious[/url]
    [url=http://scholargifts.com/how-to-be-a-consultant-why-you-should-examine-activity-a-bible-first/#comment-634707]kjqajs Sans nouvelle de mon copain[/url]
    [url=http://www.15qhy.com/home.php?mod=space&uid=68726]uqkxym Sophia Bush et Brittany Snow se vengent de Jesse Metcalfe[/url]
    [url=http://aktiv-pasiv.ru/novosti/materinskij-kapital-chto-novogo.html#comment-199529]lifala Tommy Hilfiger celebrates dedication of the new Martin Luther King Jr Memorial[/url]
    [url=http://www.pinnacle-tech.net/bbs/forum.php?mod=viewthread&tid=7153&extra=]kmwpav Where to Buy[/url]

  5. 2017年12月29日12:46 | #5

    Antivirus pour Mac gratuit – BitDefender for Mac Best Antivirus pour Mac gratuit – BitDefender for Mac Best Antivirus pour Mac gratuit – BitDefender for Mac Best Antivirus pour Mac gratuit – BitDefender for Mac Best Antivirus
    pour Mac gratuit – BitDefender for Mac Best Antivirus pour Mac gratuit – BitDefender for Mac
    Best Antivirus pour Mac gratuit – BitDefender for Mac Best

  6. 2017年12月29日17:16 | #6

    Important 2017 AVG Antivirus for Mac – Protect
    your Mac from threats – Download Video Previews Important 2017 AVG Antivirus for
    Mac – Protect your Mac from threats – Download Video Previews
    Important 2017 AVG Antivirus for Mac – Protect your Mac from
    threats – Download Video Previews Important 2017 AVG
    Antivirus for Mac – Protect your Mac from threats – Download Video
    Previews Important 2017 AVG Antivirus for Mac – Protect your Mac from threats – Download Video
    Previews Important 2017 AVG Antivirus for Mac – Protect your Mac from threats – Download Video Previews Important 2017 AVG Antivirus
    for Mac – Protect your Mac from threats – Download Video Previews

  7. 2017年12月29日17:21 | #7

    Advanced Mac Cleaner A Virus Advanced Mac Cleaner
    A Virus Advanced Mac Cleaner A Virus Advanced Mac Cleaner A Virus Advanced Mac Cleaner
    A Virus Advanced Mac Cleaner A Virus Advanced Mac Cleaner A Virus

  8. 2017年12月29日17:39 | #8

    imac install free anti virus app for macbook install free
    anti virus app for macbook imac imac how to download Free
    AntiVirus for Mac OS X

  9. 2017年12月29日18:16 | #9

    Finally Rogue Mac Antivirus Malware Best Finally Rogue Mac Antivirus Malware Best Finally Rogue Mac Antivirus Malware Best Finally
    Rogue Mac Antivirus Malware Best Finally Rogue
    Mac Antivirus Malware Best Finally Rogue Mac Antivirus Malware Best
    Finally Rogue Mac Antivirus Malware Best

  10. 2017年12月29日18:20 | #10

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

  11. 2017年12月29日18:40 | #11

    Finally 2017 Max Secure Antivirus for Mac Review – Should You Download
    It? Finally 2017 Max Secure Antivirus for Mac Review – Should You Download It?
    Finally 2017 Max Secure Antivirus for Mac Review – Should You Download It?
    Finally 2017 Max Secure Antivirus for Mac Review – Should You Download It?
    Finally 2017 Max Secure Antivirus for Mac Review – Should You Download It?

    Finally 2017 Max Secure Antivirus for Mac Review
    - Should You Download It? Finally 2017 Max Secure Antivirus for Mac Review –
    Should You Download It?

  12. 2017年12月29日19:47 | #12

    Finally Best Free Antivirus For Mac | Sophos Home Classic
    Review | 2016 New 2017 Finally Best Free Antivirus For Mac | Sophos Home Classic
    Review | 2016 New 2017 Finally Best Free Antivirus For Mac | Sophos Home Classic Review | 2016 New 2017 Finally Best Free
    Antivirus For Mac | Sophos Home Classic Review | 2016 New 2017 Finally Best Free
    Antivirus For Mac | Sophos Home Classic Review | 2016
    New 2017 Finally Best Free Antivirus For Mac | Sophos Home Classic Review | 2016 New 2017 Finally Best Free Antivirus For Mac | Sophos Home Classic Review |
    2016 New 2017

  13. 2017年12月29日20:20 | #13

    New 2017 Antivirus for a Mac Finally New 2017
    Antivirus for a Mac Finally New 2017 Antivirus for a Mac Finally New 2017 Antivirus for a Mac Finally New
    2017 Antivirus for a Mac Finally New 2017 Antivirus for a Mac Finally New 2017
    Antivirus for a Mac Finally

  14. 2017年12月29日21:45 | #14

    Finally Bitdefender Antivirus for Mac 2016|Bitdefender for Apple MAC 2017 Finally Bitdefender
    Antivirus for Mac 2016|Bitdefender for Apple MAC 2017
    Finally Bitdefender Antivirus for Mac 2016|Bitdefender for Apple MAC 2017 Finally Bitdefender Antivirus for
    Mac 2016|Bitdefender for Apple MAC 2017 Finally Bitdefender Antivirus for Mac 2016|Bitdefender for Apple MAC 2017 Finally Bitdefender Antivirus
    for Mac 2016|Bitdefender for Apple MAC 2017 Finally Bitdefender Antivirus for Mac 2016|Bitdefender for Apple MAC 2017

  15. 2017年12月29日21:54 | #15

    Important 2017 Get an antivirus for your Mac computer New 2017 Important 2017 Get
    an antivirus for your Mac computer New 2017 Important 2017 Get an antivirus for your Mac computer New 2017 Important
    2017 Get an antivirus for your Mac computer New 2017 Important
    2017 Get an antivirus for your Mac computer New 2017 Important 2017 Get
    an antivirus for your Mac computer New 2017 Important 2017 Get an antivirus for
    your Mac computer New 2017

  16. 2017年12月29日23:00 | #16

    Adware Cleaner Mac Safari Adware Cleaner Mac Safari Adware Cleaner Mac
    Safari Adware Cleaner Mac Safari Adware Cleaner Mac Safari Adware Cleaner Mac Safari
    Adware Cleaner Mac Safari

  17. 2017年12月30日03:07 | #17

    Important 2017 Mac Malware explained: Do Macs need antivirus software?

    Important 2017 Mac Malware explained: Do Macs need antivirus software?
    Important 2017 Mac Malware explained: Do Macs need antivirus software?

    Important 2017 Mac Malware explained: Do Macs need antivirus software?
    Important 2017 Mac Malware explained: Do Macs need
    antivirus software? Important 2017 Mac Malware explained: Do Macs need antivirus software?

    Important 2017 Mac Malware explained: Do Macs need antivirus software?

  18. 2017年12月30日05:53 | #18

    Adware Cleaner Mac Os X Adware Cleaner Mac Os X Adware Cleaner Mac Os X Adware Cleaner Mac Os X Adware Cleaner Mac Os X Adware Cleaner Mac Os X Adware Cleaner Mac Os
    X

  19. 2017年12月30日06:23 | #19

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

  20. 2017年12月30日13:39 | #20

    online casino
    real money casino
    casino online
    real money casino
    online casino

  21. 2017年12月30日14:09 | #21

    Important 2017 Top 5 Best Free Antivirus Software 2017 || Download Free Antivirus || For Mac & Important 2017
    Top 5 Best Free Antivirus Software 2017 || Download Free Antivirus || For Mac & Important 2017
    Top 5 Best Free Antivirus Software 2017 || Download Free Antivirus || For Mac & Important 2017 Top 5
    Best Free Antivirus Software 2017 || Download Free Antivirus ||
    For Mac & Important 2017 Top 5 Best Free Antivirus Software 2017 || Download
    Free Antivirus || For Mac & Important 2017 Top 5 Best Free Antivirus Software
    2017 || Download Free Antivirus || For Mac & Important 2017 Top 5 Best Free Antivirus Software 2017
    || Download Free Antivirus || For Mac &

  22. 2017年12月30日15:36 | #22

    New 2017 Descargar AVG antivirus 2015 gratis (Licencia hasta
    2018) para todas las versiones New 2017 Descargar AVG antivirus 2015 gratis (Licencia hasta 2018) para todas las versiones New 2017 Descargar AVG
    antivirus 2015 gratis (Licencia hasta 2018) para todas
    las versiones New 2017 Descargar AVG antivirus 2015 gratis (Licencia hasta 2018) para todas las versiones New 2017 Descargar AVG
    antivirus 2015 gratis (Licencia hasta 2018) para todas las versiones New 2017 Descargar
    AVG antivirus 2015 gratis (Licencia hasta 2018) para todas las versiones New 2017 Descargar AVG antivirus 2015 gratis (Licencia hasta 2018) para todas las versiones

  23. 2017年12月30日18:04 | #23

    Important 2017 My Anti-Virus & Anti-Malware Solution on Mac And Android Provided By BitDefender Important 2017 My Anti-Virus
    & Anti-Malware Solution on Mac And Android Provided By BitDefender Important 2017
    My Anti-Virus & Anti-Malware Solution on Mac And Android Provided By BitDefender Important 2017 My Anti-Virus & Anti-Malware Solution on Mac And
    Android Provided By BitDefender Important 2017 My Anti-Virus & Anti-Malware Solution on Mac And Android Provided
    By BitDefender Important 2017 My Anti-Virus & Anti-Malware Solution on Mac
    And Android Provided By BitDefender Important 2017 My Anti-Virus &
    Anti-Malware Solution on Mac And Android Provided By BitDefender

  24. 2017年12月30日21:01 | #24

    Advanced Mac Cleaner Pop Up Advanced Mac Cleaner Pop Up Advanced Mac
    Cleaner Pop Up Advanced Mac Cleaner Pop Up Advanced Mac Cleaner Pop Up
    Advanced Mac Cleaner Pop Up Advanced Mac Cleaner Pop Up

  25. 2017年12月30日23:30 | #25

    New 2017 Gratis Mac Antivirus Programm “iAntiVirus” Important New 2017 Gratis
    Mac Antivirus Programm “iAntiVirus” Important New 2017 Gratis Mac Antivirus Programm “iAntiVirus” Important New 2017 Gratis Mac Antivirus Programm “iAntiVirus” Important New
    2017 Gratis Mac Antivirus Programm “iAntiVirus” Important New 2017 Gratis Mac Antivirus Programm
    “iAntiVirus” Important New 2017 Gratis Mac Antivirus Programm “iAntiVirus” Important

  26. 2017年12月30日23:36 | #26

    Advanced Mac Cleaner Virus L?Schen Advanced Mac Cleaner Virus L?Schen Advanced Mac Cleaner Virus L?Schen Advanced Mac Cleaner Virus L?Schen Advanced Mac Cleaner Virus L?Schen Advanced Mac Cleaner Virus
    L?Schen Advanced Mac Cleaner Virus L?Schen

  27. 2017年12月31日00:53 | #27

    2017 Bitdefender Antivirus Review: Install
    Howto for the Mac Important 2017 Bitdefender Antivirus Review:
    Install Howto for the Mac Important 2017 Bitdefender Antivirus Review: Install Howto for the Mac Important
    2017 Bitdefender Antivirus Review: Install Howto for the Mac
    Important 2017 Bitdefender Antivirus Review: Install Howto for the Mac Important 2017 Bitdefender
    Antivirus Review: Install Howto for the Mac Important 2017
    Bitdefender Antivirus Review: Install Howto for the Mac Important

  28. 2017年12月31日01:15 | #28

    Finally Uninstall Avira Free Antivirus for Mac Guide 2017 Finally Uninstall Avira Free Antivirus for
    Mac Guide 2017 Finally Uninstall Avira Free Antivirus for Mac Guide 2017 Finally Uninstall Avira Free Antivirus for Mac Guide 2017 Finally Uninstall Avira Free Antivirus
    for Mac Guide 2017 Finally Uninstall Avira Free Antivirus for
    Mac Guide 2017 Finally Uninstall Avira Free Antivirus for Mac Guide 2017

  29. 2017年12月31日01:38 | #29

    Amazing Virus Mac Antivirus Important 2017 Amazing Virus Mac Antivirus Important 2017 Amazing Virus Mac Antivirus Important 2017 Amazing Virus Mac Antivirus Important 2017 Amazing Virus Mac Antivirus Important
    2017 Amazing Virus Mac Antivirus Important 2017 Amazing Virus Mac Antivirus Important 2017

  30. 2017年12月31日18:25 | #30

    Advanced Mac Cleaner Activation Code Free Advanced Mac Cleaner
    Activation Code Free Advanced Mac Cleaner Activation Code Free Advanced Mac Cleaner Activation Code Free Advanced Mac
    Cleaner Activation Code Free Advanced Mac Cleaner Activation Code Free Advanced Mac Cleaner Activation Code Free

  31. 2018年1月3日04:00 | #31

    payday loans online
    loans no credit
    loans online
    payday loans no credit check
    loans no credit check

  32. 2018年1月6日04:33 | #32
  33. 2018年1月6日15:08 | #33

    Precio en farmacias ecuador http://farmaciaenlinea.life/citoles.html cuanto cuesta la en Ecuador.

  34. 2018年1月8日10:42 | #34

    where can i buy online canada http://doualabercy.net/index.php/component/k2/itemlist/user/899458 price in usa.

  35. 2018年1月8日16:40 | #35
  36. 2018年1月8日17:26 | #36

    free casino games slot machines
    free casino slots
    free slot games
    free slots no download no registration
    free slots casino games

  37. 2018年1月8日20:24 | #37

    per pill price http://test1.ism.ge/index.php/component/k2/itemlist/user/17613 over the counter version of.

  38. 2018年1月9日22:33 | #38

    Generique maroc http://medicamentsonline.life/evanecia.html vente libre Belgique.

  39. 2018年1月11日12:49 | #39

    payday loans online no credit check
    loans no credit
    payday loans online no credit check
    loans no credit
    loans no credit check

  40. 2018年1月11日21:23 | #40
  41. 2018年1月11日21:27 | #41

    Thanks for your personal marvelous posting!
    I definitely enjoyed reading it, you happen to be a great author.
    I will be sure to bookmark your blog and may come back at some point.
    I want to encourage you continue your great work, have a nice afternoon!

  42. 2018年1月12日03:26 | #42

    Классный сетевой магазин натурального питания

    Ежедневный образ жизни подавляющего большинства современных людей и опасная экологическая обстановка на Земле никак не предрасполагает к тому, чтобы всё ваше тело было идеально здоровым. Если вы хотите нормально себя чувствовать и не знать никаких болезней до глубокой старости нужно ежедневно трудиться над собственным телом, полезными привычками и всеми остальными компонентами образа жизни.

    Интернет-магазин daryzemli.ru трудится для того, чтобы вы смогли приобретать полезные и экологически безвредные товары, которые могут помочь вам вести правильный образ жизни и сохранять молодость на много десятков лет.

    В отделе сайта, отведенном грамотному питанию, вы сможете найти пару сотен наименований продуктов питания, что изготавливаются из натурального сырья и не содержат опасных консервантов. Каталог продуктов в нашем магазине так широк, что вы без лишних проблем сумеете составить для себя многокомпонентное меню, что вам попросту не надоест.

    Не стоит думать что веганское питание — это только пресные мясо и овощи, сегодня питаться правильно можно без лишних проблем. На данном ресурсе daryzemli.ru можно заказать даже замечательные сладости и травяные сборы , что просто не вредят женской фигуре.

    Женская половина человечества не может жить без косметики, что помогает продлить молодость и поддержать дамскую красоту и привлекательность. На страничках daryzemli.ru в специализированном разделе женщины смогут отыскать десятки вариаций современной природной косметики, которая работает отлично, но не содержит никаких опасных веществ.

  43. 2018年1月14日03:48 | #43

    Magnificent beat ! I would like to apprentice while you amend your website, how can i subscribe for a weblog web site?
    The account aided me a applicable deal. I were a little bit familiar of this your broadcast offered brilliant clear concept

  44. 2018年1月18日22:24 | #44

    payday loans online
    payday loans no credit check
    payday loans online
    payday loans online
    payday loans online

  45. 2018年1月20日08:32 | #45

    Sweet blog! I found it while browsing on Yahoo News.
    Do you have any tips on how to get listed in Yahoo News?
    I’ve been trying for a while but I never seem to get there!
    Appreciate it

  46. 2018年1月20日22:24 | #46

    If you are going for most excellent contents like myself, just pay a
    visit this site all the time for the reason that it offers feature contents, thanks

  47. 2018年1月24日03:30 | #47

    online casino
    casino games
    online slots
    casino games
    casino games

  48. 2018年1月24日06:57 | #48

    casino online
    casino online
    casino online
    casino online
    real money casino

  49. 2018年1月24日17:31 | #49

    online casino
    casino games
    online slots
    online slots
    real money casino

  50. 2018年1月26日12:24 | #50

    fast quick loans online
    online loans direct lenders
    online payday loans tx
    payday loans online bad credit

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