… changes that have happened in the database, instead of replaying binary logs directly. …specified as the first argument on the command line: $ cat sales.sql create table dashboard_…aggregate functions. Now I delete some line items from orders: mysql> delete -> from order_lines -> where order_id -> …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…deleted rows from the ibd file and import them into the database. The time between the deletion of rows and the database… “make” command. After…our database: mysql (employees) > …LINES STARTING BY ‘salaries\t’ (emp_no, from_date, salary, to_date); Query OK, 3 rows affected (0.01 sec) Records: 3 Deleted…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD …time to find how to execute command from command line using included sqlline utility,…. First favorite query for any database benchmarker is SELECT count(*) FROM …MonetDB supports all INSERT / UPDATE / DELETE statements (and space is price…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…to improve MySQL Performance. To start with basics SHOW INNODB STATUS is command …has waited at ./../include/buf0buf.ic line 630 for 0.00 seconds the…(`parent_id`) REFERENCES `parent` (`id`) ON DELETE CASCADE Trying to add in child … size 262144 Free buffers 0 Database pages 258053 Modified db pages …
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…(id,col1,col2,..) VALUES (id,value1,value2,..)”), deletes or updates of rows that …procedure: 1. on monitor: set db2 off-line $ mmm_control @C1 set_offline … $ mysql -u root db < changes.sql At this step we load sql commands …faster method depending on your overall database size, scope of changes, and …
