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
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
Subject
Views
Written By
Posted
5097
April 04, 2016 12:51PM
3081
April 04, 2016 05:48PM
9862
April 08, 2016 12:38AM
2628
April 08, 2016 09:38AM
3405
April 08, 2016 01:53PM
2079
April 08, 2016 03:43PM
2030
April 09, 2016 02:57PM
1978
April 09, 2016 03:09PM
Re: How to reduce ibtmp1 file in mysql 5.7?
11313
April 11, 2016 01:39AM
2789
April 11, 2016 11:42AM
2338
April 14, 2016 04:50AM
4204
April 14, 2016 08:49AM
2663
April 20, 2016 07:18AM
3167
April 20, 2016 11:48AM
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.