## Packages used ushastry@ubuntu32:/dos$ ls -l *.tar* -rwxrwxrwx 1 ushastry ushastry 584816640 Jun 18 19:02 mysql-5.5.44-linux2.6-i686.tar -rwxrwxrwx 1 ushastry ushastry 303798958 Jun 18 19:06 mysql-5.6.25-linux-glibc2.5-i686.tar.gz ushastry@ubuntu32:/dos$ cat /etc/*release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=14.04 DISTRIB_CODENAME=trusty DISTRIB_DESCRIPTION="Ubuntu 14.04.2 LTS" NAME="Ubuntu" VERSION="14.04.2 LTS, Trusty Tahr" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu 14.04.2 LTS" VERSION_ID="14.04" HOME_URL="http://www.ubuntu.com/" SUPPORT_URL="http://help.ubuntu.com/" BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/" ushastry@ubuntu32:/dos$ ushastry@ubuntu32:/dos$ uname -an Linux ubuntu32 3.16.0-30-generic #40~14.04.1-Ubuntu SMP Thu Jan 15 17:45:15 UTC 2015 i686 i686 i686 GNU/Linux ushastry@ubuntu32:/dos$ ## vfat file system used to reproduce(4G file size limit) ushastry@ubuntu32:/dos$ mount |grep dos /dev/sda8 on /dos type vfat (rw,utf8,umask=0,uid=1000,gid=1000) ## 5.5.44 ## # Started with scripts/mysql_install_db --datadir=./data bin/mysqld_safe --basedir=/dos/mysql-5.5.44-linux2.6-i686 --datadir=/dos/mysql-5.5.44-linux2.6-i686/data --log_error --port=3306 --innodb_file_per_table=0 & mysql> create table t1(name varchar(1000)); Query OK, 0 rows affected (0.01 sec) mysql> insert into t1 values(repeat('A',999)); Query OK, 1 row affected (0.00 sec) mysql> insert into t1 select * from t1; Query OK, 1 row affected (0.01 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> insert into t1 select * from t1 limit 624288; Query OK, 624288 rows affected (2 min 18.87 sec) Records: 624288 Duplicates: 0 Warnings: 0 mysql> insert into t1 select * from t1 limit 624288; ERROR 1114 (HY000): The table 't1' is full mysql> \q Bye // Extract from error log 150619 16:36:08 [Note] /dos/mysql-5.5.44-linux2.6-i686/bin/mysqld: ready for connections. Version: '5.5.44' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 150619 16:59:15 InnoDB: Error: Write to file ./ibdata1 failed at offset 0 4293918720. InnoDB: 1048576 bytes should have been written, only 1048575 were written. InnoDB: Operating system error number 0. InnoDB: Check that your OS and file system support files of this size. InnoDB: Check also that the disk is not full or a disk quota exceeded. InnoDB: Error number 0 means 'Success'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html 150619 16:59:17 [ERROR] /dos/mysql-5.5.44-linux2.6-i686/bin/mysqld: The table 't1' is full ushastry@ubuntu32:/dos/mysql-5.5.44-linux2.6-i686$ // Restarting with --innodb_data_file_path='ibdata1:4294967295;ibdata2:50M:autoextend' bin/mysqld_safe --basedir=/dos/mysql-5.5.44-linux2.6-i686 --datadir=/dos/mysql-5.5.44-linux2.6-i686/data --log_error --port=3306 --innodb_file_per_table=0 --innodb_data_file_path='ibdata1:4294967295;ibdata2:50M:autoextend' & // Extract from error log 150619 17:04:45 mysqld_safe mysqld from pid file /dos/mysql-5.5.44-linux2.6-i686/data/ubuntu32.pid ended 150619 17:06:33 mysqld_safe Starting mysqld daemon with databases from /dos/mysql-5.5.44-linux2.6-i686/data Warning: World-writable config file '/dos/mysql-5.5.44-linux2.6-i686/my.cnf' is ignored 150619 17:06:33 [Note] /dos/mysql-5.5.44-linux2.6-i686/bin/mysqld (mysqld 5.5.44) starting as process 4643 ... 150619 17:06:33 [Warning] Setting lower_case_table_names=2 because file system for /dos/mysql-5.5.44-linux2.6-i686/data/ is case insensitive 150619 17:06:33 [Note] Plugin 'FEDERATED' is disabled. 150619 17:06:33 InnoDB: The InnoDB memory heap is disabled 150619 17:06:33 InnoDB: Mutexes and rw_locks use InnoDB's own implementation 150619 17:06:33 InnoDB: Compressed tables use zlib 1.2.3 150619 17:06:33 InnoDB: Using Linux native AIO 150619 17:06:33 InnoDB: Initializing buffer pool, size = 128.0M 150619 17:06:34 InnoDB: Completed initialization of buffer pool 150619 17:06:34 InnoDB: Data file ./ibdata2 did not exist: new to be created 150619 17:06:34 InnoDB: Setting file ./ibdata2 size to 50 MB <------------------------- InnoDB: Database physically writes the file full: wait... 150619 17:06:35 InnoDB: highest supported file format is Barracuda. 150619 17:06:36 InnoDB: Waiting for the background threads to start 150619 17:06:37 InnoDB: 5.5.44 started; log sequence number 3979891481 150619 17:06:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 150619 17:06:37 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 150619 17:06:37 [Note] Server socket created on IP: '0.0.0.0'. 150619 17:06:37 [Note] Event Scheduler: Loaded 0 events 150619 17:06:37 [Note] /dos/mysql-5.5.44-linux2.6-i686/bin/mysqld: ready for connections. Version: '5.5.44' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) // Confirmed that mysql is up and ibdata2 is created ushastry@ubuntu32:/dos/mysql-5.5.44-linux2.6-i686$ ls -lh data/ total 4.1G -rwxrwxrwx 1 ushastry ushastry 4.0G Jun 19 17:11 ibdata1 -rwxrwxrwx 1 ushastry ushastry 50M Jun 19 17:06 ibdata2 -rwxrwxrwx 1 ushastry ushastry 5.0M Jun 19 17:11 ib_logfile0 -rwxrwxrwx 1 ushastry ushastry 5.0M Jun 19 17:11 ib_logfile1 drwxrwxrwx 2 ushastry ushastry 8.0K Jun 19 15:36 mysql drwxrwxrwx 2 ushastry ushastry 8.0K Jun 19 15:36 performance_schema drwxrwxrwx 2 ushastry ushastry 8.0K Jun 19 16:38 test -rwxrwxrwx 1 ushastry ushastry 5.0K Jun 19 17:06 ubuntu32.err -rwxrwxrwx 1 ushastry ushastry 5 Jun 19 17:06 ubuntu32.pid ## 5.6.25 // Init and start up mysqld ushastry@ubuntu32:/dos/mysql-5.6.25-linux-glibc2.5-i686$ scripts/mysql_install_db --datadir=./data Installing MySQL system tables...2015-06-19 17:15:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-06-19 17:15:14 0 [Note] ./bin/mysqld (mysqld 5.6.25) starting as process 4717 ... 2015-06-19 17:15:14 4717 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2015-06-19 17:15:14 4717 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2015-06-19 17:15:14 4717 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2015-06-19 17:15:14 4717 [Note] InnoDB: The InnoDB memory heap is disabled 2015-06-19 17:15:14 4717 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation 2015-06-19 17:15:14 4717 [Note] InnoDB: Memory barrier is not used 2015-06-19 17:15:14 4717 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-06-19 17:15:14 4717 [Note] InnoDB: Using Linux native AIO 2015-06-19 17:15:14 4717 [Note] InnoDB: Not using CPU crc32 instructions 2015-06-19 17:15:14 4717 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-06-19 17:15:14 4717 [Note] InnoDB: Completed initialization of buffer pool 2015-06-19 17:15:14 4717 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2015-06-19 17:15:14 4717 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2015-06-19 17:15:14 4717 [Note] InnoDB: Database physically writes the file full: wait... 2015-06-19 17:15:15 4717 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2015-06-19 17:15:17 4717 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2015-06-19 17:15:18 4717 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2015-06-19 17:15:18 4717 [Warning] InnoDB: New log files created, LSN=45781 2015-06-19 17:15:18 4717 [Note] InnoDB: Doublewrite buffer not found: creating new 2015-06-19 17:15:18 4717 [Note] InnoDB: Doublewrite buffer created 2015-06-19 17:15:18 4717 [Note] InnoDB: 128 rollback segment(s) are active. 2015-06-19 17:15:18 4717 [Warning] InnoDB: Creating foreign key constraint system tables. 2015-06-19 17:15:18 4717 [Note] InnoDB: Foreign key constraint system tables created 2015-06-19 17:15:18 4717 [Note] InnoDB: Creating tablespace and datafile system tables. 2015-06-19 17:15:18 4717 [Note] InnoDB: Tablespace and datafile system tables created. 2015-06-19 17:15:18 4717 [Note] InnoDB: Waiting for purge to start 2015-06-19 17:15:18 4717 [Note] InnoDB: 5.6.25 started; log sequence number 0 2015-06-19 17:15:20 4717 [Note] Binlog end 2015-06-19 17:15:20 4717 [Note] InnoDB: FTS optimize thread exiting. 2015-06-19 17:15:20 4717 [Note] InnoDB: Starting shutdown... 2015-06-19 17:15:21 4717 [Note] InnoDB: Shutdown completed; log sequence number 1625977 OK Filling help tables...2015-06-19 17:15:22 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-06-19 17:15:22 0 [Note] ./bin/mysqld (mysqld 5.6.25) starting as process 4740 ... 2015-06-19 17:15:22 4740 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2015-06-19 17:15:22 4740 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2015-06-19 17:15:22 4740 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2015-06-19 17:15:22 4740 [Note] InnoDB: The InnoDB memory heap is disabled 2015-06-19 17:15:22 4740 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation 2015-06-19 17:15:22 4740 [Note] InnoDB: Memory barrier is not used 2015-06-19 17:15:22 4740 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-06-19 17:15:22 4740 [Note] InnoDB: Using Linux native AIO 2015-06-19 17:15:22 4740 [Note] InnoDB: Not using CPU crc32 instructions 2015-06-19 17:15:22 4740 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-06-19 17:15:22 4740 [Note] InnoDB: Completed initialization of buffer pool 2015-06-19 17:15:23 4740 [Note] InnoDB: Highest supported file format is Barracuda. 2015-06-19 17:15:23 4740 [Note] InnoDB: 128 rollback segment(s) are active. 2015-06-19 17:15:23 4740 [Note] InnoDB: Waiting for purge to start 2015-06-19 17:15:23 4740 [Note] InnoDB: 5.6.25 started; log sequence number 1625977 2015-06-19 17:15:24 4740 [Note] Binlog end 2015-06-19 17:15:24 4740 [Note] InnoDB: FTS optimize thread exiting. 2015-06-19 17:15:24 4740 [Note] InnoDB: Starting shutdown... 2015-06-19 17:15:26 4740 [Note] InnoDB: Shutdown completed; log sequence number 1625987 OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h ubuntu32 password 'new-password' Alternatively you can run: ./bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd mysql-test ; perl mysql-test-run.pl Please report any problems at http://bugs.mysql.com/ The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com New default config file was created as ./my.cnf and will be used by default by the server when you start it. You may edit this file to change server settings ushastry@ubuntu32:/dos/mysql-5.6.25-linux-glibc2.5-i686$ ushastry@ubuntu32:/dos/mysql-5.6.25-linux-glibc2.5-i686$ bin/mysqld_safe --basedir=/dos/mysql-5.6.25-linux-glibc2.5-i686 --datadir=/dos/mysql-5.6.25-linux-glibc2.5-i686/data --log_error --port=3306 --innodb_file_per_table=0 & [1] 4932 ushastry@ubuntu32:/dos/mysql-5.6.25-linux-glibc2.5-i686$ Warning: World-writable config file '/dos/mysql-5.6.25-linux-glibc2.5-i686/my.cnf' is ignored Warning: World-writable config file '/dos/mysql-5.6.25-linux-glibc2.5-i686/my.cnf' is ignored 150619 17:18:25 mysqld_safe Logging to '/dos/mysql-5.6.25-linux-glibc2.5-i686/data/ubuntu32.err'. 150619 17:18:26 mysqld_safe Starting mysqld daemon with databases from /dos/mysql-5.6.25-linux-glibc2.5-i686/data // Connect and populate data to reach 4G limit ushastry@ubuntu32:/dos/mysql-5.6.25-linux-glibc2.5-i686$ bin/mysql -u root -p test Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.25 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create table t1(name varchar(1000)); Query OK, 0 rows affected (0.03 sec) mysql> insert into t1 values(repeat('A',1500)); Query OK, 1 row affected, 1 warning (0.01 sec) mysql> insert into t1 values(repeat('A',999)); Query OK, 1 row affected (0.01 sec) mysql> insert into t1 select * from t1; .. .. mysql> insert into t1 select * from t1 limit 655555; Query OK, 655555 rows affected (2 min 22.81 sec) Records: 655555 Duplicates: 0 Warnings: 0 mysql> insert into t1 select * from t1 limit 655555; Query OK, 655555 rows affected (2 min 0.82 sec) Records: 655555 Duplicates: 0 Warnings: 0 mysql> insert into t1 select * from t1 limit 655555; ERROR 1114 (HY000): The table 't1' is full mysql> // restart with --innodb_data_file_path='ibdata1:4294967295;ibdata2:50M:autoextend' ushastry@ubuntu32:/dos/mysql-5.6.25-linux-glibc2.5-i686$ bin/mysqladmin -u root -p shutdown Enter password: 150619 17:40:07 mysqld_safe mysqld from pid file /dos/mysql-5.6.25-linux-glibc2.5-i686/data/ubuntu32.pid ended [1]+ Done bin/mysqld_safe --basedir=/dos/mysql-5.6.25-linux-glibc2.5-i686 --datadir=/dos/mysql-5.6.25-linux-glibc2.5-i686/data --log_error --port=3306 --innodb_file_per_table=0 ushastry@ubuntu32:/dos/mysql-5.6.25-linux-glibc2.5-i686$ ushastry@ubuntu32:/dos/mysql-5.6.25-linux-glibc2.5-i686$ ls -l data/ total 4292648 -rwxrwxrwx 1 ushastry ushastry 56 Jun 19 17:18 auto.cnf -rwxrwxrwx 1 ushastry ushastry 4294967295 Jun 19 17:40 ibdata1 -rwxrwxrwx 1 ushastry ushastry 50331648 Jun 19 17:40 ib_logfile0 -rwxrwxrwx 1 ushastry ushastry 50331648 Jun 19 17:39 ib_logfile1 drwxrwxrwx 2 ushastry ushastry 8192 Jun 19 17:15 mysql drwxrwxrwx 2 ushastry ushastry 8192 Jun 19 17:15 performance_schema drwxrwxrwx 2 ushastry ushastry 8192 Jun 19 17:19 test -rwxrwxrwx 1 ushastry ushastry 7133 Jun 19 17:40 ubuntu32.err ushastry@ubuntu32:/dos/mysql-5.6.25-linux-glibc2.5-i686$ bin/mysqld_safe --basedir=/dos/mysql-5.6.25-linux-glibc2.5-i686 --datadir=/dos/mysql-5.6.25-linux-glibc2.5-i686/data --log_error --port=3306 --innodb_file_per_table=0 --innodb_data_file_path='ibdata1:4294967295;ibdata2:50M:autoextend' & [1] 6676 ushastry@ubuntu32:/dos/mysql-5.6.25-linux-glibc2.5-i686$ Warning: World-writable config file '/dos/mysql-5.6.25-linux-glibc2.5-i686/my.cnf' is ignored Warning: World-writable config file '/dos/mysql-5.6.25-linux-glibc2.5-i686/my.cnf' is ignored 150619 17:41:12 mysqld_safe Logging to '/dos/mysql-5.6.25-linux-glibc2.5-i686/data/ubuntu32.err'. 150619 17:41:13 mysqld_safe Starting mysqld daemon with databases from /dos/mysql-5.6.25-linux-glibc2.5-i686/data 150619 17:41:16 mysqld_safe mysqld from pid file /dos/mysql-5.6.25-linux-glibc2.5-i686/data/ubuntu32.pid ended [1]+ Done bin/mysqld_safe --basedir=/dos/mysql-5.6.25-linux-glibc2.5-i686 --datadir=/dos/mysql-5.6.25-linux-glibc2.5-i686/data --log_error --port=3306 --innodb_file_per_table=0 --innodb_data_file_path='ibdata1:4294967295;ibdata2:50M:autoextend' ## Extract from error log 2015-06-19 17:18:28 5073 [Note] /dos/mysql-5.6.25-linux-glibc2.5-i686/bin/mysqld: ready for connections. Version: '5.6.25' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 2015-06-19 17:39:10 a46ceb40 InnoDB: Error: Write to file ./ibdata1 failed at offset 4293918720. InnoDB: 1048576 bytes should have been written, only 1048575 were written. InnoDB: Operating system error number 0. InnoDB: Check that your OS and file system support files of this size. InnoDB: Check also that the disk is not full or a disk quota exceeded. InnoDB: Error number 0 means 'Success'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html 2015-06-19 17:39:11 5073 [ERROR] /dos/mysql-5.6.25-linux-glibc2.5-i686/bin/mysqld: The table 't1' is full 2015-06-19 17:40:05 5073 [Note] /dos/mysql-5.6.25-linux-glibc2.5-i686/bin/mysqld: Normal shutdown 2015-06-19 17:40:05 5073 [Note] Giving 0 client threads a chance to die gracefully 2015-06-19 17:40:05 5073 [Note] Event Scheduler: Purging the queue. 0 events 2015-06-19 17:40:05 5073 [Note] Shutting down slave threads 2015-06-19 17:40:05 5073 [Note] Forcefully disconnecting 0 remaining clients 2015-06-19 17:40:05 5073 [Note] Binlog end 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'partition' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'BLACKHOLE' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_METRICS' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_CMPMEM' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_CMP' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_LOCKS' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'INNODB_TRX' 2015-06-19 17:40:05 5073 [Note] Shutting down plugin 'InnoDB' 2015-06-19 17:40:05 5073 [Note] InnoDB: FTS optimize thread exiting. 2015-06-19 17:40:05 5073 [Note] InnoDB: Starting shutdown... 2015-06-19 17:40:07 5073 [Note] InnoDB: Shutdown completed; log sequence number 3977840592 2015-06-19 17:40:07 5073 [Note] Shutting down plugin 'ARCHIVE' 2015-06-19 17:40:07 5073 [Note] Shutting down plugin 'MyISAM' 2015-06-19 17:40:07 5073 [Note] Shutting down plugin 'CSV' 2015-06-19 17:40:07 5073 [Note] Shutting down plugin 'MRG_MYISAM' 2015-06-19 17:40:07 5073 [Note] Shutting down plugin 'MEMORY' 2015-06-19 17:40:07 5073 [Note] Shutting down plugin 'sha256_password' 2015-06-19 17:40:07 5073 [Note] Shutting down plugin 'mysql_old_password' 2015-06-19 17:40:07 5073 [Note] Shutting down plugin 'mysql_native_password' 2015-06-19 17:40:07 5073 [Note] Shutting down plugin 'binlog' 2015-06-19 17:40:07 5073 [Note] /dos/mysql-5.6.25-linux-glibc2.5-i686/bin/mysqld: Shutdown complete 150619 17:40:07 mysqld_safe mysqld from pid file /dos/mysql-5.6.25-linux-glibc2.5-i686/data/ubuntu32.pid ended 150619 17:41:13 mysqld_safe Starting mysqld daemon with databases from /dos/mysql-5.6.25-linux-glibc2.5-i686/data Warning: World-writable config file '/dos/mysql-5.6.25-linux-glibc2.5-i686/my.cnf' is ignored 2015-06-19 17:41:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for mo re details). 2015-06-19 17:41:15 0 [Note] /dos/mysql-5.6.25-linux-glibc2.5-i686/bin/mysqld (mysqld 5.6.25) starting as process 6836 ... 2015-06-19 17:41:15 6836 [Warning] Setting lower_case_table_names=2 because file system for /dos/mysql-5.6.25-linux-glibc2.5-i686/data/ is case insensitive 2015-06-19 17:41:15 6836 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2015-06-19 17:41:15 6836 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2015-06-19 17:41:15 6836 [Note] Plugin 'FEDERATED' is disabled. 2015-06-19 17:41:16 6836 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2015-06-19 17:41:16 6836 [Note] InnoDB: The InnoDB memory heap is disabled 2015-06-19 17:41:16 6836 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation 2015-06-19 17:41:16 6836 [Note] InnoDB: Memory barrier is not used 2015-06-19 17:41:16 6836 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-06-19 17:41:16 6836 [Note] InnoDB: Using Linux native AIO 2015-06-19 17:41:16 6836 [Note] InnoDB: Not using CPU crc32 instructions 2015-06-19 17:41:16 6836 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-06-19 17:41:16 6836 [Note] InnoDB: Completed initialization of buffer pool 2015-06-19 17:41:16 6836 [ERROR] InnoDB: Data file ./ibdata1 is of a different size 262143 pages (rounded down to MB) than specified in the .cnf file 262080 pages! 2015-06-19 17:41:16 6836 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data! 2015-06-19 17:41:16 6836 [ERROR] Plugin 'InnoDB' init function returned error. 2015-06-19 17:41:16 6836 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2015-06-19 17:41:16 6836 [ERROR] Unknown/unsupported storage engine: InnoDB 2015-06-19 17:41:16 6836 [ERROR] Aborting 2015-06-19 17:41:16 6836 [Note] Binlog end 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'partition' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'BLACKHOLE' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_METRICS' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_CMPMEM' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_CMP' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_LOCKS' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'INNODB_TRX' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'ARCHIVE' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'MyISAM' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'CSV' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'MRG_MYISAM' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'MEMORY' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'sha256_password' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'mysql_old_password' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'mysql_native_password' 2015-06-19 17:41:16 6836 [Note] Shutting down plugin 'binlog' 2015-06-19 17:41:16 6836 [Note] /dos/mysql-5.6.25-linux-glibc2.5-i686/bin/mysqld: Shutdown complete 150619 17:41:16 mysqld_safe mysqld from pid file /dos/mysql-5.6.25-linux-glibc2.5-i686/data/ubuntu32.pid ended ushastry@ubuntu32:/dos/mysql-5.6.25-linux-glibc2.5-i686$