… that’s using 5.6), is that I question its readiness. There have been some unfortunate performance regressions compared to 5… more point releases before we can consider it truly production-ready. I suppose I should state an obvious disclaimer here in… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… snapshot script” you’ll many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush… #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed… comes with good settings out-of-box, but I am ready to tune something if there are suggestions.
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…_TABLES SYS_INDEXES SYS_COLUMNS SYS_FIELDS SYS_TABLES Here InnoDB keeps correspondence between human readable table names and their internal…` varchar(255) DEFAULT NULL, PRIMARY KEY (`INDEX_ID`,`POS`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Fields names explain their content. Index id…_FIELDS\t’ (`INDEX_ID`, `POS`, `COL_NAME`); 5. Now everything is ready to generate a CREATE TABLE statement for a table: ./sys…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… suggest Innodb. Application Readiness Application should be ready to work with Innodb, for example be ready to deal with deadlocks which can happen with Innodb even…) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
…: 090706 15:39:47 InnoDB: Database was not shut down normally! … 090706 16:51:56 [Note] libexec/mysqld: ready for connections. So…: 090706 17:04:11 InnoDB: Database was not shut down normally! … 090706 18:10:53 [Note] libexec/mysqld: ready for connections. 1h…: 090707 19:00:01 InnoDB: Database was not shut down normally! … 090707 19:06:42 [Note] libexec/mysqld: ready for connections. 6…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… tickets to use. Innodb tries to limit thread concurrency allowing only innodb_thread_concurrency threads to run inside Innodb kernel at the same… thread is not runniing inside innodb kernel status could be “waiting in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is… adjusted by innodb_file_io_threads variable. For each helper thread you can see thread state – if thread is ready – waiting for…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… source. (on destination you should have XtraDB with innodb_expand_import extension and with innodb_expand_import=1 setting) 4) run alter… in error.log like: InnoDB: import: extended import of test/img_out59 InnoDB: import: 3 indexes are detected. InnoDB: Progress in %: 1 2… and https://launchpad.net/percona-xtrabackup. Binary releases will be ready as soon as we have done with testing of this…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… still are doing internal QA for, but it will be ready soon. Main difference XtraDB-rel2 it contains additional scalability fixes…=8M innodb_log_files_in_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…. We have not included all the InnoDB patches available. For example Google’s well-known InnoDB patch set is omitted (at least… fixed problems with lock information. documentation Improvements to InnoDB IO. Improvements of InnoDB IO subsystem, such as multiple read and write threads…. We are open for features requests for new engine and ready to accept community patches. You can monitor Percona’s current…
