…data. Using the aggregated data can significantly improve query response times compared to accessing the non-aggregated data… includes a consumer_safe.sh script that will start up…/1 00:00:00 bash $ cat flexcdc.pid 960… be captured. Insert data in one transaction (two rows): mysql> insert into test….
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
…tail -1 | awk ‘{print $6$7}’`; mysql -u root -e “insert into tables (name,spaceid) values…data was just another Bash script: #!/bin/bash CURRENT_ID=1 mysql -u root “create database if not exists filler;” while [ 1 ] do CURRENT_SPACEID=`mysql…For that one, I had to use the Innodb recovery tools but …
Post: Adventures in archiving
February 11, 2013 By 16 Comments
…data (Our test control) Now we needed to generate the ‘payload’ data for this I quickly authored a bash script…data loss if there is not enough space to complete the operation. #37648 Use of INSERT DELAYED is not recommended. #48339 Use…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
…data` char(30) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 and I inserted 100k rows with this simple script: #!/bin/bash NUMROW=100000 COUNT=0 while [ "$NUMROW" -gt "$COUNT" ] do UUID=`uuidgen` mysql test -e “insert…
