MySQL Tuning with HQ

by Scott Feldstein on May 7, 2008 at 10:11 am | In HQ | No Comments

This past Monday, May 5th, I had the opportunity to speak at Community One on Scaling MySQL.  The presentation was based on several months of work to integrate and tune MySQL in to our fastest supported database.  MySQL is the fourth database I have developed on, and while working with it I have found a bunch of nice features that are simple to use which made HQ run extremely fast.  Unfortunately MySQL has some big issues with their query optimizer that made the work a bit more tedious than it needed to be.

Here are my top 3 keys to tuning MySQL ->

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • YahooMyWeb
  • Digg
  • e-mail
  • Facebook
  • Google
  • Reddit
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • TwitThis

Add comment May 7th, 2008

Hyperic Announces MySQL Performance Study Results

by Hyperic Press Desk on May 7, 2008 at 7:00 am | In Featured, HQ, IT Industry, Press, Press Releases | No Comments

MySQLFirst Enterprise Application to Prove MySQL Supports Immense Scale

JAVAONE—San Francisco, Calif. - News Release:

  • Today at JavaOne, Hyperic (Booth #1028), announced the results of a large scale performance study on Hyperic using Sun Microsystems’ MySQL database as a backend.
  • Results showed Hyperic monitoring upwards of 2.3 million metric transactions per minute.
  • These results definitively prove that MySQL and Hyperic can be a compelling option for even the most demanding enterprise and web applications.
  • Hyperic customer CNET was part of large-scale beta testing of MySQL on Hyperic.

About the tests:

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • YahooMyWeb
  • Digg
  • e-mail
  • Facebook
  • Google
  • Reddit
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • TwitThis

Add comment May 7th, 2008

Resin and HQ are Getting Along Again

by Marty Messer on May 6, 2008 at 11:58 am | In HQ, Hyperic Hints | No Comments

HQ and Resin user’s might have noticed that somewhere around the Resin 3.0.2x release time frame HQ stopped collecting metrics from some key values that most folks found rather important. For example, per Webapp the following metrics were no longer being collected:

Request Count
Request Count per Minute
Request Read Bytes
Request Read Bytes per Minute
Request Time
Request Time per Minute
Request Write Bytes
Request Write Bytes per Minute

Well as of Resin 3.1.6 released on May 5th, these metrics are back! Thanks to the Engineering team at Caucho, turning on JMX statistics for these key metrics is as easy as adding <statistics-enable/> to either <web-app-default> or a specific <web-app> defined in resin.conf.  Restart Resin and like magic you’ll see metrics flowing again into HQ.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • YahooMyWeb
  • Digg
  • e-mail
  • Facebook
  • Google
  • Reddit
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • TwitThis

Add comment May 6th, 2008

Google for SysAdmins

by javier on May 5, 2008 at 11:53 am | In HQ, IT Industry, Javiers Blog | No Comments

I’ve been spending a lot of time lately talking to the management team here at Hyperic about the subject of search. Specifically, Google search since its what most of our users tend to find us with. (No disrespect to our good friends at Ask.com whose search engine seems to be less popular with the sysadmin crowd).

Perhaps the greatest irony of working in the management software business is the fact that the problems our products solve are the same ones that keep people from finding us. After all, who has time to look for new software when you’re busy fighting fires, right?

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • YahooMyWeb
  • Digg
  • e-mail
  • Facebook
  • Google
  • Reddit
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • TwitThis

Add comment May 5th, 2008

Ask not what HQ can do for you…

by Marty Messer on May 2, 2008 at 2:30 pm | In Community, HQ | No Comments

Since the introduction of the HQU Plugin Framwork, we’ve seen a lot of activity in the Hyperic community around using this new capability to take HQ places it’s never been before.  I might be biased, but quite honestly the idea alone of HQU makes me a bit giddy.  Anytime I see this kind of power being put in the hands of users and administrators I know something good is happening.  No longer are users tied to official release schedules to bring new functionality to HQ.  No longer is the intended use of HQ the only use of HQ.  No longer are the tools of production held solely by the select few.  Power to the people!

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • YahooMyWeb
  • Digg
  • e-mail
  • Facebook
  • Google
  • Reddit
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • TwitThis

Add comment May 2nd, 2008

Hyperic Newsletter

by John Mark on May 1, 2008 at 2:10 pm | In Community, newsletter | No Comments

The latest edition of the Hyperic newsletter is now out! Read about the Hyperic HQ 3.2.3 release, our partnership with Terracotta, the new Oracle Application Server, the Velocity Conference, and much more!

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • YahooMyWeb
  • Digg
  • e-mail
  • Facebook
  • Google
  • Reddit
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • TwitThis

Add comment May 1st, 2008

Hyperic to support Oracle Application Server and OC4J

by Gerardo Viedma on April 30, 2008 at 4:47 pm | In Community, HQ, HQ Beta, IT Industry | No Comments

Oracle Application ServerToday, Hyperic is sharing an exciting new plugin as part of our ongoing preview of Hyperic HQ 4.0. The beauty of this plugin is it actually supports TWO products:

As a relative new-comer to the Hyperic Engineering team, I would like to use this opportunity to introduce myself to the community. I spent the previous two years as a platform engineer working on the Oracle Communication and Mobility Server. At Oracle, I helped integrate the J2EE and SIP application servers, exposing management and configuration features via Java Management Extensions (JMX).

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • YahooMyWeb
  • Digg
  • e-mail
  • Facebook
  • Google
  • Reddit
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • TwitThis

Add comment April 30th, 2008

Barry Klawans is at Hyperic

by Stacey Schneider on April 30, 2008 at 4:34 pm | In HQ, IT Industry | No Comments

The good things keep happening every day here at Hyperic. Today’s good news is that Barry Klawans has officially joined our team!

Barry Klawans at Hyperic

Many of you know Barry as the co-founder and longtime CTO of JasperSoft. Barry recently took leave of JasperSoft to find something that let him enjoy his family more. However, for those of you that know Barry well - his big brain is always cooking, and he can’t stay still for long. We’re excited that Barry is joining us at Hyperic on a part-time basis to do some more work on our JasperSoft integration. He’s actually cooking up a whole new ad-hoc reporting tool that is sure to cause millions of Hyperic-lovers out there to swoon.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • YahooMyWeb
  • Digg
  • e-mail
  • Facebook
  • Google
  • Reddit
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • TwitThis

Add comment April 30th, 2008

HQ 3.2.3 is Now Available

by Marty Messer on April 23, 2008 at 9:20 am | In HQ | 1 Comment

Like clockwork, the good people of Hyperic Engineering have shipped the third maintenance release for the HQ 3.2 family.  This release is a roll-up of the handful of bug fixes since HQ 3.2.2.  We’d like to thank those customers and users that took the time to let us know how we could improve on HQ 3.2; this one’s for you!

For a rundown of the fixes available in HQ 3.2.3, check out the Release Notes for the high level summary and a link to more detail to determine if you should consider upgrading to 3.2.3.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • YahooMyWeb
  • Digg
  • e-mail
  • Facebook
  • Google
  • Reddit
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • TwitThis

1 comment April 23rd, 2008

Undifferentiated Heavy Lifting

by javier on April 21, 2008 at 11:25 am | In Events, IT Industry, Javiers Blog | 4 Comments

This phrase was used close to a dozen times by Werner Vogels, CTO of Amazon.com at his recent keynote at the MySQL conference. Werner used it to describe the day to day tasks of most web operations teams… tasks like racking boxes, configuring routers, and installing software. He mentioned ops teams at Amazon got to spending 70% of their time in this mode, and this was one of the main catalysts for developing infrastructure that brings us S3, SQS, EC2, and more.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • YahooMyWeb
  • Digg
  • e-mail
  • Facebook
  • Google
  • Reddit
  • Slashdot
  • SphereIt
  • StumbleUpon
  • Technorati
  • TwitThis

4 comments April 21st, 2008

Previous Posts