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 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 199 Next 30 Older Entries

Displaying posts with tag: Announcements (reset)

Slides from Percona MySQL University Portland – Conquering “Big Data”: An introduction to Shard-Query
+0 Vote Up -0Vote Down

I posted the slides to my talk on SlideShare.  This talk includes high level information about Shard-Query, why it is needed, and the kind of schema it works well with.
http://www.slideshare.net/MySQLGeek/introduction-to-shard-query-m

You can also find a more technical information about Shard-Query and the how it works here:

Divide and conquer in the cloud from Justin Swanhart


  [Read more...]
MySQL Workbench 6.0.2 BETA1 released
Employee +4 Vote Up -0Vote Down

The MySQL Developer Tools team is pleased to announce the availability of the first beta release of MySQL Workbench 6.0.

MySQL Workbench 6.0 is the new major update of the Development and Administration tool for MySQL. This release includes over 100 bug fixes, 30 new features and a new redesigned UI. As a beta, this release is not suitable for production use.  Please test and file your bug reports at http://bugs.mysql.com

As always, MySQL Workbench is natively available on Windows, Mac, Linux.

Improvements in MySQL Workbench 6.0:

  • a new redesigned Home screen
  • the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific
  [Read more...]
MySQL Workbench 6.0.2 BETA 1 released
Employee_Team +1 Vote Up -0Vote Down
The MySQL Developer Tools team is pleased to announce the availability of the first beta release of MySQL Workbench 6.0. MySQL Workbench 6.0 is the new major update of the Development and Administration tool for MySQL. This release includes over 100 bug fixes, 30 new features and a new redesigned UI. As a beta, this release is not suitable for production use.  Please test and file your bug reports at http://bugs.mysql.com

As always, MySQL Workbench is natively available on Windows, Mac, Linux.

Improvements in MySQL Workbench 6.0:

  • a new redesigned Home screen
  • the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
  • improved model Synchronization, lets
  [Read more...]
Bulk insert into tables in sorted order to avoid deadlocks
+2 Vote Up -0Vote Down

Shard-Query inserts data into a “coordinator” table when answering queries.   When there is a GROUP BY on the original query, the coordinator table contains a UNIQUE KEY over the GROUP BY attributes.   Shard-Query uses INSERT .. ON DUPLICATE KEY UPDATE in combination with bulk insert (insert into … values (),(),() ) when inserting into the table.

For what would normally be efficiency sake, Shard-Query sends queries to the shards using ORDER BY NULL which disables the filesort operation. Of course, this often results in the rows being sent back from the shards in random order.

Because the results are in random order, the bulk insertion that the worker does into the coordinator table can deadlock with other worker threads when using InnoDB or TokuDB as the coordinator table. Right now I’ve just been using MyISAM for the

  [Read more...]
Fix for INFORMATION_SCHEMA.PARTITIONS losing table stats
+0 Vote Up -0Vote Down

Here is a fix for the MySQL/TokuDB/MariaDB bug I reported earlier today.  I think this fix is correct (it is only one line) but I don’t delve into the storage engine very often (and particularly not into ha_partition.cc) so I think it would be good to wait for Oracle (or Percona, MariaDB, or Tokutek) to validate that it is correct before using it.

diff -u ha_partition.cc /tmp/ha_partition.cc 
--- ha_partition.cc 2013-04-05 05:27:18.000000000 -0700
+++ /tmp/ha_partition.cc 2013-05-27 02:45:01.680676228 -0700
@@ -6455,9 +6455,11 @@
void ha_partition::get_dynamic_partition_info(PARTITION_STATS *stat_info,
uint part_id)
{
+
handler *file= m_file[part_id];
DBUG_ASSERT(bitmap_is_set(&(m_part_info->read_partitions), part_id));
- file->info(HA_STATUS_CONST | HA_STATUS_TIME | HA_STATUS_VARIABLE |
+ 
+ info(HA_STATUS_CONST |
  [Read more...]
Shard-Query 2.0 performance on the SSB with InnoDB on Tokutek’s MariaDB distribution
+2 Vote Up -0Vote Down
Scaling up a workload to many cores on a single host

Here are results for Shard-Query 2.0 Beta 1* on the Star Schema Benchmark at scale factor 10.  In the comparison below the “single threaded” response times for InnoDB are the response times reported in my previous test which did not use Shard-Query.

Shard-Query configuration

Shard-Query has been configured to use a single host.  The Shard-Query configuration repository is stored on the host.  Gearman is also running on the host, as are the Gearman workers.  In short, only one host is involved in the testing.

The

  [Read more...]
Shard-Query 2.0 Beta 1 released
+4 Vote Up -0Vote Down

It is finally here.  After three years of development, the new version of Shard-Query is finally available for broad testing.

This new version of Shard-Query is vastly improved over previous versions in many ways.  This is in large part due to the fact that the previous version of Shard-Query (version 1.1) entered into production at a large company.  Their feedback during implementation was invaluable in building the new Shard-Query features.   The great thing is that this means that many of the new 2.0 features have already been tested in at least one production environment.

This post is intended to highlight the new features in Shard-Query 2.0.  I will be making posts about individual features as well as posting benchmark results.

  [Read more...]
MySQL Workbench 5.2.47 released
Employee_Team +2 Vote Up -0Vote Down

The MySQL developer tools team announces the availability of version 5.2.47
of the MySQL Workbench GUI tool. This is a minor maintenance release, addressing a problem during data copy in databases with triggers, during migrations and server upgrades.

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...]
MySQL Workbench 5.2.46 GA released
Employee +2 Vote Up -0Vote Down

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...]
MySQL Workbench 5.2.46 released
Employee_Team +1 Vote Up -0Vote Down

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...]
MySQL Workbench 5.2.45 GA Released
Employee_Team +2 Vote Up -0Vote Down

The MySQL developer tools team announces the availability of version 5.2.45 of the MySQL Workbench GUI tool. This version contains various fixes and minor enhancements and includes 72 resolved bugs.

This version contains the following significant updates:
- Support for several new MySQL 5.6 features
- Import recordsets from CSV file for the Inserts editor in Modeling and in the SQL Editor
- Improved trigger editor
- more

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

For a full list of issues fixed in this release, see http://dev.mysql.com/doc/relnotes/workbench/en/wb-news-5-2-45.html

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





  [Read more...]
MySQL Workbench 5.2.45 GA released
Employee +2 Vote Up -0Vote Down
The MySQL developer tools team announces the availability of version 5.2.45 of the MySQL Workbench GUI tool. This version contains various fixes and minor enhancements and includes 72 resolved bugs.

This version contains the following significant updates:
- Support for several new MySQL 5.6 features
- Import recordsets from CSV file for the Inserts editor in Modeling and in the SQL Editor
- Improved trigger editor
- more

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

For a full list of issues fixed in this release, see http://dev.mysql.com/doc/relnotes/workbench/en/wb-news-5-2-45.html

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













  [Read more...]
MySQL Workbench 5.2.44 GA Released
Employee_Team +1 Vote Up -0Vote Down

The MySQL developer tools team announces the availability of version 5.2.44
of the MySQL Workbench GUI tool. This version contains various fixes
and minor enhancements and includes 8 resolved bugs.

This version improves the Migration Tool to support additional RDBMSes
- PostgreSQL 8.x and 9.x
- Sybase Adaptive Server Enterprise 15.x
- Any RDBMS that implements the INFORMATION_SCHEMA views from the SQL-92 standard

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

For a full list of issues fixed in this release, see http://dev.mysql.com/doc/workbench/en/changes-5.2.x.html

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

Sources and binary







  [Read more...]
MySQL Workbench 5.2.44 GA released
Employee +6 Vote Up -1Vote Down

The MySQL developer tools team announces the availability of version 5.2.44 of the MySQL Workbench GUI tool. This version contains various fixes and minor enhancements and includes 8 resolved bugs.

This version improves the Migration Tool to support additional RDBMSes
- PostgreSQL 8.x and 9.x
- Sybase Adaptive Server Enterprise 15.x
- Any RDBMS that implements the INFORMATION_SCHEMA views from the SQL-92 standard

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

For a full list of issues fixed in this release, see http://dev.mysql.com/doc/workbench/en/changes-5.2.x.html

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

Sources and binary packages are







  [Read more...]
MySQL Workbench 5.2.43 released
Employee_Team +3 Vote Up -2Vote Down

The MySQL developer tools team announces the availability of version 5.2.43
of the MySQL Workbench GUI tool. This version contains various fixes
and minor enhancements and includes 53 resolved bugs.

With this version, Fedora 15 packages are replaced with Fedora 17.
Also, Gatekeeper in Mac OS X Mountain Lion is now properly handled.

For a full list of issues fixed in this release, see http://dev.mysql.com/doc/workbench/en/changes-5.2.x.html

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

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





  [Read more...]
MySQL Workbench 5.2.42 GA Released
Employee_Team +3 Vote Up -0Vote Down

The MySQL developer tools team announces the availability of version 5.2.42
of the MySQL Workbench GUI tool. This version includes important corrections
over version 5.2.41

For a full list of issues fixed in this release, see  http://dev.mysql.com/doc/workbench/en/changes-5.2.x.html

Please get your copy from our Downloads site.

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 here.

http://dev.mysql.com/doc/workbench/en/index.html

Utilities Documentation



  [Read more...]
MySQL Workbench 5.2.42 GA Released
Employee +3 Vote Up -0Vote Down
The MySQL developer tools team announces the availability of version 5.2.42
of the MySQL Workbench GUI tool. This version includes important corrections
over version 5.2.41

For a full list of issues fixed in this release, see  http://dev.mysql.com/doc/workbench/en/changes-5.2.x.html

Please get your copy from our Downloads site.

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 here.

http://dev.mysql.com/doc/workbench/en/index.html















  [Read more...]
MySQL Workbench 5.2.41 GA + Migration Wizard Available
Employee +3 Vote Up -0Vote Down

The MySQL developer tools team announces the availability of version 5.2.41 of the MySQL Workbench GUI tool. This version has significant improvements in several parts of the tool and also includes the new Migration Wizard plugin.

The new Migration Wizard presents an easy to use GUI for migrating databases from third party products to MySQL. In this initial release, support for Microsoft SQL Server is included, in addition to other products that support ODBC, such as PostgreSQL.

Other improvements include:

  • More than 100 bug fixes
  • Code completion in the SQL Editor (beta)
  • Better handling of schema synchronization in modeling
For a full list of issues fixed in this release, see    [Read more...]
MySQL Workbench 5.2.41 GA + Migration Wizard Available
Employee_Team +3 Vote Up -0Vote Down

The MySQL developer tools team announces the availability of version 5.2.41 of the MySQL Workbench GUI tool. This version has significant improvements in several parts of the tool and also includes the new Migration Wizard plugin.

The new Migration Wizard presents an easy to use GUI for migrating databases from third party products to MySQL. In this initial release, support for Microsoft SQL Server is included, in addition to other products that support ODBC, such as PostgreSQL.

Other improvements include:

  • More than 100 bug fixes
  • Code completion in the SQL Editor (beta)
  • Better handling of schema synchronization in modeling
For a full list of issues fixed in this release, see  http://dev.mysql.com/doc/workbench/en/changes-5.2.x.html  [Read more...]
MySQL Workbench 5.2.40 GA Available
Employee_Team +0 Vote Up -0Vote Down

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench, version 5.2.40.
This version contains more than 28 bug fixes applied over version 5.2.39.

MySQL Workbench 5.2 GA

• Data Modeling

• Query

• Administration

Please get your copy from our Download site.

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 here.

http://dev.mysql.com/doc/workbench/en/index.html

Utilities Documentation can be found here.


  [Read more...]
MySQL Workbench 5.2.40 GA Released
Employee +4 Vote Up -0Vote Down

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench, version 5.2.40. This version contains more than 28 bug fixes applied over version 5.2.39.

MySQL Workbench 5.2 GA

• Data Modeling

• Query

• Administration

Please get your copy from our Download site.

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 here.

http://dev.mysql.com/doc/workbench/en/index.html

Utilities Documentation can be found here.

  [Read more...]
MySQL Workbench 5.2.39 released
Employee_Team +0 Vote Up -0Vote Down

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench, version 5.2.39.
This version contains MySQL Utilities 1.0.5, a set of command line Python utilities for helping performing and scripting
various administration tasks for MySQL. A complete list of changes in this release of the Utilities can be found at:
http://dev.mysql.com/doc/workbench/en/wb-utils-news-1-0-5.html

MySQL Workbench 5.2 GA

  •  Data Modeling
  •  Query (replaces the old MySQL Query Browser)
  •  Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.






  [Read more...]
MySQL Workbench 5.2.39 GA Released
Employee +1 Vote Up -0Vote Down

The MySQL Developer Tools team is announcing the next maintenance release of its flagship product, MySQL Workbench, version 5.2.39. This version contains MySQL Utilities 1.0.5, a set of command line Python utilities for helping to perform and script various administration tasks for MySQL. A complete list of changes in this release of the Utilities can be found at:
http://dev.mysql.com/doc/workbench/en/wb-utils-news-1-0-5.html

MySQL Workbench 5.2 GA

• Data Modeling

• Query (replaces the old MySQL Query Browser)

• Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site.

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


  [Read more...]
MySQL Workbench 5.2.38 GA Available
Employee_Team +0 Vote Up -0Vote Down

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench (http://www.mysql.com/products/workbench/" target="_blank), version 5.2.38.
74 bugs were fixed in this version.

MySQL Workbench 5.2 GA

• Data Modeling
• Query (replaces the old MySQL Query Browser)
• Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. 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 here.

http://dev.mysql.com/doc/workbench/en/index.html

In addition to the new Query/SQL




  [Read more...]
MySQL Workbench 5.2.38 GA Released
Employee +0 Vote Up -0Vote Down

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench, version 5.2.38.

More than 74 bugs were fixed in this version.

MySQL Workbench 5.2 GA

• Data Modeling

• Query (replaces the old MySQL Query Browser)

• Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site.

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 here.

http://dev.mysql.com/doc/workbench/en/index.html

In addition to the new Query/SQL Development and

  [Read more...]
MySQL Workbench 5.2.37 GA Available
Employee_Team +0 Vote Up -0Vote Down

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench (http://www.mysql.com/products/workbench/" target="), version 5.2.37. 

This release contains 21 bug fixes, including a fix for a slowdown on loading of schema objects in the SQL Editor.

MySQL Workbench 5.2 GA

• Data Modeling

• Query (replaces the old MySQL Query Browser)

• Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. 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 here.



  [Read more...]

MySQL Workbench 5.2.37 GA Released
Employee +0 Vote Up -0Vote Down

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench (http://www.mysql.com/products/workbench/), version 5.2.37. 

This release contains 21 bug fixes, including a fix for a slowdown on loading of schema objects in the SQL Editor. 


MySQL Workbench 5.2 GA


• Data Modeling

• Query (replaces the old MySQL Query Browser)

• Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.


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






  [Read more...]
MySQL Workbench 5.2.37 GA Released
Employee +0 Vote Up -0Vote Down

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench (http://www.mysql.com/products/workbench/), version 5.2.37. 

This release contains 21 bug fixes, including a fix for a slowdown on loading of schema objects in the SQL Editor. 


MySQL Workbench 5.2 GA


• Data Modeling

• Query (replaces the old MySQL Query Browser)

• Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.


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






  [Read more...]
Get 20% off on any Devart product (expires January 10th)!
+0 Vote Up -4Vote Down

Merry Christmas and Happy New Year!

As Christmas holidays are drawing closer, we offer you to get 20% off any product license order.

Don’t think twice, just save 20%. And what more, you get free access to all future releases of the respective products for one year.

Hurry up, this offer is available only from December 01, 2011 till January 10, 2012. Decide and order right now.

We wish you all the best in the coming year, let joy and happiness be your constant partners and friends!

Best Christmas Wishes,
Devart Team

Get 20% off on any Devart product (expires January 10th)!
+0 Vote Up -0Vote Down
Merry Christmas and Happy New Year! As Christmas holidays are drawing closer, we offer you to get 20% off any product license order. Don’t think twice, just save 20%. And what more, you get free access to all future releases of the respective products for one year. Hurry up, this offer is available only from [...]
Previous 30 Newer Entries Showing entries 31 to 60 of 199 Next 30 Older Entries

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.