…and ran it on TPC-H dataset (InnoDB tables) with a Scale Factor of 2 (InnoDB dataset size ~5G). Note that query … of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL …mrr_buffer_size were set to 6M, the query time dropped to ~40s. So the maximum possible benefit is when …
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… Squeeze avalable on DotDeb.org, and I find my qps dropping by 2/3 – with no changes to what is happening… across the board to everyone? Have some updates made to INNOdb tables really slowed down mySQL as measured by qps, in the last…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… be no way to make Innodb avoid touching it. Even when we dropped all Innodb tables (for test purposes) Innodb still was crashing if we… have some impact. Innodb tables rarely become corrupt Indeed even if you leave out crashes in my experience Innodb tables become corrupted more seldom… reason. In fact dump and reload process can be so slow restoring even week old backup and running roll forward recovery…
Post: Percona Server and XtraBackup weekly news, February 26th
February 27, 2011 By 5 Comments
… fix for InnoDB‘s slow DROP TABLE performance. A new option, innodb_lazy_drop_table, controls this behavior. Vadim asked Yasufumi to look into porting the innodb_sync…. In XtraBackup news, Alexey completed moving streaming functionality from innobackupex. InnoDB files are now streamed by the xtrabackup binary, and tar4ibd…
Post: Percona Server and XtraBackup weekly news, February 19th
February 21, 2011 By 2 Comments
… announce. Yasufumi is working on solving the problem with slow DROP TABLE performance in InnoDB. There is a lot of work on packaging and…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_status_fileblogpercona.commanual innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…drop_db’, ’0′ ‘Com_drop_function’, ’0′ ‘Com_drop_index’, ’0′ ‘Com_drop_table‘, ’0′ ‘Com_drop…innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… be an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe…. You might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA query…: wget http://hackmysql.com/scripts/mysqlsla perl mysqlsla -lt slow /path/to/slow.log By default, this outputs the top 10 most…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… tmpdir. The constant “copying to tmp table” part will not be affected by a slow tmpdir, but rebuilding the indexes will obviously… avoid dropping keys that are part of a FOREIGN KEY constraint; mysqldump –innodb-optimize-keys ignores foreign keys because InnoDB requires a full table…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 13 Comments
… using LOCK TABLES on Innodb table to ensure there is not ton of queries starting reading table with no indexes and bringing box down. You can also use this trick for ALTER TABLE which requires table rebuild. Dropping…get advantage of it and will use old slow method of building indexes by…
