MemSQL, a leader in distributed in-memory database technology, has announced the release of MemSQL Ops 2.0. MemSQL Ops provides real-time insight into high-level health and performance of the cluster, with metrics that include the context of performance bottlenecks so that database administrators (DBAs) can see performance trends and prevent potential problems. This latest release allows companies to take advantage of the full speed, scale and simplicity of MemSQL.
We built our database to be the fastest and most scalable in the world,” said Eric Frenkiel, CEO and co-founder of MemSQL. “This new release of MemSQL Ops is also one of the easiest to manage, so our customers continue to get the best performance and return on their investment.”
Real-Time Performance Insights
MemSQL Ops dashboards deliver powerful new functionality that addresses the three fundamental issues associated with optimizing a database: performance monitoring, capacity planning and problem diagnosis. MemSQL Ops 2.0 provides real-time monitoring and alerts to help DBAs get optimum performance for their MemSQL cluster. MemSQL Ops delivers out-of-box dashboards to answer key questions that seasoned DBAs typically ask; it also delivers the ability to fully customize or create new dashboards. One of the out-of-box dashboards includes a Hot Tables view that zeroes in on tables that are most active in each cluster. This helps DBAs understand exactly why they are running out of memory in a cluster and offers a quick route for preventive action.
In-memory databases continue to rapidly gain market acceptance as more organizations aim to deal simultaneously with both the volume and velocity aspects of big data. MemSQL delivers extreme performance at scale with its distributed and optimized NewSQL offering, whether it is running on commodity hardware or in a cloud,” said Enterprise Strategy Group analyst Nik Rouda. “This release makes it much easier for database administrators to manage clusters of any size; it quickly finds hot spots or resource issues through an intuitive, visual dashboard and enables users to better tune the environment for best results.”
Graphical Performance Trends
The Cluster dashboard provides graphical insight into the performance of individual nodes, as well as of the cluster as a whole, with reports on reads, writes and real-time usage of every CPU core, memory and disk usage, and on the network performance of each individual node. This graphic format makes it easy for DBAs to visually identify and diagnose problems affecting individual nodes, a process that would otherwise require time-intensive guesswork from the command line.
Deep-Dive Analytics and Statistics
The Analytics dashboard is customizable, so DBAs can receive real-time analytics on selected performance metrics at the granularity they prefer. This level of detail and the easy-to-use interface make the Analytics dashboard an excellent tool for maximizing cluster performance and understanding how users interact with an application.
The Table Stats dashboard is a powerful analytics tool that provides statistics on memory usage broken out by database, table, column and index. The dashboard also provides statistics on query performance, letting the user easily browse, sort and examine queries that have run on the cluster. In seconds, DBAs can examine memory usage at a granular level and know which queries run longest or most often. This tool eliminates the guesswork from capacity planning and makes query analysis a simple point-and-click task.
Sign up for the free insideBIGDATA newsletter.