… storing another column, and reinitializing the sequence after making certain insert/update/delete operations. If you have a dataset that changes infrequently, then…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… stay in the buffer_pool.) If I recall correctly, any INSERT/DELETE/etc always opens all partitions, even before thinking about pruning… find otherwise.) I would argue that single-row queries (SELECT, INSERT, DELETE, UPDATE) are similar in speed between PARTITIONed or non-PARTITIONed. When…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting the data on the standby server. You… traffic. This is an important step because update statements that match no rows or insert statements that have duplicate key errors may…
Post: MyISAM mmap feature (5.1)
May 26, 2006 By 10 Comments
… call remap once per 1000 inserts at the end of file and on an exclusive operation (DELETE/UPDATE/INSERT inside file), for work with… SELECT queries (OLTP ro) UPDATE primary key (update-key) UPDATE non key column (updaye-nokey) OLTP rw queries, SELECT/INSERT/DELETE/UPDATE queries (OLTP rw) batch…
Comment: Using Flexviews - part two, change data capture
August 13, 2012 By 26 Comments
… we tracking only insert/delete updates or are we tracking even UPDATE modifications? 2. I get the following error when trying to update my view…
Post: Unused indexes by single query
September 12, 2008 By 14 Comments
… unused indexes are devil, they waste diskspace, cache, they make INSERT / DELETE / UPDATE operations slower and what makes them worse – it is hard… | | art100 | article100 | forum_id_2 | | art100 | article100 | published | | art100 | article100 | inserted | | art100 | article100 | site_id_2 | | art100 | author100 | PRIMARY | | art100 | author100…
Post: Sysbench with support of multi-tables workload
April 29, 2011 By 4 Comments
… –test=oltp there are couple other scripts, likeoltp_simple select insert delete update_index update_non_index to support different OLTP modes. Most interesting…
Comment: Table locks in SHOW INNODB STATUS
June 8, 2010 By 1 Comment
… lock on DB, X lock on table? => row cannot be inserted/deleted/updated/read. Or I can do S lock on DB, X…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… 1 MySQL thread id 9697561, query id 188161264 localhost root update insert into child values(2,2) Foreign key constraint fails for… if there are any records is insert buffer. Next it shows how many inserts were done in insert buffer, how many recs were… activity Number of rows inserted 143, updated 3000041, deleted 0, read 24865563 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
…UPDATE CASCADE ) ENGINE=InnoDB; [revin@forge rsandbox_5_5_17]$ for int in {1..2000}; do ./master/use test -e “insert into…\G *************************** 1. row *************************** Level: Error Code: 1451 Message: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t2…
