… manual is only partially correct in how to properly build the server to use it (bug 61587). We …THD*, TABLE_LIST*, Item*) (sql_show.cc:5522) ==9090== by 0x74E4DF: get_schema_tables_result(JOIN*, enum_schema_table_state)… about all this? If I had my way, I’d use atomic access primitives in InnoDB …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…table_cache Innodb maintains its own (called data dictionary) which keeps all tables ever accessed since table start – there is no variable to…system tablespace. So if you create Innodb tables you better store some data …for replacing open files in the list. I guess Heikki knows how to implement LRU …
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…InnoDB status. Baron once wrote an article on how to do this. There is not such easy way for the long transaction list…to create a special InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=InnoDB Creating it causes the full status to…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…to newest, and simultaneously listed from least effective to most effective: innodb_max_dirty_pages_pct: This attempts to…tables and/or use the global tablespaces) *cough ext3 cough*. innodb_adaptive_flushing: An Innodb plugin/5.5 setting that tries to…
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
…list you really need to think how large it can get. We’re already seeing half a TB innodb…Innodb tables as transient tables where you create and drop them frequently you may avoid such design or use innodb_file_per_table…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…to demonstrate how much improvement could be made to MySQL so that is could better utilize all…InnoDB table. Partitioning example: /*!50500 PARTITION BY RANGE COLUMNS(FlightDate) (PARTITION p2 VALUES LESS THAN (’1988-01-01′) ENGINE = InnoDB…Vadim’s list. The purpose of this test is to demonstrate that…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
… | test | Query | 62 | Flushing tables | flush tables with read lock | | 6 | root | localhost | test | Field List | 35 | Waiting for table | | | 7 | root | localhost | test… to configure a backup system to avoid this global lock. There is no reason to take a lock at all for backing up only InnoDB…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
…list len 398, seg size 400, Another thread writing in background is the purge thread. It should purge all transactions up to…all InnoDB tables are reachable: mysql> select count(*) from sbtest; +———-+ | count(*) | +———-+ | 1000000 | +———-+ 1 row in set (0.19 sec) Conclusions Add to…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…to learn a great deal about what your server is doing and how to optimize it. Customer demands. Customers come to…To Come True If you have a particular need for some modification to the MySQL server, XtraDB, Maatkit, our InnoDB…to sponsor the work. There are also mailing lists…
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 18 Comments
…, descendant) ) ENGINE=InnoDB; Because there isn’t much written about using the Closure Table design, I periodically get questions about how to solve certain problems. Here’s one I got this week (paraphrased): I’m using Closure Table, which I… with the Adjacency List design, but in that design you don’t have a convenient way to query for all nodes of a…
