Table of Contents
InnoSQL - A branch version of MySQL
目前主要包括的特性有:
Home Database Mysql Tutorial NetEase/InnoSQL(网易的InnoSQL的补丁文件)_MySQL

NetEase/InnoSQL(网易的InnoSQL的补丁文件)_MySQL

Jun 01, 2016 pm 01:16 PM
download link Reference book NetEase

 README.md

InnoSQL - A branch version of MySQL

InnoSQL是杭研开发维护的MySQL分支,目前基于MySQL 5.5。InnoSQL的主要目标是提供更好的性能以及高可用性,同时便于DBA的运维以及监控管理。其完全兼容于原版MySQL数据库,所有添加的功能都是动态的。若不开启这些功能,与原版MySQL数据库的工作方式完全相同。

  • Homepage: http://mysql.netease.com/
  • Wiki: http://mysql.netease.com/doc/index.html
  • Issues: https://github.com/NetEase/InnoSQL/issues/
  • Tags: C, C++, MySQL, InnoDB

目前主要包括的特性有:

高可用特性:

  1. virtual sync replication with group commit,高性能同步复制
  2. crash safe replication slave,宕机主从数据依然一致
  3. slave batch commit 极大减少slave与master的延时,基本达到实时同步
  4. InnoDB share memory,缓冲池快速预热技术

高性能特性:

  1. InnoDB flash cache 将SSD作为L2cache,见percona CTO对此测试的结果
  2. InnoDB IO enhance 对于InnoDB的IO进行优化,尤其是SSD
  3. InnoDB死锁检测优化

运维特性:

  1. 观察InnoDB undo log信息
  2. 观察不同刷新方式的的次数
  3. 观察master thread和purge thread的线程ID
  4. slow log记录SQL语句的物理与逻辑IO次数
  5. binlog记录SQL语句执行者的user和ip信息
  6. Profiler功能,对用户资源进行限制
  7. Role Table 将用户添加到角色表中,便于对用户的管理

首先克隆这个仓库

<code style="BOX-SIZING: border-box; FONT-SIZE: 12px; FONT-FAMILY: Consolas, 'Liberation Mono', Courier, monospace; WHITE-SPACE: pre; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px; DISPLAY: inline; PADDING-RIGHT: 0px; BACKGROUND-COLOR: transparent; border-radius: 3px; -ms-word-wrap: normal">git clone git://github.com/NetEase/InnoSQL.git</code>
Copy after login

进入InnoSQL/src,在当前目录下即得到InnoSQL的各种Patch包。

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

NetEase's first! The 5V5 multi-hero skills shooting mobile game "Operation Apocalypse" pre-order is open! NetEase's first! The 5V5 multi-hero skills shooting mobile game "Operation Apocalypse" pre-order is open! Mar 16, 2024 am 08:01 AM

Since the release of the domestic game version in February, NetEase's mysterious shooting game &quot;Operation Apocalypse&quot; has attracted the curiosity of many players. As we all know, although NetEase also had some shooting games in the early years, it seems that except for &quot;The Day After Tomorrow&quot; and &quot;Knives Out&quot;, there are not many playable games. In recent years, the works launched by NetEase have gained momentum and have achieved considerable results in many niche tracks. The fact that &quot;Operation Apocalypse&quot;, which has never been exposed before, is placed as the first shot of NetEase in the new year is enough to raise eyebrows. Is this a signal that NetEase is going to launch an attack on the shooting track? Players are eagerly looking forward to new mobile shooting games. , on March 13, this 5V5 multi-hero skills shooting mobile game &quot;Operation Apocalypse&quot; developed by NetEase finally unveiled its mystery and officially released its first live demonstration

NetEase NetEase Mar 28, 2024 pm 12:50 PM

On March 27, 2024, Beijing time, NetEase Games and Marvel Games officially announced a new game: the superhero PVP team shooting game "Marvel Rivals". Players can choose their favorite characters from a rich and diverse lineup of superheroes and super villains to form an all-star team, and use their unique superpowers to engage in exciting battles on various breakable maps in the Marvel multiverse. "We are very excited to bring "Marvel Confrontation" to players around the world. We have always loved the Marvel Universe and its characters, and we are excited to develop this game." The main creative team of "Marvel Contest" said, "This is exactly the game we dreamed of creating, and we are extremely proud to be able to turn it from a dream into a reality." "NetEase

Blizzard's national server returns to the scene to watch, Valina shows off her snow-skinned skin and long legs, and Dva in her pink skirt is so cute! Blizzard's national server returns to the scene to watch, Valina shows off her snow-skinned skin and long legs, and Dva in her pink skirt is so cute! Apr 11, 2024 pm 04:04 PM

NetEase and Microsoft Blizzard have officially announced the return of Blizzard's national server. NetEase also held a celebration ceremony under the headquarters building. The scene was also very exciting. Let's go to the scene together! The scene was set up early in the morning, and all Blizzard’s games are listed, including World of Warcraft, Hearthstone, Diablo 3, Heroes of the Storm, Overwatch, StarCraft 2, etc. Pay attention to the official announcements from Blizzard and NetEase Heroes of the Storm is not mentioned, but there is no poster that can be seen on site for this game, so players who like Heroes of the Storm don’t have to worry, Blizzard’s entire family will be back. We should also pay special attention to World of Warcraft. The poster displayed is for World of Warcraft 11.0 War for the Center of the Earth. Obviously, this classic version in which Mason personally copied the sword will be played on the Chinese server this summer.

Game version of Sora? Nishuihan mobile game releases AI video generation tool, supports typing input Game version of Sora? Nishuihan mobile game releases AI video generation tool, supports typing input Feb 26, 2024 pm 08:55 PM

Recently, Nishuihan mobile game officially released a new AI video generation tool, through which players can "produce blockbusters just by typing." According to the official introduction, the functions are implemented based on the Nishuihan game itself and are highly involved in AI. There is no need for any equipment, actors, or special effects. You only need to type in any character image, actions, and lines, and the corresponding content can be generated in real time in the game through AI and filmed. At the same time, players are supported to adjust details, including the character’s clothing, makeup, hairstyle, personality, voice, etc. This function also supports the uploading of pictures/videos, motion capture through AI, and real-time generation of movements and expressions that are “not available in the game” in the game. Officials stated that this feature has the same vision as Sora, which is to “make the creative space endless and the creative threshold close to the limit”.

NetEase announced the suspension of 'Marvel Super War', which was Marvel's first MOBA game! NetEase announced the suspension of 'Marvel Super War', which was Marvel's first MOBA game! Apr 18, 2024 am 10:50 AM

NetEase's "Marvel Super War" announced that it will terminate operations and close the game server at 15:00 on June 17, 2024. The download entrance for all platforms has now been closed, and game recharge and new user registration have been stopped. As Marvel's first MOBA mobile game, this game authentically displays the combat characteristics of superheroes and restores the grand world view of the Marvel universe. In the game, you will be able to assemble in the parallel universe with the Avengers, X-Men, Fantastic Four and many superheroes and super villains, and compete with Iron Man, Captain America, Spider-Man, Loki, Thanos, Deadpool Wait for more than 60 classic Marvel characters to fight together!

Can NetEase Master re-register after logging out? Can NetEase Master re-register after logging out? Mar 07, 2024 pm 03:25 PM

NetEase Master APP is a social platform for gamers. Users can get game consultation here. Many users want to know whether NetEase Master can re-register after logging out. NetEase Master can re-register after logging out. Can NetEase Master re-register after logging out? Answer: Yes. 1. NetEase Master can re-register after logging out. 2. But you must register for at least one week before you can choose this number to register. 3. The account cannot be specified, and previous data will be cleared. 4. After the user logs out, all previous information and related balances have been cleared. Related articles: How does NetEase master change the bound mobile phone number?

Tencent Photon H Studio is hiring in Hangzhou and plans to make a 3A open world RPG Tencent Photon H Studio is hiring in Hangzhou and plans to make a 3A open world RPG Feb 05, 2024 pm 01:45 PM

Recently, Tencent Interactive Entertainment Recruitment released a recruitment information, indicating that Photon H Studio is committed to developing a content-rich, AAA-level open world RPG project. The hot recruitment positions cover multiple fields such as UE5 engineers, backend, level design, action scene design, character modeling, special effects and distribution. The target working location of these positions is in Hangzhou, where NetEase is headquartered.

On the occasion of the re-opening of the national server of World of Warcraft, here are the 4 major version selection guides, the last one is more suitable for casual players On the occasion of the re-opening of the national server of World of Warcraft, here are the 4 major version selection guides, the last one is more suitable for casual players Apr 13, 2024 am 09:16 AM

There are currently 4 versions of World of Warcraft. The national server has been closed for more than a year. It is estimated that many players do not know where each version has developed. Let's sort out the current status of each version. 1. At the end of the official server version 10.0, before the closure of the national server, version 10.0 has just started. It is currently in version 10.26. There will be version 10.27 later, and the Age of Dragon expansion pack will be over. Although version 10.0 has received good reviews in foreign servers and has restored some popularity for Blizzard, the core of the game in version 10.0 has not changed at all. It is still mainly about big secrets and raids, and the number of PVP players is very small. With the continuous updates of the official server version, players’ gaming tendencies have also changed from PVE and PVP to collecting.

See all articles