Хочу добиться максимального быстродействия от Percona Server;
Вся база в InnoDB, База на 7 гб. На штатном mysql, при "авктонфигурация" - еле ползала.
Как добиться максимального быстродействия от Percona?
Логи:
TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
[Note] Plugin 'FEDERATED' is disabled.
[Note] InnoDB: Using atomics to ref count buffer pool pages
[Note] InnoDB: The InnoDB memory heap is disabled
[Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
[Note] InnoDB: Memory barrier is not used
[Note] InnoDB: Compressed tables use zlib 1.2.8
[Note] InnoDB: Using Linux native AIO
[Note] InnoDB: Using CPU crc32 instructions
[Note] InnoDB: Initializing buffer pool, size = 5.0G
[Note] InnoDB: Completed initialization of buffer pool
[Note] InnoDB: Highest supported file format is Barracuda.
[Note] InnoDB: 128 rollback segment(s) are active.
[Note] InnoDB: Waiting for purge to start
[Note] InnoDB: Percona XtraDB (
www.percona.com) 5.6.23-72.1 started; log sequence number 1625987
[Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
[Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
[Note] Binlog end
[Note] InnoDB: FTS optimize thread exiting.
[Note] InnoDB: Starting shutdown...
[Note] InnoDB: Shutdown completed; log sequence number 1625997
Простой
