Hello sir,
Please check the logs :
MySQL Configuration :
Please check the logs :
Code:
2015-09-21 08:16:17 759323 [Warning] Checking table: './onliners_marketdb/wp_options'
2015-09-21 08:16:17 759323 [ERROR] /usr/sbin/mysqld: Table './nazilchw_wp/wp_options' is marked as crashed and should be repaired
2015-09-21 08:16:17 759323 [Warning] Checking table: './nazilchw_wp/wp_options'
2015-09-21 08:16:17 759323 [ERROR] /usr/sbin/mysqld: Table './nazilchw_wp/wp_TABLE_STATISTICS' is marked as crashed and should be repaired
2015-09-21 08:16:17 759323 [Warning] Checking table: './nazilchw_wp/wp_TABLE_STATISTICS'
2015-09-21 08:16:17 759323 [ERROR] /usr/sbin/mysqld: Table './nazilchw_wp/wp_TABLE_STATISTICS_RAW' is marked as crashed and should be repaired
2015-09-21 08:16:17 759323 [Warning] Checking table: './nazilchw_wp/wp_TABLE_STATISTICS_RAW'
2015-09-21 08:17:30 759323 [ERROR] /usr/sbin/mysqld: Table './salmanca_asli/e107_online' is marked as crashed and should be repaired
2015-09-21 08:17:30 759323 [Warning] Checking table: './salmanca_asli/e107_online'
2015-09-21 08:22:54 759323 [ERROR] /usr/sbin/mysqld: Table './mosavi_mivdl/wp_options' is marked as crashed and should be repaired
2015-09-21 08:22:54 759323 [Warning] Checking table: './mosavi_mivdl/wp_options'
2015-09-21 08:22:55 759323 [ERROR] /usr/sbin/mysqld: Table './mosavi_mivdl/wp_TABLE_STATISTICS' is marked as crashed and should be repaired
2015-09-21 08:22:55 759323 [Warning] Checking table: './mosavi_mivdl/wp_TABLE_STATISTICS'
2015-09-21 08:22:55 759323 [ERROR] /usr/sbin/mysqld: Table './mosavi_mivdl/wp_TABLE_STATISTICS_RAW' is marked as crashed and should be repaired
2015-09-21 08:22:55 759323 [Warning] Checking table: './mosavi_mivdl/wp_TABLE_STATISTICS_RAW'
2015-09-21 08:23:38 759323 [ERROR] /usr/sbin/mysqld: Table './almascar_db/state_visit' is marked as crashed and should be repaired
2015-09-21 08:23:38 759323 [Warning] Checking table: './almascar_db/state_visit'
2015-09-21 08:26:30 759323 [ERROR] /usr/sbin/mysqld: Table './buyprope_buyprope/wp_server_name' is marked as crashed and should be repaired
2015-09-21 08:26:30 759323 [Warning] Checking table: './buyprope_buyprope/wp_server_name'
2015-09-21 08:29:53 759323 [ERROR] /usr/sbin/mysqld: Table './asanyadb_sitedb/wp_TABLE_STATISTICS' is marked as crashed and should be repaired
2015-09-21 08:29:53 759323 [Warning] Checking table: './asanyadb_sitedb/wp_TABLE_STATISTICS'
2015-09-21 08:29:53 759323 [ERROR] /usr/sbin/mysqld: Table './asanyadb_sitedb/wp_TABLE_STATISTICS_RAW' is marked as crashed and should be repaired
2015-09-21 08:29:53 759323 [Warning] Checking table: './asanyadb_sitedb/wp_TABLE_STATISTICS_RAW'
2015-09-21 08:29:53 759323 [ERROR] /usr/sbin/mysqld: Table './asanyadb_sitedb/wp_wfHits' is marked as crashed and should be repaired
2015-09-21 08:29:53 759323 [Warning] Checking table: './asanyadb_sitedb/wp_wfHits'
2015-09-21 08:30:04 759323 [ERROR] /usr/sbin/mysqld: Table './abite_b/news_tmp' is marked as crashed and last (automatic?) repair failed
2015-09-21 08:33:36 759323 [ERROR] /usr/sbin/mysqld: Table './dokan_shop/wp_options' is marked as crashed and should be repaired
2015-09-21 08:33:36 759323 [Warning] Checking table: './dokan_shop/wp_options'
2015-09-21 12:30:04 759323 [ERROR] /usr/sbin/mysqld: Table './abite_b/news_tmp' is marked as crashed and last (automatic?) repair failed
2015-09-21 16:30:03 759323 [ERROR] /usr/sbin/mysqld: Table './abite_b/news_tmp' is marked as crashed and last (automatic?) repair failed
14:10:02 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
key_buffer_size=33554432
read_buffer_size=131072
max_used_connections=222
max_threads=4000
thread_count=56
connection_count=55
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1620143 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x4818c5c0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7fa17d7b7e18 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8e0985]
/usr/sbin/mysqld(handle_fatal_signal+0x494)[0x6670c4]
/lib64/libpthread.so.0(+0xf790)[0x7faeb3e96790]
/usr/sbin/mysqld[0xab73c0]
/usr/sbin/mysqld(_ZN17Query_cache_query16unlock_n_destroyEv+0x2c)[0x6a424c]
/usr/sbin/mysqld(_ZN11Query_cache12move_by_typeEPPhPP17Query_cache_blockPmS3_+0x407)[0x6a7a67]
/usr/sbin/mysqld(_ZN11Query_cache10pack_cacheEv+0x5d)[0x6a7fcd]
/usr/sbin/mysqld(_ZN11Query_cache4packEmj+0x60)[0x6a80a0]
/usr/sbin/mysqld(_Z20reload_acl_and_cacheP3THDmP10TABLE_LISTPi+0x445)[0x6fe705]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x78a)[0x6e47ca]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x443)[0x6e93e3]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x149a)[0x6ea94a]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xcf)[0x6b589f]
/usr/sbin/mysqld(handle_one_connection+0x52)[0x6b59d2]
/usr/sbin/mysqld(pfs_spawn_thread+0x12a)[0xab92ca]
/lib64/libpthread.so.0(+0x7a51)[0x7faeb3e8ea51]
/lib64/libc.so.6(clone+0x6d)[0x7faeb2bf798d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f9f5c0eacf0): FLUSH QUERY CACHE
Connection ID (thread ID): 1521975
Status: NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file
150921 18:41:08 mysqld_safe Number of processes running now: 0
150921 18:41:08 mysqld_safe mysqld restarted
2015-09-21 18:41:09 0 [Note] libgovernor.so found
2015-09-21 18:41:09 0 [Note] All governors functions found too
2015-09-21 18:41:09 0 [Note] Governor connected
2015-09-21 18:41:09 0 [Note] All governors lve functions found too
2015-09-21 18:41:09 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2015-09-21 18:41:09 0 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --slow-query-log is not set
2015-09-21 18:41:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-09-21 18:41:09 0 [Note] /usr/sbin/mysqld (mysqld 5.6.26-cll-lve) starting as process 868528 ...
2015-09-21 18:41:10 868528 [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-09-21 18:41:10 868528 [Note] Plugin 'FEDERATED' is disabled.
2015-09-21 18:41:10 868528 [Warning] option 'innodb-buffer-pool-instances': signed value 36507222016 adjusted to 64
2015-09-21 18:41:10 868528 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-09-21 18:41:10 868528 [Note] InnoDB: The InnoDB memory heap is disabled
2015-09-21 18:41:10 868528 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-09-21 18:41:10 868528 [Note] InnoDB: Memory barrier is not used
2015-09-21 18:41:10 868528 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-09-21 18:41:10 868528 [Note] InnoDB: Using Linux native AIO
2015-09-21 18:41:10 868528 [Note] InnoDB: Using CPU crc32 instructions
2015-09-21 18:41:10 868528 [Note] InnoDB: Initializing buffer pool, size = 34.0G
2015-09-21 18:41:12 868528 [Note] InnoDB: Completed initialization of buffer pool
2015-09-21 18:41:13 868528 [Note] InnoDB: Highest supported file format is Barracuda.
2015-09-21 18:41:13 868528 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1023787269208
2015-09-21 18:41:13 868528 [Note] InnoDB: Database was not shutdown normally!
2015-09-21 18:41:13 868528 [Note] InnoDB: Starting crash recovery.
2015-09-21 18:41:13 868528 [Note] InnoDB: Reading tablespace information from the .ibd files...
150921 18:41:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
2015-09-21 18:41:17 0 [Note] libgovernor.so found
2015-09-21 18:41:17 0 [Note] All governors functions found too
2015-09-21 18:41:17 0 [Note] Governor connected
2015-09-21 18:41:17 0 [Note] All governors lve functions found too
2015-09-21 18:41:17 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2015-09-21 18:41:17 0 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --slow-query-log is not set
2015-09-21 18:41:17 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-09-21 18:41:17 0 [Note] /usr/sbin/mysqld (mysqld 5.6.26-cll-lve) starting as process 869318 ...
2015-09-21 18:41:17 869318 [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-09-21 18:41:17 869318 [Note] Plugin 'FEDERATED' is disabled.
2015-09-21 18:41:17 869318 [Warning] option 'innodb-buffer-pool-instances': signed value 36507222016 adjusted to 64
2015-09-21 18:41:17 869318 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-09-21 18:41:17 869318 [Note] InnoDB: The InnoDB memory heap is disabled
2015-09-21 18:41:17 869318 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-09-21 18:41:17 869318 [Note] InnoDB: Memory barrier is not used
2015-09-21 18:41:17 869318 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-09-21 18:41:17 869318 [Note] InnoDB: Using Linux native AIO
2015-09-21 18:41:17 869318 [Note] InnoDB: Using CPU crc32 instructions
2015-09-21 18:41:17 869318 [Note] InnoDB: Initializing buffer pool, size = 34.0G
2015-09-21 18:41:19 869318 [Note] InnoDB: Completed initialization of buffer pool
2015-09-21 18:41:19 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:19 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:19 869318 [Note] InnoDB: Retrying to lock the first data file
2015-09-21 18:41:20 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:20 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:21 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:21 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:22 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:22 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:23 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:23 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:24 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:24 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:25 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:25 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:26 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:26 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:27 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:27 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:28 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:28 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:29 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:29 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:30 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:30 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:31 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:31 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:32 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:32 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:33 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:33 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:34 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:34 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:35 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:35 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:36 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:36 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:37 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:37 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:38 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:38 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:39 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:39 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:40 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:40 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:41 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:41 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:42 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:42 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:44 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:44 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:45 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:45 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:46 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:46 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:47 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:47 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:48 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:48 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:49 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:49 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:50 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:50 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:51 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:51 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:52 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:52 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:53 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:53 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:54 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:54 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:55 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:55 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:56 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:56 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:57 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:57 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:58 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:58 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:41:59 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:41:59 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:00 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:00 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:01 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:01 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:02 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:02 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:03 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:03 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:04 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:04 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:05 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:05 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:06 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:06 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:07 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:07 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:08 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:08 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:09 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:09 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:10 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:10 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:11 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:11 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:12 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:12 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:13 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:13 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:14 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:14 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:15 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:15 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:16 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:16 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:17 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:17 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:18 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:18 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:20 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:20 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:21 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:21 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:22 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:22 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:23 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:23 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:24 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:24 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:25 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:25 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:26 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:26 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:27 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:27 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:28 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:28 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:29 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:29 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:30 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:30 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:31 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:31 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:32 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:32 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:33 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:33 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:34 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:34 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:35 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:35 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:36 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:36 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:37 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:37 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:38 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:38 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:39 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:39 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:40 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:40 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:41 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:41 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:42 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:42 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:43 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:43 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:44 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:45 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:46 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:46 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:47 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:47 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:48 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:48 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:49 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:49 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:50 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:50 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:51 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:51 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:52 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:52 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:53 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:53 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:54 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:54 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:55 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:55 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:56 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:56 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:57 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:57 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:58 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:58 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:42:59 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:42:59 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:43:00 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:43:00 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:43:01 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:43:01 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:43:02 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-09-21 18:43:02 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-09-21 18:43:02 869318 [Note] InnoDB: Unable to open the first data file
2015-09-21 18:43:02 7f58017fc720 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2015-09-21 18:43:02 869318 [ERROR] InnoDB: Can't open './ibdata1'
2015-09-21 18:43:02 869318 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2015-09-21 18:43:02 869318 [ERROR] Plugin 'InnoDB' init function returned error.
2015-09-21 18:43:02 869318 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-09-21 18:43:02 869318 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-09-21 18:43:02 869318 [ERROR] Aborting
Code:
[mysql]
#port = 3306
#socket = /var/lib/mysql/mysql.sock
[mysqld]
core-file
#user = mysql
innodb_lock_wait_timeout=2000
default-storage-engine=InnoDB
#socket = /var/lib/mysql/mysql.sock
key-buffer-size=32M
myisam-recover="FORCE,BACKUP"
thread_concurrency=16
max-allowed-packet=16M
max-connect-errors=1000000
datadir="/var/lib/mysql/"
expire-logs-days=14
sync-binlog=1
tmp-table-size=32M
max-heap-table-size=32M
query-cache-type=1
query-cache-size=16G
max-connections=4000
thread-cache-size=150
open-files-limit=65535
table-definition-cache=4096
table-open-cache=1000
innodb-flush-method=O_DIRECT
innodb-log-files-in-group=2
innodb-log-file-size = 1G
innodb-flush-log-at-trx-commit=1
innodb-file-per-table=1
innodb-buffer-pool-size=34G
innodb_buffer_pool_instances=34G
log-queries-not-using-indexes=1
innodb_file_per_table=1
max_allowed_packet=536870912
open_files_limit=50000
#max_user_connections=30
[mysqld_safe]
core-file-size = unlimited
