Падает сервер, много соединений

[zetsasha9]

Сервер зависает, оверлоад под 13.
Захожу "графики" там резкий скачек под 14м подключений
Этот Ddos или глюк ?
Помогите разобраться, плиз !

[skurudo]

C таким количеством данных можно только начать гадать.

[zetsasha9]

C таким количеством данных можно только начать гадать.

Вот /var/log/mysql/error.log

Code: Select all

160421 12:10:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-04-21 12:10:49 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2016-04-21 12:10:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-21 12:10:49 0 [Note] /usr/sbin/mysqld (mysqld 5.6.28-0ubuntu0.15.10.1) starting as process 1056 ...
2016-04-21 12:10:50 1056 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2016-04-21 12:10:52 1056 [Note] Plugin 'FEDERATED' is disabled.
2016-04-21 12:10:53 1056 [ERROR] Function 'innodb' already exists
2016-04-21 12:10:53 1056 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2016-04-21 12:10:53 1056 [ERROR] Function 'federated' already exists
2016-04-21 12:10:53 1056 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2016-04-21 12:10:53 1056 [ERROR] Function 'blackhole' already exists
2016-04-21 12:10:53 1056 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2016-04-21 12:10:53 1056 [ERROR] Function 'archive' already exists
2016-04-21 12:10:53 1056 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2016-04-21 12:10:54 1056 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-04-21 12:10:54 1056 [Note] InnoDB: The InnoDB memory heap is disabled
2016-04-21 12:10:54 1056 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-21 12:10:54 1056 [Note] InnoDB: Memory barrier is not used
2016-04-21 12:10:54 1056 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-04-21 12:10:54 1056 [Note] InnoDB: Using Linux native AIO
2016-04-21 12:10:54 1056 [Note] InnoDB: Using CPU crc32 instructions
2016-04-21 12:10:54 1056 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-04-21 12:10:54 1056 [Note] InnoDB: Completed initialization of buffer pool
2016-04-21 12:10:55 1056 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-21 12:10:55 1056 [Note] InnoDB: Log scan progressed past the checkpoint lsn 12263933427
2016-04-21 12:10:55 1056 [Note] InnoDB: Database was not shutdown normally!
2016-04-21 12:10:55 1056 [Note] InnoDB: Starting crash recovery.
2016-04-21 12:10:55 1056 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-04-21 12:11:28 1056 [Note] InnoDB: Restoring possible half-written data pages 
2016-04-21 12:11:28 1056 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 12263956400
2016-04-21 12:11:30 1056 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
2016-04-21 12:11:31 1056 [Note] InnoDB: 128 rollback segment(s) are active.
2016-04-21 12:11:31 1056 [Note] InnoDB: Waiting for purge to start
2016-04-21 12:11:31 1056 [Note] InnoDB: 5.6.28 started; log sequence number 12263956400
2016-04-21 12:11:31 1056 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-21 12:11:31 1056 [Note] IPv6 is available.
2016-04-21 12:11:31 1056 [Note]   - '::' resolves to '::';
2016-04-21 12:11:31 1056 [Note] Server socket created on IP: '::'.
2016-04-21 12:11:33 1056 [Note] Event Scheduler: Loaded 0 events
2016-04-21 12:11:33 1056 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.28-0ubuntu0.15.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
160421 13:55:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-04-21 13:55:03 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2016-04-21 13:55:03 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-21 13:55:03 0 [Note] /usr/sbin/mysqld (mysqld 5.6.28-0ubuntu0.15.10.1) starting as process 1050 ...
2016-04-21 13:55:04 1050 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2016-04-21 13:55:05 1050 [Note] Plugin 'FEDERATED' is disabled.
2016-04-21 13:55:06 1050 [ERROR] Function 'innodb' already exists
2016-04-21 13:55:06 1050 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2016-04-21 13:55:06 1050 [ERROR] Function 'federated' already exists
2016-04-21 13:55:06 1050 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2016-04-21 13:55:06 1050 [ERROR] Function 'blackhole' already exists
2016-04-21 13:55:06 1050 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2016-04-21 13:55:06 1050 [ERROR] Function 'archive' already exists
2016-04-21 13:55:06 1050 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2016-04-21 13:55:06 1050 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-04-21 13:55:06 1050 [Note] InnoDB: The InnoDB memory heap is disabled
2016-04-21 13:55:06 1050 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-21 13:55:06 1050 [Note] InnoDB: Memory barrier is not used
2016-04-21 13:55:06 1050 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-04-21 13:55:06 1050 [Note] InnoDB: Using Linux native AIO
2016-04-21 13:55:06 1050 [Note] InnoDB: Using CPU crc32 instructions
2016-04-21 13:55:06 1050 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-04-21 13:55:06 1050 [Note] InnoDB: Completed initialization of buffer pool
2016-04-21 13:55:07 1050 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-21 13:55:07 1050 [Note] InnoDB: Log scan progressed past the checkpoint lsn 12273160736
2016-04-21 13:55:07 1050 [Note] InnoDB: Database was not shutdown normally!
2016-04-21 13:55:07 1050 [Note] InnoDB: Starting crash recovery.
2016-04-21 13:55:07 1050 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-04-21 13:55:32 1050 [Note] InnoDB: Restoring possible half-written data pages 
2016-04-21 13:55:32 1050 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 12273161107
2016-04-21 13:55:36 1050 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
2016-04-21 13:55:36 1050 [Note] InnoDB: 128 rollback segment(s) are active.
2016-04-21 13:55:36 1050 [Note] InnoDB: Waiting for purge to start
2016-04-21 13:55:36 1050 [Note] InnoDB: 5.6.28 started; log sequence number 12273161107
2016-04-21 13:55:36 1050 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-21 13:55:36 1050 [Note] IPv6 is available.
2016-04-21 13:55:36 1050 [Note]   - '::' resolves to '::';
2016-04-21 13:55:36 1050 [Note] Server socket created on IP: '::'.
2016-04-21 13:55:37 1050 [Note] Event Scheduler: Loaded 0 events
2016-04-21 13:55:37 1050 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.28-0ubuntu0.15.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2016-04-21 13:57:36 1050 [Note] /usr/sbin/mysqld: Normal shutdown

2016-04-21 13:57:36 1050 [Note] Giving 0 client threads a chance to die gracefully
2016-04-21 13:57:36 1050 [Note] Event Scheduler: Purging the queue. 0 events
2016-04-21 13:57:36 1050 [Note] Shutting down slave threads
2016-04-21 13:57:36 1050 [Note] Forcefully disconnecting 0 remaining clients
2016-04-21 13:57:36 1050 [Note] Binlog end
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'partition'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_METRICS'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_CMP'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'INNODB_TRX'
2016-04-21 13:57:36 1050 [Note] Shutting down plugin 'InnoDB'
2016-04-21 13:57:36 1050 [Note] InnoDB: FTS optimize thread exiting.
2016-04-21 13:57:36 1050 [Note] InnoDB: Starting shutdown...
2016-04-21 13:57:38 1050 [Note] InnoDB: Shutdown completed; log sequence number 12273491017
2016-04-21 13:57:38 1050 [Note] Shutting down plugin 'ARCHIVE'
2016-04-21 13:57:38 1050 [Note] Shutting down plugin 'BLACKHOLE'
2016-04-21 13:57:38 1050 [Note] Shutting down plugin 'MRG_MYISAM'
2016-04-21 13:57:38 1050 [Note] Shutting down plugin 'MyISAM'
2016-04-21 13:57:38 1050 [Note] Shutting down plugin 'CSV'
2016-04-21 13:57:38 1050 [Note] Shutting down plugin 'MEMORY'
2016-04-21 13:57:38 1050 [Note] Shutting down plugin 'sha256_password'
2016-04-21 13:57:38 1050 [Note] Shutting down plugin 'mysql_old_password'
2016-04-21 13:57:38 1050 [Note] Shutting down plugin 'mysql_native_password'
2016-04-21 13:57:38 1050 [Note] Shutting down plugin 'binlog'
2016-04-21 13:57:38 1050 [Note] /usr/sbin/mysqld: Shutdown complete

160421 13:57:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160421 13:57:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-04-21 13:57:39 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2016-04-21 13:57:39 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-21 13:57:39 0 [Note] /usr/sbin/mysqld (mysqld 5.6.28-0ubuntu0.15.10.1) starting as process 2253 ...
2016-04-21 13:57:39 2253 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2016-04-21 13:57:40 2253 [Note] Plugin 'FEDERATED' is disabled.
2016-04-21 13:57:40 2253 [ERROR] Function 'innodb' already exists
2016-04-21 13:57:40 2253 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2016-04-21 13:57:40 2253 [ERROR] Function 'federated' already exists
2016-04-21 13:57:40 2253 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2016-04-21 13:57:40 2253 [ERROR] Function 'blackhole' already exists
2016-04-21 13:57:40 2253 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2016-04-21 13:57:40 2253 [ERROR] Function 'archive' already exists
2016-04-21 13:57:40 2253 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2016-04-21 13:57:40 2253 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-04-21 13:57:40 2253 [Note] InnoDB: The InnoDB memory heap is disabled
2016-04-21 13:57:40 2253 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-21 13:57:40 2253 [Note] InnoDB: Memory barrier is not used
2016-04-21 13:57:40 2253 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-04-21 13:57:40 2253 [Note] InnoDB: Using Linux native AIO
2016-04-21 13:57:40 2253 [Note] InnoDB: Using CPU crc32 instructions
2016-04-21 13:57:40 2253 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-04-21 13:57:40 2253 [Note] InnoDB: Completed initialization of buffer pool
2016-04-21 13:57:40 2253 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-21 13:57:41 2253 [Note] InnoDB: 128 rollback segment(s) are active.
2016-04-21 13:57:41 2253 [Note] InnoDB: Waiting for purge to start
2016-04-21 13:57:41 2253 [Note] InnoDB: 5.6.28 started; log sequence number 12273491017
2016-04-21 13:57:41 2253 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-21 13:57:41 2253 [Note] IPv6 is available.
2016-04-21 13:57:41 2253 [Note]   - '::' resolves to '::';
2016-04-21 13:57:41 2253 [Note] Server socket created on IP: '::'.
2016-04-21 13:57:41 2253 [Note] Event Scheduler: Loaded 0 events
2016-04-21 13:57:41 2253 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.28-0ubuntu0.15.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2016-04-21 13:57:49 2253 [Note] /usr/sbin/mysqld: Normal shutdown

2016-04-21 13:57:49 2253 [Note] Giving 1 client threads a chance to die gracefully
2016-04-21 13:57:49 2253 [Note] Event Scheduler: Purging the queue. 0 events
2016-04-21 13:57:49 2253 [Note] Shutting down slave threads
2016-04-21 13:57:51 2253 [Note] Forcefully disconnecting 0 remaining clients
2016-04-21 13:57:51 2253 [Note] Binlog end
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'partition'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_METRICS'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_CMP'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'INNODB_TRX'
2016-04-21 13:57:51 2253 [Note] Shutting down plugin 'InnoDB'
2016-04-21 13:57:51 2253 [Note] InnoDB: FTS optimize thread exiting.
2016-04-21 13:57:51 2253 [Note] InnoDB: Starting shutdown...
2016-04-21 13:57:52 2253 [Note] InnoDB: Shutdown completed; log sequence number 12273500290
2016-04-21 13:57:52 2253 [Note] Shutting down plugin 'ARCHIVE'
2016-04-21 13:57:52 2253 [Note] Shutting down plugin 'BLACKHOLE'
2016-04-21 13:57:52 2253 [Note] Shutting down plugin 'MRG_MYISAM'
2016-04-21 13:57:52 2253 [Note] Shutting down plugin 'MyISAM'
2016-04-21 13:57:52 2253 [Note] Shutting down plugin 'CSV'
2016-04-21 13:57:52 2253 [Note] Shutting down plugin 'MEMORY'
2016-04-21 13:57:52 2253 [Note] Shutting down plugin 'sha256_password'
2016-04-21 13:57:52 2253 [Note] Shutting down plugin 'mysql_old_password'
2016-04-21 13:57:52 2253 [Note] Shutting down plugin 'mysql_native_password'
2016-04-21 13:57:52 2253 [Note] Shutting down plugin 'binlog'
2016-04-21 13:57:52 2253 [Note] /usr/sbin/mysqld: Shutdown complete

160421 13:57:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160421 13:59:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-04-21 13:59:15 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2016-04-21 13:59:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-21 13:59:15 0 [Note] /usr/sbin/mysqld (mysqld 5.6.28-0ubuntu0.15.10.1) starting as process 3162 ...
2016-04-21 13:59:15 3162 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2016-04-21 13:59:15 3162 [Note] Plugin 'FEDERATED' is disabled.
2016-04-21 13:59:15 3162 [ERROR] Function 'innodb' already exists
2016-04-21 13:59:15 3162 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2016-04-21 13:59:15 3162 [ERROR] Function 'federated' already exists
2016-04-21 13:59:15 3162 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2016-04-21 13:59:15 3162 [ERROR] Function 'blackhole' already exists
2016-04-21 13:59:15 3162 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2016-04-21 13:59:15 3162 [ERROR] Function 'archive' already exists
2016-04-21 13:59:15 3162 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2016-04-21 13:59:15 3162 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-04-21 13:59:15 3162 [Note] InnoDB: The InnoDB memory heap is disabled
2016-04-21 13:59:15 3162 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-21 13:59:15 3162 [Note] InnoDB: Memory barrier is not used
2016-04-21 13:59:15 3162 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-04-21 13:59:15 3162 [Note] InnoDB: Using Linux native AIO
2016-04-21 13:59:15 3162 [Note] InnoDB: Using CPU crc32 instructions
2016-04-21 13:59:15 3162 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-04-21 13:59:15 3162 [Note] InnoDB: Completed initialization of buffer pool
2016-04-21 13:59:15 3162 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-21 13:59:15 3162 [Note] InnoDB: 128 rollback segment(s) are active.
2016-04-21 13:59:15 3162 [Note] InnoDB: Waiting for purge to start
2016-04-21 13:59:16 3162 [Note] InnoDB: 5.6.28 started; log sequence number 12273500290
2016-04-21 13:59:16 3162 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-21 13:59:16 3162 [Note] IPv6 is available.
2016-04-21 13:59:16 3162 [Note]   - '::' resolves to '::';
2016-04-21 13:59:16 3162 [Note] Server socket created on IP: '::'.
2016-04-21 13:59:16 3162 [Note] Event Scheduler: Loaded 0 events
2016-04-21 13:59:16 3162 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.28-0ubuntu0.15.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

[zetsasha9]

C таким количеством данных можно только начать гадать.

Что может означать эта запись ? :

Code: Select all

InnoDB: Warning: a long semaphore wait:
--Thread 140614815078144 has waited at btr0cur.cc line 256 for 249.00 seconds the semaphore:
X-lock on RW-latch at 0x7fe3773a1340 created in file buf0buf.cc line 1069
a writer (thread id 140614815344384) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file buf0flu.cc line 1056
Last time write locked in file /build/mysql-5.6-MBrMyb/mysql-5.6-5.6.28/storage/innobase/btr/btr0cur.cc line 256

[skurudo]

Что может означать эта запись ?

Code: Select all

InnoDB: Warning: a long semaphore wait:
--Thread 140614815078144 has waited at btr0cur.cc line 256 for 249.00 seconds the semaphore:
X-lock on RW-latch at 0x7fe3773a1340 created in file buf0buf.cc line 1069
a writer (thread id 140614815344384) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file buf0flu.cc line 1056
Last time write locked in file /build/mysql-5.6-MBrMyb/mysql-5.6-5.6.28/storage/innobase/btr/btr0cur.cc line 256

Лочится база при работе.

Попробовать можно с такого
- восстановлении при перезапуске
http://dev.mysql.com/doc/refman/5.6/en/ ... overy.html

- отключить адаптивный хэш
http://dev.mysql.com/doc/refman/5.6/en/ ... -hash.html