…Com_show_innodb_statusblogpercona.commanual Com_show_keysblogpercona.commanual Com_show_logsblogpercona.commanual Com_show_master_statusblogpercona.commanual Com_show_new_masterblogpercona.commanual Com_show_open_tablesblogpercona.commanual Com_show_pluginsblogpercona.commanual Com_show…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’ ‘Com_show_new_master’, ’0′ ‘Com_show_open_tables‘, ’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave_status’, ’13834′ ‘Com_show_status’, ’194766′ ‘Com_show_storage_engines’, ’0′ ‘Com_show_tables‘, ’2842′ ‘Com_show_variables’, ’176825′ ‘Com_show_warnings…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
…open table test/test_innodb from the internal data dictionary of InnoDB though the .frm file for the table…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…show status like ‘Open%tables‘; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables | 30 | | Opened_tables | 1 | +—————+——-+ 2 rows in set (0.00 sec) session10 > show…
Post: Drop table performance
April 20, 2011 By 22 Comments
…com/2011/02/03/performance-problem-with-innodb-and-drop-table/ and these bug reports: http://bugs.mysql.com… during this operation InnoDB holds the LOCK_open mutex, which prevents other queries from executing….Also, to show the dynamics, here is a graph showing the number of dropped tables per second …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… test (http://mysqlha.blogspot.com/2009/03/pbxt-is-fast-no-kidding.html) by Mark Callaghan shows that PBXT can actually out… locks when calling back into MySQL to do things like open a table, create a session structure (THD) or create a .frm… needs to do recovery. In PBXT’s case this means opening tables (reading a .frm file), which requires creating a THD. The…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch… Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, … showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table …
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
…to do LVM performance research which showed horrible results forcing us to … solution but it is not Open Source and so we can’… changes from last backup),table-level backup (copy only specified tables), streaming and parallel…, contact us http://www.percona.com/contacts.html if you are interested…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
…_parse.cc:5809 #23 dispatch_command (command=COM_QUERY, thd=0x33acd30, packet=
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table…openings in chess — the great chess players study openings…
