….) First, we set long_query_time to 0 in order to log …percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema… want it to redirect to /dev/null, and only have a log file… This is an important step because update statements that match no rows …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… should produce updates in-place (I will use INSERT .. ON DUPLICATE KEY UPDATE statements …NULL, k INTEGER UNSIGNED DEFAULT ’0′ NOT NULL, c CHAR(120) DEFAULT ” NOT NULL, pad CHAR(60) DEFAULT ” NOT NULL…mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…LENGTH: 0 DATA_LENGTH: 16384 INDEX_LENGTH: 0 CREATE_TIME: NULL UPDATE_TIME: NULL *************************** 2. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test …. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow … 6291456 Auto_increment: NULL Create_time: 2012-12-31 16:24:54 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G … Auto_increment: NULL Create_time: 2011-05-10 04:26:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment:…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… 10000 rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE test_read(pl INT) -> BEGIN -> DECLARE t… Auto_increment: NULL Create_time: NULL Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec) mysql> select…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… following in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name…: 10000001 Create_time: 2012-06-27 13:04:56 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…) NOT NULL, `b7` bit(1) NOT NULL, `b8` bit(1) NOT NULL, `b9` bit(1) NOT NULL, `b10` bit(1) NOT NULL ) ENGINE=MyISAM mysql> show…: 0 Auto_increment: NULL Create_time: 2008-04-24 00:54:18 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: InnoDB…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…= ‘/*!*/; ### UPDATE test.test ### WHERE ### @1=2 /* INT meta=0 nullable=0 is_null=0 */ ### @2=0 /* INT meta=0 nullable=1 is_null… was using MySQL version < 5.5 as the datastore. There was another interesting case this time with how Active MQ uses MySQL when… TABLE t1(i int(11) not null auto_increment primary key) ENGINE=InnoDB; When using MySQL 5.1 the second CREATE would…
Post: Recovering from a bad UPDATE statement
October 19, 2012 By 5 Comments
… thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1350677442/*!*/; UPDATE `t1` SET `c2` = ‘tom’… is_null=0 */ ### UPDATE test.t1 ### WHERE ### @1=3 /* INT meta=0 nullable=0 is_null=0 */ ### @2=’aamina… doesn’t help as in my testing as MySQL chooses to binlog UPDATEs in STATEMENT format when in MIXED…
