8000 collect innodb statistics by alxrem · Pull Request #621 · collectd/collectd · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

collect innodb statistics #621

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
wants to merge 2 commits into from
Closed

collect innodb statistics #621

wants to merge 2 commits into from

Conversation

alxrem
Copy link
Contributor
@alxrem alxrem commented May 22, 2014

No description provided.

@ekilby
Copy link
ekilby commented May 22, 2014

Looks good to me.

@marekbecka
Copy link
Contributor

There are some values in innodb stats that should be considered to be gauge:

innodb_os_log_pending_*
innodb_data_pending_*
innodb_buffer_pool_pages_*

@pyr
Copy link
Member
pyr commented Jul 29, 2014

@alxrem how does this compare to #82 and #248 ?

@mfournier mfournier removed the Patch label Jul 29, 2014
@ekilby
Copy link
ekilby commented Aug 5, 2014

Very interested in getting the innodb variables included. I've gone through the ones in SHOW STATUS on 5.6 and tried to sort out which are counter-esque vs gauge-esque. Included below (sorry for long comment).

#248 actually seems to cover this well

Innodb_Buffer_Pool_Dump_Status NaN
Innodb_Buffer_Pool_Load_Status NaN
Innodb_Buffer_Pool_Pages_Data Gauge
Innodb_Buffer_Pool_Bytes_Data Gauge
Innodb_Buffer_Pool_Pages_Dirty Gauge
Innodb_Buffer_Pool_Bytes_Dirty Gauge
Innodb_Buffer_Pool_Pages_Flushed Counter
Innodb_Buffer_Pool_Pages_Free Gauge
Innodb_Buffer_Pool_Pages_Misc Gauge
Innodb_Buffer_Pool_Pages_Total Gauge
Innodb_Buffer_Pool_Read_Ahead_Rnd Counter
Innodb_Buffer_Pool_Read_Ahead Counter
Innodb_Buffer_Pool_Read_Ahead_Evicted Counter
Innodb_Buffer_Pool_Read_Requests Counter
Innodb_Buffer_Pool_Reads Counter
Innodb_Buffer_Pool_Wait_Free Counter
Innodb_Buffer_Pool_Write_Requests Counter
Innodb_Data_Fsyncs Counter
Innodb_Data_Pending_Fsyncs Gauge
Innodb_Data_Pending_Reads Gauge
Innodb_Data_Pending_Writes Gauge
Innodb_Data_Read Counter
Innodb_Data_Reads Counter
Innodb_Data_Writes Counter
Innodb_Data_Written Counter
Innodb_Dblwr_Pages_Written Counter
Innodb_Dblwr_Writes Counter
Innodb_Have_Atomic_Builtins NaN
Innodb_Log_Waits Counter
Innodb_Log_Write_Requests Counter
Innodb_Log_Writes Counter
Innodb_Os_Log_Fsyncs Counter
Innodb_Os_Log_Pending_Fsyncs Gauge
Innodb_Os_Log_Pending_Writes Gauge
Innodb_Os_Log_Written Counter
Innodb_Page_Size Gauge
Innodb_Pages_Created Counter
Innodb_Pages_Read Counter
Innodb_Pages_Written Counter
Innodb_Row_Lock_Current_Waits Gauge
Innodb_Row_Lock_Time Counter
Innodb_Row_Lock_Time_Avg Gauge
Innodb_Row_Lock_Time_Max Gauge
Innodb_Row_Lock_Waits Counter
Innodb_Rows_Deleted Counter
Innodb_Rows_Inserted Counter
Innodb_Rows_Read Counter
Innodb_Rows_Updated Counter
Innodb_Num_Open_Files Gauge
Innodb_Truncated_Status_Writes Counter
Innodb_Available_Undo_Logs Gauge

@ekilby ekilby mentioned this pull request Aug 5, 2014
Closed
@octo
Copy link
Member
octo commented Aug 8, 2014

I just merged #248. Is there anything in this PR that #248 is missing?

@alxrem
Copy link
Contributor Author
alxrem commented Aug 8, 2014

This PR is not considered the difference of types of variables. Therefore, it would be better if there will be only #248.

@marekbecka
Copy link
Contributor

As of 5.6 there are some important innodb metrics that are missing in #248:
Innodb_buffer_pool_bytes_data
Innodb_buffer_pool_bytes_dirty
Innodb_log_waits
Innodb_log_write_requests
Innodb_log_writes
Innodb_os_log_fsyncs
Innodb_os_log_written
Innodb_pages_created
Innodb_pages_read
Innodb_pages_written
Innodb_row_lock_time
Innodb_row_lock_waits

The rest of remarkable missing values are gauge types that should also be useful:
Innodb_data_pending_fsyncs
Innodb_data_pending_reads
Innodb_data_pending_writes
Innodb_os_log_pending_fsyncs
Innodb_os_log_pending_writes
Innodb_row_lock_current_waits
Innodb_row_lock_time_avg
Innodb_row_lock_time_max
Innodb_num_open_files
Innodb_available_undo_logs

@marekbecka
Copy link
Contributor

I have created #699 with additional metrics to the #248.

@octo
Copy link
Member
octo commented Aug 14, 2014

Thanks @marekbecka

@octo octo closed this Aug 14, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
6 participants
@alxrem @ekilby @marekbecka @pyr @octo @mfournier
0