Not the answer you need?
Register and ask your own question!

Percona server is EXTREMELY slow

ClarkClark EntrantInactive User Role Beginner
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

Comments

  • ClarkClark Entrant Inactive User Role Beginner
    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
  • lk94109lk94109 Entrant Current User Role Beginner
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.