mysql> use test
ERROR 1049 (42000): Unknown database 'test'
mysql> CREATE DATABASE test
-> ;
Query OK, 1 row affected (0.00 sec)
mysql> use test
Database changed
mysql> CREATE TABLE blob1 (
-> id int(11) NOT NULL,
-> a tinyint(4) DEFAULT NULL,
-> big longblob,
-> PRIMARY KEY (id)
-> ) ENGINE=InnoDB;
Query OK, 0 rows affected (0.03 sec)
mysql> insert into blob1 values (1,1,LOAD_FILE('/tmp/blob'));
ERROR 1118 (42000): The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size.
So, the size of this file was reduced.
issue not reproduced after
root@node-1:~# for i in {1..50}; do mysql test -e "UPDATE blob1 SET a=$i,big=LOAD_FILE('/tmp/blob')"; done
root@node-1:~# for i in {1..5000}; do mysql test -e "UPDATE blob1 SET a=$i,big=LOAD_FILE('/tmp/blob')"; done
root@node-1:~#
Verified om MOS 8.0 RC1:
mysql> use test
ERROR 1049 (42000): Unknown database 'test'
mysql> CREATE DATABASE test
-> ;
Query OK, 1 row affected (0.00 sec)
mysql> use test
Database changed
mysql> CREATE TABLE blob1 (
-> id int(11) NOT NULL,
-> a tinyint(4) DEFAULT NULL,
-> big longblob,
-> PRIMARY KEY (id)
-> ) ENGINE=InnoDB;
Query OK, 0 rows affected (0.03 sec)
mysql> insert into blob1 values (1,1,LOAD_ FILE('/ tmp/blob' )); log_file_ size.
ERROR 1118 (42000): The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_
So, the size of this file was reduced.
issue not reproduced after LOAD_FILE( '/tmp/blob' )"; done LOAD_FILE( '/tmp/blob' )"; done
root@node-1:~# for i in {1..50}; do mysql test -e "UPDATE blob1 SET a=$i,big=
root@node-1:~# for i in {1..5000}; do mysql test -e "UPDATE blob1 SET a=$i,big=
root@node-1:~#
Moved to Fix Released.