diff options
Diffstat (limited to 'storage/perfschema/pfs_server.h')
| -rw-r--r-- | storage/perfschema/pfs_server.h | 195 |
1 files changed, 191 insertions, 4 deletions
diff --git a/storage/perfschema/pfs_server.h b/storage/perfschema/pfs_server.h index 8cb68cd52b1..f65febdeb6d 100644 --- a/storage/perfschema/pfs_server.h +++ b/storage/perfschema/pfs_server.h @@ -1,4 +1,4 @@ -/* Copyright (c) 2008, 2010, Oracle and/or its affiliates. All rights reserved. +/* Copyright (c) 2008, 2011, Oracle and/or its affiliates. All rights reserved. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by @@ -54,11 +54,17 @@ #ifndef PFS_MAX_FILE_HANDLE #define PFS_MAX_FILE_HANDLE 32768 #endif +#ifndef PFS_MAX_SOCKETS + #define PFS_MAX_SOCKETS 1000 +#endif +#ifndef PFS_MAX_SOCKET_CLASS + #define PFS_MAX_SOCKET_CLASS 10 +#endif #ifndef PFS_MAX_TABLE_SHARE - #define PFS_MAX_TABLE_SHARE 50000 + #define PFS_MAX_TABLE_SHARE 1000 #endif #ifndef PFS_MAX_TABLE - #define PFS_MAX_TABLE 100000 + #define PFS_MAX_TABLE 10000 #endif #ifndef PFS_WAITS_HISTORY_SIZE #define PFS_WAITS_HISTORY_SIZE 10 @@ -66,36 +72,217 @@ #ifndef PFS_WAITS_HISTORY_LONG_SIZE #define PFS_WAITS_HISTORY_LONG_SIZE 10000 #endif +#ifndef PFS_MAX_SETUP_ACTOR + #define PFS_MAX_SETUP_ACTOR 100 +#endif +#ifndef PFS_MAX_SETUP_OBJECT + #define PFS_MAX_SETUP_OBJECT 100 +#endif +#ifndef PFS_MAX_HOST + #define PFS_MAX_HOST 100 +#endif +#ifndef PFS_MAX_USER + #define PFS_MAX_USER 100 +#endif +#ifndef PFS_MAX_ACCOUNT + #define PFS_MAX_ACCOUNT 100 +#endif +#ifndef PFS_MAX_STAGE_CLASS + #define PFS_MAX_STAGE_CLASS 150 +#endif +#ifndef PFS_STAGES_HISTORY_SIZE + #define PFS_STAGES_HISTORY_SIZE 10 +#endif +#ifndef PFS_STAGES_HISTORY_LONG_SIZE + #define PFS_STAGES_HISTORY_LONG_SIZE 10000 +#endif +#ifndef PFS_STATEMENTS_HISTORY_SIZE + #define PFS_STATEMENTS_HISTORY_SIZE 10 +#endif +#ifndef PFS_STATEMENTS_HISTORY_LONG_SIZE + #define PFS_STATEMENTS_HISTORY_LONG_SIZE 10000 +#endif +#ifndef PFS_STATEMENTS_STACK_SIZE + #define PFS_STATEMENTS_STACK_SIZE 10 +#endif +#ifndef PFS_DIGEST_SIZE + #define PFS_DIGEST_SIZE 200 +#endif +/** Performance schema global sizing parameters. */ struct PFS_global_param { - bool m_enabled; + /** True if the performance schema is enabled. */ + bool m_enabled; + /** Default values for SETUP_CONSUMERS. */ + bool m_consumer_events_stages_current_enabled; + bool m_consumer_events_stages_history_enabled; + bool m_consumer_events_stages_history_long_enabled; + bool m_consumer_events_statements_current_enabled; + bool m_consumer_events_statements_history_enabled; + bool m_consumer_events_statements_history_long_enabled; + bool m_consumer_events_waits_current_enabled; + bool m_consumer_events_waits_history_enabled; + bool m_consumer_events_waits_history_long_enabled; + bool m_consumer_global_instrumentation_enabled; + bool m_consumer_thread_instrumentation_enabled; + bool m_consumer_statement_digest_enabled; + + /** Default instrument configuration option. */ + char *m_pfs_instrument; + + /** + Maximum number of instrumented mutex classes. + @sa mutex_class_lost. + */ ulong m_mutex_class_sizing; + /** + Maximum number of instrumented rwlock classes. + @sa rwlock_class_lost. + */ ulong m_rwlock_class_sizing; + /** + Maximum number of instrumented cond classes. + @sa cond_class_lost. + */ ulong m_cond_class_sizing; + /** + Maximum number of instrumented thread classes. + @sa thread_class_lost. + */ ulong m_thread_class_sizing; + /** + Maximum number of instrumented table share. + @sa table_share_lost. + */ ulong m_table_share_sizing; + /** + Maximum number of instrumented file classes. + @sa file_class_lost. + */ ulong m_file_class_sizing; + /** + Maximum number of instrumented mutex instances. + @sa mutex_lost. + */ ulong m_mutex_sizing; + /** + Maximum number of instrumented rwlock instances. + @sa rwlock_lost. + */ ulong m_rwlock_sizing; + /** + Maximum number of instrumented cond instances. + @sa cond_lost. + */ ulong m_cond_sizing; + /** + Maximum number of instrumented thread instances. + @sa thread_lost. + */ ulong m_thread_sizing; + /** + Maximum number of instrumented table handles. + @sa table_lost. + */ ulong m_table_sizing; + /** + Maximum number of instrumented file instances. + @sa file_lost. + */ ulong m_file_sizing; + /** + Maximum number of instrumented file handles. + @sa file_handle_lost. + */ ulong m_file_handle_sizing; + /** + Maxium number of instrumented socket instances + @sa socket_lost + */ + ulong m_socket_sizing; + /** + Maximum number of instrumented socket classes. + @sa socket_class_lost. + */ + ulong m_socket_class_sizing; + /** Maximum number of rows per thread in table EVENTS_WAITS_HISTORY. */ ulong m_events_waits_history_sizing; + /** Maximum number of rows in table EVENTS_WAITS_HISTORY_LONG. */ ulong m_events_waits_history_long_sizing; + /** Maximum number of rows in table SETUP_ACTORS. */ + ulong m_setup_actor_sizing; + /** Maximum number of rows in table SETUP_OBJECTS. */ + ulong m_setup_object_sizing; + /** Maximum number of rows in table HOSTS. */ + ulong m_host_sizing; + /** Maximum number of rows in table USERS. */ + ulong m_user_sizing; + /** Maximum number of rows in table ACCOUNTS. */ + ulong m_account_sizing; + /** + Maximum number of instrumented stage classes. + @sa stage_class_lost. + */ + ulong m_stage_class_sizing; + /** Maximum number of rows per thread in table EVENTS_STAGES_HISTORY. */ + ulong m_events_stages_history_sizing; + /** Maximum number of rows in table EVENTS_STAGES_HISTORY_LONG. */ + ulong m_events_stages_history_long_sizing; + /** + Maximum number of instrumented statement classes. + @sa statement_class_lost. + */ + ulong m_statement_class_sizing; + /** Maximum number of rows per thread in table EVENTS_STATEMENT_HISTORY. */ + ulong m_events_statements_history_sizing; + /** Maximum number of rows in table EVENTS_STATEMENTS_HISTORY_LONG. */ + ulong m_events_statements_history_long_sizing; + /** Maximum number of digests to be captured */ + ulong m_digest_sizing; }; +/** + Performance schema sizing values for the server. + This global variable is set when parsing server startup options. +*/ extern PFS_global_param pfs_param; +/** + Initialize the performance schema. + @param param Size parameters to use. + @return A boostrap handle, or NULL. +*/ struct PSI_bootstrap* initialize_performance_schema(const PFS_global_param *param); +/** + Initialize the performance schema ACL. + ACL is strictly enforced when the server is running in normal mode, + to enforce that only legal operations are allowed. + When running in boostrap mode, ACL restrictions are relaxed, + to allow the boostrap scripts to DROP / CREATE performance schema tables. + @sa ACL_internal_schema_registry + @param bootstrap True if the server is starting in bootstrap mode. +*/ void initialize_performance_schema_acl(bool bootstrap); void check_performance_schema(); +/** + Initialize the dynamic array holding individual instrument settings collected + from the server configuration options. +*/ +void init_pfs_instrument_array(); + +/** + Process one PFS_INSTRUMENT configuration string. +*/ +int add_pfs_instr_to_array(const char* name, const char* value); + +/** + Shutdown the performance schema. +*/ void shutdown_performance_schema(); #endif |