Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what are the characteristics of TokuDB". In the operation of actual cases, many people will encounter such a dilemma. Then let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Let's find out about him first:

Tokudb is a storage engine in mysql and MariaDB. It uses indexes to speed up queries, has high scalability, and supports hot scheme modification.

Features:

1. Insertion performance is 20 to 80 times faster

two。 Compress data to reduce storage space

3. The amount of data can be expanded to several TB

4. There is no index fragmentation.

5. Support for hot column addition, hot indexing, mvcc

How to consider using:

1. If you want to store blob, do not use tokuDB, because his record cannot be too large.

two。 If the number of records exceeds 100 million, use tokuDB

3. If you pay attention to the performance of update, do not use tokuDB, it is not as fast as innodb

4. If you want to store old records, use tokuDB

5. If you want to reduce the storage space occupied by the data, use tokuDB

This is the end of the content of "what are the characteristics of TokuDB". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.