A few weeks ago we released MySQL Connector/Python v1.0.12. Bugs were fixed, and LOAD DATA LOCAL INFILE should now work correctly. The announcement can be read on the MySQL forums.
Some useful links:
MySQL Enterprise Backup team is excited to announce the new release of MySQL Enterprise Backup (MEB) 3.9.0.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Overview
MEB 3.9.0 focusses more on the ease of use of the product and addresses some of the challenges faced currently by database administrators. With growing data the need for hardware for database backups has significantly increased. Keeping that in mind MEB 3.9.0 has extended the product capability to save disk space during backup and restore. MEB 3.9.0 has also enhanced some of the existing features helping MEB users to perform their tasks in a more user friendly way without much overhead.
Product Enhancements
MEB 3.9.0 is a major release with the following valuable features.
· Single …
[Read more]Dear MySQL users,
MySQL Connector/Net 6.5.7, a new version of the all-managed .NET
driver for MySQL has been released. This is a maintenance
release for 6.5.x.
This release is feature complete. It is recommended for use in
production environments.
It is appropriate for use with MySQL server versions 5.0-5.6
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)
Enjoy and thanks for the support!Enjoy and thanks for the support!
Connector/NET Team
This Log Buffer Edition starts with an awesome post by Dana Pylayeva from Rakuten LinkShare, a long term Pythian client, about her deep and insightful reflections about security. And as usual, it also brings together all the sparkling gems of Oracle, SQL Server, and MySQL. Enjoy!
Oracle:
Alberto illustrates the algorithm used by Oracle (in 11.2.0.3) to fast refresh a materialized view (MV) containing only the SUM aggregate function.
Tim Hall writes about Oracle 12c Multitenant Option : CDBs and PDBs. …
[Read more]
If you have thread_concurrency, innodb_additional_mem_pool_size or innodb_use_sys_malloc in one of your my.cnf or
my.ini files please remove it at your next opportunity unless one
of the unlikely exceptions applies.
Thread_concurrency is a setting for only Solaris that has no effect in recent Solaris versions like 11. For Solaris 8 and earlier it gave the thread system a hint about how many threads to use for MySQL. Solaris 8 was last a supported platform for MySQL 5.1. We have deprecated this setting from 5.6.1 and removed it from 5.7.
…
[Read more]In my recent SQL work for a large Swiss bank, I have maintained nested database view monsters whose unnested SQL code amounted up to 5k lines of code, joining the same table over and over again in separate subselects combined via UNION operations. This monster performed in way under 50ms, no matter how we queried … Continue reading The Myth About Slow SQL JOIN Operations →
UPDATE 2013-08-30: Tungsten 2.1.2 was released.
UPDATE 2013-08-23: We have found a few problems that happen when replicating with RBR and temporal columns. We will have to publish an updated bugfix release quite soon.
Tungsten Replicator 2.1.1 is out. Key features in this release are:
Dear MySQL users,
MySQL Connector/Net 6.6.6, a new version of the all-managed .NET driver for MySQL has been released. This is a maintenance release for 6.6.x.
This release is feature complete. It is recommended for use in production environments.
It is appropriate for use with MySQL server versions 5.0-5.6
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)
This post will show how to use Connector/NET and Windows Store Apps in Windows 8 to connect and retrieve data from a MySql Server database.
Does size matter? This question has been teasing mankind since the beginning. But now, due to improvements in technology, size doesn’t really matter. Databases now have the features to tackle all data: big, medium, small, or very small. This Log Buffer Edition is here once again to bring you your data news of all sizes.
Oracle:
Marco tells us how to create a pluggable database by cloning an existing local PDB and talks about a bug in Oracle 12c.
Niall installs …
[Read more]