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 61 to 90 of 225 Next 30 Older Entries

Displaying posts with tag: Windows (reset)

MySQL Connector/Net 6.5.1 beta has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.5.1, a new version of the all-managed .NET driver for MySQL has been released.  This is a beta release of our newest connector and comes with several new features.  It is of beta quality and should not be used in any production environment.  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 new versions brings new features such as
  • Exception and command injector support





  [Read more...]
Query-Digest on Windows
+0 Vote Up -0Vote Down
The best way to run pt-query-digest is by making absolutely sure it is not running on any server that is even slightly important to production.

I recently had a case where pt-query-digest took up all the memory and swap on a (linux) development server. I think the reason was that the slow log had blob data in it.
Even though it wasn't a production server, it managed to upset some people.


So I:
  • Installed strawberry perl on my windows computer
  • Downloaded the gzip'd slow log file (using WinSCP)
  • Unzip'd it
  • Saved percon.com/get/pt-query-digest to a .pl







  •   [Read more...]
    2012 to be year of Linux domination
    +0 Vote Up -1Vote Down

    Previously, I’ve called out years for non-desktop Linux in 2008, Linux in both the low and high-ends of the market in 2009, ‘hidden’ Linux in 2010 and last year, cloud computing in 2011. For 2012, I see continued growth, prevalence, innovation and impact from Linux, thus leading to a 2012 that is dominated by Linux.

    I expect to see nothing but continued strength for Linux and

      [Read more...]
    Running Connector/Net 6.5 inside Medium-Trust Level
    Employee +1 Vote Up -1Vote Down

    As you probably know, there were some problems using our connector in medium-trust level scenarios. Most hosting services provide MySQL access.  Most of these hosting providers run their .NET web apps using medium trust.  Prior to 6.5, our connector required the hosting provider to either run the application in full trust or to enable broad privileges like SocketPermission globally.  Many hosting providers are unwilling to do that.  So fully enabling our provider to run in a partial trust scenario was a strongly requested feature. The request was a very simple task: enable Connector/Net to work correctly in a medium-trust level environment when the library is installed in the GAC.

    The implementation consisted of including the necessary security imperative asserts so the CLR allows our code to perform the operations where it needs

      [Read more...]
    Running Connector/Net 6.5 inside Medium-Trust Level
    Employee +0 Vote Up -0Vote Down
    Connector/Net is now enabled to work inside a Medium/Partial Trust security level. Just download the new 6.5 version to use with your .Net application and you should be able to see it working just fine.
    Using MySqlClientPermission Class on Connector/Net 6.5 to restrict data access
    Employee +1 Vote Up -0Vote Down

    We have a new feature as part of the 6.5 release. There is a new class that you can use to restrict access to specific connection strings that you want to use in all the connections in applications that use MySQL databases.

    The following example shows how you can use the MySQLClientPermission class to restrict access to a specific server name and a database, while allowing any value for the User Id and Password within the connection string:

    MySqlClientPermission permission = new MySqlClientPermission(PermissionState.None);

    permission.Add("server=localhost;database=test;", " user id=; password=;",

    KeyRestrictionBehavior.AllowOnly);

    permission.PermitOnly();

    MySqlConnection myconn = new MySqlConnection();

    myconn.ConnectionString =

      [Read more...]
    Using MySqlClientPermission Class on Connector/Net 6.5 to restrict data access
    Employee +0 Vote Up -0Vote Down
    The release of the new 6.5 Connector/Net version includes a MySqlClientPermission class to help all the users define the security polices to use in the database connections within any application using a MySQL database.
    Intellisense Support
    Employee +0 Vote Up -0Vote Down

     Intellisense Support in Visual Studio

    One of the cool features coming in Connector/NET 6.5 is the support in Visual Studio 2010 of Intellisense for MySql files.

    As you probably know, the capability of editing mysql files (in the way of both .mysql raw files included in the solution and stored procedures/functions from Server Explorer) has been around for a while, yet a missing piece of the puzzle was to have advanced completion of sql statements in those files… until now.

    Let’s explore the set of features currently implemented as part of Intellisense support.

    Note: For completion intellisense features to work a database connection must be properly configured, see images below



      [Read more...]
    Intellisense Support
    Employee +0 Vote Up -0Vote Down

    One of the cool features coming in Connector/NET 6.5 is the support in Visual Studio 2010 of Intellisense for MySql files.

    As you probably know, the capability of editing mysql files (in the way of both .mysql raw files included in the solution and stored procedures/functions from Server Explorer) has been around for a while, yet a missing piece of the puzzle was to have advanced completion of sql statements in those files… until now.

    Milliseconds value support on DateTime Columns
    Employee +0 Vote Up -0Vote Down

    Since the release of the 5.6 Community MySQL Server there is support for the milliseconds value in Time, TimeStamp and DateTime types.  You can find more information on this new feature at (http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html).  Starting with version 6.5, Connector/Net fully supports milliseconds. This support does not affect compatibility with older versions of MySQL and it gives you the ability to use fractional seconds when combining Connector/Net 6.5 with MySQL Server 5.6 or later.  Let's see how we should use it.

    Creating a DateTime column that include Milliseconds value.

    You can do this either using Connector/Net or using any MySQL client with a valid connection to your database.

    For this case we're going to

      [Read more...]
    2011, A great year for MySQL in review...
    +11 Vote Up -0Vote Down
    I see so many posts on what happened to company X, product Y and dream Z that I couldn't resist the temptation to summarize this great year for MySQL. At the end of 2010, Oracle did an announcement we were all waiting for: MySQL 5.5 is GA! Another year has passed since then and it's time to reflect on what has been done.

    I know this is a long post. I tried to rewrite it at least 10 times to make it shorter, but I couldn't condense the list. Hence, I wrote a summary in the beginning for those who don't want to read it all.

    I believe that 2011 was an exceptional year for MySQL and I really enjoy being part of this team. I wish all of us a lot of success and fun in the years to come!

    Summary:







      [Read more...]
    MySQL Connector/Net 6.5.0 beta has been released
    Employee +0 Vote Up -0Vote Down
    MySQL Connector/Net 6.5.0, a new version of the all-managed .NET driver for MySQL has been released.  This is a beta release of our newest connector and comes with several new features.  It is of beta quality and should not be used in any production environment.  It is appropriate for use with MySQL server versions 5.0-5.6

    It is now available in source and binary form from here 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 new versions brings new features such as
    • Exception and command injector support
    • Millseconds support
    • Better partial-trust support
    • Better





      [Read more...]
    MySQL Connector/Net 6.5.0 beta has been released
    Employee +0 Vote Up -0Vote Down
    MySQL Connector/Net 6.5.0, a new version of the all-managed .NET driver for MySQL has been released.  This is a beta release of our newest connector and comes with several new features.  It is of beta quality and should not be used in any production environment.  It is appropriate for use with MySQL server versions 5.0-5.6

    It is now available in source and binary form from here 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 new versions brings new features such as
    • Exception and command injector support
    • Millseconds support
    • Better partial-trust support
    • Better





      [Read more...]
    Introducing the team!
    Employee +3 Vote Up -0Vote Down

    When Oracle acquired MySQL there was some concern about what would happen with the world's most popular open-source database.  It's clear now that not only is Oracle very serious about continuing the great database but it is expanding the teams working on it and it's related technologies.  I know because I run one of those teams!

    I've been working on MySQL and .NET technologies for the past 8 years and I'm very proud to introduce a couple of people who have been and will continue be working on my team.  

    Fernando Gonzalez currently serves as leader of our Connector/Net team and has just completed some early work on major intellisense improvements on Connector/Net 6.5.  He's done work on developing a new parser for our product.  [Read more...]
    Introducing the team!
    Employee +0 Vote Up -0Vote Down

    When Oracle acquired MySQL there was some concern about what would happen with the world's most popular open-source database.  It's clear now that not only is Oracle very serious about continuing the great database but it is expanding the teams working on it and it's related technologies.  I know because I run one of those teams!

    I've been working on MySQL and .NET technologies for the past 8 years and I'm very proud to introduce a couple of people who have been and will continue be working on my team.  

    Fernando Gonzalez currently serves as leader of our Connector/Net team and has just completed some early work on major intellisense improvements on Connector/Net 6.5.  He's done work on developing a new parser for our  [Read more...]
    MySQL Connector/Net 6.3.8 has been released
    Employee +0 Vote Up -0Vote Down
    MySQL Connector/Net 6.3.8, a new version of the all-managed .NET driver for MySQL has been released.  This is a maintenance release to our 6.3 release chain and includes 40 changes and fixes.

    Version 6.3.8 is appropriate for use with versions of MySQL 5.0-5.5.

    It is now available in source and binary form from here 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.)

    The release is also available for download on My Oracle Support (MOS).

    Enjoy and thanks for the support!
    MySQL Connector/Net 6.3.8 has been released
    Employee +0 Vote Up -0Vote Down
    MySQL Connector/Net 6.3.8, a new version of the all-managed .NET driver for MySQL has been released.  This is a maintenance release to our 6.3 release chain and includes 40 changes and fixes.

    Version 6.3.8 is appropriate for use with versions of MySQL 5.0-5.5.

    It is now available in source and binary form from here 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.)

    The release is also available for download on My Oracle Support (MOS).

    Enjoy and thanks for the support!
    MySQL HA Solutions – webinar replay
    Employee +1 Vote Up -0Vote Down

    If you were unable to attend the live webinar (or you want to go back and listen to it again) then it’s now available to view on-line here.

    Databases are the center of today’s web and enterprise applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization. Tune into this webcast to learn more.

    The session discusses:

      [Read more...]
    MySQL Workbench 5.2.36 GA available
    Employee_Team +0 Vote Up -0Vote Down

    MySQL Workbench 5.2.36 has been released. This release is part of an ongoing effort committed to improving the day to day usability of the product based on accumulated experience from tools such as MySQL Query Browser and input from user feedback.

    This specific version was focused on improving usability of the Query Editor. Some of the changes introduced are:

    • New, redesigned Query Editor layout. Output messages are always visible while resultsets and the query editor can be resized according to the task at hand. Resultsets are now in the same tab as their generating query editor.
    • Several minor changes that make the difference for a frustration-free, comfortable use of the tool. Sidebar sizes, the last selected schema and other state information is now properly remembered between sessions. Keyboard navigation of resultsets has been fixed to properly handle Tab key navigation in all
      [Read more...]
    Announcing new features in MariaDB
    +3 Vote Up -0Vote Down

    We have lately been talking about some upcoming features that we feel are important to MariaDB users, because the corresponding ones that will be provided with MySQL will be incompatible with MariaDB and closed source.

    We’re happy to announce the following:

    • The next version of MariaDB, version 5.2.10 will include an open source PAM Authentication Plugin. MariaDB 5.2.10 is scheduled for release next week.
    • A Windows Authentication Plugin is in development and QA currently and will be part of MariaDB 5.2.11, which is scheduled for release before Christmas.
    • MariaDB 5.5 will include both of the above plugins and an open source thread pool implementation. The soon-to-be-launched first version however will not include the thread pool.

    Stay tuned for more information

      [Read more...]
    Added a Table of Contents
    +1 Vote Up -0Vote Down

    Not a big deal, but I just added a “Table of Contents” page to my blog to make finding older articles much easier.

    I noticed most of my posts are quite lengthy, and it can take a bit of searching/clicking to find an older entry. So unless you happen to recall the ‘month/year’ it was published, which I don’t even remember that, then hopefully this will help.

    Really simple, and looks just like this:

      [Read more...]
    Startup problems with 5.2.35? Get 5.2.35.1
    Employee_Team +0 Vote Up -0Vote Down

    In the latest release of MySQL Workbench (5.2.35), we received a number of reports that some people upgrading over a previous installation ended up in not being able to launch MySQL Workbench afterwards, instead receiving an error such as Access to the path ‘C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.35\db_utils.pyc’ is denied. The cause for that seems to be a problem with access privileges on files that are created when Workbench is run. If you run into that problem, a possible workaround should be to start Workbench with elevated privileges one time. To do this, right-click the Workbench application icon in your startmenu and select “Run as administrator”. Please leave a comment whether this workaround solves the reported problem for you.

    UPDATE: A new 5.2.35.1 msi package has been uploaded, which resolves this issue. You can download it from the

      [Read more...]
    451 CAOS Links 2011.10.25
    +0 Vote Up -0Vote Down

    Microsoft: “more than half your Android devices are belong to us”. And more

    # Microsoft claimed that more than half of the world’s ODM industry for Android and Chrome devices is now under license to Microsoft’s patent portfolio following its agreement with Compal Electronics.

    # Hadapt expanded its board of directors and confirmed its $9.5m series A funding round.

    # Appcelerator entered into an

      [Read more...]
    Setting up Perl on Windows for MySQL Scripts (mysqldumpslow, mysql_explain_log, etc.)
    +3 Vote Up -0Vote Down

    This article is just a how-to for setting up Perl on Windows in order to use the perl scripts provided with MySQL, such as mysqldumpslow.pl or mysql_explain_log.pl.

    Now, you might say there is a section on this topic in the MySQL manual, to which I’d agree. But, this was for ActiveState Perl 5.6. The latest ActiveState Perl is 5.12, so thoese instructions are a bit out-of-date. Also, there are some helpful “User Comments” on that same page, but again, those are slightly out-of-date in the ActiveState 5.12. So, I thought I’d just post the steps I took in order to set this up.

    First, download and install ActivePerl. Click the “Download ActivePerl 5.12.4 for Windows” button (choose either 32-bit or 64-bit). You’ll be

      [Read more...]
    New Episode of Oracle’s "Meet The MySQL Experts" Podcast Series
    Employee_Team +0 Vote Up -0Vote Down

    This month, Alex Roedling interviews Software Development Manager Reggie Burnett about MySQL on Windows.

    Reggie covers Connector/NET, integration with Visual Studio, MySQL Workbench, the new MySQL installer for Windows, the new external authentication module for Windows, and more...

    Enjoy the podcast!

    And, a quick reminder that if you’re either attending Oracle OpenWorld or in the bay area next Tuesday, we hope to see you at the MySQL Community Reception!

    New Episode of Oracle’s "Meet The MySQL Experts" Podcast Series
    Employee_Team +2 Vote Up -0Vote Down

    This month, Alex Roedling interviews Software Development Manager Reggie Burnett about MySQL on Windows.

    Reggie covers Connector/NET, integration with Visual Studio, MySQL Workbench, the new MySQL installer for Windows, the new external authentication module for Windows, and more...

    Enjoy the podcast!

    And, a quick reminder that if you’re either attending Oracle OpenWorld or in the bay area next Tuesday, we hope to see you at the MySQL Community Reception!

    MySQL Connector/Net 6.4.4 has been released
    Employee +0 Vote Up -0Vote Down
    MySQL Connector/Net 6.4.4, a new version of the all-managed .NET driver for MySQL has been released.  This is an update to our latest GA release and is intended for full production deployment.

    Version 6.4.4 is intended for use with versions of MySQL from 5.0 - 5.5

    It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.4.html] and mirror
    sites (note that not all mirror sites may be up to date at this point of time
    - if you can't find this version on some mirror, please try again later or choose another download site.)
    The release is also available for download on the My Oracle






      [Read more...]
    MySQL Connector/Net 6.4.4 has been released
    Employee +0 Vote Up -0Vote Down
    MySQL Connector/Net 6.4.4, a new version of the all-managed .NET driver for MySQL has been released.  This is an update to our latest GA release and is intended for full production deployment.

    Version 6.4.4 is intended for use with versions of MySQL from 5.0 - 5.5

    It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.4.html] and mirror
    sites (note that not all mirror sites may be up to date at this point of time
    - if you can't find this version on some mirror, please try again later or choose another download site.)
    The release is also available for download on the My Oracle






      [Read more...]
    MySQL Workbench 5.2.35 GA Available
    Employee_Team +2 Vote Up -0Vote Down

    The MySQL Developer Tools team is proud to announce the next release of it’s flagship product, MySQL Workbench, version 5.2.35. This is the next maintenance release containing 29 bug fixes as well as new feature additions. We also updated the supported platforms to include most recent editions of Fedora and Ubuntu Linux.

    MySQL Workbench 5.2.35 now supports the Native Windows Authentication Method – available in the commercial MySQL server product – and the creation of user accounts utilizing this new authentication method.

    For the PHP developers out there, Workbench now also comes with a new set of plugins to turn SQL Queries into PHP code to be put right into your scripts.

    A big “Thank You” again to everyone for the large amount of feedback and ideas we have received on how to further improve and extend MySQL Workbench. We are continuously working on improving the

      [Read more...]
    MySQL Installer, once again
    +2 Vote Up -0Vote Down
    First an apology. I have not been blogging much lately, but I do have a reason, and I think a valid one for once (i.e. not along the lines of "I was out drinking last night" or "I was busy boiling potatoes" or something), I have been moving house. And my new office is now as tidy as ever (and if you believe that, let me tell you about a bridge in New York that I have for sale at a really good price). No, the place is a mess, but my beautiful wife keeps up with me, and I am slowly getting things together.

    That said, let's get to the point, MySQL Installer! If you read this blog, you know I have copmplained about this puppy several times before (First attempts with MySQL Installer and

      [Read more...]
    Previous 30 Newer Entries Showing entries 61 to 90 of 225 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.