The latest update (v 3.0.9) includes a feature for excluding queries from statistics. To make Jet Profiler ignore certain queries, you need to edit the original query in the application code.

Start the query with /*jp-ignore*/ (no spaces), for example "/*jp-ignore*/ SELECT ... FROM ..."

This will prevent the query from showing up in Top Queries and the other tabs. The query will, however, still affect general preset statistics (such as number of threads running and threads busy). Also make sure that your mysql client library preserves comments - some libraries including the mysql command line client removes comments by default.


Comments

New updates in Jet Profiler 3 include the following improvements:

• Improved multiple instance handling.
• Faster data retrieval.
• New, more efficient MySQL JDBC driver from SkySQL / MariaDB.
• Top Schemas is now available in the free version by default.
• Faster startup time.
• Bug fixes.

To read the full changelog, click here.


Comments

There are a lot of great articles and reviews written about Jet Profiler and we think it's about time they get a bit of attention. Here's a great article, Hands on with Jet Profiler, that was published yesterday by a company called Monitis.

A few highlights from the article:

"I recorded continuously for more than 2 days and Jet Profiler was as responsive at the end as it was at the start. Only the switching between the graphs seemed to get slower when there is more recorded data. But that seems to be logical. Let’s do the math again here to establish the number of queries dealt with over 2 days i.e. 2 days = 48 hours or 2,880 minutes. And with 12,000 queries a minute we have a staggering 34,560,000 queries recorded in those 2



  [Read more...]

New Version of Data Traffic Manager Supports Infinite Application Scalability, a Sleek New Look and Easier-than-Ever Deployment BOSTON – February 12, 2013 — ScaleBase, the company that keeps next gen apps and business-critical databases up-and-running, just released Data Traffic Manager 2.0.  It’s the only database scalability software that solves the three biggest challenges next-gen apps face [...] Read More

This webinar will examine the benefits of Read-Write splitting. To register, click here. There are thousands of new online and mobile apps launching every day…but what happens when demand climbs for these apps and databases can’t keep up?  The long-term success of any app hangs on a company’s ability to provide uninterrupted access and availability – translation: Database performance [...] Read More

MariaDB 5.3 and up and MySQL 5.6 RC introduced real support for milliseconds:
https://kb.askmonty.org/en/microseconds-in-mariadb/
http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html

HeidiSQL now lets you define a LENGTH/SET value for data types which allow a microsecond precision (0-6, where 0 is the default). Also, when editing such TIME, TIMESTAMP or DATETIME values in a grid, HeidiSQL lets you press arrow up/down to increase/decrease the microseconds part of the underlying value. Thanks to rjgebis for the report and documentation links.

We are really getting into the Christmas spirit this year, so we are offering 25% flat discount on all your purchases in the run-up to the big day. Time to go shopping again and buy yourself a gift, and make super savings of the year.

It’s a limited period offer, so head right away to the Online Shop and apply the coupon code save25.

Cheers,
Team Webyog

Tweet

We are excited to announce that the new version of Jet Profiler for MySQL 3 is finally available.

This release includes the following important improvements:
- SSH Tunneling - connect to remote database servers using SSH tunneling.
- HTML Reports - makes saving and sharing the profiling results easier.
- Japanese translation.
- Improved memory management for large result sets.
- Bug fixes.

We also offer a completely new solution called Jet Profiler Enterprise. In addition to all the features in the professional version, it allows multiple instances so you can record from many databases at once. It also supports command line scheduling for automated recording.

For more details please read










  [Read more...]

Industry Leading Database Analyst Matt Aslett, MySQL Pioneer Doron Levari and Industry Veteran Paul Campaniello Host Webinar on The New World Order of NoSQL, NewSQL & MySQL BOSTON – November 7, 2012 — Picking the wrong database can result in slow performance or downtime, frustrated customers and lost revenue.  But navigating the new world order of [...] Read More

We're excited to announce that Jet Profiler for MySQL will be featured on BitsDuJour, a 'deal-of-the-day' website that offers extensive, one-time discounts on a variety of great products.

Jet Profiler for MySQL will be featured at BitsDuJour on Friday, 26 October, at the dramatically reduced price of $249.50 (50% discount). The normal purchase price for Jet Profiler for MySQL is $499.00!

If you have any friends or colleagues who might be interested in Jet Profiler for MySQL, please let them know about this sale. We can't afford to offer this kind of discount often, and it will only be available on BitsDuJour for a single day.

Visit the promotion page on BitsDuJour on Friday 26 October to get Jet Profiler for MySQL for $249.50.







  [Read more...]

Choosing a Next-Gen Database: The new world order of NoSQL, NewSQL & MySQL Tuesday, November 13, 2012, 12:00 PM – 1:00 PM EST The database market is becoming increasingly complex and is changing on an almost daily basis.  Matt Aslett is the Research Manager for Data Management and Analytics at 451 Research.  He has overall responsibility for the coverage [...] Read More

There’s a lot happening in the world of MySQL and it’s really vital to be up-to-date with the latest advancements in this field to stay ahead of the game. Reminds me of this quote by Albert Einstein “Once you stop learning, you start dying.” The easiest way to stay updated is by reading blogs. There are loads of blogs talking about MySQL, and even more for databases in general, so which of these really matter and are worth your time and attention?

We’ve handpicked the best MySQL community/ experts blogs and grouped them into various categories. You can also add these great blogs to your RSS reader to get all industry news, tips that

  [Read more...]

Industry’s First Unified Database Scalability & Replication Solution Now Available for MySQL Environments PERCONA LIVE – NEW YORK – October 1, 2012 — ScaleBase, the company enabling next generation applications that require big data transactional processing, and Codership, the market leader in synchronous multi-master replication, are teaming up to deliver the industry’s first unified database scalability and [...] Read More

While monitoring MySQL servers, managing their configuration becomes important. There could be a need of comparing configuration of one or more MySQL or a server’s running configuration with that of its own My.cnf. Let me explain this a little more.

If you are in a situation where a server ‘A’ is performing better than a server ‘B’ while both have the same resources and environment, then the first thing you might want to do is compare their configuration. Then, make the configuration changes in server ‘B’ looking into ‘A’. There by fine tuning ‘B’ to level up to ‘A’. Comparing MySQL configurations is the key here.

When you change a MySQL

  [Read more...]

Security is always a major concern in an application. But when an application attempts data communication over a network, it becomes even tougher ordeal to keep the connection secure. In this post we will discuss about Secure Shell (SSH) to add an extra security edge to your application when it communicates over a network.

What is SSH Tunnel?

SSH is an encrypted network protocol generally used for remote shell service, secure data communication, command execution etc. In SSH tunneling, a payload protocol is wrapped around the SSH protocol (the delivery protocol) and sent over the network.

When is SSH tunneling useful?

SSH

  [Read more...]

Monitoring MySQL servers is no rocket science provided you know what to monitor. MySQL gives a comprehensive list of variables to check your server’s health and performance. Let me walk you through the crucial variables you should be monitoring. Lets assume that you have one or more MySQL servers, which have been setup and running fine. Here are the top 10 things to monitor on your MySQL.

1. MySQL availability

Yes, this is the first thing you should be looking at! It would not make sense to monitor your MySQL if its not even available. MySQL downtime is simply not acceptable in production. At the same time ensuring zero

  [Read more...]

One of our users has published a “Quick Manual to SQLyog” to his blog.

Sometimes you do better writing about a subject as an ‘outsider’ than as an ‘insider’.  As an ‘insider’ you easily take things for granted that are actually not obvious for everyone.  This is a good example of this – and the writing is excellent. Enjoy!

Tweet

October 1-2, 2012 New York Discover the Power of MySQL » MySQL is the world’s most popular open-source database, powering web-scale applications such as Facebook, YouTube, and Twitter. MySQL continues to evolve rapidly, reaching more markets and powering more applications every day. Click here to register for the conference.  

Yes, it's true, Oracle CEO Larry Ellison has bought 98% of the Hawaiian Island of Lanai for $500m.  The island was previously owned by David Murdock who bought Dole in 1985.  The island has 3,200 residents, two luxury resorts, two golf courses and is 88,000 acres (141 square miles) in size. 

Here are some alternate headlines & subheads

Ellison Buys Island of Lanai
Declares Bill & Melinda Gates Marriage to be in Violation of Oracle Terms of Service

Says "What Island?  I only

  [Read more...]

MySQL is receiving mainstream media attention this week with Twitter publicly deciding to open source work on its MySQL database. Of course, the problems we see every day are being called out. Per GigaOm’s article:

But it [MySQL] has its problems, among them scalability and performance under the pressure of high transaction rates.

Like Twitter, our customer AppDynamics, is working to better manage data at high availability rates, but they’re taking a slightly different tact. In a recent post on the AppSignal blog, Boris Livshutz, introduces what he calls a ‘Data Cloud’ and looks for common ground between SQL and NoSQL

  [Read more...]

Hi,

Webyog and Percona are giving away free tickets to the Percona Live MySQL Conference and Expo, and you can win them! We’re also giving away copies of High Performance MySQL, 3rd Edition!

This year’s event is the best ever, with a better lineup of talks and speakers than ever before.  It’s the one event you should not miss if you’re at all interested in MySQL.  We really want you to be there — and that’s why we’re joining with Percona to give away free tickets! It’s easy to enter:

• Follow our Twitter feed, and

  [Read more...]

Newly appointed Paul Campaniello to bring years of emerging markets experience to growing database middleware company

NEWTON, MA – March 5, 2012 – ScaleBase, the database infrastructure company, announced today that Paul Campaniello has joined the company as Vice President of Global Marketing. ScaleBase enables organizations to instantly respond and adapt to dynamic business requirements.

The ScaleBase Data Traffic Manager is a simple solution that dynamically manages and scales your MySQL database to meet the demands of your business. ScaleBase delivers real time elasticity, increases availability and improves capacity planning – all without requiring any changes to your existing infrastructure.

Campaniello brings 25 years of experience working with rapidly-growing software companies,

  [Read more...]