Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 39

Displaying posts with tag: MySQL Enterprise (reset)

MySQL Query Analyzer: Tracking query executions
+0 Vote Up -0Vote Down

From a performance standpoint, sometimes even tightly tuned queries can cause a performance drag. The common problem here is not one of actual query performance, rather it is a function of:

- the velocity and frequency that a query is submiited for execution
- the total execution time of the aggregated executions

This could be symptomatic of an application not properly configured for caching (see Darren Oldag's blog on this!), or just overall poor design. Regardless of why, when or how we all know …




  [Read more...]
MySQL Query Analyzer: DBA Task #1: Finding Bad Queries
+0 Vote Up -0Vote Down

One of the biggest problems I faced as a field DBA was defending my production databases against poorly performing SQL code. Talking to folks at the MySQL UC, during customer visits and trolling the MySQL forums/blogs confirms that this is a common problem and even more challenging when a performance problem pops up during times when no code promotions have taken place.

Traditional/popular way of finding bad SQL code
For MySQL DBAs the challenge to identify and isolate resource intensive SQL code is really two-fold; job #1 is to find the offending code (after that the chore becomes fixing it so it performs, but that …


  [Read more...]
MySQL Enterprise Monitor: Agent = Extensibility
+0 Vote Up -0Vote Down

I have gotten a few questions around my 7/29 blog posting on agent vs client-side products and wanted to make it clear that our decision to go with a distributed agent architecture was a strategic decision that has paved the way for us to deliver on our overall "pain point" addressing roadmap. True, building a client-side app would have meant a faster go-to-market delivery, but that path would have imposed serious limitations on our ability to address and alleviate common pain points around the use and scaling of apps on …

  [Read more...]
MySQL Query Analyzer: Open Beta Coming!
+0 Vote Up -0Vote Down

We are quickly approaching opening up the MySQL Query Analyzer for general beta and I wanted to pass along an open invite to the following related and informational events.

On 8/13, I will be doing a micro level presentation on MySQL Enterprise. Please attend and learn more about the database software, monitoring and advisor services and support solutions that make up a subscription. I plan to do a demo of the Enterprise Monitor and the new Query Analyzer; that alone makes attending worth the price of admission (in this case 45 minutes of your time!). Learn more and register …

  [Read more...]
MySQL Enterprise Monitor: Competition is a good thing!
+0 Vote Up -0Vote Down

As the Product Manager for MySQL Enterprise and the Enterprise Monitor I am constantly being asked questions from our Sales team, prospects, customers, etc. about how our products stack up against competing products. This is tough for a PM because competitive situations change with each new release cycle and ISVs (both free/open and commercial) with agile development practices can deliver new features in very short order. Further, getting into a feature-feature discussion is a no win situation because someone will ALWAYS have more check marks. Also, I tend to be more …

  [Read more...]
Comparison - Monolith vs. MySQL Enterprise Dashboard
+0 Vote Up -0Vote Down

I’m attempting this is be as unbiased as possible, since I write the Monolith application. This will hopefully help one decide between a free MySQL server monitoring system and paying for a per-server based licensed product. Both have strengths and weaknesses that should be pointed out before making a decision. You can infer the weaknesses based on the strengths below. That said, let’s just get into it.

Strengths of each product over the other

Monolith - MySQL DBA Console

  • presents overall database size, index size, data size, number of schema per server, and aggregate statistics for all monitored servers
  • runs mysql …
  [Read more...]
Memcached and MySQL: webminar from a Web 2.0 company
+0 Vote Up -0Vote Down

At OSCON, Brian and Dormando gave their ever famous talk, Memcached and MySQL: Everything You Need To Know. I didn’t attend the tutorial, but they assured me it was similar to what was given at the MySQL Conference 2008 (everything, but the very nice buttons dormando was giving out with the memcached logo!). Great, because not only is …

  [Read more...]
Q&A and Recording of the Memcached Webinar
+0 Vote Up -0Vote Down

The session has been recorded. The webex file and the webinar are available here.

Here is the Q&A session, with more detailed answers.

Q from Tomasz: You said memcached is integrated with, among others, MySQL. Did you mean integration by e.g. php or direct, automatic integration?
A: Memcached API are available for many enviroments, such as Php, Perl, C/C++, Rails etc. With MySQL, you can use UDF functions or a storage engine. Both are community projects.

Q from Juan: memcached: Facts data …






  [Read more...]
Webinar - Another webinar on MySQL Enterprise
+0 Vote Up -0Vote Down

For the MySQL users who are still unfamiliar with the new features of MySQL Enterprise (2007 Fall Edition), I will present a webinar on this topic on Monday 3rd of March @ 3pm CET. The webinar will be in Italian, but the slides are rigourously in English, so if you are interested, just wait approx one week and you will be able to download slides and recording of this event.

The latest version of MySQL Enterprise is powered with an improved version of the Enterprise Monitor, which has a new set of Replication advisors and new set of cool graphs, to instantly control your servers. There is also a big improvement in the overall scalability of …

  [Read more...]
10 Newer Entries Showing entries 31 to 39

Planet MySQL © 1995, 2016, 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.