… 44.35 sec (1184.35 sec) 9694.534 sec Q2.2 1 hour 13 min 33.15 sec (4413.15) 19 min…) 8875.349 sec Q3.1 NA 19 min 11.23 sec (1151.23 sec) 16376.93 sec Q3.2 3 hours 30 min… (1977.49 sec ) 19843.213 sec Q4.2 5 hours 38 min 7.60 sec / 5 hours 36 min 35.69 sec (20195… 58 min 4.27 sec (46684.27 sec) 33 min 47.32 sec (2027.32 sec) 7241.791 sec Graph with…
Comment: MySQL Server Variables - SQL layer or Storage Engine specific.
December 1, 2006 By 14 Comments
….427.471 10362 1737133 144871 futex 5.11 1.084.404.926 22078 49117 1 select 4.89 1.037.780.473 393 2637973 274671… 47 2 gettimeofday 0.00 0.000046 23 2 rt_sigaction 0.00 0.000028 14 2 2 rt_sigreturn 0.00 0.000009 9 1… about the server that I use: Linux DL585 2.6.15.1-huge-page #1 SMP Thu Nov 23 22:37:15 CET…
Post: Using pt-table-checksum with Percona XtraDB Cluster
October 15, 2012 By 2 Comments
…v2.1.5 or newer and Percona XtraDB Cluster 5.5…| dsn | +—-+———–+———————–+ | 1 | NULL | h=127.1,P=4000,u=root | | 2 | NULL | h=127.1…1 Changed: 1 Warnings: 0 node5000> SELECT * FROM test.t WHERE id=30; +—-+——+ | id | val | +—-+——+ | 30 | 11…10-05T14:47:52 0 1 10 1 0 0…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… how of LVM and snaphots and using LVM2 >= 2.02.58 (January 2010) which is when the … lvconvert binary. Base installs of Ubuntu 11.04 (Natty) and CentOS 5.7 includes packages with this feature, … at 336797160 #120223 1:59:55 server id 1 end_log_pos 336797275 Query thread_id=47 exec_time=1 error_code=…
Comment: Analyzing air traffic performance with InfoBright and MonetDB
November 28, 2009 By 50 Comments
…2 Quarter (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…in Minutes AirTime DECIMAL(6,2) NOT NULL, — 47 Flight Time, in Minutes Flights …
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…) 1) do backup of specific tables on sources server with xtrabackup (server can run InnoDB or XtraDB, it does not matter) 2… 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… 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57…
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… 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57… log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
