June 18, 2013

Post: Eventual Consistency in MySQL

November 18, 2011 By 8 Comments

… (333,444); mysql> INSERT INTO Bar (ID,X,Y) VALUES (21,333,444); mysql> SET FOREIGN_KEY_CHECKS=0; mysql> INSERT INTO Bar (ID,X,Y) …_key_checks.sql | mysql -N | mysql -E *************************** 1. row *************************** test.Bar.ID: 42 DIY RI We can get information about foreign key …

Filed Under: Insight for DBAs, MySQL

Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

February 25, 2013 By 10 Comments

… under $80? Introducing the Raspberry Pi with Percona Server: [caption id="attachment_13122" align="aligncenter" width="582"] Raspberry Pi Fully Connected… have your hardware, here is how to get Percona Server for MySQL up and running: Insert the SD card into a slot on… system (to prevent partial writes), take out the card and insert into your Pi. Carefull, the card goes upside down :) Plug…

Filed Under: Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , ,

Post: The case for getting rid of duplicate “sets”

May 17, 2011 By 2 Comments

…,15,15,16) group by val ; +—–+——————–+ | val | count(distinct id) | +—–+——————–+ | -10 | 1 | | -3 | 1 | | -2 | 1 | | 15 | 35417088 | +—–+——————–+ 4 …0.00 sec) mysql> insert into ex2 values (2,1); Query OK, 1 row affected (0.00 sec) mysql> select a.val, …

Filed Under: MySQL

Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables

March 23, 2012 By 20 Comments

…mysql> show processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id…mysql client, so you might get a feel you can’t connect to the database at all (use mysql…read lock | insert into C …

Filed Under: Insight for DBAs, MySQL

Post: Recovering Innodb table Corruption

July 4, 2008 By 22 Comments

…I am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test; …mysql> insert ignore into test2 select * from test where id>250; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> insert…

Filed Under: Insight for DBAs Tagged With:

Post: Test Drive of Solid

September 22, 2006 By 5 Comments

… insert into test2 values (1,’Mysql‘),(2,’Solid’),(3,’MyISAM’); mysql> begin; mysql> update test2 set names=’mysql‘ where id=1; Session 2: mysql> begin; mysql> …where id=2; …waiting… Session2: mysql> update test2 set names=’mysql2′ where id=1; ERROR 1213 (40001): Deadlock found when trying to get…

Filed Under: Uncategorized Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…_DOC_ID column, however, MySQL apparently has no problem with either of the following statements: mysql> insert into dir_test_innodb3 (fts_doc_id, full_name) values (1, ‘john smith’); mysql> select * from dir_test_innodb3 where fts_doc_id… new FULLTEXT KEY that you create, you’ll get a corresponding FTS_*_DOC_ID.ibd file (but none of the others), and…

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

Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes

July 25, 2012 By 6 Comments

…mysql> insert into percona values (0,’percona1′,’peter’); ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction percona1 mysql> insert…percona2 mysql> select * from percona; +—-+—————+——–+ | id | inserted_from | name | +—-+—————+——–+ …

Filed Under: MySQL, XtraDB Cluster

Post: Can MySQL temporary tables be made safe for statement-based replication?

May 26, 2008 By 8 Comments

…. (However, if you type ROLLBACK the temporary table doesn’t get dropped. It’s not really transactional — it just doesn’t…. row *************************** Log_name: mysql-bin.000007 Pos: 271 Event_type: Query Server_id: 1 End_log_pos: 90 Info: insert into test.t(a) values(1) *************************** 5. row *************************** Log_name: mysql-bin.000007…

Filed Under: Insight for DBAs Tagged With:

Post: InnoDB's gap locks

March 27, 2012 By 15 Comments

… transaction, two identical statements get different values, because some …to insert another value on the second session: transaction2 > START TRANSACTION; transaction2 > INSERT…MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163 localhost msandbox TABLE LOCK table `test`.`t` trx id…

Filed Under: MySQL
« Older Posts
Newer Posts »