Showing entries 61 to 70 of 311
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: News (reset)
New feature: Display UNIX timestamps as date/time values

One of the best new ideas in my eyes came from quelbs. Using an integer column for storing UNIX timestamp values is a wide spread approach in the world of web development. For example in a Typo3 database, all date/time handling is done with UNIX timestamps. Unfortunately, for MySQL this is of course a normal integer value, with no meaning of being a date/time value.

Now, HeidiSQL allows the user to explicitly set a column to "This is a UNIX timestamp" via right click menu. Once activated, integers are internally converted to and displayed as human readable date/time values. Editing such values also uses the inplace editor for date values.

MySQL Workbench 6.0 – A Sneak Preview

The MySQL Workbench team has been a little quiet for the past few months, but that’s because we’ve been busy working on an exciting new version. Read more about it in Tomas’ blog

Excluding queries from statistics

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

Jet Profiler 3 updates

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

Hands on with Jet Profiler

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 days."

"Without going through all the great features of Jet …

[Read more]
ScaleBase Releases Version 2.0 of its MySQL Database Scalability Software

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

MySQL Workbench 5.2.46 released

The MySQL developer tools team announces the availability of version 5.2.46
of the MySQL Workbench GUI tool. This version contains 30 resolved bugs
and support for the new MySQL 5.6 server.

Additionally, MySQL Utilities 1.2.0 have been included on the distribution.

For a full list of issues fixed in this release, see the release notes.

Please get your copy from our Downloads site. In Windows, you can also
use the MySQL Windows Installer to update Workbench and other MySQL products.

Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

Workbench Documentation can be found …

[Read more]
Scaling MySQL: Catch 22 of Read-Write Splitting | January 17, 2013 2:00pm EST

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

New feature: Microseconds in DATE/TIME values

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.

New feature: Microseconds in DATE/TIME values


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.

Showing entries 61 to 70 of 311
« 10 Newer Entries | 10 Older Entries »