Well.. just wanted to share the more technical details I went into when preparing the "A MySQL Odyssey: A Blackhole crossover" for the OpenSUSE Conference in Thessaloniki, July 2013. There's a youtube version as well, of the actual session, on the opensuse channel. http://youtu.be/Nt2w1UvKEp0. (Audio kicks in at minute 6:40 so enjoy my miming act).
Here goes:
5.6 Enterprise Edition ->
This week’s Log Buffer Edition casts light on selected blog posts from different database logs across the globe slicing and dicing different ideas. Enjoy!
Oracle:
Saurabh Verma is correlating SQL statements in DB Sessions with ODI Sessions in ODI 11.1.1.7.
David Allan is writing about file transformation debatching within ODI.
An interesting thread about OEM 12c support for the database 12c release is currently on the oracle-l mailing list. Martin has more.
Anyone who has been around Oracle performance over the years knows the grief that …
[Read more]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.)