#!/bin/bash

mysql="mysql -uroot -S /var/run/mysql/mysql.sock "

$mysql test < ./createTable.sql

#for i in $( seq 22 1 122 ); do

for i in $( seq 22 1 2722 ); do

  echo $i

  $mysql test -e "INSERT INTO \`mdl_course_modules\` VALUES ($i,4,5,5,24,NULL,1141569781,'',0,0,1,0,'',0,'locked',1,1,0,0,0,0,NULL,0,0,0,0,0,0);"

done

$mysql test -e "ALTER TABLE test.mdl_course_modules ADD stefantest LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci AFTER showdescription;"

sles12-x86-64:/var/lib/mysql/test # ls -ahl

total 9.0G

-rw-rw---- 1 mysql mysql  6.2K Jun  2 12:52 #sql-ba5_b99.frm

-rw-rw---- 1 mysql mysql  9.0G Jun  2 13:08 #sql-ib18-3361842814.ibd

drwx------ 1 mysql root    168 Jun  2 12:52 .

drwx------ 1 mysql root    248 Jun  2 13:08 ..

-rw-rw---- 1 mysql mysql  6.2K Jun  2 12:46 mdl_course_modules.frm

-rw-rw---- 1 mysql mysql 1008K Jun  2 12:52 mdl_course_modules.ibd