Re: How to reduce ibtmp1 file in mysql 5.7?

[Magi Home]

Unfortunately I did not keep a log.

No, I used the script mysql_upgrade

Error.log:

2016-04-09T23:10:54.017898Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-04-09T23:10:54.041253Z 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 65535)
2016-04-09T23:10:54.041393Z 0 [Warning] Changed limits: max_connections: 214 (requested 500)
2016-04-09T23:10:54.041405Z 0 [Warning] Changed limits: table_open_cache: 400 (requested 4096)
2016-04-09T23:10:54.352866Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details
).
2016-04-09T23:10:54.352916Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode
in a future release.
2016-04-09T23:10:54.352926Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-04-09T23:10:54.354792Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.11) starting as process 4808 ...
2016-04-09T23:10:54.372799Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-04-09T23:10:54.372870Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-04-09T23:10:54.372889Z 0 [Note] InnoDB: Uses event mutexes
2016-04-09T23:10:54.372908Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-04-09T23:10:54.372925Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-04-09T23:10:54.372942Z 0 [Note] InnoDB: Using Linux native AIO
2016-04-09T23:10:54.373935Z 0 [Note] InnoDB: Number of pools: 1
2016-04-09T23:10:54.374341Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-09T23:10:54.496815Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M
2016-04-09T23:10:54.792961Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-04-09T23:10:54.851395Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-04-09T23:10:54.889018Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-09T23:10:55.538214Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-04-09T23:10:55.538402Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-04-09T23:10:55.765485Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-04-09T23:10:55.769552Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-04-09T23:10:55.769612Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-04-09T23:10:55.773206Z 0 [Note] InnoDB: Waiting for purge to start
2016-04-09T23:10:55.829767Z 0 [Note] InnoDB: 5.7.11 started; log sequence number 36294669941
2016-04-09T23:10:55.830352Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2016-04-09T23:10:55.831877Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-04-09T23:10:55.847084Z 0 [ERROR] Function 'archive' already exists
2016-04-09T23:10:55.847132Z 0 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
2016-04-09T23:10:55.847235Z 0 [ERROR] Function 'blackhole' already exists
2016-04-09T23:10:55.847250Z 0 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2016-04-09T23:10:55.847267Z 0 [ERROR] Function 'federated' already exists
2016-04-09T23:10:55.847280Z 0 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2016-04-09T23:10:55.847297Z 0 [ERROR] Function 'innodb' already exists
2016-04-09T23:10:55.847310Z 0 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2016-04-09T23:10:55.879204Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2016-04-09T23:10:55.904788Z 0 [Warning] CA certificate ca.pem is self signed.
2016-04-09T23:10:55.911091Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-09T23:10:55.916054Z 0 [Note] IPv6 is not available.
2016-04-09T23:10:55.916119Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2016-04-09T23:10:55.916159Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2016-04-09T23:10:56.302910Z 0 [Note] Event Scheduler: Loaded 0 events
2016-04-09T23:10:56.303636Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.11' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2016-04-09T23:10:56.674813Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-04-09T23:11:58.185801Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160410 2:11:58
2016-04-09T23:17:12.091916Z 39 [ERROR] /usr/sbin/mysqld: The table '/tmp/mysql/#sql_12c8_4' is full