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 | HA_STATUS_TIME | HA_STATUS_VARIABLE |
HA_STATUS_VARIABLE_EXTRA | HA_STATUS_NO_LOCK);
stat_info->records= …

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 …

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.

…

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 …

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 …

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 …

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 platforms, including Windows, Mac OS X and Linux.

…

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 platforms, including Windows, Mac …

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 available for several …

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 available for several platforms, …