…file is well commented. The example settings file should work for most MySQL installations which allow connections… ps 6248 pts/1 00:00:00 bash $ cat flexcdc.pid 960 Adding a changelog…demo` will automatically be captured. Insert data in one transaction (two rows): mysql> insert into test.demo values …
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
…00 00 |O…G………..| In the above example, the table space id is “00 11… | tail -1 | awk ‘{print $6$7}’`; mysql -u root -e “insert into tables (name,spaceid) values (‘$…Bash script: #!/bin/bash CURRENT_ID=1 mysql -u root “create database if not exists filler;” while [ 1 ] do CURRENT_SPACEID=`mysql…
Post: Adventures in archiving
February 11, 2013 By 16 Comments
…for further testing. InnoDB’s inbuilt row compression MySQL‘s inbuilt compress() function leveraging zlib to provide…’payload’ data for this I quickly authored a bash script for the task to provide an …flush the buffer for example by running a select on the table before inserts are written to disk….
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
… to analyze performance of various MySQL features, benchmark, compare, analyze things and post our findings on MySQL Performance Blog. However recently we…” understanding what happens on all layers (MySQL, Operation System, Hardware) when for example row is being inserted into Innodb table on Linux stored… develop fixes for them One should know some scripting languages – bash,perl,php to be able to script benchmark runs This…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…/) this week. And following Baron’s example I also run the same load …. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA … line is weak ( I had to use bash and pass query as parameter, otherwise… only LOAD DATA. InfoBright Enterprise allows INSERT / UPDATE but that also is not …
