… engine, you can take one of our binary builds with 5.1.36. On new server we run set global innodb_expand…` smallint(6) NOT NULL, `ol_number` tinyint(4) NOT NULL, `ol_i_id` int(11) default NULL, `ol_supply_w_id` smallint… indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 10 Comments
… the export files SET GLOBAL innodb_import_table_from_xtrabackup = 1; ALTER TABLE data IMPORT TABLESPACE; After those being done i… have been detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61… log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…_import extension and with innodb_expand_import=1 setting) 4) run alter table IMPORTEDTABLE discard tablespace; 5) copy .exp and .ibd files to… indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61…
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
… tested 1, 2, 4 parallel threads for tools that support it and different level of compression ( 1,2,3 for qpress; -1 and -5 for….86 125,892.620.5120129.3212347.91 135,885.010.51 47312.448470.06 216,058.930.526593.216691.80 225,892.620.51 11053.5711252.61 235,885.010.51 24524.028470.06 416,058.930.5248126…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…_terms wp_term_taxonomy wp_term_relationships # 5 0xA3EEB63EFBA42E9B 0.1999 2.5% 51 0.0039 1.00 0.00 SELECT UNION wp_pp… 0x88BA308B9C0EB583 0.0905 1.1% 4 0.0226 1.00 0.01 SELECT poller_item # 11 0xD0A520C9DB2D6AC7 0.0850 1.0% 125 0.0007 1.00 0… 4.18k 11.91k 3.35k 2.06k # Merge passes 0 0 0 0 0 0 0 0 # Tmp tables 10 149 1 1 1 1…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… 93 101K 135K 0.0 0 14 1 5 19:17:09 trime P 3 3 …1 19:17:14 trime P 3 3 node3 Sync T/T 0 0 70 83 106K 121K 0.0 0 11…s go through the columns. Cluster There are 4 columns in the cluster section, and it’… cluster gets split brained, then only a quorum (>=51%) of the remaining nodes will remain Primary. …
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… enabled on all servers: #111214 0:51:54 server id 1 end_log_pos 1593 Query thread_id=…@`this_year`:=2011/*!*/; # at 457 #111213 23:58:11 server id 1 end_log_pos 552 Query thread_id=…1,2,3,5 Then we execute the following: insert into y (i,value) VALUES(4,1),(NULL,1),(NULL,1); Binary Log: The value 4…
Comment: The perils of uniform hardware and RAID auto-learn cycles
November 17, 2010 By 16 Comments
… brevity): Sep 9 01:21:51 kernel: mfi0: (info) – Battery relearn will start in 4 days Sep 11 01:22:29 kernel: mfi0: (info) – Battery relearn will start in 2 day Sep 11 03:02… will start in 1 day Sep 12 20:21:56 kernel: mfi0: (info) – Battery relearn will start in 5 hours Sep 13…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
… sec MonetDB: 42 608 sec (without indexes) InfoBright: 51 779 sec LucidDB: 140 736 sec (without indexes…(1192.25 sec) 8875.349 sec Q3.1 NA 19 min 11.23 sec (1151.23 sec) … (1198.29 sec) 2517.621 sec Q3.4 1 hour 41 min 41.29 sec (6101.29… 19843.213 sec Q4.2 5 hours 38 min 7.60 sec / 5 hours 36 min 35.69…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
November 28, 2009 By 50 Comments
…1-4) Month TINYINT NOT NULL, — 3 Month DayofMonth TINYINT NOT NULL, — 4 Day of Month DayOfWeek TINYINT NOT NULL, — 5…10 Tail Number FlightNum SMALLINT NOT NULL, — 11 Flight Number Origin CHAR(3) NOT NULL…Flight Segment CarrierDelay DECIMAL(6,2), — 51 Carrier Delay, in Minutes WeatherDelay DECIMAL…
