…it in a browser-displayable format. It lets you click …: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127…., PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A… of children, parents, count of columns, row counts, and comments — a …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… examines very little data. It seems that InnoDB performs better when a larger number of rows must be joined together (Q4.1…/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users …. However, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay with … be good if your async master can use ROW based binlog format as well to achieve better consistency, if you …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… with approximately 78GiB of data (32 tables, 10M rows each) and a 4GiB buffer pool. The cache …mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… the default format is COMPACT. More information about row format on the following link: http://dev.mysql.com/doc/refman/5.5/en/innodb-physical-record.html You can also get the table row format from the Information Schema: mysql (information_schema) > SELECT ROW_FORMAT from TABLES…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… compression. With the original InnoDB Antelope file format you have the choice of ROW_FORMAT=COMPACT and ROW_FORMAT=REDUNDANT where InnoDB stored the first 768 bytes… InnoDB’s new Barracuda file format (available since InnoDB plugin 1.1 or MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb … does it uses dynamic or static record format ? (static record format for sort used by MyISAM may… problems because they target at least MySQL 5.1 with row level replication readily available. Speaking…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… INNODB STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL… source of information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the… deal with phantom reads and your binary log is in row format, changing the ISOLATION to READ COMMITTED will help you to…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure … time: mysql> show table status like “post_channel” \G *************************** 1. row *************************** Name: post_channel Engine: InnoDB Version: 10 Row_format: Compact Rows: 278987416 Avg_row_length: 75…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…: 38278 sec. Compressed tables are create as: ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8, with final…=0 –rand-type=uniform –max-time=1800 –mysql-user=root –report-interval=10 run this… have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression tables…
