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 11 to 40 of 32762 Next 30 Older Entries
MariaDB 10.1.0 Overview and Highlights
+0 Vote Up -0Vote Down

MariaDB 10.1.0 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.1.0/

This is the first alpha release of MariaDB 10.1, so there are a lot of new changes and functionalities added, which cover a wide variety of areas such as: Performance, InnoDB/XtraDB, WebScaleSQL, Optimizer, Security, Storage Engine functionality, & Administration Improvements.

These are 9 of the most notable changes in MariaDB 10.1.0 (but do check out the release notes and changelogs below for the full list of changes):

  • InnoDB: Allow > 16K pages on InnoDB – InnoDB now allows page size to be configured as 16K, 32K and 64K. Note that single row size must be
  • InnoDB:
  •   [Read more...]
    MySQL Enterprise Monitor 3.0.13 has been released
    Employee_Team +0 Vote Up -0Vote Down

    We are pleased to announce that MySQL Enterprise Monitor 3.0.13 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud in a few weeks. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.

    You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.

    You will also find the binaries on the

      [Read more...]
    Systemtap solves phantom MySQLd SIGTERM / SIGKILL issue
    +0 Vote Up -0Vote Down

    The Percona Managed Services team recently faced a somewhat peculiar client issue. We’d receive pages about their MySQL service being unreachable. However, studying the logs showed nothing out of the ordinary…. for the most part it appeared to be a normal shutdown and there was nothing in anyone’s command history nor a cron task to speak of that was suspicious.

    This is one of those obscure and peculiar (read: unique) issues that triggered an old memory; I’d seen this behavior before and I had just the tool to catch the culprit in the act.

    Systemtap made diagnostics of this issue possible and I can’t state enough how much of a powerful and often under-utilized tool set systemtap really is.

    cat >

      [Read more...]
    OurSQL Episode 194: Common Schema, part 4
    +0 Vote Up -0Vote Down
    PodcastsPerformanceQuery OptimizationServer Tuning

    This week we continue our series on Common Schema and talk about different ways to look at the processlist, help with the query profiler, and some internal Common Schema tables. Ear Candy is about RHEL 7.0 using MariaDB, and At the Movies is The Human Postmortem.

    OurSQL Episode 193: Common Schema, part 3
    +0 Vote Up -0Vote Down
    PodcastsServer Tuning

    This week we continue our discussion about Common Schema by talking about security views and schema analysis views. Ear Candy is that apt repositories for MySQL are available, and At the Movies is about copyright vs. civil liberties.

    MySQL Webinar: MySQL EXPLAIN, explained
    Employee +0 Vote Up -0Vote Down
    Some time ago, Matt Lord and I delivered a webinar on the MySQL EXPLAIN feature.  This webinar is available for on-demand access here (http://www.mysql.com/news-and-events/web-seminars/mysql-explain-explained/).  Based on the questions we got during the webinar, I want to emphasize that EXPLAIN does not execute the query, it only determines the query plan for the query.  Hence, EXPLAIN will not be able to evaluate how good the chosen query plan actually is.

    If you have questions on this topic after listening to this webinar, feel free to ask questions; either as comments on this blog or at the MySQL Optimizer Forum.

    You can also access other webinars on MySQL (http://www.mysql.com/news-and-events/on-demand-webinars/). New webinars will be announced here (http://www.mysql.com/news-and-events/web-seminars).
    Hadoop BoF Session at OSCON
    +0 Vote Up -0Vote Down

    I have a BoF session next week at OSCON next week:

    Migrating Data from MySQL and Oracle into Hadoop

    The session is at 7pm Tuesday night – look for rooms D135 and/or D137/138.

    Correction: We are now in  E144 on Tuesday with the Hadoop get together first at 7pm, and the Data Migration to follow at 8pm.

    I’m actually going to be joined by Gwen Shapira from Cloudera, who has a BoF session on Hadoop next door at the same time, along with Eric Herman from Booking.com. We’ll use the opportunity to talk all things Hadoop, but particularly the ingestion of data from MySQL and other databases into the Hadoop datastore.

    As always, it’d be great to meet anybody interested in Hadoop at the BoF, please come along and

      [Read more...]
    Connector/ODBC 5.3
    +0 Vote Up -0Vote Down
    Connector/ODBC 5.3 (5.3.4 GA, published on Friday, 18 Jul 2014)
    Q&A: Even More Deadly Mistakes of MySQL Development
    +1 Vote Up -0Vote Down

    On Wednesday I gave a presentation on “How to Avoid Even More Common (but Deadly) MySQL Development Mistakes” for Percona MySQL Webinars.  If you missed it, you can still register to view the recording and my slides.

    Thanks to everyone who attended, and especially to folks who asked the great questions.  I answered as many as we had time for

      [Read more...]
    Update on MySQL on POWER8
    +2 Vote Up -0Vote Down

    About 1.5 months ago I blogged on MySQL 5.6 on POWER andtalked about what I had to poke at to make modern MySQL versions run and run well on shiny POWER8 systems.

    One of those bugs, MySQL bug 47213 (InnoDB mutex/rw_lock should be conscious of memory ordering other than Intel) was recently marked as CLOSED by the Oracle MySQL team and the upcoming 5.6.20 and 5.7.5 releases should have the fix!

    This is excellent news for those wanting to run MySQL on SMP systems that don’t have an Intel-like memory model (e.g. POWER and MIPS64).

    This was the most major and invasive patch in the patchset for MySQL on POWER. It’s

      [Read more...]
    Brainiac Corner with Jeremy Tinley
    +0 Vote Up -0Vote Down

    The Brainiac Corner is a format where we talk with some of the smartest minds in the system, database, devops, and IT world. If you have opinions on pirates, or anything else related, please don't hesitate to contact us

    Today, we interview Jeremy Tinley, the current Database Administrator at Etsy. He is a huge fan of puns and jokes. His favorite today is "A DBA walks into a bar and sees two tables. He says 'Can I join you?'" He gets randomly preselected for TSA precheck lines more than anyone else he knows. If you are interested in his thoughts, connect through Twitter.

    How did you get from

      [Read more...]
    Recover after DROP TABLE. Case 2
    +1 Vote Up -0Vote Down

    Introduction

    In the previous post we described the situation when TwinDB recovery toolkit can be used to recover accidentaly dropped table in the case innodb_file_per_table=OFF setting.
    Now we consider another situation. Let’s assume that mysql server has setting innodb_file_per_table=ON. This option tells InnoDB to store each table with user in a separate data  file.

    We will use for recovery test the same database sakila, that was used in the previous post.

    root@test:/var/lib/mysql/sakila# ll
    total 23468
    drwx------ 2 mysql mysql     4096 Jul 15 04:26 ./
    drwx------ 6 mysql

      [Read more...]
    High Availability with mysqlnd_ms on Percona XtraDB Cluster
    +1 Vote Up -0Vote Down

    This is the second part of my series on High Availability with mysqlnd_ms. In my first post, “Simple MySQL Master HA with mysqlnd_ms,” I showed a simple HA solution using asynchronous MySQL replication. This time we will see how to leverage an all-primary cluster where you can write to all nodes. In this post I used Percona XtraDB Cluster, but you should also be able to do the same with MySQL NDB Cluster or Tungsten Replicator.

    To start with, here is the mysqlnd_ms configuration I used:

    mysqlnd_ms_mm.ini
    .  All of these files are available from my

      [Read more...]
    Oracle Critical Patch Update for MySQL
    +1 Vote Up -0Vote Down
    Oracle has released the Critical Patch Update (CPU) for July 2014. The Oracle MySQL Risk Matrix lists 10 security fixes.

    It took me some time to understand the subcomponent names. So here is the list with the full name of each subcomponent:

    SubcomponentFull nameSRFTSServer: Full Text SearchSRINFOSCServer: INFORMATION_SCHEMASRCHARServer: Character setsENARCEngine: ArchiveSROPTZRServer: OptimizerSRREPServer: ReplicationSRSPServer: Stored ProcecureENFEDEngine: Federated
    I don't think there is anything really important in the list, but it might be a good trigger to update to the latest release.

    Upgrading should be easy especially if you're using the APT or






      [Read more...]
    MySQL Slave Scaling and more
    +2 Vote Up -0Vote Down

    Jean-François talks about binlog servers. Take a look here: http://blog.booking.com/mysql_slave_scaling_and_more.html

    ClouSE 1.0 is generally available
    +1 Vote Up -0Vote Down


    OblakSoft is pleased to announce general availability of the Cloud Storage Engine for MySQL (ClouSE) version 1.0.  Whether you want to use ready-to-run WordPress for Amazon Cloud / Google Cloud, configure your own WordPress installation with WP2Cloud plugin, or use ClouSE to deploy your own applications, ClouSE lets you tap the power of cloud storage to store your data extremely durably and make serving the content highly scalable.

    We would like to thank more than 2,000 registered Beta


      [Read more...]
    Install Apache2, PHP5 And MySQL Support On CentOS 7 (LAMP)
    +1 Vote Up -0Vote Down

    Install Apache2, PHP5 And MySQL Support On CentOS 7 (LAMP)

    This tutorial shows how you can install an Apache2 webserver on a CentOS 7.0 server with PHP5 support (mod_php) and MySQL support. LAMP is short for Linux, Apache, MySQL, PHP.

    Making Real-Time Analytics a Reality — TDWI -The Data Warehousing Institute
    +0 Vote Up -0Vote Down

    My article on how to make the real-time processing of information from traditional transactional stores into Hadoop a reality has been published over at TDWI:

    Making Real-Time Analytics a Reality — TDWI -The Data Warehousing Institute.


    TokuDB tips: MySQL backups
    +0 Vote Up -0Vote Down

    In my recent post, “TokuDB gotchas: slow INFORMATION_SCHEMA TABLES,” I saw a couple questions and tweets asking if we use TokuDB in production. Actually I mentioned it in that post and we also blogged about it in a couple of other recent posts:

    So, yes, we are using Percona Server + TokuDB as a main storage engine in Percona Cloud Tools to store timeseries data.

    And, yes, Percona

      [Read more...]
    OurSQL Episode 192: Common Schema, part 2
    +0 Vote Up -0Vote Down
    PodcastsGeneralPerformanceRoutines

    This week we continue our discussion of Common Schema by finishing up the routines and starting to look at the views it offers. Ear Candy is and At The Movies is

    News
    In the news, the OurSQL podcast will change to a monthly format after episode 200. We love doing the podcast, but it is very time consuming and production is expensive. We will still bring quality episodes, they will just be spaced further apart.

    OurSQL Episode 191: Common Schema, part 1
    +0 Vote Up -0Vote Down
    PodcastsRoutines

    This week we start talking about common schema by Shlomi Noach. Ear Candy is some caveats about GTIDs and replication, and At the Movies is using jQuery, AJAX and PHP to insert data into MySQL.

    News
    In the news, the OurSQL podcast will change to a monthly format after episode 200. We love doing the podcast, but it is very time consuming and production is expensive. We will still bring quality episodes, they will just be spaced further apart.

    OurSQL Episode 190: Server State Monitoring
    +0 Vote Up -0Vote Down
    PodcastsPerformanceQuery Optimization

    This week we discuss pt-sift and pt-stalk. Ear Candy is about a new tool called Orchestrator, and At the Movies is about Trove on OpenStack to provide open source Database as a Service.

    News
    Gerry:
    In the news, the OurSQL podcast will change to a monthly format after episode 200. We love doing the podcast, but it is very time consuming and production is expensive. We will still bring quality episodes, they will just be spaced further apart.

    OurSQL Episode 189: Syncing Both Ways
    +0 Vote Up -0Vote Down
    PodcastsLearning

    This week we discuss advanced pt-table-sync, including bidirectional sync. Ear Candy is starting MySQL on low-memory virtual machines, and At the Movies is "What's New With MySQL and MariaDB?"

    pt-table-sync
    Episode 188, where we talked about pt-table-sync basics
    pt-table-sync documentation

    OurSQL Episode 188: Back in Sync
    +0 Vote Up -0Vote Down
    PodcastsSoftwareLearning

    This week we discuss pt-table-sync basics. Ear Candy is about how MyISAM can seem transaction-aware, and At the Movies is MySQL and NoSQL at Craigslist.

    Events
    DB Hangops - every other Wednesay at noon Pacific time
    Upcoming SkySQL events
    Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

    OurSQL Episode 187: Hanging Out
    +0 Vote Up -0Vote Down
    PodcastsLearning

    This week, we discuss DB Hangops with special guest, Geoffrey Anderson. Ear Candy is that GTIDs in MariaDB and MySQL are different, and At the Movies is Jonathan Levin talking about deduplicating your data with MySQL.

    DB Hangops
    DB Hangops - blog and videos of previous hangouts
    YouTube DB Hangops channel
    DB Hangops twitter account

    OurSQL Episode 186: Data at OSCon
    +0 Vote Up -0Vote Down
    PodcastsConferences

    This week we talk with former co-host Sarah Novotny about Data at OSCon. Ear Candy is about SQL Courses, and At the Movies is a two and a half hour tutorial about MySQL Scaling Strategies for Developers.

    Events
    DB Hangops - every other Wednesay at noon Pacific time

    Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

    OurSQL Episode 185: Getting in Sync
    +0 Vote Up -0Vote Down
    PodcastsGeneralLearning

    This week we discuss pt-table-checksum for keeping data in sync. Ear Candy is a rational look at why one company chose MySQL; At the Movies is using MySQL in a practical way for Big Data.

    pt-table-checksum
    pt-table-checksum
    pt-table-sync

    OurSQL Episode 184: Digging Through the Tool Chest
    +0 Vote Up -0Vote Down
    PodcastsGeneralLearningPerformance

    This week we discuss more Percona tools: pt-online-schema-change and pt-slave-find. Ear Candy is using the CONNECT storage engine to read GPX files, and At the Movies is Performance at Scale with TokuDB.

    Events
    DB Hangops - every other Wednesay at noon Pacific time

    Upcoming MySQL events


      [Read more...]
    MySQL Cluster 7.1
    +4 Vote Up -0Vote Down
    MySQL Cluster 7.1 (7.1.32 GA, published on Tuesday, 15 Jul 2014)
    Adding summary fields when importing MySQL data with MySQL for Excel
    Employee +0 Vote Up -0Vote Down

    Welcome to another blog post from the MySQL for Excel Team. Today we're going to talk about a new feature included since 1.3.0, remember you can always install the latest GA or maintenance version using the MySQL Installer also you can download directly any GA or non-GA version from the MySQL Developer Zone.

    In this post we will learn how to add summary fields to our data imports to excel easily.



    Remember that your feedback is very important for us, please drop us a message with your comments, suggestions for this or other features and



      [Read more...]
    Previous 30 Newer Entries Showing entries 11 to 40 of 32762 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.