Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 20

Displaying posts with tag: monitor (reset)

Monitoring Related OpenWorld Talks
Employee_Team +0 Vote Up -0Vote Down

I gave two monitoring related talks at OpenWorld, thanks to all that came along!

Both were monitoring related, the first an introduction to MySQL Enterprise Monitor, and the second a look at some of the new instrumentation that is getting developed, primarily within the MySQL 5.6 release. 

If you'd like to get a quick overview of how MySQL Enterprise Monitor works, then take a look through the "Getting to Know MySQL Enterprise Monitor" talk. This gives you a high level view of how the different pieces fit together, and then each of the important factors within the user interface:

Getting to Know MySQL Enterprise Monitor

And if you are interested in seeing how the instrumentation and monitoring

  [Read more...]
Monitoring Related OpenWorld Talks
Employee_Team +0 Vote Up -0Vote Down

I gave two monitoring related talks at OpenWorld, thanks to all that came along!

Both were monitoring related, the first an introduction to MySQL Enterprise Monitor, and the second a look at some of the new instrumentation that is getting developed, primarily within the MySQL 5.6 release. 

If you'd like to get a quick overview of how MySQL Enterprise Monitor works, then take a look through the "Getting to Know MySQL Enterprise Monitor" talk. This gives you a high level view of how the different pieces fit together, and then each of the important factors within the user interface:

Getting to Know MySQL Enterprise Monitor

And if you are interested in seeing how the instrumentation and monitoring

  [Read more...]
SQLStats 1.3 released
+2 Vote Up -0Vote Down
I have released SQLStats 1.3 now, and it is available for download from sourceforge. The changes are small:
  • Cleaned up the build script a bit.
  • Fixed a bug that caused statements to be counted twice.
  • Made statement comparison non case sensitive.
  • A small fix to the normalizer, that would miss a few statements in some cases.
SQLStats is a plugin for MySQL 5.5 and up that allows live monitoring of SQL statements, without using the general query log and with the added benefit of managing statements with the literals removed. read more in my previous blog-post in the subject.

Enjoy!
/Karlsson
Careful how you monitor MySQL
+8 Vote Up -0Vote Down

I was recently struck by a problem which is unusual. In order to keep an eye on the database server I use nagios, cacti, merlin (http://www.mysql.com/products/enterprise/monitor.html" target="_blank) and some local scripts to monitor the database instance and ensure that it is working properly.  That normally works fine.  The different monitor processes do various things, one of which is to monitor the replication status of a slave, and warn me if the replication is not working or if it’s behind. This is done with the command SHOW SLAVE STATUS.

The server I was looking at runs some large local batch jobs aggregating data. Unfortunately, I was experiencing that replication was interfering with these batch jobs so decided to see if things would perform better if

  [Read more...]
Don’t forget to monitor your nameservers
+0 Vote Up -0Vote Down
As I mentioned in a past article I got my IPv6 connectivity working so started working on setting up various IPv6 services. One of these was to setup my name server so it also worked on IPv6. This worked fine, but recently I lost my IPv6 connectivity but thought no more about it. I’m trying [...]
Enable MySQL Enterprise Plugin for Connector/NET
Employee +1 Vote Up -0Vote Down

Figure 1. Source Location

In a prior post ( Trace SQL From Database to Source Code ), I showed how to enable SQL trace capabilities for java/MySQL application to trace SQL statements from the database to the exact line of code from which the statement was executed (see Figure 1).  In this post, I’ll enable SQL tracing in the sample C# application, which is included with the MySQL Connector/NET (MySQL’s ADO.NET provider ) install.

The following instructions assume that the MySQL

  [Read more...]
Trace SQL From the Database to the Source Code with MySQL Enterprise Monitor
Employee +3 Vote Up -0Vote Down

OK, you found the problem SQL statement that was affecting your server’s performance, now where did it originate?

The new MySQL Enterprise Plugins for Connector/J and Connector/NET send query statistics, including the source location for each query, directly to the MySQL Enterprise Monitor.

Figure 1 is a screenshot of new source location feature.

Figure 1. Source Location

Figure 2 shows the standard query statistics, which are collected in the query analyzer.  In both cases, the statistics are gathered by the MySQL Connector and the Plugin, not MySQL proxy.

  [Read more...]
Monitor multiple mysql replication using php: Updated
+0 Vote Up -0Vote Down
Monitoring a replication is an important aspect. As replication includes multiple nodes, it is essential to track activity and status across all mysql servers involved in replication. To monitor replication we know commands like: Show slave status; Show master status; Refer: http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-replication.html But when it comes to non-gui interface, it becomes little tedious. With some […]
Agents, Hosts and Instances, Oh My!
Employee +0 Vote Up -0Vote Down
What defines instances for the MySQL Enterprise Monitoring (MEM) software and how do they relate to either other and the workings of MEM? 
Agents, Hosts and Instances, Oh My!
Employee +0 Vote Up -0Vote Down
What defines instances for the MySQL Enterprise Monitoring (MEM) software and how do they relate to either other and the workings of MEM? 
Agents, Hosts and Instances, Oh My!
Employee +0 Vote Up -0Vote Down
What defines instances for the MySQL Enterprise Monitoring (MEM) software and how do they relate to either other and the workings of MEM? 
MySQL University: Customizing MySQL Enterprise Monitor
Employee +0 Vote Up -0Vote Down
Today (September 10, 13:00 UTC), Mark Leith will show how to customize the MySQL Enterprise Monitor: Customizing MySQL Enterprise Monitor. Mark is a MySQL support manager, and knows Enterprise Monitor by heart.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All MySQL

  [Read more...]
MySQL University: Customizing MySQL Enterprise Monitor
Employee +0 Vote Up -0Vote Down
Today (September 10, 13:00 UTC), Mark Leith will show how to customize the MySQL Enterprise Monitor: Customizing MySQL Enterprise Monitor. Mark is a MySQL support manager, and knows Enterprise Monitor by heart.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All

  [Read more...]
MySQL University: Customizing MySQL Enterprise Monitor
Employee +0 Vote Up -0Vote Down
Today (September 10, 13:00 UTC), Mark Leith will show how to customize the MySQL Enterprise Monitor: Customizing MySQL Enterprise Monitor. Mark is a MySQL support manager, and knows Enterprise Monitor by heart.

For MySQL University sessions, point your browser to this page. You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) All

  [Read more...]
MEM with missing Agents?
Employee +0 Vote Up -0Vote Down

You could set this up simply by adding the no_proxy option to the .curlrc file of the MEM  user to make the change permanent. Remember that to turn off the proxy for all connections, you would use:

$ setenv  no_proxy  '*'

MEM with missing Agents?
Employee +0 Vote Up -0Vote Down

You could set this up simply by adding the no_proxy option to the .curlrc file of the MEM  user to make the change permanent. Remember that to turn off the proxy for all connections, you would use:

$ setenv  no_proxy  '\*'

MEM with missing Agents?
Employee +0 Vote Up -0Vote Down

You could set this up simply by adding the no_proxy option to the .curlrc file of the MEM  user to make the change permanent. Remember that to turn off the proxy for all connections, you would use:

$ setenv  no_proxy  '\*'

MySQL Enterprise Monitor documentation public now
Employee +0 Vote Up -0Vote Down

The MySQL Enterprise Monitor continuously monitors MySQL servers and alerts to potential problems before they impact the system. It helps eliminating security vulnerabilities, improves replication, optimizes performance, and more. Its newest feature, Quan (Query Analyzer), helps identify queries that could be tuned to improve performance. Quan enables database administrators to do the work that would otherwise require hours in just minutes, or even seconds, and it provides ongoing statistical information about the performance of your queries.

MySQL Enterprise Monitor is a commercial offering by Sun Microsystems, and so was the documentation. To help anyone (even if they're not customers) get a better and complete understanding of what exactly MySQL Enterprise Monitor is about and what it can do, we've decided to make its full documentation publicly available.

  [Read more...]
Capacity Planning, Architecture, Scaling, Response time, Throughput
+0 Vote Up -0Vote Down
First of all let me start off saying that I learned a lot of Capacity Planning from two people. Jozo Dujmovic, and John Allspaw-who by the way is coming out with a book.

Capacity != Performance
. You may have the capacity to do a bubble sort but a bubble sort is still a bubble sort.

Really to Scale you need to know when your application will break. I have a tool set to help determine what application is producing what SQL and use that to figure out which SQL is producing the most load on the system. Some common tricks I do is put the execution path automatically as a SQL comment, then sample the FULL Processlist to build a graph on what application, function, SQL pattern is the top load.

On top of that I use





  [Read more...]
MySQL Conference Liveblogging: Benchmarking Tools (Wednesday 4:25PM)
+0 Vote Up -0Vote Down
  [Read more...]
Showing entries 1 to 20

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.