…new features regarding replication in MySQL 5.6. They …one master and two slaves, all running MySQL 5.6 …mysql> create table test.t (id int not null auto_increment primary key…field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
…the same question arises: How many MySQL records were recovered and how many…are organized in an unidirectional list. The list is sorted by primary key and …up with the supremum record then two conclusions can be make: The …records. It checks whether fields have permitted values, etc. In the end it …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…PRIMARY KEY (`INDEX_ID`,`POS`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Fields names explain their content. Index id in our example is 1679: mysql…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… and make primary key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with primary key appended… Table1′s primary key. Should table2 have an index on the field that is used to join the two tables? A: The question in this…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…In this case, there are two indexes with the IDs 0-26 and 0-27. InnoDB has Clustered Primary Key…FIELDS: emp_no from_date [...] The second method has the same result, 0-26 is our primary key. After identifying the Primary Key… in our hands the last step is to import it in our database: mysql (…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
… different files. Usually system tablespace is located in ibdata1 file and every InnoDB table has two files e.g. actor.frm and…, PRIMARY KEY (`TABLE_ID`,`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Please note field SPACE. For table actor it is equal to 15: mysql> select…, PRIMARY KEY (actor_id), KEY idx_actor_last_name (last_name) )ENGINE=InnoDB DEFAULT CHARSET=utf8; This command will create respective records in SYS…
Post: Recover BLOB fields
July 1, 2010 By 4 Comments
…(120), `N_FIELDS` int(10), PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Here COMPACT format is used, which is default in MySQL >= 5.1. The record consists of four parts: Offsets. Effectively these are field lengths. Only variable length… one or two bytes depending on maximum field size. The highest bit of the offset is 1 if the field is stored in external…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
…fields to use ENUM column type, but is it really necessary (from performance standpoint)? In…keys: PRIMARY key: PRIMARY key_len: 1 ref: test.c.state_id rows: 1 Extra: 2 rows in…MySQL to store Join result in…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…in the comments of the last post. ICE does not have any indexes (not even primary keys…shown in the EC2 console. That the “private ip” field is selected in…one or two nodes. You should start two workers per core in the …3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…getting a really solid # of hits in memcached, but the # of writes in MySQL coupled with the still large …from a database based on an integer based primary key B.) Update data from that row and …row in another table based on a text field ( called email address ). Seems simple enough right? My two …
