Need help optimizing mysql config
I'd like some input on my mysql config, sites on my server are constantly getting a " Could Not connect to DB. DB connection closed . Can't connect to MySQL server on '127.0.0.1' (99)" error. :(
I have a Intel Xeon E5-1620 v2 with 64gb memory installed, Network connection of 1 Gbps running CentOS 6.5 with Whm/Cpanel. Most sites do not see a lot of traffic, use joomla mostly.
Here's my current my.cnf
Here's the mysqltuners output
Thanks :)
[mysqld]
slow-query-log=1
long_query_time=1
#symbolic-links=0
socket="/var/lib/mysql/mysql.sock"
user=mysql
default-storage-engine=MyISAM
log_queries_not_using_indexes=1
table_cache=1024
# MyISAM #
key_buffer_size=512M
myisam_recover="FORCE,BACKUP"
# SAFETY #
max_allowed_packet=268435456
max_connect_errors=1000000
# DATA STORAGE #
datadir="/var/lib/mysql/"
tmpdir="/tmp/mysql"
# CACHES AND LIMITS #
tmp_table_size=512M
max_heap_table_size=512M
query_cache_type=1
query_cache_size=256M
query_cache_limit=32M
max_connections=500
thread_cache_size=200
open_files_limit=65535
table_definition_cache=1024
table_open_cache=8000
wait_timeout=360
join_buffer_size=8M
sort_buffer_size=4M
read_rnd_buffer_size=4M
read_buffer_size=2M
# INNODB #
#innodb_flush_method = O_DIRECT
innodb_flush_method=O_DSYNC
innodb_log_files_in_group=2
innodb_log_file_size=256M
innodb_flush_log_at_trx_commit=0
innodb_file_per_table=1
innodb_buffer_pool_size=2G
myisam_sort_buffer_size=4M
[mysqld_safe]
log="/var/log/mysqld.log"
log-error="/var/log/mysqld.error.log"
general_log_file=/var/log/mysql-general.log
general_log=1
Here's the mysqltuners output
>> MySQLTuner 1.3.0 - Major Hayden
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
[OK] Currently running supported MySQL version 5.5.37-cll
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: 1G (Tables: 3499)
[--] Data in InnoDB tables: 844M (Tables: 441)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 0B (Tables: 35)
[!!] Total fragmented tables: 85
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 1d 16h 28m 40s (60M q [412.354 qps], 9M conn, TX: 20B, RX: 4B)
[--] Reads / Writes: 78% / 22%
[--] Total buffers: 3.3G global + 18.2M per thread (500 max threads)
[OK] Maximum possible memory usage: 12.2G (19% of installed RAM)
[OK] Slow queries: 0% (33K/60M)
[OK] Highest usage of available connections: 13% (66/500)
[OK] Key buffer size / total MyISAM indexes: 512.0M/188.2M
[OK] Key buffer hit rate: 99.9% (36M cached / 20K reads)
[OK] Query cache efficiency: 95.6% (9M cached / 10M selects)
[!!] Query cache prunes per day: 107299
[OK] Sorts requiring temporary tables: 0% (26 temp sorts / 94K sorts)
[!!] Joins performed without indexes: 2086
[!!] Temporary tables created on disk: 44% (61K on disk / 138K total)
[OK] Thread cache hit rate: 99% (66 created / 9M connections)
[OK] Table cache hit rate: 23% (4K open / 17K opened)
[OK] Open file limit used: 10% (7K/65K)
[OK] Table locks acquired immediately: 99% (788K immediate / 788K locks)
[OK] InnoDB buffer pool / data size: 2.0G/845.0M
[OK] InnoDB log waits: 0
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Increasing the query_cache size over 128M may reduce performance
Adjust your join queries to always utilize indexes
Temporary table size is already large - reduce result set size
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
query_cache_size (> 256M) [see warning above]
join_buffer_size (> 8.0M, or always use indexes with joins)
Thanks :)
-
Hello, Please post mysql log files out put. you get log file at below location : /var/lib/mysql/serverhostname.err 0 -
One issue that might be a problem, is that i recently switched hosts (about 4 months ago), earlier my server was located at pri.servername.com, but at switch we made it to servername.com. I'm not sure why but the log file was only there with name pri.servername.com.err not as servername.com.err, I have posted my variables output too for reference, please check, thanks. Here's my log files out put - 140527 16:37:26 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 16:42:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 16:42:18 [Note] Plugin 'FEDERATED' is disabled. 140527 16:42:18 InnoDB: The InnoDB memory heap is disabled 140527 16:42:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 16:42:18 InnoDB: Compressed tables use zlib 1.2.3 140527 16:42:18 InnoDB: Using Linux native AIO 140527 16:42:18 InnoDB: Initializing buffer pool, size = 128.0M 140527 16:42:18 InnoDB: Completed initialization of buffer pool 140527 16:42:18 InnoDB: highest supported file format is Barracuda. 140527 16:42:18 InnoDB: Waiting for the background threads to start 140527 16:42:19 InnoDB: 5.5.36 started; log sequence number 78583462 140527 16:42:19 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140527 16:42:19 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140527 16:42:19 [Note] Server socket created on IP: '0.0.0.0'. 140527 16:42:19 [Note] Event Scheduler: Loaded 0 events 140527 16:42:19 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.36-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 140527 16:42:26 [Note] /usr/sbin/mysqld: Normal shutdown 140527 16:42:26 [Note] Event Scheduler: Purging the queue. 0 events 140527 16:42:26 InnoDB: Starting shutdown... 140527 16:42:27 InnoDB: Shutdown completed; log sequence number 78583462 140527 16:42:27 [Note] /usr/sbin/mysqld: Shutdown complete 140527 16:42:27 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 16:42:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 16:42:27 [Note] Plugin 'FEDERATED' is disabled. 140527 16:42:27 InnoDB: The InnoDB memory heap is disabled 140527 16:42:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 16:42:27 InnoDB: Compressed tables use zlib 1.2.3 140527 16:42:27 InnoDB: Using Linux native AIO 140527 16:42:27 InnoDB: Initializing buffer pool, size = 128.0M 140527 16:42:27 InnoDB: Completed initialization of buffer pool 140527 16:42:27 InnoDB: highest supported file format is Barracuda. 140527 16:42:27 InnoDB: Waiting for the background threads to start 140527 16:42:28 InnoDB: 5.5.36 started; log sequence number 78583462 140527 16:42:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140527 16:42:28 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140527 16:42:28 [Note] Server socket created on IP: '0.0.0.0'. 140527 16:42:28 [Note] Event Scheduler: Loaded 0 events 140527 16:42:28 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.36-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 140527 16:42:50 [Note] /usr/sbin/mysqld: Normal shutdown 140527 16:42:50 [Note] Event Scheduler: Purging the queue. 0 events 140527 16:42:52 InnoDB: Starting shutdown... 140527 16:42:53 InnoDB: Shutdown completed; log sequence number 78583462 140527 16:42:53 [Note] /usr/sbin/mysqld: Shutdown complete 140527 16:42:53 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 16:59:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 16:59:56 [Note] Plugin 'FEDERATED' is disabled. 140527 16:59:56 InnoDB: The InnoDB memory heap is disabled 140527 16:59:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 16:59:56 InnoDB: Compressed tables use zlib 1.2.3 140527 16:59:56 InnoDB: Using Linux native AIO 140527 16:59:56 InnoDB: Initializing buffer pool, size = 128.0M 140527 16:59:56 InnoDB: Completed initialization of buffer pool InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 16:59:56 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:01:37 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 140527 17:01:37 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.5/en/operating-system-error-codes.html 140527 17:01:37 InnoDB: Could not open or create data files. 140527 17:01:37 InnoDB: If you tried to add new data files, and it failed here, 140527 17:01:37 InnoDB: you should now edit innodb_data_file_path in my.cnf back 140527 17:01:37 InnoDB: to what it was, and remove the new ibdata files InnoDB created 140527 17:01:37 InnoDB: in this failed attempt. InnoDB only wrote those files full of 140527 17:01:37 InnoDB: zeros, but did not yet use them in any way. But be careful: do not 140527 17:01:37 InnoDB: remove old data files which contain your precious data! 140527 17:01:37 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:01:37 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:01:37 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:01:37 [ERROR] Aborting 140527 17:01:37 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:01:37 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:02:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:02:36 [Note] Plugin 'FEDERATED' is disabled. 140527 17:02:36 InnoDB: The InnoDB memory heap is disabled 140527 17:02:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:02:36 InnoDB: Compressed tables use zlib 1.2.3 140527 17:02:36 InnoDB: Using Linux native AIO 140527 17:02:36 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:02:36 InnoDB: Completed initialization of buffer pool InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:02:36 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:02:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:02:59 [Note] Plugin 'FEDERATED' is disabled. 140527 17:02:59 InnoDB: The InnoDB memory heap is disabled 140527 17:02:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:02:59 InnoDB: Compressed tables use zlib 1.2.3 140527 17:02:59 InnoDB: Using Linux native AIO 140527 17:02:59 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:02:59 InnoDB: Completed initialization of buffer pool InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:02:59 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:04:16 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 140527 17:04:16 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.5/en/operating-system-error-codes.html 140527 17:04:16 InnoDB: Could not open or create data files. 140527 17:04:16 InnoDB: If you tried to add new data files, and it failed here, 140527 17:04:16 InnoDB: you should now edit innodb_data_file_path in my.cnf back 140527 17:04:16 InnoDB: to what it was, and remove the new ibdata files InnoDB created 140527 17:04:16 InnoDB: in this failed attempt. InnoDB only wrote those files full of 140527 17:04:16 InnoDB: zeros, but did not yet use them in any way. But be careful: do not 140527 17:04:16 InnoDB: remove old data files which contain your precious data! 140527 17:04:16 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:04:16 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:04:16 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:04:16 [ERROR] Aborting 140527 17:04:16 [Note] /usr/sbin/mysqld: Shutdown complete InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:04:40 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 140527 17:04:40 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.5/en/operating-system-error-codes.html 140527 17:04:40 InnoDB: Could not open or create data files. 140527 17:04:40 InnoDB: If you tried to add new data files, and it failed here, 140527 17:04:40 InnoDB: you should now edit innodb_data_file_path in my.cnf back 140527 17:04:40 InnoDB: to what it was, and remove the new ibdata files InnoDB created 140527 17:04:40 InnoDB: in this failed attempt. InnoDB only wrote those files full of 140527 17:04:40 InnoDB: zeros, but did not yet use them in any way. But be careful: do not 140527 17:04:40 InnoDB: remove old data files which contain your precious data! 140527 17:04:40 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:04:40 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:04:40 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:04:40 [ERROR] Aborting 140527 17:04:40 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:04:40 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:05:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:05:30 [Note] Plugin 'FEDERATED' is disabled. 140527 17:05:30 InnoDB: The InnoDB memory heap is disabled 140527 17:05:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:05:30 InnoDB: Compressed tables use zlib 1.2.3 140527 17:05:30 InnoDB: Using Linux native AIO 140527 17:05:30 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:05:30 InnoDB: Completed initialization of buffer pool InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:05:30 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:07:10 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 140527 17:07:10 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.5/en/operating-system-error-codes.html 140527 17:07:10 InnoDB: Could not open or create data files. 140527 17:07:10 InnoDB: If you tried to add new data files, and it failed here, 140527 17:07:10 InnoDB: you should now edit innodb_data_file_path in my.cnf back 140527 17:07:10 InnoDB: to what it was, and remove the new ibdata files InnoDB created 140527 17:07:10 InnoDB: in this failed attempt. InnoDB only wrote those files full of 140527 17:07:10 InnoDB: zeros, but did not yet use them in any way. But be careful: do not 140527 17:07:10 InnoDB: remove old data files which contain your precious data! 140527 17:07:10 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:07:10 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:07:10 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:07:10 [ERROR] Aborting 140527 17:07:10 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:35:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:35:26 [Note] Plugin 'FEDERATED' is disabled. 140527 17:35:26 InnoDB: The InnoDB memory heap is disabled 140527 17:35:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:35:26 InnoDB: Compressed tables use zlib 1.2.3 140527 17:35:26 InnoDB: Using Linux native AIO 140527 17:35:26 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:35:26 InnoDB: Completed initialization of buffer pool InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:35:26 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:36:57 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:36:57 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:36:57 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:36:57 [ERROR] Aborting 140527 17:36:57 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:36:57 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:37:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:37:05 [Note] Plugin 'FEDERATED' is disabled. 140527 17:37:05 InnoDB: The InnoDB memory heap is disabled 140527 17:37:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:37:05 InnoDB: Compressed tables use zlib 1.2.3 140527 17:37:05 InnoDB: Using Linux native AIO 140527 17:37:05 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:37:05 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:37:05 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:37:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:37:05 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:37:05 [ERROR] Aborting 140527 17:37:05 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:37:05 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:38:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:38:25 [Note] Plugin 'FEDERATED' is disabled. 140527 17:38:25 InnoDB: The InnoDB memory heap is disabled 140527 17:38:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:38:25 InnoDB: Compressed tables use zlib 1.2.3 140527 17:38:25 InnoDB: Using Linux native AIO 140527 17:38:25 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:38:25 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:38:25 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:38:25 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:38:25 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:38:25 [ERROR] Aborting 140527 17:38:25 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:38:25 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:38:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:38:49 [Note] Plugin 'FEDERATED' is disabled. 140527 17:38:49 InnoDB: The InnoDB memory heap is disabled 140527 17:38:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:38:49 InnoDB: Compressed tables use zlib 1.2.3 140527 17:38:49 InnoDB: Using Linux native AIO 140527 17:38:49 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:38:49 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:38:49 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:38:49 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:38:49 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:38:49 [ERROR] Aborting 140527 17:38:49 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:38:49 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:39:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:39:31 [Note] Plugin 'FEDERATED' is disabled. 140527 17:39:31 InnoDB: The InnoDB memory heap is disabled 140527 17:39:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:39:31 InnoDB: Compressed tables use zlib 1.2.3 140527 17:39:31 InnoDB: Using Linux native AIO 140527 17:39:31 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:39:31 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:39:31 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:39:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:39:31 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:39:31 [ERROR] Aborting 140527 17:39:31 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:39:31 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:39:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:39:44 [Note] Plugin 'FEDERATED' is disabled. 140527 17:39:44 InnoDB: The InnoDB memory heap is disabled 140527 17:39:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:39:44 InnoDB: Compressed tables use zlib 1.2.3 140527 17:39:44 InnoDB: Using Linux native AIO 140527 17:39:44 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:39:44 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:39:44 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:39:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:39:44 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:39:44 [ERROR] Aborting 140527 17:39:44 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:39:44 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:39:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:39:59 [Note] Plugin 'FEDERATED' is disabled. 140527 17:39:59 InnoDB: The InnoDB memory heap is disabled 140527 17:39:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:39:59 InnoDB: Compressed tables use zlib 1.2.3 140527 17:39:59 InnoDB: Using Linux native AIO 140527 17:39:59 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:39:59 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:39:59 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:39:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:39:59 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:39:59 [ERROR] Aborting 140527 17:39:59 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:39:59 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:41:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:41:00 [Note] Plugin 'FEDERATED' is disabled. 140527 17:41:00 InnoDB: The InnoDB memory heap is disabled 140527 17:41:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:41:00 InnoDB: Compressed tables use zlib 1.2.3 140527 17:41:00 InnoDB: Using Linux native AIO 140527 17:41:00 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:41:00 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:41:00 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:41:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:41:00 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:41:00 [ERROR] Aborting 140527 17:41:00 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:41:00 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:46:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:46:27 [Note] Plugin 'FEDERATED' is disabled. 140527 17:46:27 InnoDB: The InnoDB memory heap is disabled 140527 17:46:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:46:27 InnoDB: Compressed tables use zlib 1.2.3 140527 17:46:27 InnoDB: Using Linux native AIO 140527 17:46:27 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:46:27 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:46:27 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:46:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:46:27 [ERROR] /usr/sbin/mysqld: unknown variable 'storage_engine=MYISAM' 140527 17:46:27 [ERROR] Aborting 140527 17:46:27 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:46:27 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:47:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:47:06 [Note] Plugin 'FEDERATED' is disabled. 140527 17:47:06 InnoDB: The InnoDB memory heap is disabled 140527 17:47:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:47:06 InnoDB: Compressed tables use zlib 1.2.3 140527 17:47:06 InnoDB: Using Linux native AIO 140527 17:47:06 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:47:06 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:47:06 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:47:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:47:06 [ERROR] /usr/sbin/mysqld: unknown variable 'storage_engine=MYISAM' 140527 17:47:06 [ERROR] Aborting 140527 17:47:06 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:47:06 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:34:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:34:49 [Note] Plugin 'FEDERATED' is disabled. 140527 20:34:49 InnoDB: The InnoDB memory heap is disabled 140527 20:34:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:34:49 InnoDB: Compressed tables use zlib 1.2.3 140527 20:34:49 InnoDB: Using Linux native AIO 140527 20:34:49 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:34:49 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 268435456 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:34:49 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:34:49 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:34:49 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 20:34:49 [ERROR] Aborting 140527 20:34:49 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:34:49 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:46:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:46:28 [Note] Plugin 'FEDERATED' is disabled. 140527 20:46:28 InnoDB: The InnoDB memory heap is disabled 140527 20:46:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:46:28 InnoDB: Compressed tables use zlib 1.2.3 140527 20:46:28 InnoDB: Using Linux native AIO 140527 20:46:28 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:46:28 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 268435456 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:46:28 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:46:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:46:28 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 20:46:28 [ERROR] Aborting 140527 20:46:28 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:46:28 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:48:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:48:42 [Note] Plugin 'FEDERATED' is disabled. 140527 20:48:42 InnoDB: The InnoDB memory heap is disabled 140527 20:48:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:48:42 InnoDB: Compressed tables use zlib 1.2.3 140527 20:48:42 InnoDB: Using Linux native AIO 140527 20:48:42 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:48:42 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 268435456 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:48:42 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:48:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:48:42 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 20:48:42 [ERROR] Aborting 140527 20:48:42 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:48:42 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:50:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:50:00 [Note] Plugin 'FEDERATED' is disabled. 140527 20:50:00 InnoDB: The InnoDB memory heap is disabled 140527 20:50:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:50:00 InnoDB: Compressed tables use zlib 1.2.3 140527 20:50:00 InnoDB: Using Linux native AIO 140527 20:50:00 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:50:00 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:50:00 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:50:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:50:00 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 20:50:00 [ERROR] Aborting 140527 20:50:00 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:50:01 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:51:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:51:55 [Note] Plugin 'FEDERATED' is disabled. 140527 20:51:55 InnoDB: The InnoDB memory heap is disabled 140527 20:51:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:51:55 InnoDB: Compressed tables use zlib 1.2.3 140527 20:51:55 InnoDB: Using Linux native AIO 140527 20:51:55 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:51:55 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:51:55 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:51:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:51:55 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 20:51:55 [ERROR] Aborting 140527 20:51:55 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:51:55 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:53:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:53:26 [Note] Plugin 'FEDERATED' is disabled. 140527 20:53:26 InnoDB: The InnoDB memory heap is disabled 140527 20:53:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:53:26 InnoDB: Compressed tables use zlib 1.2.3 140527 20:53:26 InnoDB: Using Linux native AIO 140527 20:53:26 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:53:26 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:53:26 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:53:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:53:26 [ERROR] /usr/sbin/mysqld: unknown variable 'error-log=/var/log/mysql.error.log' 140527 20:53:26 [ERROR] Aborting 140527 20:53:26 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:53:26 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:55:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:55:02 [Note] Plugin 'FEDERATED' is disabled. 140527 20:55:02 InnoDB: The InnoDB memory heap is disabled 140527 20:55:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:55:02 InnoDB: Compressed tables use zlib 1.2.3 140527 20:55:02 InnoDB: Using Linux native AIO 140527 20:55:02 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:55:02 InnoDB: Completed initialization of buffer pool 140527 20:55:02 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 140527 20:55:02 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... 140527 20:55:02 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140527 20:55:02 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140527 20:55:02 InnoDB: Waiting for the background threads to start 140527 20:55:03 InnoDB: 5.5.36 started; log sequence number 112145932 140527 20:55:03 [ERROR] /usr/sbin/mysqld: unknown variable 'error-log=/var/log/mysql.error.log' 140527 20:55:03 [ERROR] Aborting 140527 20:55:03 InnoDB: Starting shutdown... 140527 20:55:04 InnoDB: Shutdown completed; log sequence number 112145932 140527 20:55:04 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:55:04 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended0 -
Here's my variable file's output Variables (--variable-name=value) and boolean options {FALSE|TRUE} Value (after reading options) ------------------------------------------------- ------------------------ abort-slave-event-count 0 allow-suspicious-udfs FALSE archive ON auto-increment-increment 1 auto-increment-offset 1 autocommit TRUE automatic-sp-privileges TRUE back-log 50 basedir /usr/ big-tables FALSE bind-address (No default value) binlog-cache-size 32768 binlog-direct-non-transactional-updates FALSE binlog-format STATEMENT binlog-row-event-max-size 1024 binlog-stmt-cache-size 32768 blackhole ON bulk-insert-buffer-size 8388608 character-set-client-handshake TRUE character-set-filesystem binary character-set-server latin1 character-sets-dir /usr/share/mysql/charsets/ chroot (No default value) collation-server latin1_swedish_ci completion-type NO_CHAIN concurrent-insert AUTO connect-timeout 10 console FALSE datadir /var/lib/mysql/ date-format %Y-%m-%d datetime-format %Y-%m-%d %H:%i:%s default-storage-engine InnoDB default-time-zone (No default value) default-week-format 0 delay-key-write ON delayed-insert-limit 100 delayed-insert-timeout 300 delayed-queue-size 1000 des-key-file (No default value) disconnect-slave-event-count 0 div-precision-increment 4 engine-condition-pushdown TRUE event-scheduler OFF expire-logs-days 0 external-locking FALSE federated ON flush FALSE flush-time 0 ft-boolean-syntax + -><()~*:""&| ft-max-word-len 84 ft-min-word-len 4 ft-query-expansion-limit 20 ft-stopword-file (No default value) gdb FALSE general-log FALSE general-log-file /var/lib/mysql/servername.log group-concat-max-len 1024 help TRUE ignore-builtin-innodb FALSE init-connect init-file (No default value) init-rpl-role MASTER init-slave innodb ON innodb-adaptive-flushing TRUE innodb-adaptive-hash-index TRUE innodb-additional-mem-pool-size 8388608 innodb-autoextend-increment 8 innodb-autoinc-lock-mode 1 innodb-buffer-page ON innodb-buffer-page-lru ON innodb-buffer-pool-instances 1 innodb-buffer-pool-size 134217728 innodb-buffer-pool-stats ON innodb-change-buffering all innodb-checksums TRUE innodb-cmp ON innodb-cmp-reset ON innodb-cmpmem ON innodb-cmpmem-reset ON innodb-commit-concurrency 0 innodb-concurrency-tickets 500 innodb-data-file-path (No default value) innodb-data-home-dir (No default value) innodb-doublewrite TRUE innodb-fast-shutdown 1 innodb-file-format Antelope innodb-file-format-check TRUE innodb-file-format-max Antelope innodb-file-io-threads 4 innodb-file-per-table FALSE innodb-flush-log-at-trx-commit 1 innodb-flush-method (No default value) innodb-force-load-corrupted FALSE innodb-force-recovery 0 innodb-io-capacity 200 innodb-large-prefix FALSE innodb-lock-wait-timeout 50 innodb-lock-waits ON innodb-locks ON innodb-locks-unsafe-for-binlog FALSE innodb-log-buffer-size 8388608 innodb-log-file-size 5242880 innodb-log-files-in-group 2 innodb-log-group-home-dir (No default value) innodb-max-dirty-pages-pct 75 innodb-max-purge-lag 0 innodb-mirrored-log-groups 1 innodb-old-blocks-pct 37 innodb-old-blocks-time 0 innodb-open-files 300 innodb-print-all-deadlocks FALSE innodb-purge-batch-size 20 innodb-purge-threads 0 innodb-random-read-ahead FALSE innodb-read-ahead-threshold 56 innodb-read-io-threads 4 innodb-replication-delay 0 innodb-rollback-on-timeout FALSE innodb-rollback-segments 128 innodb-spin-wait-delay 6 innodb-stats-method nulls_equal innodb-stats-on-metadata TRUE innodb-stats-sample-pages 8 innodb-status-file FALSE innodb-strict-mode FALSE innodb-support-xa TRUE innodb-sync-spin-loops 30 innodb-table-locks TRUE innodb-thread-concurrency 0 innodb-thread-sleep-delay 10000 innodb-trx ON innodb-use-native-aio TRUE innodb-use-sys-malloc TRUE innodb-write-io-threads 4 interactive-timeout 28800 join-buffer-size 131072 keep-files-on-create FALSE key-buffer-size 8388608 key-cache-age-threshold 300 key-cache-block-size 1024 key-cache-division-limit 100 language /usr/share/mysql/ large-pages FALSE lc-messages en_US lc-messages-dir /usr/share/mysql/ lc-time-names en_US local-infile TRUE lock-wait-timeout 31536000 log /var/lib/mysql/servername.log log-bin (No default value) log-bin-index (No default value) log-bin-trust-function-creators FALSE log-error log-isam myisam.log log-output FILE log-queries-not-using-indexes FALSE log-short-format FALSE log-slave-updates FALSE log-slow-admin-statements FALSE log-slow-queries /var/lib/mysql/servername-slow.log log-slow-slave-statements FALSE log-tc tc.log log-tc-size 24576 log-warnings 1 long-query-time 10 low-priority-updates FALSE lower-case-table-names 0 master-info-file master.info master-retry-count 86400 max-allowed-packet 1048576 max-binlog-cache-size 18446744073709547520 max-binlog-dump-events 0 max-binlog-size 1073741824 max-binlog-stmt-cache-size 18446744073709547520 max-connect-errors 10 max-connections 151 max-delayed-threads 20 max-error-count 64 max-heap-table-size 16777216 max-join-size 18446744073709551615 max-length-for-sort-data 1024 max-long-data-size 1048576 max-prepared-stmt-count 16382 max-relay-log-size 0 max-seeks-for-key 18446744073709551615 max-sort-length 1024 max-sp-recursion-depth 0 max-tmp-tables 32 max-user-connections 0 max-write-lock-count 18446744073709551615 memlock FALSE metadata-locks-cache-size 1024 min-examined-row-limit 0 multi-range-count 256 myisam-block-size 1024 myisam-data-pointer-size 6 myisam-max-sort-file-size 9223372036853727232 myisam-mmap-size 18446744073709551615 myisam-recover-options OFF myisam-repair-threads 1 myisam-sort-buffer-size 8388608 myisam-stats-method nulls_unequal myisam-use-mmap FALSE net-buffer-length 16384 net-read-timeout 30 net-retry-count 10 net-write-timeout 60 new FALSE old FALSE old-alter-table FALSE old-passwords FALSE old-style-user-limits FALSE open-files-limit 1024 optimizer-prune-level 1 optimizer-search-depth 62 optimizer-switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on partition ON performance-schema FALSE performance-schema-events-waits-history-long-size 10000 performance-schema-events-waits-history-size 10 performance-schema-max-cond-classes 80 performance-schema-max-cond-instances 1000 performance-schema-max-file-classes 50 performance-schema-max-file-handles 32768 performance-schema-max-file-instances 10000 performance-schema-max-mutex-classes 200 performance-schema-max-mutex-instances 1000000 performance-schema-max-rwlock-classes 30 performance-schema-max-rwlock-instances 1000000 performance-schema-max-table-handles 100000 performance-schema-max-table-instances 50000 performance-schema-max-thread-classes 50 performance-schema-max-thread-instances 1000 pid-file /var/lib/mysql/servername.pid plugin-dir /usr/lib64/mysql/plugin/ plugin-load (No default value) port 3306 port-open-timeout 0 preload-buffer-size 32768 profiling-history-size 15 query-alloc-block-size 8192 query-cache-limit 1048576 query-cache-min-res-unit 4096 query-cache-size 0 query-cache-type ON query-cache-wlock-invalidate FALSE query-prealloc-size 8192 range-alloc-block-size 4096 read-buffer-size 131072 read-only FALSE read-rnd-buffer-size 262144 relay-log (No default value) relay-log-index (No default value) relay-log-info-file relay-log.info relay-log-purge TRUE relay-log-recovery FALSE relay-log-space-limit 0 replicate-same-server-id FALSE report-host (No default value) report-password (No default value) report-port 0 report-user (No default value) rpl-recovery-rank 0 safe-user-create FALSE secure-auth FALSE secure-file-priv (No default value) server-id 0 show-slave-auth-info FALSE skip-grant-tables FALSE skip-name-resolve FALSE skip-networking FALSE skip-show-database FALSE skip-slave-start FALSE slave-compressed-protocol FALSE slave-exec-mode STRICT slave-load-tmpdir /tmp slave-max-allowed-packet 1073741824 slave-net-timeout 3600 slave-skip-errors (No default value) slave-transaction-retries 10 slave-type-conversions slow-launch-time 2 slow-query-log FALSE slow-query-log-file /var/lib/mysql/servername-slow.log socket /var/lib/mysql/mysql.sock sort-buffer-size 2097152 sporadic-binlog-dump-fail FALSE sql-mode ssl FALSE ssl-ca (No default value) ssl-capath (No default value) ssl-cert (No default value) ssl-cipher (No default value) ssl-key (No default value) stored-program-cache 256 super-large-pages FALSE symbolic-links TRUE sync-binlog 0 sync-frm TRUE sync-master-info 0 sync-relay-log 0 sync-relay-log-info 0 sysdate-is-now FALSE table-cache 400 table-definition-cache 400 table-open-cache 400 tc-heuristic-recover COMMIT temp-pool TRUE thread-cache-size 0 thread-concurrency 10 thread-handling one-thread-per-connection thread-stack 262144 thread-statistics FALSE time-format %H:%i:%s timed-mutexes FALSE tmp-table-size 16777216 tmpdir /tmp transaction-alloc-block-size 8192 transaction-isolation REPEATABLE-READ transaction-prealloc-size 4096 updatable-views-with-limit YES userstat FALSE verbose TRUE wait-timeout 28800
[COLOR="silver">- - - Updated - - - One issue i noticed is that there was no servername.err file, there was a pri.servername.err file which i have posted. We moved servers about 4 months ago, and earlier we had pri.servername.com, but after move, we moved it to servername.com, maybe that might be causing trouble, i have posted our mysql variables list too.140527 16:37:26 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 16:42:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 16:42:18 [Note] Plugin 'FEDERATED' is disabled. 140527 16:42:18 InnoDB: The InnoDB memory heap is disabled 140527 16:42:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 16:42:18 InnoDB: Compressed tables use zlib 1.2.3 140527 16:42:18 InnoDB: Using Linux native AIO 140527 16:42:18 InnoDB: Initializing buffer pool, size = 128.0M 140527 16:42:18 InnoDB: Completed initialization of buffer pool 140527 16:42:18 InnoDB: highest supported file format is Barracuda. 140527 16:42:18 InnoDB: Waiting for the background threads to start 140527 16:42:19 InnoDB: 5.5.36 started; log sequence number 78583462 140527 16:42:19 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140527 16:42:19 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140527 16:42:19 [Note] Server socket created on IP: '0.0.0.0'. 140527 16:42:19 [Note] Event Scheduler: Loaded 0 events 140527 16:42:19 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.36-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 140527 16:42:26 [Note] /usr/sbin/mysqld: Normal shutdown 140527 16:42:26 [Note] Event Scheduler: Purging the queue. 0 events 140527 16:42:26 InnoDB: Starting shutdown... 140527 16:42:27 InnoDB: Shutdown completed; log sequence number 78583462 140527 16:42:27 [Note] /usr/sbin/mysqld: Shutdown complete 140527 16:42:27 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 16:42:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 16:42:27 [Note] Plugin 'FEDERATED' is disabled. 140527 16:42:27 InnoDB: The InnoDB memory heap is disabled 140527 16:42:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 16:42:27 InnoDB: Compressed tables use zlib 1.2.3 140527 16:42:27 InnoDB: Using Linux native AIO 140527 16:42:27 InnoDB: Initializing buffer pool, size = 128.0M 140527 16:42:27 InnoDB: Completed initialization of buffer pool 140527 16:42:27 InnoDB: highest supported file format is Barracuda. 140527 16:42:27 InnoDB: Waiting for the background threads to start 140527 16:42:28 InnoDB: 5.5.36 started; log sequence number 78583462 140527 16:42:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 140527 16:42:28 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 140527 16:42:28 [Note] Server socket created on IP: '0.0.0.0'. 140527 16:42:28 [Note] Event Scheduler: Loaded 0 events 140527 16:42:28 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.36-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 140527 16:42:50 [Note] /usr/sbin/mysqld: Normal shutdown 140527 16:42:50 [Note] Event Scheduler: Purging the queue. 0 events 140527 16:42:52 InnoDB: Starting shutdown... 140527 16:42:53 InnoDB: Shutdown completed; log sequence number 78583462 140527 16:42:53 [Note] /usr/sbin/mysqld: Shutdown complete 140527 16:42:53 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 16:59:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 16:59:56 [Note] Plugin 'FEDERATED' is disabled. 140527 16:59:56 InnoDB: The InnoDB memory heap is disabled 140527 16:59:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 16:59:56 InnoDB: Compressed tables use zlib 1.2.3 140527 16:59:56 InnoDB: Using Linux native AIO 140527 16:59:56 InnoDB: Initializing buffer pool, size = 128.0M 140527 16:59:56 InnoDB: Completed initialization of buffer pool InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 16:59:56 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:01:37 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 140527 17:01:37 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.5/en/operating-system-error-codes.html 140527 17:01:37 InnoDB: Could not open or create data files. 140527 17:01:37 InnoDB: If you tried to add new data files, and it failed here, 140527 17:01:37 InnoDB: you should now edit innodb_data_file_path in my.cnf back 140527 17:01:37 InnoDB: to what it was, and remove the new ibdata files InnoDB created 140527 17:01:37 InnoDB: in this failed attempt. InnoDB only wrote those files full of 140527 17:01:37 InnoDB: zeros, but did not yet use them in any way. But be careful: do not 140527 17:01:37 InnoDB: remove old data files which contain your precious data! 140527 17:01:37 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:01:37 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:01:37 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:01:37 [ERROR] Aborting 140527 17:01:37 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:01:37 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:02:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:02:36 [Note] Plugin 'FEDERATED' is disabled. 140527 17:02:36 InnoDB: The InnoDB memory heap is disabled 140527 17:02:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:02:36 InnoDB: Compressed tables use zlib 1.2.3 140527 17:02:36 InnoDB: Using Linux native AIO 140527 17:02:36 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:02:36 InnoDB: Completed initialization of buffer pool InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:02:36 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:02:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:02:59 [Note] Plugin 'FEDERATED' is disabled. 140527 17:02:59 InnoDB: The InnoDB memory heap is disabled 140527 17:02:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:02:59 InnoDB: Compressed tables use zlib 1.2.3 140527 17:02:59 InnoDB: Using Linux native AIO 140527 17:02:59 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:02:59 InnoDB: Completed initialization of buffer pool InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:02:59 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:04:16 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 140527 17:04:16 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.5/en/operating-system-error-codes.html 140527 17:04:16 InnoDB: Could not open or create data files. 140527 17:04:16 InnoDB: If you tried to add new data files, and it failed here, 140527 17:04:16 InnoDB: you should now edit innodb_data_file_path in my.cnf back 140527 17:04:16 InnoDB: to what it was, and remove the new ibdata files InnoDB created 140527 17:04:16 InnoDB: in this failed attempt. InnoDB only wrote those files full of 140527 17:04:16 InnoDB: zeros, but did not yet use them in any way. But be careful: do not 140527 17:04:16 InnoDB: remove old data files which contain your precious data! 140527 17:04:16 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:04:16 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:04:16 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:04:16 [ERROR] Aborting 140527 17:04:16 [Note] /usr/sbin/mysqld: Shutdown complete InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:04:40 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 140527 17:04:40 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.5/en/operating-system-error-codes.html 140527 17:04:40 InnoDB: Could not open or create data files. 140527 17:04:40 InnoDB: If you tried to add new data files, and it failed here, 140527 17:04:40 InnoDB: you should now edit innodb_data_file_path in my.cnf back 140527 17:04:40 InnoDB: to what it was, and remove the new ibdata files InnoDB created 140527 17:04:40 InnoDB: in this failed attempt. InnoDB only wrote those files full of 140527 17:04:40 InnoDB: zeros, but did not yet use them in any way. But be careful: do not 140527 17:04:40 InnoDB: remove old data files which contain your precious data! 140527 17:04:40 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:04:40 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:04:40 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:04:40 [ERROR] Aborting 140527 17:04:40 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:04:40 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:05:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:05:30 [Note] Plugin 'FEDERATED' is disabled. 140527 17:05:30 InnoDB: The InnoDB memory heap is disabled 140527 17:05:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:05:30 InnoDB: Compressed tables use zlib 1.2.3 140527 17:05:30 InnoDB: Using Linux native AIO 140527 17:05:30 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:05:30 InnoDB: Completed initialization of buffer pool InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 140527 17:05:30 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 ....(removing some repetitive queries to fit post limit) InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:36:57 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:36:57 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:36:57 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:36:57 [ERROR] Aborting 140527 17:36:57 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:36:57 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:37:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:37:05 [Note] Plugin 'FEDERATED' is disabled. 140527 17:37:05 InnoDB: The InnoDB memory heap is disabled 140527 17:37:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:37:05 InnoDB: Compressed tables use zlib 1.2.3 140527 17:37:05 InnoDB: Using Linux native AIO 140527 17:37:05 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:37:05 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:37:05 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:37:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:37:05 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:37:05 [ERROR] Aborting 140527 17:37:05 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:37:05 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:38:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:38:25 [Note] Plugin 'FEDERATED' is disabled. 140527 17:38:25 InnoDB: The InnoDB memory heap is disabled 140527 17:38:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:38:25 InnoDB: Compressed tables use zlib 1.2.3 140527 17:38:25 InnoDB: Using Linux native AIO 140527 17:38:25 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:38:25 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:38:25 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:38:25 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:38:25 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:38:25 [ERROR] Aborting 140527 17:38:25 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:38:25 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:38:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:38:49 [Note] Plugin 'FEDERATED' is disabled. 140527 17:38:49 InnoDB: The InnoDB memory heap is disabled 140527 17:38:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:38:49 InnoDB: Compressed tables use zlib 1.2.3 140527 17:38:49 InnoDB: Using Linux native AIO 140527 17:38:49 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:38:49 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:38:49 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:38:49 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:38:49 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:38:49 [ERROR] Aborting 140527 17:38:49 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:38:49 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:39:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:39:31 [Note] Plugin 'FEDERATED' is disabled. 140527 17:39:31 InnoDB: The InnoDB memory heap is disabled 140527 17:39:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:39:31 InnoDB: Compressed tables use zlib 1.2.3 140527 17:39:31 InnoDB: Using Linux native AIO 140527 17:39:31 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:39:31 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:39:31 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:39:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:39:31 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:39:31 [ERROR] Aborting 140527 17:39:31 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:39:31 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:39:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:39:44 [Note] Plugin 'FEDERATED' is disabled. 140527 17:39:44 InnoDB: The InnoDB memory heap is disabled 140527 17:39:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:39:44 InnoDB: Compressed tables use zlib 1.2.3 140527 17:39:44 InnoDB: Using Linux native AIO 140527 17:39:44 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:39:44 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:39:44 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:39:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:39:44 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:39:44 [ERROR] Aborting 140527 17:39:44 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:39:44 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:39:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:39:59 [Note] Plugin 'FEDERATED' is disabled. 140527 17:39:59 InnoDB: The InnoDB memory heap is disabled 140527 17:39:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:39:59 InnoDB: Compressed tables use zlib 1.2.3 140527 17:39:59 InnoDB: Using Linux native AIO 140527 17:39:59 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:39:59 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:39:59 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:39:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:39:59 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:39:59 [ERROR] Aborting 140527 17:39:59 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:39:59 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:41:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:41:00 [Note] Plugin 'FEDERATED' is disabled. 140527 17:41:00 InnoDB: The InnoDB memory heap is disabled 140527 17:41:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:41:00 InnoDB: Compressed tables use zlib 1.2.3 140527 17:41:00 InnoDB: Using Linux native AIO 140527 17:41:00 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:41:00 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:41:00 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:41:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:41:00 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 17:41:00 [ERROR] Aborting 140527 17:41:00 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:41:00 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:46:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:46:27 [Note] Plugin 'FEDERATED' is disabled. 140527 17:46:27 InnoDB: The InnoDB memory heap is disabled 140527 17:46:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:46:27 InnoDB: Compressed tables use zlib 1.2.3 140527 17:46:27 InnoDB: Using Linux native AIO 140527 17:46:27 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:46:27 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:46:27 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:46:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:46:27 [ERROR] /usr/sbin/mysqld: unknown variable 'storage_engine=MYISAM' 140527 17:46:27 [ERROR] Aborting 140527 17:46:27 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:46:27 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 17:47:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 17:47:06 [Note] Plugin 'FEDERATED' is disabled. 140527 17:47:06 InnoDB: The InnoDB memory heap is disabled 140527 17:47:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 17:47:06 InnoDB: Compressed tables use zlib 1.2.3 140527 17:47:06 InnoDB: Using Linux native AIO 140527 17:47:06 InnoDB: Initializing buffer pool, size = 128.0M 140527 17:47:06 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 17:47:06 [ERROR] Plugin 'InnoDB' init function returned error. 140527 17:47:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 17:47:06 [ERROR] /usr/sbin/mysqld: unknown variable 'storage_engine=MYISAM' 140527 17:47:06 [ERROR] Aborting 140527 17:47:06 [Note] /usr/sbin/mysqld: Shutdown complete 140527 17:47:06 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:34:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:34:49 [Note] Plugin 'FEDERATED' is disabled. 140527 20:34:49 InnoDB: The InnoDB memory heap is disabled 140527 20:34:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:34:49 InnoDB: Compressed tables use zlib 1.2.3 140527 20:34:49 InnoDB: Using Linux native AIO 140527 20:34:49 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:34:49 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 268435456 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:34:49 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:34:49 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:34:49 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 20:34:49 [ERROR] Aborting 140527 20:34:49 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:34:49 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:46:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:46:28 [Note] Plugin 'FEDERATED' is disabled. 140527 20:46:28 InnoDB: The InnoDB memory heap is disabled 140527 20:46:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:46:28 InnoDB: Compressed tables use zlib 1.2.3 140527 20:46:28 InnoDB: Using Linux native AIO 140527 20:46:28 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:46:28 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 268435456 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:46:28 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:46:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:46:28 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 20:46:28 [ERROR] Aborting 140527 20:46:28 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:46:28 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:48:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:48:42 [Note] Plugin 'FEDERATED' is disabled. 140527 20:48:42 InnoDB: The InnoDB memory heap is disabled 140527 20:48:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:48:42 InnoDB: Compressed tables use zlib 1.2.3 140527 20:48:42 InnoDB: Using Linux native AIO 140527 20:48:42 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:48:42 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 268435456 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:48:42 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:48:42 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:48:42 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 20:48:42 [ERROR] Aborting 140527 20:48:42 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:48:42 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:50:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:50:00 [Note] Plugin 'FEDERATED' is disabled. 140527 20:50:00 InnoDB: The InnoDB memory heap is disabled 140527 20:50:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:50:00 InnoDB: Compressed tables use zlib 1.2.3 140527 20:50:00 InnoDB: Using Linux native AIO 140527 20:50:00 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:50:00 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:50:00 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:50:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:50:00 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 20:50:00 [ERROR] Aborting 140527 20:50:00 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:50:01 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:51:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:51:55 [Note] Plugin 'FEDERATED' is disabled. 140527 20:51:55 InnoDB: The InnoDB memory heap is disabled 140527 20:51:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:51:55 InnoDB: Compressed tables use zlib 1.2.3 140527 20:51:55 InnoDB: Using Linux native AIO 140527 20:51:55 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:51:55 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:51:55 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:51:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:51:55 [ERROR] Unknown/unsupported storage engine: InnoDB 140527 20:51:55 [ERROR] Aborting 140527 20:51:55 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:51:55 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:53:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:53:26 [Note] Plugin 'FEDERATED' is disabled. 140527 20:53:26 InnoDB: The InnoDB memory heap is disabled 140527 20:53:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:53:26 InnoDB: Compressed tables use zlib 1.2.3 140527 20:53:26 InnoDB: Using Linux native AIO 140527 20:53:26 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:53:26 InnoDB: Completed initialization of buffer pool InnoDB: Error: log file ./ib_logfile0 is of different size 0 67108864 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 140527 20:53:26 [ERROR] Plugin 'InnoDB' init function returned error. 140527 20:53:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 140527 20:53:26 [ERROR] /usr/sbin/mysqld: unknown variable 'error-log=/var/log/mysql.error.log' 140527 20:53:26 [ERROR] Aborting 140527 20:53:26 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:53:26 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended 140527 20:55:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140527 20:55:02 [Note] Plugin 'FEDERATED' is disabled. 140527 20:55:02 InnoDB: The InnoDB memory heap is disabled 140527 20:55:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140527 20:55:02 InnoDB: Compressed tables use zlib 1.2.3 140527 20:55:02 InnoDB: Using Linux native AIO 140527 20:55:02 InnoDB: Initializing buffer pool, size = 128.0M 140527 20:55:02 InnoDB: Completed initialization of buffer pool 140527 20:55:02 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 140527 20:55:02 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... 140527 20:55:02 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140527 20:55:02 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140527 20:55:02 InnoDB: Waiting for the background threads to start 140527 20:55:03 InnoDB: 5.5.36 started; log sequence number 112145932 140527 20:55:03 [ERROR] /usr/sbin/mysqld: unknown variable 'error-log=/var/log/mysql.error.log' 140527 20:55:03 [ERROR] Aborting 140527 20:55:03 InnoDB: Starting shutdown... 140527 20:55:04 InnoDB: Shutdown completed; log sequence number 112145932 140527 20:55:04 [Note] /usr/sbin/mysqld: Shutdown complete 140527 20:55:04 mysqld_safe mysqld from pid file /var/lib/mysql/pri.servername.com.pid ended0 -
Hello :) The following thread might be helpful based on some of the InnoDB output in your MySQL error log: InnoDB Repair Guide Thank you. 0 -
Thanks here's my df -h log, i am follwing up on the leads posted here rootfs 20G 19G 284M 99% / /dev/root 20G 19G 284M 99% / devtmpfs 32G 276K 32G 1% /dev /dev/md2 202G 66G 126G 35% /home tmpfs 32G 0 32G 0% /dev/shm /dev/sdc1 1.8T 177G 1.6T 11% /home2 /dev/sdd1 1.8T 287G 1.5T 17% /backup tmpfs 32G 0 32G 0% /tmp/mysql /dev/root 20G 19G 284M 99% /var/tmp /dev/root 20G 19G 284M 99% /var/named/chroot/etc/named /dev/root 20G 19G 284M 99% /var/named/chroot/etc/named.rfc1912.zones /dev/root 20G 19G 284M 99% /var/named/chroot/etc/rndc.key /dev/root 20G 19G 284M 99% /var/named/chroot/usr/lib64/bind /dev/root 20G 19G 284M 99% /var/named/chroot/etc/named.iscdlv.key /dev/root 20G 19G 284M 99% /var/named/chroot/etc/named.root.key0 -
Hello, Your server temp directory almost full. You need to clear you /var/tmp directory. Please remove unwanted files and directory. You can see sess_##### files please remove those files to free the space. After removing this please restart the mysql service. Thanks :) 0
Please sign in to leave a comment.
Comments
7 comments