MySQL Forums
Forum List  »  Performance

MySQL Performance Schema: A Big Bag of Epic Awesomeness
Posted by: Edwin DeSouza
Date: February 05, 2009 07:25PM

MySQL Performance Schema

Articles:
http://www.drdobbs.com/database/detailed-profiling-of-sql-activity-in-my/240154959?pgno=1

Docs:
http://dev.mysql.com/doc/refman/5.6/en/performance-schema.html
http://www.markleith.co.uk/2011/04/01/a-big-bag-of-epic-awesomeness/

Presentations:
http://dimitrik.free.fr/mysqltechday_2013_10/MySQL_PFS_2013-dim.pdf
http://mysql.wisborg.dk/wp-content/uploads/2013/10/mysql_connect_2013_con5282_performance_schema_easy.pdf
http://mysql.wisborg.dk/wp-content/uploads/2013/10/mysql_connect_2013_hol9733_improving_performance_with_perf_schema.pdf
http://www.slideshare.net/Leithal/performance-schema-andpshelper

ps_helper:
http://www.markleith.co.uk/ps_helper/
http://www.markleith.co.uk/2012/07/09/helper-functions-for-ps_helper/

ps_tools:
http://mysql.wisborg.dk/2013/05/20/easier-overview-of-current-performance-schema-setting/


Performance Schema: Statement Digests
http://www.markleith.co.uk/2012/07/04/mysql-performance-schema-statement-digests/


Performance Schema: Mutexes, Locks
http://www.markleith.co.uk/2010/09/24/tracking-mutex-locks-in-a-process-list-mysql-55s-performance_schema/


Performance Schema: Processes
http://www.markleith.co.uk/2012/07/13/monitoring-processes-with-performance-schema-in-mysql-5-6/


Performance Schema: IO
http://www.markleith.co.uk/2010/10/28/tracking-io-with-performance_schema/
http://www.markleith.co.uk/2011/04/18/monitoring-table-and-index-io-with-performance_schema/
http://www.markleith.co.uk/2011/05/23/monitoring-mysql-io-latency-with-performance_schema/


Performance Schema: Replication
http://shivjijha.blogspot.com/2013/09/Introducing-the-performance-schema-tables-to-monitor-MySQL-replication.html
http://www.markleith.co.uk/2012/07/24/a-mysql-replication-load-average-with-performance-schema/


Performance Schema: Prepared Statements
http://mysqlserverteam.com/mysql-performance-schema-prepared-statements-instrumentation/
http://mayankmysql.blogspot.com/2014/04/mysql-performance-schema-prepared.html
http://mysqlblog.fivefarmers.com/2012/07/03/prepared-statement-peculiarities-p_s-to-the-rescue/
http://mysqlblog.fivefarmers.com/2012/07/05/whos-leaking-prepared-statements/


Performance Schema: Security
https://blogs.oracle.com/svetasmirnova/entry/performance_schema_in_version_5


Performance Schema: Benchmarks
http://dimitrik.free.fr/blog/archives/2012/06/mysql-performance-pfs-overhead-in-56.html
http://dimitrik.free.fr/blog/archives/2011/04/mysql-performance-562-and-performance-schema.html
http://dimitrik.free.fr/blog/archives/2010/05/mysql-performance-using-performance-schema.html
http://marcalff.blogspot.com/2011/06/performance-schema-overhead-tuning.html
http://marcalff.blogspot.com/2011/04/performance-schema-faq-2-what-are-all.html


Performance Schema: Configuration
http://marcalff.blogspot.com/2013/04/on-configuring-performance-schema.html

Performance Schema: Overview
http://mysqlserverteam.com/performance-schema-implementation-internals-registering-instruments/
http://mayankmysql.blogspot.com/2014/01/performance-schema-implementation.html
http://marcalff.blogspot.com/2012/04/performance-schema-nailing-host-cache.html
http://marcalff.blogspot.com/2011/12/performance-schema-or-com-status.html
http://marcalff.blogspot.com/2011/12/mysql-564-performance-schema.html
http://marcalff.blogspot.com/2011/08/explaining-performance-schema-tables.html
http://marcalff.blogspot.com/2010/01/performance-schema-overview.html



Edited 34 time(s). Last edit at 04/04/2014 10:01AM by Edwin Desouza.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Performance Schema: A Big Bag of Epic Awesomeness
12289
February 05, 2009 07:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.