… to the database at all (use mysql -A in this case, to prevent it from getting field list from all tables) Reads though would not be blocked, ie there is no MYISAM like table lock priority problem…’re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) you…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…speedier joins, faster subqueries, and elimination of useless tables in joins Thread pooling and a segmented …forms, so there is some subtlety to this list. For example, Percona Server has the same … partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be here…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
…’s all about time – copying whole 500GB backup while you need to restore only single 20GB table is very non-productive Open InnoDB tables in parallel. Currently opening table is serialized, and it is especially bad at start time, when InnoDB takes probes during opening table… the solution is far from perfect As you see the list list is not about performance but mostly about operations tasks, but…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… deadlocks and the list of all open transactions. This is in your reach with one simple command — SHOW ENGINE InnoDB STATUS. On most… possibility is to create a special InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=InnoDB Creating it causes the full status to… see all the file descriptors that are being kept open by the process. So go to /proc/
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
…innodb_file_per_table=1 the tablespace is dropped when you’re running DROP TABLE, and Innodb has to go through LRU list…. Worst of all this is done while table_cache lock …Innodb tables as transient tables where you create and drop them frequently you may avoid such design or use innodb_file_per_table…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… variable reference for all three sites in …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…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… MySQL table_cache Innodb maintains its own (called data dictionary) which keeps all tables ever accessed since table start -… in system tablespace. So if you create Innodb tables you better store some data in them… downs for replacing open files in the list. I guess Heikki knows how to implement…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… high performance environments. Percona XtraDB includes all of InnoDB‘s ACID-compliant design and advanced… is a list of new features and enhancements: INFORMATION_SCHEMA.XTRADB_ENHANCEMENTS. This table contains …builds. XtraDB is fully compatible with existing InnoDB tables and we are going to keep …
Post: When does Innodb Start Transaction ?
January 11, 2011 By 9 Comments
… INNODB STATUS” and you will see “not started” status in transaction list. It is only when you read (or write) to INNODB table you… this mode will NOT start transaction however reading or writing Innodb table will. I would call it delayed transaction creation – having transaction… actually first access of Innodb table. In most cases you would not care but if you really need all data be seen at…
Post: Innodb undo segment size and transaction isolation
January 12, 2011 By 2 Comments
…not you can check history size in SHOW INNODB STATUS: History list length 4000567 Mind however this size is …There is something else you need to know – not all changes are created equal from their impact on… any row in Innodb table at that point in time. If you use READ-COMMITTED mode Innodb does NOT …
