[РЕШЕНО] проблема с установкой CMS

150606 12:47:56 mysqld_safe mysqld from pid file /run/mysqld/mysqld.pid ended
150606 12:47:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-06-06 12:47:57 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-06-06 12:47:57 0 [Note] /usr/bin/mysqld (mysqld 5.6.24-72.2) starting as process 3520 ...
2015-06-06 12:47:57 3520 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2015-06-06 12:47:57 3520 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

max_open_files
table_open_cache

indeviral
а там видно будет...

150606 16:56:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-06-06 16:56:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-06-06 16:56:03 0 [Note] /usr/bin/mysqld (mysqld 5.6.24-72.2) starting as process 9979 ...
2015-06-06 16:56:03 9979 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2015-06-06 16:56:03 9979 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

2015-06-06 16:56:03 9979 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-06-06 16:56:03 9979 [Note] InnoDB: The InnoDB memory heap is disabled
2015-06-06 16:56:03 9979 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-06-06 16:56:03 9979 [Note] InnoDB: Memory barrier is not used
2015-06-06 16:56:03 9979 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-06-06 16:56:03 9979 [Note] InnoDB: Using Linux native AIO
2015-06-06 16:56:03 9979 [Note] InnoDB: Using CPU crc32 instructions
2015-06-06 16:56:03 9979 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-06-06 16:56:03 9979 [Note] InnoDB: Completed initialization of buffer pool
2015-06-06 16:56:03 9979 [Note] InnoDB: Highest supported file format is Barracuda.
2015-06-06 16:56:04 9979 [Warning] InnoDB: Resizing redo log from 2*2048 to 2*3072 pages, LSN=63502125
2015-06-06 16:56:04 9979 [Warning] InnoDB: Starting to delete and rewrite log files.
2015-06-06 16:56:04 9979 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2015-06-06 16:56:05 9979 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2015-06-06 16:56:06 9979 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2015-06-06 16:56:06 9979 [Warning] InnoDB: New log files created, LSN=63502348
2015-06-06 16:56:06 9979 [Note] InnoDB: 128 rollback segment(s) are active.
2015-06-06 16:56:06 9979 [Note] InnoDB: Waiting for purge to start
2015-06-06 16:56:06 9979 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 63502125
2015-06-06 16:56:06 9979 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-06-06 16:56:06 9979 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-06-06 16:56:06 9979 [Note] Server hostname (bind-address): '*'; port: 3306
2015-06-06 16:56:06 9979 [Note] IPv6 is available.
2015-06-06 16:56:06 9979 [Note]   - '::' resolves to '::';
2015-06-06 16:56:06 9979 [Note] Server socket created on IP: '::'.
2015-06-06 16:56:06 9979 [Note] Event Scheduler: Loaded 0 events
2015-06-06 16:56:06 9979 [Note] /usr/bin/mysqld: ready for connections.
Version: '5.6.24-72.2'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2015-06-06 16:59:24 9979 [Note] /usr/bin/mysqld: Normal shutdown

2015-06-06 16:59:24 9979 [Note] Giving 0 client threads a chance to die gracefully
2015-06-06 16:59:24 9979 [Note] Event Scheduler: Purging the queue. 0 events
2015-06-06 16:59:24 9979 [Note] Shutting down slave threads
2015-06-06 16:59:24 9979 [Note] Forcefully disconnecting 0 remaining clients
2015-06-06 16:59:24 9979 [Note] Binlog end
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'partition'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'ARCHIVE'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'BLACKHOLE'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_METRICS'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_CMP'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'INNODB_TRX'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'XTRADB_RSEG'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
2015-06-06 16:59:24 9979 [Note] Shutting down plugin 'InnoDB'
2015-06-06 16:59:24 9979 [Note] InnoDB: FTS optimize thread exiting.
2015-06-06 16:59:24 9979 [Note] InnoDB: Starting shutdown...
2015-06-06 16:59:26 9979 [Note] InnoDB: Shutdown completed; log sequence number 64840429
2015-06-06 16:59:26 9979 [Note] Shutting down plugin 'CSV'
2015-06-06 16:59:26 9979 [Note] Shutting down plugin 'MRG_MYISAM'
2015-06-06 16:59:26 9979 [Note] Shutting down plugin 'MyISAM'
2015-06-06 16:59:26 9979 [Note] Shutting down plugin 'MEMORY'
2015-06-06 16:59:26 9979 [Note] Shutting down plugin 'sha256_password'
2015-06-06 16:59:26 9979 [Note] Shutting down plugin 'mysql_old_password'
2015-06-06 16:59:26 9979 [Note] Shutting down plugin 'mysql_native_password'
2015-06-06 16:59:26 9979 [Note] Shutting down plugin 'binlog'
2015-06-06 16:59:26 9979 [Note] /usr/bin/mysqld: Shutdown complete

150606 16:59:26 mysqld_safe mysqld from pid file /run/mysqld/mysqld.pid ended
150606 16:59:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-06-06 16:59:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-06-06 16:59:27 0 [Note] /usr/bin/mysqld (mysqld 5.6.24-72.2) starting as process 10311 ...
2015-06-06 16:59:27 10311 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2015-06-06 16:59:27 10311 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

2015-06-06 16:59:27 10311 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-06-06 16:59:27 10311 [Note] InnoDB: The InnoDB memory heap is disabled
2015-06-06 16:59:27 10311 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-06-06 16:59:27 10311 [Note] InnoDB: Memory barrier is not used
2015-06-06 16:59:27 10311 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-06-06 16:59:27 10311 [Note] InnoDB: Using Linux native AIO
2015-06-06 16:59:27 10311 [Note] InnoDB: Using CPU crc32 instructions
2015-06-06 16:59:27 10311 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-06-06 16:59:27 10311 [Note] InnoDB: Completed initialization of buffer pool
2015-06-06 16:59:27 10311 [Note] InnoDB: Highest supported file format is Barracuda.
2015-06-06 16:59:28 10311 [Note] InnoDB: 128 rollback segment(s) are active.
2015-06-06 16:59:28 10311 [Note] InnoDB: Waiting for purge to start
2015-06-06 16:59:28 10311 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 64840429
2015-06-06 16:59:28 10311 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-06-06 16:59:28 10311 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-06-06 16:59:28 10311 [Note] Server hostname (bind-address): '*'; port: 3306
2015-06-06 16:59:28 10311 [Note] IPv6 is available.
2015-06-06 16:59:28 10311 [Note]   - '::' resolves to '::';
2015-06-06 16:59:28 10311 [Note] Server socket created on IP: '::'.
2015-06-06 16:59:28 10311 [Note] Event Scheduler: Loaded 0 events
2015-06-06 16:59:28 10311 [Note] /usr/bin/mysqld: ready for connections.
Version: '5.6.24-72.2'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2015-06-06 17:01:40 10311 [Note] /usr/bin/mysqld: Normal shutdown

2015-06-06 17:01:40 10311 [Note] Giving 0 client threads a chance to die gracefully
2015-06-06 17:01:40 10311 [Note] Event Scheduler: Purging the queue. 0 events
2015-06-06 17:01:40 10311 [Note] Shutting down slave threads
2015-06-06 17:01:40 10311 [Note] Forcefully disconnecting 0 remaining clients
2015-06-06 17:01:40 10311 [Note] Binlog end
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'partition'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'ARCHIVE'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'BLACKHOLE'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_METRICS'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_CMP'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'INNODB_TRX'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'XTRADB_RSEG'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
2015-06-06 17:01:40 10311 [Note] Shutting down plugin 'InnoDB'
2015-06-06 17:01:40 10311 [Note] InnoDB: FTS optimize thread exiting.
2015-06-06 17:01:40 10311 [Note] InnoDB: Starting shutdown...
2015-06-06 17:01:41 10311 [Note] InnoDB: Shutdown completed; log sequence number 66845672
2015-06-06 17:01:41 10311 [Note] Shutting down plugin 'CSV'
2015-06-06 17:01:41 10311 [Note] Shutting down plugin 'MRG_MYISAM'
2015-06-06 17:01:41 10311 [Note] Shutting down plugin 'MyISAM'
2015-06-06 17:01:41 10311 [Note] Shutting down plugin 'MEMORY'
2015-06-06 17:01:41 10311 [Note] Shutting down plugin 'sha256_password'
2015-06-06 17:01:41 10311 [Note] Shutting down plugin 'mysql_old_password'
2015-06-06 17:01:41 10311 [Note] Shutting down plugin 'mysql_native_password'
2015-06-06 17:01:41 10311 [Note] Shutting down plugin 'binlog'
2015-06-06 17:01:41 10311 [Note] /usr/bin/mysqld: Shutdown complete

150606 17:01:42 mysqld_safe mysqld from pid file /run/mysqld/mysqld.pid ended

150606 16:24:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
2015-06-06 16:24:05 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-06-06 16:24:05 0 [Note] /usr/bin/mysqld (mysqld 5.6.24-72.2-log) starting as process 8958 ...
2015-06-06 16:24:06 8958 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535)

2015-06-06 16:24:06 8958 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 500)

2015-06-06 16:24:06 8958 [Warning] Buffered warning: Changed limits: table_open_cache: 400 (requested 2048)

2015-06-06 16:24:06 8958 [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.
2015-06-06 16:24:06 8958 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2015-06-06 16:24:06 8958 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-06-06 16:24:06 8958 [Note] InnoDB: The InnoDB memory heap is disabled
2015-06-06 16:24:06 8958 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-06-06 16:24:06 8958 [Note] InnoDB: Memory barrier is not used
2015-06-06 16:24:06 8958 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-06-06 16:24:06 8958 [Note] InnoDB: Using Linux native AIO
2015-06-06 16:24:06 8958 [Note] InnoDB: Using CPU crc32 instructions
2015-06-06 16:24:06 8958 [Note] InnoDB: Initializing buffer pool, size = 300.0M
2015-06-06 16:24:06 8958 [Note] InnoDB: Completed initialization of buffer pool
2015-06-06 16:24:06 8958 [Note] InnoDB: Highest supported file format is Barracuda.
2015-06-06 16:24:07 8958 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*2048 pages, LSN=60182343
2015-06-06 16:24:07 8958 [Warning] InnoDB: Starting to delete and rewrite log files.
2015-06-06 16:24:07 8958 [Note] InnoDB: Setting log file ./ib_logfile101 size to 32 MB
2015-06-06 16:24:08 8958 [Note] InnoDB: Setting log file ./ib_logfile1 size to 32 MB
2015-06-06 16:24:09 8958 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2015-06-06 16:24:09 8958 [Warning] InnoDB: New log files created, LSN=60182540
2015-06-06 16:24:09 8958 [Note] InnoDB: 128 rollback segment(s) are active.
2015-06-06 16:24:09 8958 [Note] InnoDB: Waiting for purge to start
2015-06-06 16:24:09 8958 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 60182343
2015-06-06 16:24:09 8958 [ERROR] Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 39, event_type: -93
2015-06-06 16:24:09 8958 [Warning] Error reading GTIDs from binary log: -1
2015-06-06 16:24:09 8958 [ERROR] Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 25, event_type: -93
2015-06-06 16:24:09 8958 [Warning] Error reading GTIDs from binary log: -1
2015-06-06 16:24:09 8958 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-06-06 16:24:09 8958 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-06-06 16:24:09 8958 [Note] Server hostname (bind-address): '*'; port: 3306
2015-06-06 16:24:09 8958 [Note] IPv6 is available.
2015-06-06 16:24:09 8958 [Note]   - '::' resolves to '::';
2015-06-06 16:24:09 8958 [Note] Server socket created on IP: '::'.
2015-06-06 16:24:10 8958 [Note] Event Scheduler: Loaded 0 events
2015-06-06 16:24:10 8958 [Note] /usr/bin/mysqld: ready for connections.
Version: '5.6.24-72.2-log'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
2015-06-06 16:40:17 8958 [Note] /usr/bin/mysqld: Normal shutdown

# Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208
[mysql]

# CLIENT #
# Configure default options for clients
port                           = 3306

[mysqld]

# GENERAL #
# Choose user for execution, default storage engine and location of the PID file
user                           = mysql
default-storage-engine         = InnoDB
pid-file                       = /var/lib/mysql/mysql.pid

# MyISAM #
# Setup MyISAM options with a minimal config, as InnoDB is our default engine
key-buffer-size                = 32M
myisam-recover                 = FORCE,BACKUP

# SAFETY #
# Enforce limits and safety checks
max-allowed-packet             = 16M
max-connect-errors             = 1000000
innodb                         = FORCE

# DATA STORAGE #
# Select location for database files
datadir                        = /var/lib/mysql/

# BINARY LOGGING #
# Enable and setup the binary log
log-bin                        = /var/lib/mysql/mysql-bin
expire-logs-days               = 14
sync-binlog                    = 1

# CACHES AND LIMITS #
# Configure reasonable default limits throughout Percona Server
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         = 1024
table-open-cache               = 2048

# INNODB #
# Setup InnoDB/XtraDB engine a 300MB buffer pool and 32MB log file size
innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2
innodb-log-file-size           = 32M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table          = 1
innodb-buffer-pool-size        = 300M

# LOGGING #
# Setup log file locations for error log and slow log
# Slow log may be disabled on production setups to prevent extra IO
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

# MySQL systemd service file

[Unit]
Description=MySQL Community Server
After=network.target
After=syslog.target

[Install]
WantedBy=multi-user.target

[Service]
User=mysql
Group=mysql
PermissionsStartOnly=true
ExecStartPre=/usr/share/mysql/mysql-systemd-start pre
ExecStart=/usr/bin/mysqld_safe
ExecStartPost=/usr/share/mysql/mysql-systemd-start post
TimeoutSec=600
Restart=on-failure
RuntimeDirectory=mysqld
RuntimeDirectoryMode=755
LimitNOFILE=2048

indeviral
да вряд ли...

LimitNOFILE=infinity
LimitMEMLOCK=infinity

indeviral
довольно таки хорошая версия... может вообще отключить бинарные логи?

explicit_defaults_for_timestamp = 1

mysql> show global variables like 'explicit_defaults_for_timestamp';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| explicit_defaults_for_timestamp | OFF   |
+---------------------------------+-------+
1 row in set (0.00 sec)

indeviral
довольно таки хорошая версия... может вообще отключить бинарные логи?

indeviral
закоментируйте
log-bin, expire-logs-days, sync-binlog

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[client]
#password       = your_password
port            = 3306
socket          = /run/mysqld/mysqld.sock

[mysqld]
port            = 3306
socket          = /run/mysqld/mysqld.sock
datadir         = /var/lib/mysql

#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]
log-error       = /var/log/mysqld.log
pid-file        = /run/mysqld/mysqld.pid

#
explicit_defaults_for_timestamp = 1