MySQL Forums
Forum List  »  InnoDB

Re: How to reduce ibtmp1 file in mysql 5.7?
Posted by: Magi Home
Date: April 11, 2016 01:39AM

Unfortunately I did not keep a log.

No, I used the script mysql_upgrade


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 ''.
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 ''.
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 ''.
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 ''.
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] - '' resolves to '';
2016-04-09T23:10:55.916159Z 0 [Note] Server socket created on IP: ''.
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

Options: ReplyQuote

Written By
Re: How to reduce ibtmp1 file in mysql 5.7?
April 11, 2016 01:39AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.