-
Server stats not working
Hi,
Server stats are not working on our Zimbra installation. It is the following version: Version 6.0.4_GA_2038.RHEL5_64.NETWORK. I've searched the forums and tried a number of different possible solutions (waiting at least 48 hours after each solution to see if the stats show up), but no joy. I'm attaching the information specified at
Logger (ZCS 6.0.x and later) - Zimbra :: Wiki
in case anyone can give me any pointers? Thanks.
zimbra@mail ~ $ zmloggerctl status; echo $?; ps ax | grep zmlogger
0
1855 pts/0 S+ 0:00 grep --colour=auto zmlogger
16486 ? S 17:42 /usr/bin/perl /opt/zimbra/libexec/zmlogger
16712 ? S 0:00 zmlogger: zmrrdfetch: server
zimbra@mail ~ $ /opt/zimbra/libexec/zmrrdfetch -f zmmtastats
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 225.
zimbra@mail ~ $ /opt/zimbra/libexec/zmrrdfetch -c -f zmmtastats
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 225.
zimbra@mail ~ $ grep -w MTA /var/log/zimbra-stats.log
zimbra@mail ~ $ tail /var/log/zimbra-stats.log
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BA322-67C5-11DF-BC6C-E14B7B19F7B7:::, Com_purge_before_date, Com_rename_table, Com_repair, Com_replace, Com_replace_select, Com_reset, Com_restore_table, Com_revoke, Com_revoke_all, Com_rollback, Com_savepoint, Com_select, Com_set_option, Com_show_binlog_events, Com_show_binlogs, Com_show_charsets, Com_show_collations, Com_show_column_types, Com_show_create_db, Com_show_create_table, Com_show_databases, Com_show_errors, Com_show_fields, Com_show_grants, Com_show_innodb_status, Com_show_keys, Com_show_logs, Com_show_master_status, Com_show_ndb_status, Com_show_new_master, Com_show_open_tables, Com_show_privileges, Com_show_processlist, Com_show_slave_hosts, Com_show_slave_status, Com_show_status, Com_show_storage_engines, Com_show_tables, Com_show_triggers, Com_show_variables, Com_show_warnings, Com_slave_start, Com_slave_sto:::689BAE3A-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BAE3A-67C5-11DF-BC6C-E14B7B19F7B7:::p, Com_stmt_close, Com_stmt_execute, Com_stmt_fetch, Com_stmt_prepare, Com_stmt_reset, Com_stmt_send_long_data, Com_truncate, Com_unlock_tables, Com_update, Com_update_multi, Com_xa_commit, Com_xa_end, Com_xa_prepare, Com_xa_recover, Com_xa_rollback, Com_xa_start, Compression, Connections, Created_tmp_disk_tables, Created_tmp_files, Created_tmp_tables, Delayed_errors, Delayed_insert_threads, Delayed_writes, Flush_commands, Handler_commit, Handler_delete, Handler_discover, Handler_prepare, Handler_read_first, Handler_read_key, Handler_read_next, Handler_read_prev, Handler_read_rnd, Handler_read_rnd_next, Handler_rollback, Handler_savepoint, Handler_savepoint_rollback, Handler_update, Handler_write, Innodb_buffer_pool_pages_data, Innodb_buffer_pool_pages_dirty, Innodb_buffer_pool_pages_flush:::689BB268-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BB268-67C5-11DF-BC6C-E14B7B19F7B7:::ed, Innodb_buffer_pool_pages_free, Innodb_buffer_pool_pages_misc, Innodb_buffer_pool_pages_total, Innodb_buffer_pool_read_ahead_rnd, Innodb_buffer_pool_read_ahead_seq, Innodb_buffer_pool_read_requests, Innodb_buffer_pool_reads, Innodb_buffer_pool_wait_free, Innodb_buffer_pool_write_requests, Innodb_data_fsyncs, Innodb_data_pending_fsyncs, Innodb_data_pending_reads, Innodb_data_pending_writes, Innodb_data_read, Innodb_data_reads, Innodb_data_writes, Innodb_data_written, Innodb_dblwr_pages_written, Innodb_dblwr_writes, Innodb_log_waits, Innodb_log_write_requests, Innodb_log_writes, Innodb_os_log_fsyncs, Innodb_os_log_pending_fsyncs, Innodb_os_log_pending_writes, Innodb_os_log_written, Innodb_page_size, Innodb_pages_created, Innodb_pages_read, Innodb_pages_written, Innodb_row_lock_current_wai:::689BB68C-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BB68C-67C5-11DF-BC6C-E14B7B19F7B7:::ts, Innodb_row_lock_time, Innodb_row_lock_time_avg, Innodb_row_lock_time_max, Innodb_row_lock_waits, Innodb_rows_deleted, Innodb_rows_inserted, Innodb_rows_read, Innodb_rows_updated, Key_blocks_not_flushed, Key_blocks_unused, Key_blocks_used, Key_read_requests, Key_reads, Key_write_requests, Key_writes, Last_query_cost, Max_used_connections, Not_flushed_delayed_rows, Open_files, Open_streams, Open_tables, Opened_tables, Prepared_stmt_count, Qcache_free_blocks, Qcache_free_memory, Qcache_hits, Qcache_inserts, Qcache_lowmem_prunes, Qcache_not_cached, Qcache_queries_in_cache, Qcache_total_blocks, Queries, Questions, Rpl_status, Select_full_join, Select_full_range_join, Select_range, Select_range_check, Select_scan, Slave_open_temp_tables, Slave_retried_transactions, Slave_running, Slow_launch:::689BBABA-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BBABA-67C5-11DF-BC6C-E14B7B19F7B7:::_threads, Slow_queries, Sort_merge_passes, Sort_range, Sort_rows, Sort_scan, Ssl_accept_renegotiates, Ssl_accepts, Ssl_callback_cache_hits, Ssl_cipher, Ssl_cipher_list, Ssl_client_connects, Ssl_connect_renegotiates, Ssl_ctx_verify_depth, Ssl_ctx_verify_mode, Ssl_default_timeout, Ssl_finished_accepts, Ssl_finished_connects, Ssl_session_cache_hits, Ssl_session_cache_misses, Ssl_session_cache_mode, Ssl_session_cache_overflows, Ssl_session_cache_size, Ssl_session_cache_timeouts, Ssl_sessions_reused, Ssl_used_session_cache_entries, Ssl_verify_depth, Ssl_verify_mode, Ssl_version, Table_locks_immediate, Table_locks_waited, Tc_log_max_pages_used, Tc_log_page_size, Tc_log_page_waits, Threads_cached, Threads_connected, Threads_created, Threads_running, Uptime:: 05/25/2010 16:19:00,33,0,0,0,369338102:::689BBECA-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BBECA-67C5-11DF-BC6C-E14B7B19F7B7:::4,65431578771,39,0,0,0,0,0,0,266,0, 2427,0,2999329,26,0,90,196,0,0,383507,0,0,0,0,0,42 ,0,0,0,0,0,0,0,0,873960,14681,0,0,0,0,0,0,0,0,0,0, 0,0,196553,32,0,0,0,0,4601927,0,5169159,13797655,0 ,0,0,65,0,0,0,3,0,0,0,30122,0,0,0,0,0,0,0,0,0,0,98 348,0,292,0,65,0,0,0,0,0,0,0,0,0,0,0,1689408,12224 7,0,0,0,0,0,0,OFF,98417,126998,213,430855,0,0,0,1, 5833721,134,0,0,122894,74066147,1193512326,7230638 ,9036030,15567730,48595,0,0,6939804,16154186,10983 2,0,2780125,231047,6129,347008,31,419,3872989961,6 9163,0,49837817,954249,0,0,0,1533104128,71857,2837 388,93834289664,2780125,145550,0,6108499,230026,32 1040,0,0,2688510976,16384,16910,93440,2780125,0,0, 0,0,0,923535,663312,1291484019,1748935,0,6680,5439 ,6055773,14,367875,356038,0.000000,7,0,76,0,986,14 62,0,0,0,0,0,0,0,0,0,30040709,30040709,NULL,0,0,76 3731,0,66016,0,:::689BC2E4-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: :::689BC2E4-67C5-11DF-BC6C-E14B7B19F7B7:::0,OFF,0,5597,124,668801,3827740,125 576,0,0,0,,,0,0,0,0,0,0,0,0,0,NONE,0,0,0,0,0,0,0,, 9763978,0,0,0,0,0,7,7,1,1808444
May 25 16:19:02 mail zimbramon[9716]: 9716:info: zmstat cpu.csv: timestamp, cpu:user, cpu:nice, cpu:sys, cpu:idle, cpu:iowait, cpu:irq, cpu:softirq, cpu0:user, cpu0:nice, cpu0:sys, cpu0:idle, cpu0:iowait, cpu0:irq, cpu0:softirq, cpu1:user, cpu1:nice, cpu1:sys, cpu1:idle, cpu1:iowait, cpu1:irq, cpu1:softirq, cpu2:user, cpu2:nice, cpu2:sys, cpu2:idle, cpu2:iowait, cpu2:irq, cpu2:softirq, cpu3:user, cpu3:nice, cpu3:sys, cpu3:idle, cpu3:iowait, cpu3:irq, cpu3:softirq, cpu4:user, cpu4:nice, cpu4:sys, cpu4:idle, cpu4:iowait, cpu4:irq, cpu4:softirq, cpu5:user, cpu5:nice, cpu5:sys, cpu5:idle, cpu5:iowait, cpu5:irq, cpu5:softirq, cpu6:user, cpu6:nice, cpu6:sys, cpu6:idle, cpu6:iowait, cpu6:irq, cpu6:softirq, cpu7:user, cpu7:nice, cpu7:sys, cpu7:idle, cpu7:iowait, cpu7:irq, cpu7:softirq, cpu8:user, cpu8:nice, cpu8:sys, cpu8:idle, cpu8:iowait, cpu8:::6A006950-67C5-11DF-9B15-D34B7B19F7B7:::
May 25 16:19:02 mail zimbramon[9716]: 9716:info: :::6A006950-67C5-11DF-9B15-D34B7B19F7B7::::irq, cpu8:softirq, cpu9:user, cpu9:nice, cpu9:sys, cpu9:idle, cpu9:iowait, cpu9:irq, cpu9:softirq, cpu10:user, cpu10:nice, cpu10:sys, cpu10:idle, cpu10:iowait, cpu10:irq, cpu10:softirq, cpu11:user, cpu11:nice, cpu11:sys, cpu11:idle, cpu11:iowait, cpu11:irq, cpu11:softirq, cpu12:user, cpu12:nice, cpu12:sys, cpu12:idle, cpu12:iowait, cpu12:irq, cpu12:softirq, cpu13:user, cpu13:nice, cpu13:sys, cpu13:idle, cpu13:iowait, cpu13:irq, cpu13:softirq, cpu14:user, cpu14:nice, cpu14:sys, cpu14:idle, cpu14:iowait, cpu14:irq, cpu14:softirq, cpu15:user, cpu15:nice, cpu15:sys, cpu15:idle, cpu15:iowait, cpu15:irq, cpu15:softirq:: 05/25/2010 16:19:02, 11.8, 0.0, 0.9, 86.4, 0.8, 0.0, 0.1, 15.9, 0.0, 3.1, 72.1, 8.2, 0.0, 0.8, 2.1, 0.0, 0.3, 97.4, 0.3, 0.0, 0.0, 9.8, 0.0, 0.4, 89.8, 0.1, 0.0, 0.0, 7.8, 0.0, :::6A0070A8-67C5-11DF-9B15-D34B7B19F7B7:::
May 25 16:19:02 mail zimbramon[9716]: :::6A0070A8-67C5-11DF-9B15-D34B7B19F7B7:::0.8, 91.4, 0.1, 0.0, 0.0, 12.5, 0.0, 1.6, 85.9, 0.0, 0.0, 0.0, 3.1, 0.0, 0.3, 96.5, 0.0, 0.0, 0.0, 9.3, 0.0, 0.4, 90.2, 0.0, 0.0, 0.0, 8.3, 0.0, 0.5, 91.3, 0.0, 0.0, 0.0, 22.7, 0.0, 1.4, 73.1, 2.9, 0.0, 0.0, 13.4, 0.0, 1.0, 85.4, 0.2, 0.0, 0.0, 7.7, 0.0, 0.7, 91.5, 0.0, 0.0, 0.0, 15.5, 0.0, 0.7, 83.8, 0.0, 0.0, 0.0, 20.1, 0.0, 1.2, 78.5, 0.1, 0.0, 0.0, 12.8, 0.0, 0.9, 85.8, 0.5, 0.0, 0.0, 13.6, 0.0, 0.8, 85.6, 0.0, 0.0, 0.0, 14.8, 0.0, 0.9, 84.3, 0.0, 0.0, 0.0
zimbra@mail ~ $ zmsoap -z GetLoggerStatsRequest stats/@name=zmmtastats | head -20
<GetLoggerStatsResponse xmlns="urn:zimbraAdmin"/>
zimbra@mail ~ $ zmsoap -z GetLoggerStatsRequest stats/@name=zmmtastats @limit=1 | head -50
<GetLoggerStatsResponse xmlns="urn:zimbraAdmin"/>