… MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2). XtraDB-rel2 has not been…_size=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_io…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
…, innodb_write_threads (see docs). Better Diagnostics – The SHOW ENGINE INNODB STATUS command in XtraDB shows a lot more information than the standard InnoDB status (see docs). Â The built-in InnoDB status also has…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…ID SHOW STATUS LIKE ‘Innodb_scan_pages%’; +——————————+——-+ | Variable_name | Value | +——————————+——-+ | Innodb_scan_pages_contiguous | 37864 | | Innodb_scan_pages_jumpy | … it (tough it is possible in XtraDB / InnoDB-plugin with FAST INDEX creation) so …
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… forked from InnoDB-plugin-1.0.2. Percona XtraDB is released under GPL v2, as is InnoDB-plugin base source code. Percona XtraDB is… number of standard InnoDB, so you can always learn what your engine can do. documentation Improvements to SHOW INNODB STATUS. We’ve added more memory information and lock information, and fixed problems with lock information. documentation Improvements to InnoDB IO…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…, but QA still needs to have some tables in fresh status. – resharding databases, moving some shards from one server to another… on source. (on destination you should have XtraDB with innodb_expand_import extension and with innodb_expand_import=1 setting) 4) run alter… XtraDB innodb_expand_import available only in source code for now, you can get them from Launchpad projects https://launchpad.net/percona-xtradb…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 1 Comment
… the graphs you need. If you’re looking at SHOW INNODB STATUS this is how you can see Insert Buffer Size: Ibuf… Percona Server the following can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id | zip_size | page_no | max… work in all cases. If you’re running XtraDB you can also use innodb_use_purge_thread to use dedicated purge thread…
Post: How much memory Innodb Dictionary can take ?
May 6, 2010 By 3 Comments
… and indexes. Innodb allocates this memory once table is accessed and keeps until server is shut down. In XtraDB we have an… INNODB_SYS_INDEXES; +———-+ | count(*) | +———-+ | 451773 | +———-+ 1 row in set (2.75 sec) In this case The memory stats from SHOW INNODB STATUS look… Memory Allocated” in SHOW INNODB STATUS any more, as that allocations were moved to use malloc() and so Innodb does not track them…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… thinktime XtraDB: (mysql-5.1.39 + XtraDB-1.0.4-current) innodb_io_capacity = 4000 innodb_support_xa = false innodb_file_per_table = true innodb_buffer… mutex/lock contention roughly by the SEMAPHORES sction of SHOW INNODB STATUS output. “xx-lock on RW-latch at 0x7f2ff40a3dc0 created in…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
…SHOW INNODB STATUS was made available in new status variables in InnoDB Show Status. Bug fixed:#698797. Variable Changes New variable innodb_adaptive_…INNODB_INDEX_STATS were renamed. Bug fixed: #691777. (Yasufumi Kinoshita) The XtraDB version was set to 20.0. (Aleksandr Kuzminsky) Many InnoDB…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 13 Comments
… it. If you’re running Innodb Plugin on Percona Server with XtraDB you get benefit of a great… optimize, doing recreate + analyze instead | | test.a | optimize | status | OK | +——–+———-+———-+——————————————————————-+ 2 rows in set (3 hours 3…
