# Percona server is EXTREMELY slow
**URL:** https://forums.percona.com/t/percona-server-is-extremely-slow/5637
**Category:** Other MySQL® Questions
**Created:** [May 24, 2017, 6:18am UTC](https://forums.percona.com/t/percona-server-is-extremely-slow/5637 "2017-05-24T06:18:30Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Clark](https://forums.percona.com/u/Clark)
#### Post date: [May 24, 2017, 6:18am UTC](https://forums.percona.com/t/percona-server-is-extremely-slow/5637/1 "2017-05-24T06:18:30Z")
I have just installed Percona server 5.7 and have reused the same my.cnf as I did in mysql
Right now I’m importing a sql file with a mysql dump and it is EXTREMELY slow.. At least 5-6 times slower than Mysql
What is wrong? I don’t get it because I just reused the same configuration.. If there is no easy way to make percona faster I’m about to go back to mysql right away
Hardware:
Intel i7 2600
16GB RAM
Here is my conf
[mysql]
# CLIENT
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld]
# GENERAL
user = mysql
default-storage-engine = InnoDB
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
# SAFETY
max-allowed-packet = 16M
max-connect-errors = 1000000
skip-name-resolve
sql-mode = STRICT\_ALL\_TABLES,NO\_AUTO\_CREATE\_USER,NO\_AUTO\_VALU E\_ON\_ZERO,NO\_ENGINE\_SUBSTITUTION,ONLY\_FULL\_GROUP\_B Y,NO\_ZERO\_DATE,NO\_ZERO\_IN\_DATE,ERROR\_FOR\_DIVISION\_ BY\_ZERO
sysdate-is-now = 1
symbolic-links = 0
# DATA STORAGE
datadir = /var/lib/mysql/
# BINARY LOGGING
server-id = 2
log-bin = /var/lib/mysql/mysql-bin
expire-logs-days = 14
sync-binlog = 1
log-bin-trust-function-creators= 1
# REPLICATION
log-slave-updates
gtid-mode = ON
enforce-gtid-consistency
# CACHES AND LIMITS
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definition-cache = 4096
table-open-cache = 4096
# INNODB
innodb-flush-method = O\_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 256M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 12G
# LOGGING
log-error = /var/lib/mysql/mysql-error.log
log-queries-not-using-indexes = 1
slow-query-log = 1
slow-query-log-file = /var/lib/mysql/mysql-slow.log
basedir = /usr
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
explicit\_defaults\_for\_timestamp
---
### Author:  [@Clark](https://forums.percona.com/u/Clark)
#### Post date: [May 24, 2017, 9:48am UTC](https://forums.percona.com/t/percona-server-is-extremely-slow/5637/2 "2017-05-24T09:48:27Z")
ok…
I realised that the mysql dump was with single inserts so the import is slower…
But… I have just tested mysql 5.7 and percona 5.7 on two identical servers with a new debian install…
Within a timespan mysql 5.7 imported 9000 rows of the dump in a table and percona 5.7 only imported 7200 rows with the configuration above
---
### Author:  [@lk94109](https://forums.percona.com/u/lk94109)
#### Post date: [May 30, 2017, 10:37am UTC](https://forums.percona.com/t/percona-server-is-extremely-slow/5637/3 "2017-05-30T10:37:06Z")
Hello Clark, have you been able to find answers to your question about same/worse Percona performance in comparison to MySQL?
I’m trying to valuate the Percona, but my initial comparison of performance (using sysbench) between Percona 5.7 and MySQL 5.6
show the same results for both databases. I’ve applied the same my.cnf. The MySQL and Percona are running on separate boxes (same hardware), with the same Centos version. Used the following distro: Percona-Server-5.7.18-14-r2c06f4d-el6-x86\_64-bundle.tar