# Performance advice requested for Percona 5.6 w/Tokudb application

**URL:** <https://forums.percona.com/t/performance-advice-requested-for-percona-5-6-w-tokudb-application/7230>\
**Category:** Percona Server for MySQL 5.6\
**Created:** [October 6, 2019, 7:43am UTC](https://forums.percona.com/t/performance-advice-requested-for-percona-5-6-w-tokudb-application/7230 "2019-10-06T07:43:05Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![charlessss](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@charlessss](https://forums.percona.com/u/charlessss)\
**Post date:** [October 6, 2019, 7:43am UTC](https://forums.percona.com/t/performance-advice-requested-for-percona-5-6-w-tokudb-application/7230/1 "2019-10-06T07:43:05Z")

</div>

At my company, we have been deploying Percona 5.6.36-rel82.1 on Centos servers as the data backend for our Java application.

Oddly, on one of our sites the performance is much lower than the others, and we are at a loss for figuring out why.  
The database server at this site is a Centos 7.6 Dell PowerEdge R740xd, with a H740P RAID controller and a 7 x 1.92TB SSD RAID5, with 1.5TB of 2666Mhz DDR4 , connected via 10Gbit ethernet to a server running the java application.

The my.cnf for this server is currently:

[mysql]  
max\_allowed\_packet = 10M

[mysqld]  
datadir = /export/ssdraid/mysql  
socket = /export/ssdraid/mysql/mysql.sock  
max\_connections = 10000  
key\_buffer = 1M  
max\_allowed\_packet = 10M  
myisam\_sort\_buffer\_size = 64M  
query\_cache\_size = 16M  
innodb\_buffer\_pool\_instances = 16  
innodb\_buffer\_pool\_size = 640G  
tokudb\_cache\_size = 640G  
net\_write\_timeout = 120  
net\_read\_timeout = 120  
connect\_timeout = 120  
innodb\_lock\_wait\_timeout = 120  
thread\_pool\_idle\_timeout = 120  
innodb\_additional\_mem\_pool\_size = 20M  
innodb\_checksums = 0  
innodb\_log\_file\_size = 2000M  
innodb\_log\_buffer\_size = 1024M  
innodb\_flush\_log\_at\_trx\_commit = 0  
performance\_schema = OFF  
innodb\_read\_ahead\_threshold = 32  
innodb\_file\_format = Barracuda  
bulk\_insert\_buffer\_size = 16M  
innodb\_file\_per\_table  
transaction-isolation = READ-UNCOMMITTED  
secure-file-priv = “”  
tmpdir = /export/ssdraid/tmp  
symbolic-links = 1

[mysqld\_safe]  
thp-setting=never  
log-error = /var/log/mysqld.log  
pid-file = /var/run/mysqld/mysqld.pid

When I examine the server during the slow jobs, I see that it is fairly busy. About 1.1GB/sec SSD reads/ 50MB/sec SSD writes, about 1000% CPU showing in ‘top’ for the mysqld process.

The database is a mixture of InnoDB and TokuDB tables.

Any advice on tuning this?

Also, we are willing to contract with Percona to provide paid optimization consulting for this problem. Who do we contact about this?