… ago. My previous observations are based on 0.9.5-dev back in mars this year. I have now… SPH_MATCH_ALL) returning top 200 matches): — PROFILE — root: 12.86, self: 0.00 query_load_dir: 0.01,… and 24.32 MB mysqlindex, 299.54 MB in total. In both cases 1 million indexed messages (forum posts). Which…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… extension and with innodb_expand_import=1 setting) 4) run alter table IMPORTEDTABLE discard tablespace; 5) copy .exp and .ibd files to… are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64… – you just need to shutdown instance with innodb_fast_shutdown=1 (done in xtrabackup –prepare –export call). The more complex problem…
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… been detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64… log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
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…CHAR(3) NOT NULL COMMENT ‘LOOKUP’, — 12 Origin Airport OriginCityName VARCHAR(50) NOT … in Minutes SecurityDelay DECIMAL(6,2), — 54 Security Delay, in Minutes LateAircraftDelay …
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…:53:28 [Note] /usr/sbin/mysqld: ready for connections. Version: ‘5.0.51a-community-log’ socket: ‘/var/lib/mysql/mysql.sock… 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64…:06:20 [Note] /usr/sbin/mysqld: ready for connections. Version: ‘5.0.51a-community-log’ socket: ‘/var/lib/mysql/mysql.sock…): Linux 2.6.9-42.0.8.ELsmp #1 SMP Tue Jan 23 12:49:51 EST 2007 x86_64 x86_64…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 75 Comments
… tables are in InnoDB with MySQL 5 and RHEL 5. Its a 32 bit machine with 12 Gb RAM. The imp param for…_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 A count command with approx… count(1),field1 from Table where REQUEST_TIME >= ’2012-03-26′ group by field1; 14 rows in set (15 min 54.29…
