• ADADADADAD

    percona 5.7怎么添加tokudb[ mysql数据库 ]

    mysql数据库 时间:2024-11-26 22:08:04

    作者:文/会员上传

    简介:

    确保 libjemalloc 高于 3.3.0[root@fund-mgmt-db-mog-2 ~]# yum list |grep jemallocjemalloc.x86_643.6.0-1.el7 @percona-release-x86_64jemalloc-debuginfo.x86_64 3.3.1

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

    确保 libjemalloc 高于 3.3.0
    [root@fund-mgmt-db-mog-2 ~]# yum list |grep jemalloc
    jemalloc.x86_643.6.0-1.el7 @percona-release-x86_64
    jemalloc-debuginfo.x86_64 3.3.1-1.el7 percona-release-x86_64
    jemalloc-devel.x86_64 3.6.0-1.el7 percona-release-x86_64

    一定要大页支持,才能启动 tokudb
    echo never > /sys/kernel/mm/transparent_hugepage/enabled
    echo never > /sys/kernel/mm/transparent_hugepage/defrag

    安装tokudb包
    yum -y UNINSTALL Percona-Server-tokudb-57.x86_64

    让 tokudb 引擎生效
    ps_tokudb_admin --enable -uroot -p###### -S /home/mysql/my3313/run/mysql.sock -P 3313

    mysql> show engines;
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    | Engine | Support | Comment| Transactions | XA| Savepoints |
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    | InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES|
    | CSV| YES | CSV storage engine | NO| NO| NO |
    | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO| NO| NO |
    | BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) | NULL | NULL | NULL|
    | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO| NO| NO |
    | TokuDB | YES | Percona TokuDB Storage Engine with Fractal Tree(tm) Technology | YES | YES | YES|
    | PERFORMANCE_SCHEMA | YES | Performance Schema | NO| NO| NO |
    | ARCHIVE| YES | Archive storage engine | NO| NO| NO |
    | MyISAM | YES | MyISAM storage engine | NO| NO| NO |
    | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL|
    +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
    10 rows in set (0.00 sec)

    -- 卸载 tokudb

    UNINSTALL PLUGIN tokudb ;
    UNINSTALL PLUGIN tokudb_file_map ;
    UNINSTALL PLUGIN tokudb_fractal_tree_info ;
    UNINSTALL PLUGIN tokudb_fractal_tree_block_map ;
    UNINSTALL PLUGIN tokudb_trx ;
    UNINSTALL PLUGIN tokudb_locks ;
    UNINSTALL PLUGIN tokudb_lock_waits;
    UNINSTALL PLUGIN tokudb_background_job_status;

    percona 5.7怎么添加tokudb.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: perconatokudb