{"repo":"alibaba/innodb-java-reader","free":true,"listed":false,"github":"https://github.com/alibaba/innodb-java-reader","clone":"git clone https://github.com/alibaba/innodb-java-reader.git","description":"A library and command-line tool to access MySQL InnoDB data file directly in Java","language":"Java","stars":495,"topics":["mysql","java","mysql-database","mysqldump","heatmap","innodb","command-line-tool"],"license":"Apache-2.0","category":"cli-tools","readme_excerpt":"MySQL InnoDB Java Reader innodb-java-reader is a java implementation to access MySQL InnoDB storage engine file directly. With the library or command-line tool, it provides read-only features like examining pages, looking up record by primary key, secondary key and generating page heatmap by LSN or filling rate. Innodb-java-reader can be a tool to dump/query table by offloading from MySQL server. Moreover, this project is useful for prototyping and learning MySQL. 1. Background 2. Prerequisites 3. Features 4. Quick Start 5. API usage 6. Command-line tool 7. Building 8. Benchmark 9. Future works 1. Background InnoDB is a general-purpose storage engine that balances high reliability and high performance in MySQL, since 5.6 InnoDB has become the default MySQL storage engine. In Alibaba, I encountered one performance issue related to MySQL, and this led me to deep dive into InnoDB internal mechanism. To better understand how InnoDB stores data, I introduce this project, and I choose Java language to implement because it is widely used and more understandable. Some of the works are inspired by Jeremy Cole's blog about InnoDB, which helps me a lot. Currently this project is production-ready and is able to work in real environment. 2. Prerequisites Supported MySQL version: 5.6, 5.7, 8.0. Make sure InnoDB row format is either COMPACT or DYNAMIC . Enable innodb file per table , which will create standalone .ibd file for each table. InnoDB file page size is set to 16K. 3. Features The ","default_branch":null,"files":null,"tree":[],"storefront":"/r/alibaba","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/alibaba/innodb-java-reader/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}