…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 18 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 4 Comments
…open table test/test_innodb from the internal data dictionary of InnoDB though the .frm file for the table…
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 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…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
….. 
We recently opened up the following Worklogs on the forge site: PERFORMANCE_SCHEMA Instrumenting Table IO – http://forge.mysql.com/worklog/task.php… the level, along through “stages” (think, SHOW PROFILE), allowing a fully nested tree of events showing where time and resources (bytes read…
Post: Making the impossible: 3 nodes intercontinental replication
January 11, 2012 By 25 Comments
… I want to show new possibilities which open with Percona XtraDB Cluster. We will create 3 …script which does all the work: http://percona.com/downloads/Percona-XtraDB-Cluster/scripts/intercont.tar.gz,…in such environment. We can check it. Simple table: CREATE TABLE t (ID INT) and simple query: INSERT…
