· 8 years ago · Jan 17, 2018, 11:08 AM
1drop table if exists t;
2create table t(a longblob)engine=innodb;
3insert into t values(repeat('a',1000)),(repeat('a',1000)),(repeat('a',1000)),(repeat('a',1000));
4insert into t select t.a from t,t b,t c,t d,t e,t f,t g;
5insert into t select * from t;
6insert into t select * from t;
7analyze table t;
8show table status like 't'\g
9
10drop procedure if exists p;
11delimiter $
12create procedure p()
13begin
14 declare v_a longblob;
15 declare v_lengt bigint default 0;
16 declare done int default false;
17 declare cur1 cursor for select * from t;
18 declare continue handler for not found set done = true;
19 open cur1;
20 read_loop: loop
21 fetch cur1 into v_a;
22 if done then
23 leave read_loop;
24 end if;
25 set v_lengt:=v_length+length(v_a);
26 end loop;
27 close cur1;
28 select v_lengt;
29end $
30
31delimiter ;
32
33call p();
34
35
36
37----------------
38
39E:\mysql-5.7.21-winx64\bin>mysqld --no-defaults --console --skip-grant-tables --innodb-temp-data-file-path="ibdata:12M:autoextend:max:50M"
402018-01-17T11:06:03.601800Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documen
412018-01-17T11:06:03.601800Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
422018-01-17T11:06:03.602300Z 0 [Note] mysqld (mysqld 5.7.21) starting as process 13380 ...
432018-01-17T11:06:03.611802Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
442018-01-17T11:06:03.613802Z 0 [Note] InnoDB: Uses event mutexes
452018-01-17T11:06:03.615302Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
462018-01-17T11:06:03.616302Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
472018-01-17T11:06:03.618302Z 0 [Note] InnoDB: Number of pools: 1
482018-01-17T11:06:03.619803Z 0 [Note] InnoDB: Not using CPU crc32 instructions
492018-01-17T11:06:03.624803Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
502018-01-17T11:06:03.635304Z 0 [Note] InnoDB: Completed initialization of buffer pool
512018-01-17T11:06:03.691312Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
522018-01-17T11:06:03.857333Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
532018-01-17T11:06:03.859333Z 0 [Note] InnoDB: Setting file '.\ibdata' size to 12 MB. Physically writing the file full; Please wait ...
542018-01-17T11:06:03.928342Z 0 [Note] InnoDB: File '.\ibdata' size is now 12 MB.
552018-01-17T11:06:03.932342Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
562018-01-17T11:06:03.933842Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
572018-01-17T11:06:03.936343Z 0 [Note] InnoDB: Waiting for purge to start
582018-01-17T11:06:03.988849Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 262211319
592018-01-17T11:06:03.991350Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\mysql-5.7.21-winx64\data\ib_buffer_pool
602018-01-17T11:06:03.991350Z 0 [Note] Plugin 'FEDERATED' is disabled.
612018-01-17T11:06:04.108865Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private k
622018-01-17T11:06:04.111865Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
632018-01-17T11:06:04.114865Z 0 [Note] IPv6 is available.
642018-01-17T11:06:04.116866Z 0 [Note] - '::' resolves to '::';
652018-01-17T11:06:04.118366Z 0 [Note] Server socket created on IP: '::'.
662018-01-17T11:06:04.482912Z 0 [Note] mysqld: ready for connections.
67Version: '5.7.21' socket: '' port: 3306 MySQL Community Server (GPL)
682018-01-17T11:06:04.743445Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180117 13:06:04
692018-01-17T11:06:14.991247Z 2 [ERROR] mysqld: The table 'c:\tmp\#sql3444_2_4' is full