… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
… CLUSTER_NAME: SPACE: 15 1 row in set (0.00 sec) SPACE is equal to 15 in all actor’s indexes: mysql> select * from INNODB_SYS_INDEXES WHERE TABLE_ID = 13G *************************** 1. row *************************** TABLE_ID: 13 ID: 15… UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (actor_id), KEY idx_actor_last_name (last_name) )ENGINE=InnoDB DEFAULT CHARSET=utf8; This command will…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… The #14 and #15 here is kernel and user CPU usage of MySQL process in 1…: 336986112 BINLOG_BYTES_WRITTEN: 0 ROWS_FETCHED: 485139 ROWS_UPDATED: 0 TABLE_ROWS_READ: 610954 SELECT_COMMANDS:…3BBF3B55 (1/0%), 3BBF3B5A (1/0%)… 1753695 more # Last errno 0 # Users user # Query_time distribution # 1us # 10us…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…logging atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise …Last_errno: 0 Killed: 0 # Query_time: 0.117904 Lock_time: 0.002886 Rows_sent: 1 Rows_examined: 655360 Rows_affected: 0 Rows… 238 296 241.67 246.02 10.15 234.30 # Rows affecte 0 0 0 0 0 0 …
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
MySQL 5.1 introduces row based binary logging. In fact, the default binary logging format in GA versions of MySQL 5.1…: mysql_sandbox25162-relay-bin.000002 Relay_Log_Pos: 340718 Slave_SQL_Running: No Last_Errno: 1032 Last_Error: Could not execute Update_rows event…_pos 340718       Update_rows: table id 15 flags: STMT_END_F ### UPDATE repl.t1 ### WHERE ###Â…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
Last week I played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0…Multi-Range-Read feature which allows to read data not row-by-row but in batches reads. So let us see how…wkB/s avgrq-sz avgqu-sz await svctm %util sda 15.78 0.20 524.39 0.41 130224.59 4…
Post: MySQL: Followup on UNION for query optimization, Query profiling
August 14, 2006 By 12 Comments
… Handler_savepoint_rollback | 0 | | Handler_update | 0 | | Handler_write | 14 | +—————————-+——-+ 15 rows in set (0.00 sec) So you can … 1 row in set (0.00 sec) mysql> explain select * from people where age in(18,19,20) order by last_…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…in the comments of the last post. ICE does not …mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row…# ping shard20 PING shard20 (10.126.15.34) 56(84) bytes …
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…. Example: mysql> create trigger Copy_data AFTER INSERT on t FOR EACH ROW INSERT INTO t_copy VALUE(NEW.i); mysql> insert into… variables are replicated on the slave. Example: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql> insert into t VALUES(@this_year) Binary… Query thread_id=15 exec_time=0 error_code=0 SET TIMESTAMP=1323817490/*!*/; INSERT INTO y (value) VALUES(LAST_INSERT_ID()) That…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
…on Monday, so this is the last in the series of free-Percona… ever wondered what servers are in your MySQL replication hierarchy? We have, too. As …:59 (started 2011-10-06T16:46:15) Replication Is a slave, has 0 …_ignore_table=foo%.mount% Binary logging ROW Slave status 0 seconds behind, running,…
