Showing entries 391 to 400 of 1629
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: Oracle (reset)
A MySQL Odyssey: A Blackhole crossover - The technical side of the preso.

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

Log Buffer #335, A Carnival of the Vanities for DBAs

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]
MySQL Connector/Python v1.0.12 released

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:

[Read more]
MySQL Enterprise Backup 3.9.0 – An Insight

 

 

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]
MySQL Connector/Net 6.5.7 has been released

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

Log Buffer #334, A Carnival of the Vanities for DBAs

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]
Remove on sight: thread_concurrency, innodb_additional_mem_pool_size, innodb_use_sys_malloc

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]
The Myth About Slow SQL JOIN Operations

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 →

Tungsten-Replicator 2.1.1 with better installation and built-in security


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:

  • A better installer, of which we have already given a preview in tpm, the multi-master composer. The new installer allows faster and more powerful deployments of both single and multiple masters topologies. And it also allows the next feature:
  • Secured communication layer. Now the replicator data and administrative …
[Read more]
MySQL Connector/Net 6.6.6 has been released

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

Showing entries 391 to 400 of 1629
« 10 Newer Entries | 10 Older Entries »