June 18, 2013

Comment: InnoDB's gap locks

May 7, 2012 By 15 Comments

… exceeded; try restarting transaction root@localhost:test 14:38:03>insert into t values(23); ERROR 1205 (HY000): Lock wait timeout… table `test`.`t` trx id 0 27638 lock_mode X insert intention waiting Record lock, heap no 1 PHYSICAL RECORD: n_fields… 8; hex 73757072656d756d; asc supremum;; —————— The lock_mode is “X insert intention” .

Filed Under: MySQL

Post: Edge-case behavior of INSERT...ODKU

October 27, 2012 By 6 Comments

… this table were almost exclusively INSERT … ON DUPLICATE KEY UPDATE (INSERT ODKU), with the columns from the INSERT part of the statement corresponding… the auto-increment range, and then try to insert another one: (root@localhost) [test]> insert into update_test (id,username,host_id… got updated. The secondary UNIQUE on username is, for all intents and purposes, ignored. For the customer whose database served as…

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: Recovering Innodb table Corruption

July 4, 2008 By 22 Comments

…_page_no(page) == dict_index_get_page(index)) InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report… page data. The next comes trial and error approach: mysql> insert into test2 select * from test; ERROR 2013 (HY000): Lost connection… use higher innodb_force_recovery modes to block purging activity, insert buffer merge or recovery from transactional logs all together. Though…

Filed Under: Insight for DBAs Tagged With:

Post: MySQL performance on EC2/EBS versus RDS

August 4, 2011 By 11 Comments

… inside information to share on that speculation, but for all intents and purposes, it seems valid. However, the versions of MySQL… and logical design, you can make certain workloads, such as insert-heavy, work better in the Amazon cloud platform. But this… balance. It requires tricks, such as partitioning so all the inserts go into one partition, whose indexes fit in memory. The…

Filed Under: Benchmarks, Cloud and NoSQL, MySQL

Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo

March 2, 2009 By 10 Comments

… of rseg may be helpful for CPU scale of write-intentional workloads. See benchmark results. Scalability fix — replaced page_hash… XtraDB io patches: innodb_ibuf_max_size — Restrict innodb-insert-buffer size innodb_ibuf_active_contract — Enabling it makes…_rate — This parameter is additional tuning the amount of insert buffer processing by background thread. innodb_flush_neighbor_pages â…

Filed Under: Percona Software Tagged With: , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… MyISAM list. What happens if we take the MyISAM stopwords, insert them into a table, and configure that table to be…_list2′; Query OK, 0 rows affected (0.00 sec) mysql: INSERT INTO innodb_ft_list2 SELECT * FROM innodb_myisam_stopword; Query…/type, so I’m not sure if this is an intentional restriction that just needs to be better documented or if…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Adventures in archiving

February 11, 2013 By 16 Comments

…_data (The change here being VARCHAR(1000) -> BLOB for the intentions of using compress() ) compressed_row (The row format being set… not enough space to complete the operation.  #37648 Use of INSERT DELAYED is not recommended. #48339 Use of statement based replication… for example by running a select on the table before inserts are written to disk. Followup A few alternative suggestions have…

Filed Under: MySQL Tagged With: , ,

Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.

December 1, 2012 By 48 Comments

… returns “2 rows affected,” if only does the insert it returns 1. Methinks intentional (coz still like that in v5.5) and… be before someone asks: ‘how do I know if it inserted or updated?” – hence returning 1 or 2 they have the…

Filed Under: Insight for DBAs Tagged With: , , ,

Post: Announcing Percona Server for MySQL version 5.1.67-14.4

March 8, 2013 By Leave a Comment

… #1083058 (Laurynas Biveinis). The server could crash when executing an INSERT or UPDATE statement containing BLOB values for a compressed table… InnoDB data files for flushing purposes, which wasn’t original intention. Bug fixed #1105709 (Laurynas Biveinis). INFORMATION_SCHEMA plugin name innodb…

Filed Under: Events and Announcements, MySQL, Percona Software Tagged With: , ,

Post: Announcing Percona Server for MySQL version 5.5.29-30.0

February 26, 2013 By Leave a Comment

… #1017192 (Sergei Glushchenko). The server could crash when executing an INSERT or UPDATE statement containing BLOB values for a compressed table… InnoDB data files for flushing purposes, which wasn’t original intention. Bug fixed #1105709 (Laurynas Biveinis). INFORMATION_SCHEMA plugin name innodb…

Filed Under: Events and Announcements, MySQL, Percona Software Tagged With: , , ,
« Older Posts