USA: +1-866-221-0634
Canada: +1-866-221-0634
Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447
Japan: 0120-065556
China: 10800-811-0823
India: 0008001005870
Brazil: +55 11 5189-1097
| General | |
| 1. | Check the health, security, performance and available of all your MySQL servers from a consolidated view. |
| 2. | Monitor 600+ MySQL and OS specific variables. |
| 3. | Use 160+ MySQL provided Advisor Rules to enforce security, performance, replication best practices. |
| 4. | Define and customize thresholds and alert severity levels to meet your specific requirements. |
| 5. | Automatically receive new and updated Advisor Rules and MySQL/OS Graphs periodically as soon as they are available. |
| 6. | Quickly test applications to ensure they are secure, tuned and working efficiently before deploying them into production. |
| 7. | Make it easier to get approvals for hardware upgrades by sending a graph to your boss that shows CPU/memory utilization creeping towards the danger zone over a period of time. |
| Monitoring | |
| 8. | Download, install, configure and begin proactively monitoring all MySQL servers within 20 minutes. |
| 9. | Auto detect, group and monitor all of your Replication topologies. |
| 10. | Use Use color-coded server heat chart for at-a-glance view into the health, security and performance of all your MySQL servers. |
| 11. | Monitor groups of MySQL servers by different Service Level Agreement (SLA) requirements. |
| 12. | Monitor all your MySQL servers or only specific groups of MySQL servers. |
| 13. | Monitor and get alerted to only events you deem critical. |
| 14. | Monitor your MySQL servers across multiple geographic locations. |
| 15. | Monitor your MySQL servers remotely from home or away from the office. |
| 16. | Quickly identify the up/down status of your MySQL servers. |
| 17. | Quickly correlate OS system performance spikes with MySQL related performance issues. |
| 18. | Visually correlate MySQL and OS performance issues with query activity quickly. |
| 19. | Help predict when you will need more hardware to scale-out further using graphs of historical data. |
| Query Analyzer | |
| 20. | Quickly find and tune the queries behind system performance spikes. |
| 21. | Identify and fix poorly-written queries across all your MySQL servers from a single console. |
| 22. | Collect, aggregate and analyze queries across all your MySQL servers, with no dependence on Query Log or SHOW PROCESSLIST using several flexible configuration options. |
| 23. | Analyze queries aggregated by execution times, number of executions, total rows, or total bytes. |
| 24. | View an EXPLAIN to determine the current access path and index usage. |
| 25. | View historical queries by a specific time interval or by a date/time range. |
| 26. | View and sort queries by MySQL server, application grouping, database, query type or content. |
| 27. | Analyze query load across all your MySQL replicated read slaves. |
| 28. | Easily find newly deployed queries by when they were first seen. |
| 29. | Tag queries you want to watch as they are tuned. |
| 30. | Test and tune your code during development before it is promoted to production. |
| 31. | Sample queries during non-peak hours for later analysis. |
| 32. | Quickly detect when new or changed queries are first seen. |
| 33. | Filter for specific query problems like full table scans and bad indexes using advanced global search options. |
| 34. | Perform in-depth cause analysis using MySQL Connector Plug-ins. |
| Performance | |
| 35. | Receive tailored advice on how to tune MySQL's built in caching capabilities to improve throughput. |
| 36. | Get immediately notified if indexes have been altered or dropped which will impact and performance of your database. |
| 37. | Get alerted to poorly running queries so you can improve application performance. |
| 38. | Monitor dynamic metrics over time and leverage advice on tuning for optimal performance. |
| Administration | |
| 39. | Monitor MySQL Enterprise Backup operations and quickly identify backup related issues or servers that need backup. |
| 40. | Resolve issues quickly using MySQL recommended commands to fix security, replication, schema, and performance issues. |
| 41. | Notify multiple DBAs as a single group when thresholds are violated so that critical alerts are addressed immediately. |
| 42. | Quickly identify the version numbers of all of my MySQL Servers so you can make sure they are all current. |
| 43. | Get immediately notified if databases or tables have been altered or dropped. |
| 44. | Learn from others' experience using historical annotations on issues that have been previously corrected and closed. |
| 45. | Get notified before maximum connection limits are reached to ensure the server does not run out of resources. |
| 46. | Gain deeper insight into reported issues with the integrated MySQL Enterprise Knowledge Base and MySQL Reference Manual. |
| 47. | Ensure your MySQL servers are configured for highest level of performance and recoverability |
| 48. | Ensure your MySQL Servers are configured to detect/identify poorly performing queries |
| Replication | |
| 49. | Monitor configuration, synchronization and performance of master/slaves configured for semi-synchronous replication. |
| 50. | Quickly identify and resolve MySQL replication latency issues such as Slave Lag. |
| 51. | Get notified if a slave has been stopped or has stopped replicating to ensure read capacity is maintained. |
| 52. | Verify that slaves are configured to start as masters if necessary. |
| 53. | Determine exactly which thread or permission setting has stopped the replication process. |
| 54. | Secure slaves by ensuring that ALTER TABLE and DROP TABLE statements are not replicated. |
| 55. | Monitor the status of all your Master/Slaves from a consolidate view. |
| 56. | Drill into each Master/Slave for status details. |
| 57. | Ensure Binary Log purge frequency and size limits are configured correctly. |
| 58. | Identify network issues that impact Master/Slave synchronization. |
| 59. | Identify and correct Relay log issues that can lead to Master/Slave synchronization issues. |
| Security | |
| 60. | Resolve security vulnerabilities across all MySQL servers in under 20 minutes. |
| 61. | Get immediately notified of security vulnerabilities as they occur, such as Accounts without Passwords, Accounts with Global Privileges, and Servers with Anonymous Accounts. |
| 62. | Get notified if privileges are being granted or revoked without your knowledge. |
| 63. | Determine if you have appropriately limited external domain access to your server. |
| 64. | Verify that user accounts don't have powerful file write privileges. |
| 65. | Monitor dynamic security settings over time and close loopholes as they occur. |
| 66. | Use single sign-on capabilities through LDAP integration. |
| MySQL Cluster | |
| 67. | Monitor health and performance of MySQL Cluster data nodes. |
| Customization | |
| 68. | Use the MySQL provided Advisor Rules as a template to build your own custom Advisors. |
| 69. | Create and manage server groupings (by location, application, etc.). |
| 70. | Create targeted notification groups (by server, location, application, etc.). |
| 71. | Create custom SMTP and SNMP notifications. |
| 72. | Apply custom thresholds and alerts for specific servers, applications, notification groups. |
| 73. | Get live feeds for your open support issues. |
| 74. | Get live feeds for MySQL product updates, announcements and alerts. |
| 75. | Resolve problems faster by providing the option to collect and package server specific MySQL, OS and query diagnostic for MySQL Support. |
