Re: cannot create new thread
Posted by: sirajudeen j
Date: December 11, 2013 01:19AM

SHOW GLOBAL STATUS:


'Aborted_clients', '40'
'Aborted_connects', '1'
'Binlog_cache_disk_use', '0'
'Binlog_cache_use', '0'
'Binlog_stmt_cache_disk_use', '0'
'Binlog_stmt_cache_use', '0'
'Bytes_received', '57909555'
'Bytes_sent', '442273854'
'Com_admin_commands', '141'
'Com_assign_to_keycache', '0'
'Com_alter_db', '0'
'Com_alter_db_upgrade', '0'
'Com_alter_event', '0'
'Com_alter_function', '0'
'Com_alter_procedure', '0'
'Com_alter_server', '0'
'Com_alter_table', '0'
'Com_alter_tablespace', '0'
'Com_analyze', '0'
'Com_begin', '1'
'Com_binlog', '0'
'Com_call_procedure', '0'
'Com_change_db', '40'
'Com_change_master', '0'
'Com_check', '0'
'Com_checksum', '0'
'Com_commit', '0'
'Com_create_db', '0'
'Com_create_event', '0'
'Com_create_function', '0'
'Com_create_index', '0'
'Com_create_procedure', '0'
'Com_create_server', '0'
'Com_create_table', '0'
'Com_create_trigger', '0'
'Com_create_udf', '0'
'Com_create_user', '0'
'Com_create_view', '0'
'Com_dealloc_sql', '0'
'Com_delete', '0'
'Com_delete_multi', '0'
'Com_do', '0'
'Com_drop_db', '0'
'Com_drop_event', '0'
'Com_drop_function', '0'
'Com_drop_index', '0'
'Com_drop_procedure', '0'
'Com_drop_server', '0'
'Com_drop_table', '0'
'Com_drop_trigger', '0'
'Com_drop_user', '0'
'Com_drop_view', '0'
'Com_empty_query', '0'
'Com_execute_sql', '0'
'Com_flush', '0'
'Com_grant', '0'
'Com_ha_close', '0'
'Com_ha_open', '0'
'Com_ha_read', '0'
'Com_help', '0'
'Com_insert', '0'
'Com_insert_select', '0'
'Com_install_plugin', '0'
'Com_kill', '0'
'Com_load', '0'
'Com_lock_tables', '0'
'Com_optimize', '0'
'Com_preload_keys', '0'
'Com_prepare_sql', '0'
'Com_purge', '0'
'Com_purge_before_date', '0'
'Com_release_savepoint', '0'
'Com_rename_table', '0'
'Com_rename_user', '0'
'Com_repair', '0'
'Com_replace', '0'
'Com_replace_select', '0'
'Com_reset', '0'
'Com_resignal', '0'
'Com_revoke', '0'
'Com_revoke_all', '0'
'Com_rollback', '49'
'Com_rollback_to_savepoint', '0'
'Com_savepoint', '0'
'Com_select', '157863'
'Com_set_option', '139368'
'Com_signal', '0'
'Com_show_authors', '0'
'Com_show_binlog_events', '0'
'Com_show_binlogs', '0'
'Com_show_charsets', '1'
'Com_show_collations', '46365'
'Com_show_contributors', '0'
'Com_show_create_db', '0'
'Com_show_create_event', '0'
'Com_show_create_func', '0'
'Com_show_create_proc', '112'
'Com_show_create_table', '20'
'Com_show_create_trigger', '0'
'Com_show_databases', '33'
'Com_show_engine_logs', '0'
'Com_show_engine_mutex', '0'
'Com_show_engine_status', '0'
'Com_show_events', '0'
'Com_show_errors', '0'
'Com_show_fields', '496'
'Com_show_function_status', '2'
'Com_show_grants', '0'
'Com_show_keys', '6'
'Com_show_master_status', '0'
'Com_show_open_tables', '0'
'Com_show_plugins', '0'
'Com_show_privileges', '0'
'Com_show_procedure_status', '2'
'Com_show_processlist', '14'
'Com_show_profile', '0'
'Com_show_profiles', '0'
'Com_show_relaylog_events', '0'
'Com_show_slave_hosts', '0'
'Com_show_slave_status', '31'
'Com_show_status', '117'
'Com_show_storage_engines', '0'
'Com_show_table_status', '130'
'Com_show_tables', '2'
'Com_show_triggers', '0'
'Com_show_variables', '46328'
'Com_show_warnings', '0'
'Com_slave_start', '0'
'Com_slave_stop', '0'
'Com_stmt_close', '0'
'Com_stmt_execute', '0'
'Com_stmt_fetch', '0'
'Com_stmt_prepare', '0'
'Com_stmt_reprepare', '0'
'Com_stmt_reset', '0'
'Com_stmt_send_long_data', '0'
'Com_truncate', '0'
'Com_uninstall_plugin', '0'
'Com_unlock_tables', '0'
'Com_update', '0'
'Com_update_multi', '0'
'Com_xa_commit', '0'
'Com_xa_end', '0'
'Com_xa_prepare', '0'
'Com_xa_recover', '0'
'Com_xa_rollback', '0'
'Com_xa_start', '0'
'Compression', 'OFF'
'Connections', '46422'
'Created_tmp_disk_tables', '812'
'Created_tmp_files', '6'
'Created_tmp_tables', '95003'
'Delayed_errors', '0'
'Delayed_insert_threads', '0'
'Delayed_writes', '0'
'Flush_commands', '1'
'Handler_commit', '76'
'Handler_delete', '0'
'Handler_discover', '0'
'Handler_prepare', '0'
'Handler_read_first', '80'
'Handler_read_key', '371'
'Handler_read_last', '0'
'Handler_read_next', '1830'
'Handler_read_prev', '0'
'Handler_read_rnd', '182'
'Handler_read_rnd_next', '10257847'
'Handler_rollback', '48'
'Handler_savepoint', '0'
'Handler_savepoint_rollback', '0'
'Handler_update', '0'
'Handler_write', '9952279'
'Innodb_buffer_pool_pages_data', '15447'
'Innodb_buffer_pool_bytes_data', '253083648'
'Innodb_buffer_pool_pages_dirty', '0'
'Innodb_buffer_pool_bytes_dirty', '0'
'Innodb_buffer_pool_pages_flushed', '1'
'Innodb_buffer_pool_pages_free', '50086'
'Innodb_buffer_pool_pages_misc', '2'
'Innodb_buffer_pool_pages_total', '65535'
'Innodb_buffer_pool_read_ahead_rnd', '0'
'Innodb_buffer_pool_read_ahead', '0'
'Innodb_buffer_pool_read_ahead_evicted', '0'
'Innodb_buffer_pool_read_requests', '318576'
'Innodb_buffer_pool_reads', '15448'
'Innodb_buffer_pool_wait_free', '0'
'Innodb_buffer_pool_write_requests', '1'
'Innodb_data_fsyncs', '7'
'Innodb_data_pending_fsyncs', '0'
'Innodb_data_pending_reads', '0'
'Innodb_data_pending_writes', '0'
'Innodb_data_read', '255283200'
'Innodb_data_reads', '15458'
'Innodb_data_writes', '7'
'Innodb_data_written', '35328'
'Innodb_dblwr_pages_written', '1'
'Innodb_dblwr_writes', '1'
'Innodb_have_atomic_builtins', 'ON'
'Innodb_log_waits', '0'
'Innodb_log_write_requests', '0'
'Innodb_log_writes', '2'
'Innodb_os_log_fsyncs', '5'
'Innodb_os_log_pending_fsyncs', '0'
'Innodb_os_log_pending_writes', '0'
'Innodb_os_log_written', '1024'
'Innodb_page_size', '16384'
'Innodb_pages_created', '0'
'Innodb_pages_read', '15447'
'Innodb_pages_written', '1'
'Innodb_row_lock_current_waits', '0'
'Innodb_row_lock_time', '0'
'Innodb_row_lock_time_avg', '0'
'Innodb_row_lock_time_max', '0'
'Innodb_row_lock_waits', '0'
'Innodb_rows_deleted', '0'
'Innodb_rows_inserted', '0'
'Innodb_rows_read', '213822'
'Innodb_rows_updated', '0'
'Innodb_truncated_status_writes', '0'
'Key_blocks_not_flushed', '0'
'Key_blocks_unused', '26790'
'Key_blocks_used', '2'
'Key_read_requests', '240'
'Key_reads', '2'
'Key_write_requests', '0'
'Key_writes', '0'
'Last_query_cost', '0.000000'
'Max_used_connections', '143'
'Not_flushed_delayed_rows', '0'
'Open_files', '48'
'Open_streams', '0'
'Open_table_definitions', '279'
'Open_tables', '278'
'Opened_files', '4225'
'Opened_table_definitions', '275'
'Opened_tables', '285'
'Performance_schema_cond_classes_lost', '0'
'Performance_schema_cond_instances_lost', '0'
'Performance_schema_file_classes_lost', '0'
'Performance_schema_file_handles_lost', '0'
'Performance_schema_file_instances_lost', '0'
'Performance_schema_locker_lost', '0'
'Performance_schema_mutex_classes_lost', '0'
'Performance_schema_mutex_instances_lost', '0'
'Performance_schema_rwlock_classes_lost', '0'
'Performance_schema_rwlock_instances_lost', '0'
'Performance_schema_table_handles_lost', '0'
'Performance_schema_table_instances_lost', '0'
'Performance_schema_thread_classes_lost', '0'
'Performance_schema_thread_instances_lost', '0'
'Prepared_stmt_count', '0'
'Qcache_free_blocks', '0'
'Qcache_free_memory', '0'
'Qcache_hits', '0'
'Qcache_inserts', '0'
'Qcache_lowmem_prunes', '0'
'Qcache_not_cached', '0'
'Qcache_queries_in_cache', '0'
'Qcache_total_blocks', '0'
'Queries', '437276'
'Questions', '437276'
'Rpl_status', 'AUTH_MASTER'
'Select_full_join', '0'
'Select_full_range_join', '0'
'Select_range', '2'
'Select_range_check', '0'
'Select_scan', '93555'
'Slave_heartbeat_period', '0.000'
'Slave_open_temp_tables', '0'
'Slave_received_heartbeats', '0'
'Slave_retried_transactions', '0'
'Slave_running', 'OFF'
'Slow_launch_threads', '0'
'Slow_queries', '1'
'Sort_merge_passes', '0'
'Sort_range', '0'
'Sort_rows', '10'
'Sort_scan', '2'
'Ssl_accept_renegotiates', '0'
'Ssl_accepts', '0'
'Ssl_callback_cache_hits', '0'
'Ssl_cipher', ''
'Ssl_cipher_list', ''
'Ssl_client_connects', '0'
'Ssl_connect_renegotiates', '0'
'Ssl_ctx_verify_depth', '0'
'Ssl_ctx_verify_mode', '0'
'Ssl_default_timeout', '0'
'Ssl_finished_accepts', '0'
'Ssl_finished_connects', '0'
'Ssl_session_cache_hits', '0'
'Ssl_session_cache_misses', '0'
'Ssl_session_cache_mode', 'NONE'
'Ssl_session_cache_overflows', '0'
'Ssl_session_cache_size', '0'
'Ssl_session_cache_timeouts', '0'
'Ssl_sessions_reused', '0'
'Ssl_used_session_cache_entries', '0'
'Ssl_verify_depth', '0'
'Ssl_verify_mode', '0'
'Ssl_version', ''
'Table_locks_immediate', '228'
'Table_locks_waited', '0'
'Tc_log_max_pages_used', '0'
'Tc_log_page_size', '0'
'Tc_log_page_waits', '0'
'Threads_cached', '59'
'Threads_connected', '84'
'Threads_created', '143'
'Threads_running', '1'
'Uptime', '66464'
'Uptime_since_flush_status', '66464'

Options: ReplyQuote


Subject
Written By
Posted
November 06, 2013 01:41AM
November 15, 2013 08:40PM
December 05, 2013 04:21AM
December 05, 2013 12:28PM
December 06, 2013 12:21AM
December 06, 2013 12:13PM
December 09, 2013 01:04AM
December 10, 2013 01:39AM
December 11, 2013 01:18AM
Re: cannot create new thread
December 11, 2013 01:19AM
December 11, 2013 01:20AM
December 11, 2013 01:21AM
December 11, 2013 01:15PM


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.