==================================================================
Please DO NOT REPLY to this mail or send email to the developers
about this bug. Please follow-up to Bugzilla using this link:
http://bugs.contribs.org/show_bug.cgi?id=8091
Have you checked the Frequently Asked Questions (FAQ)?
http://wiki.contribs.org/SME_Server:Documentation:FAQ
Please also take the time to read the following useful guide:
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
==================================================================
Bug ID: 8091
Summary: monitor mysql
Classification: Contribs
Product: SME Contribs
Version: 8.0
Hardware: ---
OS: ---
Status: CONFIRMED
Severity: normal
Priority: P3
Component: smeserver-sme8admin
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
would be nice to monitor mysql for important values
- status
# mysqladmin status
Uptime: 24713 Threads: 1 Questions: 47604 Slow queries: 0 Opens: 5905
Flush tables: 1 Open tables: 512 Queries per second avg: 1.926
-aborted connection
# echo "SHOW GLOBAL STATUS LIKE 'aborted_connects';"|mysql mysql
Variable_name Value
Aborted_connects 2
-Percentage of used connection
# echo "SHOW GLOBAL VARIABLES LIKE 'max_connections';"|mysql mysql
Variable_name Value
max_connections 100
# echo "SHOW GLOBAL STATUS LIKE 'max_used_connections';"|mysql mysql
Variable_name Value
Max_used_connections 3
-Percentage of full table scans
((Handler_read_rnd_next + Handler_read_rnd) / (Handler_read_rnd_next +
Handler_read_rnd + Handler_read_first + Handler_read_next + Handler_read_key +
Handler_read_prev)).
where :
# echo 'SHOW GLOBAL STATUS LIKE "Handler_read%";'|mysql mysql
Variable_name Value
Handler_read_first 4103
Handler_read_key 38008
Handler_read_next 190097
Handler_read_prev 0
Handler_read_rnd 14222
Handler_read_rnd_next 8666158
--
You are receiving this mail because:
You are the QA Contact for the bug.
_______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at http://lists.contribs.org/mailman/public/contribteam/
