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 121 to 150 of 1340 Next 30 Older Entries

Displaying posts with tag: Oracle (reset)

Log Buffer #333, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

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.


Marco tells us how to create a pluggable database by cloning an existing local PDB and talks about a bug in Oracle 12c.

  [Read more...]
Log Buffer #332, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

We know very well that database technologies need a blog presence, and how to best offer that blogging experience — without the danger of boredom — is something tons of Oracle, SQL Server, and MySQL bloggers continue to show through Log Buffer. Enjoy!


Various approaches exist to organize your groovy scripts and package up utilities.

Oracle Certification announces the release of the new Oracle Linux 6 certification paths.

Designed for the Cloud, the new multitenant architecture of Oracle Database 12c now enables customers to greatly simplify and

  [Read more...]
Who works on MariaDB and MySQL?
+1 Vote Up -0Vote Down

Looking at the committers/authors of patches in the bzr tree for MariaDB 5.5.31.

Non Oracle Contributors:

  • Alexander Barkov
  • Alexey Botchkov
  • Elena Stepanova
  • Igor Babaev
  • knielsen
  • Michael Widenius
  • sanja
  • Sergei Golubchik
  • Sergey Petrunya
  • timour
  • Vladislav Vaintroub
  • Oracle (as they pull Oracle changes):

  • Aditya A
  • Akhila Maddukuri
  • Alexander Nozdrin
  • Anirudh Mangipudi
  • Annamalai Gurusami
  • Astha Pareek
  • Balasubramanian Kandasamy
  • Chaithra Gopalareddy
  • Daniel Fischer
  • Gleb Shchepa
  • Harin Vadodaria
  • Hery Ramilison
  • Igor Solodovnikov
  • Inaam Rana
  • Jon Olav Hauglid
  •   [Read more...]
    Log Buffer #331, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down

    More and more blogs are springing up to cover database technologies. This ethereal Log Buffer Edition yet again cherishes this spectacular growth and offers a few links from the Oracle, SQL Server, and MySQL arenas.


    Are Oracle enqueue rules leading to deadlock changes again in 12.1? Charles Hooper asks.

    James Morle writes about optimal Oracle configuration for efficient table scanning.

    Richard Foote writes a quick post on the reuse of empty leaf blocks in index.

      [Read more...]
    Percona Server 5.6 Webinar follow-up and Q&A
    +1 Vote Up -0Vote Down

    Good news everyone! I recently presented a webinar: Percona Server 5.6: Enterprise Grade MySQL. It was also recorded so you can watch along or view the slide deck. As with all my talks, I am not simply reading the slides so it really is worth to listen to the audio rather than just glance through the slide deck.

    There were a number of great questions asked which I’ll answer below:

    Q: How does Stewart feel about this version of 5.6 taking into consideration “Stewart’s .20 rule?” (ref 2013 Percona Live Conference).

    A: For those who aren’t familiar with it, I have a rule which I call “Stewart’s dot twenty rule” which I’ve posted a few times about on

      [Read more...]
    MySQL for Windows Store apps
    Employee +1 Vote Up -0Vote Down

    Windows 8 has ushered in the era of Windows Store apps and touch in a Windows OS.  Windows Store apps can be written in a multitude of languages including all .NET languages, Javascript, HTML, and C/C++.  We want to make it easy to write Windows Store apps that connect to the MySQL database.  To that end, we have included Windows Store compatibility in our recent Connector/Net 6.7 release.

     This is done by providing a separate assembly that exposes some of the functionality of the standard Connector/Net provider.   Some of the areas of functionality that is limited or missing as compared to stock Connector/Net are:

    • SSL connections or Windows authentication is not supported
    • MySQLDataAdapter objects are not supported. All access should be through MySQLCommand and MySQLDataReader.
      [Read more...]
    Log Buffer #330, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down

    This Log Buffer Edition marvels at the ease, simplicity, and power of the database bloggers as they go about their adventures in the realms of Oracle, SQL Server, and MySQL.


    The new Oracle Database 12c’s “Implicit Result Sets” (IRS) feature allows query results to be returned from a stored PL/SQL procedure (or a PL/SQL anonymous block) without requiring a special PHP code.

    Ranka has been spending a lot of time on big data and its application, architecture, and processes.

    Kashif Manzoor tells us how to use the new Clone Log Parser utility in Oracle

      [Read more...]
    Log Buffer #329, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down

    In this Log Buffer, you have naan bread, two types of roti, pasta, Karachi biryani, Chiken Tandoori, Beef tikka, eggplant masala, mixed pickles, French pastry with some elixir to wash all of it down. Yes, once again, this edition of Log Buffer contains numerous flavors from Oracle, SQL Server and MySQL.


    Sometimes it’s the little differences that make something really cool, and Martin was wondering why this hasn’t made it into the Oracle dictionary before.

    Oracle introduced a new feature for DataGuard called Far Sync. This configuration is designed to support synchronous redo transport between primary and standby database, which

      [Read more...]
    Improved Backup Progress in MySQL Enterprise Backup(MEB) 3.8.2
    Employee_Team +0 Vote Up -0Vote Down

    Forums available for your questions
    Employee +2 Vote Up -0Vote Down

    We have forums available to help you answer your questions when dealing with our Windows products.  You can post questions, answer other user's questions, and find solutions to your own problems there.   You can find these forums along with many other resources in our Development Zione found at http://dev.mysql.com/.  The forums are located at http://forums.mysql.com/.

     Here are the forum links for our products:

      [Read more...]
    MySQL Notifier 1.1.4 has been released
    Employee +2 Vote Up -0Vote Down

    The MySQL Windows Experience Team is proud to announce the release of MySQL Notifier version 1.1.4, the  latest addition to the MySQL Installer for Windows.

    MySQL Notifier 1.1.4 introduces the following features:

    • Monitoring of services in remote Windows computers (any service, not only MySQL Server services, similar to the local services monitoring offered in MySQL Notifier 1.0.3) via asynchronous Windows Management Instrumentation. Monitored services are grouped by computer name where the topmost is the Localhost. After a service in the Localhost or a remote computer is added to the monitored list, the MySQL Notifier automatically monitors for MySQL Server services addition (this option can be turned-off by users).
    • Monitoring of MySQL Server instances on any platform via a timer configurable by users.  These instances
      [Read more...]
    MySQL Presentations to the Colombia Oracle Users Group
    +1 Vote Up -1Vote Down

    My slides for presentations on MySQL Backup and Recovery Essentials and Understanding and using MySQL in the Cloud from the Oracle Technology Network (OTN) event in Medellín‎ Colombia are now available.

    Thank you to the Colombia Oracle Users Group for inviting me to the event.

    Site Blocked in Russia?
    +1 Vote Up -0Vote Down

    This is either too funny or too sad.

    An acquaintance sent me this image from a cyber cafe or hotel in Russia. It says that my blog site is prohibited and violates Russian law, and that they’re blocking my site in accordance with the Russian Federal Law of 27.07.2006 No. 149-FZ.

    All I can say is, “Wow!” I didn’t know that stuff about writing programs, web pages, and solving generic database and operating system problems was so sensitive. For that matter, I didn’t know

      [Read more...]
    SQL Like Comparisons
    +1 Vote Up -0Vote Down

    SQL tidbits are always valuable and highly searched for by newbies (as opposed to reading the SQL documentation). Sometimes we seasoned SQL developers take for granted little things like when a single- or multiple-character wildcard comparison works. It seems we know what newbies don’t. That you need a wildcard comparison operator not simply and equality comparison operator.

    The question posed to me was, “Why doesn’t my wildcard comparison work?” Here’s a simplified example of their question.

    SELECT 'Valid' AS "Test"
    FROM    dual
    WHERE  'Treat' = 'Tre_t'
    OR     'Treet' = 'Tre_t';

    Naturally, the answer is that the equality operator compares the strings based on their exact match (character sensitively in Oracle and character insensitively in MySQL). It needs to be rewritten by replacing the equals (=)

      [Read more...]
    Oracle OpenWorld 2013
    +0 Vote Up -0Vote Down

    I registered yesterday for Oracle OpenWorld 2013, and I’ll look forward to seeing friends there. Having worked in the Oracle 12c beta for a year, I’ll be interested in the presentations. Also, hearing more about Java 7 at JavaOne. On the downside, I’m missing MySQL Connect this year.

    Cloud computing offers many possibilities, and container and pluggable databases are a great solution. We’ve two new acronyms with the Oracle 12c release. A containerized database is a CDB, and a pluggable database is a PDB. I’m looking forward to seeing more about the provisioning of PDBs during the conference. If

      [Read more...]
    Log Buffer #328, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down

    There is a tsunami of blog posts out there as Oracle has made public its 12c database and SQL Server and MySQL with numerous new offerings. This Log Buffer Edition covers a few salient blog posts.


    Among the major ETL tools in the market , Oracle Data Integrator outshines not just for a couple of reason. Oracle has invested a lot in developing the tool after it took over from Sunopsis.

    You want to learn more about innovative features of WLS 11g and 12c? You want to get answers about the roadmap and capabilities?

    Kristin Rose tells us that 12c  offers the latest

      [Read more...]
    MySQL Connector/Python v1.1.0 alpha
    Employee +2 Vote Up -0Vote Down

    Finally, Connector/Python v1.1.0 is out. It’s the first of a series of alpha releases which will bring some new features. Check out the Change History if you want to keep up with what is being added and changed.

    Notable changes for v1.1.0:

    • Connector/Python v1.0 was known to work with Python v2.4 and 2.5. We now break compatibility with these older Python versions.
    • MySQL Prepared Statements are supported using cursor.MySQLCursorPrepared.
    • You can find out whether there is an ongoing transaction by checking
      [Read more...]
    I want to contribute,
    +5 Vote Up -0Vote Down
    Over at David Stoke's Open Source DBA blog, the following was posted: http://opensourcedba.wordpress.com/2013/07/05/mysql-is-looking-for-external-contributions My reply: Allow me to contribute code with a BSD (3-clause) license without having to sign anything new and then we can talk. Don’t tell me that it can’t be done: Oracle already has some code of mine in another product which was
    Log Buffer #327, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down

    Nelson Mandela, The Madiba, said: ” There is nothing like returning to a place that remains unchanged to find the ways in which you yourself have altered.” Bloggers return to their blogs to experience the same charming thing, and database bloggers are no different. Enjoy this edition of Log Buffer.


    With the new release of Oracle Database 12c, Oracle has removed the old Database Console.  In its place, they have given us Enterprise Manager Express (EM Express for short).

    And here is a perspective about Why Not to Upgrade to Oracle 12c Database.

    Sayan Malakshinov talks about Oracle 12c: Lateral,

      [Read more...]
    MySql for Visual Studio 1.0.2 GA has been released
    Employee +2 Vote Up -0Vote Down
    MySQL for Visual Studio is a new product including all of the Visual Studio integration previously available as part of Connector/Net.  The product is now released as GA and is appropriate for use in production environments.  It is compatible with MySQL Server versions 5.0-5.7 and Visual Studio versions 2008-2012.
    MySql Connector/NET 6.7.4 GA has been released
    Employee +0 Vote Up -0Vote Down

    MySQL Connector/Net 6.7.4, a new version of the all-managed .NET driver for MySQL has been released.  This is the GA, is feature complete. It is recommended for production environments.  It is appropriate for use with MySQL server versions 5.0-5.7.

    New features include WinRT Connector, Load Balancing support, Entity Framework 5 and Memcached. 

    How To: Using spatial data with Entity Framework and Connector/Net
    Employee +0 Vote Up -0Vote Down
    This post is an introduction on how to use the new support  for spatial data types with Entity Framework 5.0 on applications with MySQL and Connector/Net.
    Becoming an Expert MySQL DBA Across Five Continents
    Employee_Team +1 Vote Up -0Vote Down

    You can take Oracle's MySQL Database Administrator training on five continents. In this 5-day, live, instructor-led course, you learn to install and optimize the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.

    Below is a selection of the in-class events already on the schedule for the MySQL for Database Administrators course.




      [Read more...]
    MySQL Enterprise Backup 3.8.2 - Overview
    Employee_Team +4 Vote Up -0Vote Down


    MySQL Enterprise Backup (MEB) is the ideal solution for backing up MySQL databases. MEB 3.8.2 is released in June 2013.

    MySQL Enterprise Backup 3.8.2 release’s main goal is to improve usability. With this release, users can know the progress of backup completed both in terms of size and as a percentage of the total. This release also offers options to be able to manage the behavior of MEB in case the space on the secondary storage is completely exhausted during backup.

    The progress indicator is a (short) string that indicates how far the execution of a time-consuming MEB command has progressed. It consists of one or more "meters" that measures the progress of the command. There are two options introduced to control the progress reporting function of mysqlbackup command (1) –show-progress (2)

      [Read more...]
    Log Buffer #326, A Carnival of the Vanities for DBAs
    +1 Vote Up -0Vote Down

    Just like the new car model excites the car enthusiasts, the new version of the database products fascinates the database professionals. A plethora of blog posts sprung up as the new versions of databases are released. Oracle, SQL Server, and MySQL now have new things to offer. This Log Buffer shares that excitement and anticipation.


    Samer Forzley of Pythian explains why you should upgrade to Oracle 12c.

    Abhinav Agarwal informs that Oracle Business Intelligence Suite Bundle Patch is now available for download.

    Yury Velikanov presents a step by step guide to

      [Read more...]
    MySQL Enterprise Backup 3.8.2 has been released!
    Employee_Team +3 Vote Up -0Vote Down

    MySQL Enterprise Backup v3.8.2, a maintenance release of online MySQL backup tool, is now available for download from My Oracle Support  (MOS) website as our latest GA release.  It will also be available via the Oracle Software Delivery Cloud in approximately 1-2 weeks. A brief summary of the changes in MySQL Enterprise Backup version 3.8.2 is given below.

      A. Functionality Added or Changed: 

    • MySQL Enterprise Backup has a new --on-disk-full command line option. mysqlbackup could hang when the disk became full, rather than detecting the low space condition. mysqlbackup now monitors disk space when running backup commands, and users can now specify the action to take at a disk-full condition with the --on-disk-full option. For more details, refer this

      [Read more...]
    Log Buffer #325, A Carnival of the Vanities for DBAs
    +1 Vote Up -0Vote Down

    Close your eyes and imagine an affordable holiday featuring islands, pools, simmering white sandy beaches, and clubs. Chances are that you’re thinking about a resort in Hawaii, Fiji or French Polynesia. Now picture such a trip right now. I’ll give you a second. Still wondering? Yep, it’s this edition of Log buffer. :)


    Bobby has hacked a script together Tuesday night to figure out how to fit all his production data files and temp files on a development server for a RMAN restore of a production backup onto a new server.

    SQL Gone Bad – But Plan Not Changed? Kerry has more.


      [Read more...]
    Thanks Oracle for fixing the GPL man page issue
    +2 Vote Up -3Vote Down

    Timing is everything. I wrote about how MySQL man pages were silently relicensed away from the GPL. It was picked up by a lot of sites: Hacker News, Slashdot, LWN, and probably more. That led to a bug report in Debian (#712730) to complain that MySQL is no longer compliant with the Debian Free Software Guidelines (DFSG). That prompted Norvald Ryeng who’s active in Debian (thanks Oracle!) to file MySQL bug

      [Read more...]
    Continuent Tungsten Replicator 2.1 Now Available
    +2 Vote Up -0Vote Down
    Continuent Tungsten Replicator 2.1 is now available for download at www.continuent.com/software and http://code.google.com/p/tungsten-replicator/downloads/list.  Tungsten Replicator is a high performance, open source, data replication engine for MySQL and Oracle, released under a GPL V2 license. Tungsten Replicator has all the features you expect from enterprise-class data replication products
    MySQL Camp at Bangalore - 19 June
    Employee_Team +0 Vote Up -0Vote Down

    As promised we are back with the 2nd edition of Bangalore MySQL User camp this Wednesday 19 June.

    As requested we are going into the details of InnoDB and Performance Schema.

    See the details here:


    Venue remains the same as last time : 

    Our Kalyani Magnum Office behind Apollo hospital on the Bannerghatta road

    Time - 5PM-6PM

    Don't miss the chance to meet the MySQL engineering team at Bangalore and learn internals of MySQL.

    Hope to see you there.



    Previous 30 Newer Entries Showing entries 121 to 150 of 1340 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.