MariaDB 10之TokuDB存储引擎
TokuDB存储引擎，你可以把它看做是ARCHIVE存储引擎的升级版，它拥有了密集压缩，并且支持事务。压缩比：EngineCompressionTablesize[MB]InnoDBnone2272InnoDBKEY
TokuDB存储引擎，你可以把它看做是ARCHIVE存储引擎的升级版，它拥有了密集压缩，并且支持事务。
压缩比：
EngineCompressionTable size [MB]
InnoDB none 2272
InnoDB KEY_BLOCK_SIZE=8 1144
InnoDB KEY_BLOCK_SIZE=4 584
MyISAM none 1810
MyISAM compressed with myisampack 809
Archive default 211
TokuDB ZLIB 284
TokuDB LZMA 208
特性：
FeatureArchiveMyISAM (compressed)InnoDBTokuDB
only INSERTsnoyesyes
Transactionsnonoyesyes
nonoyesyes
Indexesnoyesyesyes
Online DDLnonoyes *yes **
MariaDB10，已经内嵌了TokuDB存储引擎，安装超简单，如下：
调优：
Configuration: what’s really important
As noted by Vadim long ago, “Tuning of TokuDB is much easier than InnoDB, there’re only a few parameters to change, and actually out-of-box things running pretty well“:
TokuDB调优比InnoDB简单的多，只是有一些参数变化，，或者你直接使用默认参数，也运行的良好。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Connect to MariaDB database using PHP
May 17, 2023 am 08:24 AM
MariaDB is an open source relational database management system, which is a branch of MySQL. PHP, as an open source server-side scripting language, is widely used in web development. In many web development projects, you need to use PHP to connect to the MariaDB database in order to store and retrieve data in the web application. This article will introduce how to use PHP to write code to connect to the MariaDB database. 1. Install the MariaDB server and use PHP to connect to Maria.
How to connect to MariaDB database using PDO
Jul 28, 2023 pm 02:49 PM
How to use PDO to connect to MariaDB database 1. Introduction PDO (PHPDataObjects) is a lightweight abstraction layer used in PHP to access the database. It provides developers with a unified set of interfaces to connect and operate different types of databases, including MariaDB, MySQL, SQLite, etc. This article will introduce how to use PDO to connect to the MariaDB database and give sample code. 2. Install and configure using PDO to connect to MariaDB
An article explaining the difference between MariaDB and MySQL in detail
Mar 09, 2023 am 11:39 AM
This article brings you relevant knowledge about MariaDB and MySQL. It mainly talks about the differences between MariaDB and MySQL. Friends who are interested can take a look at it together. I hope it will be helpful to everyone.
Optimize network performance of PHP applications using Docker Compose, Nginx and MariaDB
Oct 12, 2023 pm 12:49 PM
Introduction to optimizing network performance of PHP applications using DockerCompose, Nginx and MariaDB: In today's Internet era, network performance is crucial to the stability and responsiveness of web applications. In order to improve the network performance of PHP applications, we can use the containerization technology DockerCompose, the efficient web server Nginx and the stable database MariaDB. This article will introduce in detail how to use these tools to optimize the network of PHP applications.
Optimizing performance issues of PHP applications using Docker Compose, Nginx and MariaDB
Oct 12, 2023 pm 12:55 PM
Optimizing Performance Issues in PHP Applications Using DockerCompose, Nginx, and MariaDB When developing and deploying PHP applications, performance issues are often encountered. To solve these problems, we can leverage DockerCompose, Nginx, and MariaDB to optimize application performance. DockerCompose is a tool for defining and managing multiple Docker containers. It helps us create and run multiple containers easily
How to install MariaDB database on Debian 12
Feb 20, 2024 pm 02:24 PM
MariaDB is an open source multi-threaded relational database management system and a replacement for MySQL. MariaDB is the default replacement for MySQL in Debian. This tutorial explains how to install MariaDB on Debian12. Preparation conditions 1. A VPS virtual machine with Debian12 installed (it is recommended that you purchase an Alibaba Cloud VPS or Tencent Cloud VPS virtual host. If you prefer foreign servers, it is recommended that you try VPS on Vultr, and you will receive a $50 trial experience when you register) , very cost-effective), of course you can also use it on your own computer or virtual machine. 2. If you use VPS, for security reasons, it is recommended to use a non-root account, which can be done in Debian12
Security hardening of PHP applications using Docker Compose, Nginx and MariaDB
Oct 12, 2023 am 09:02 AM
Security Hardening of PHP Applications Using DockerCompose, Nginx, and MariaDB With the frequent occurrence of network attacks and data leaks, protecting the security of applications and databases has become increasingly important. In PHP applications, using DockerCompose, Nginx and MariaDB can achieve security hardening and provide certain security protection measures. This article explains how to use these tools for security hardening and provides some code examples. Using Doc
The perfect combination of Docker Compose, Nginx and MariaDB: best practices for deploying PHP applications
Oct 12, 2023 am 11:24 AM
The perfect combination of DockerCompose, Nginx and MariaDB: Best practices for deploying PHP applications Introduction: In modern web application development, the use of containerization technology has become a trend. Containerization technology can package an application and its dependencies into a single container, so that the application can run in any environment that supports containerization technology. Docker is currently the most popular containerization technology, which can simplify the deployment, management and expansion of applications. For use
