Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MySQL log from the library than the main library     - Red Hat Enterprise Linux 6.4 Configuring VNC Remote Desktop login access (Linux)

- Android source code compiled fatal error solutions (Programming)

- CentOS / Linux install VNC Server (Linux)

- Linux System Getting Started Tutorial: How to find the maximum memory your system supports (Linux)

- Zabbix monitoring disk IO status (Server)

- Linux ACL permissions (Linux)

- How Vim playing a mature IDE (Linux)

- How to restart after a crash Cinnamon (Linux)

- About enhanced Linux / Unix server system security program (Linux)

- To install PXE + Kickstart under CentOS 6.x operating system (Linux)

- Android thread mechanism --AsyncTask (Programming)

- How to Install Apache on Linux servers (Server)

- bash login and welcome message: / etc / issue, / etc / motd (Linux)

- Ubuntu / openSUSE users to install Veusz 1.21.1 (Linux)

- Use PuTTY to access the virtual machine Linux under Windows xp (Programming)

- Python implementation Bursa transition model (Programming)

- In-depth understanding of PHP ini configuration (Server)

- VNC configuration detailed analysis under Linux (Linux)

- Simple RPM package production (Linux)

- CentOS replaces update source and Linux kernel compilation summary (Linux)

  MySQL log from the library than the main library
  Add Date : 2018-11-21      
  In the group chat, a group of friends said, MySQL Library main library production downtime, but consistent master data from the database, but the logs from the library than the main library, it is not understood!

After consultation found that the production of the main library database is not set sync_binlog = 1, but for sync_binlog = 0

Therefore, when writing data to the main library, the transaction has been submitted, but the data in the binlog cache, no write to the disk, and the data has been synchronized to the library, at the moment the main library down, binlog cache data loss, resulting from library logs than the main library.

Group of friends from the master after reconfiguration and sync_binlog set to 1

sync_binlog importance and significance:

sync_binlog = n, n times after each transaction commits, MySQL will conduct a fsync like disk synchronization instruction to the data binlog_cache the mandatory written to disk.

In MySQL, the default setting is sync_binlog = 0, that is, without any mandatory disks refresh command, this time the performance is the best, but the risk is greatest. Because once the system Crash, all binlog information will be lost in the binlog_cache.
- Why do you need close contact Rust 1.0 (Programming)
- An example of troubleshooting of embedded Linux OpenWRT (Linux)
- Windows 8.1 hard drive to install Ubuntu 14.04 dual system reference tutorials and multi-drive Precautions (Linux)
- In-depth summary of the PHP core of object-oriented (Programming)
- Android Action Compendium (Programming)
- Linux print file and send mail (Linux)
- Running the open-source Swift under Linux platform (Linux)
- Ansible installation configuration and simple to use (Server)
- Android Studio 1.0.2 set the memory size (Linux)
- Java memory mechanism Description (Programming)
- Nginx multi-domain certificate HTTPS (Server)
- How to install Git client in Ubuntu (Linux)
- Standardized UNIX command-line tool (Linux)
- ORA-00020: No more process state objects available (Database)
- C language keywords Comments (Programming)
- How to use scientific data Docker quickly configure the development environment (Server)
- Linux Telnet access Windows 7 configuration procedure (Linux)
- Android WebView use layman (Programming)
- Analyzing Linux server architecture is 32-bit / 64-bit (Server)
- HAProxy Windows version of the compiler and its application in the CORS (Server)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.