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 31 to 60 of 32118 Next 30 Older Entries
Developing with MySQL and NoSQL
Employee_Team +1 Vote Up -0Vote Down

MySQL adopts a very different approach to 'NoSQL' than other databases. With the memcached plugin, MySQL provides the speed and high availability benefits of a standard 'NoSQL' database solution, while mitigating many of the drawbacks to this approach.

A traditional memcached application bypasses the SQL layer entirely, and stores all its data in memory. This makes data access extremely fast, but there is a risk that the data will disappear in the event of a system problem. 

The MySQL memcached plugin for InnoDB also bypasses the SQL and optimization layers, resulting in excellent performance. It goes further, writing key-value data directly to  InnoDB tables. The result is fast data access while retaining the advantages provided by the existing relational database infrastructure, such as the ability to run complex queries with SQL, maintain data

  [Read more...]
#DBHangOps 04/16/14 -- PLMCE Learnings and Defending your DBs!
+0 Vote Up -0Vote Down
#DBHangOps 04/16/14 -- PLMCE Learnings and Defending your DBs!

Come join the GHangout at http://goo.gl/rxttYG or watch the livestream below:

Hello everybody!

Join in #DBHangOps this Wednesday, April, 16, 2014 at 12:00pm pacific (19:00 GMT), to participate in the discussion about:

  • Learnings from Percona Live MySQL Conference and Expo
  • Defending your databases!

Be sure to check out the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Wednesday!

See all of you on Wednesday!

Examining Query Samples with VividCortex
+0 Vote Up -0Vote Down

Customers love our Top Queries feature, which lets them rank queries by a metric such as overall execution time or count. This is a great way to examine entire families of similar queries together. We group queries by digesting out the literals, normalizing whitespace, and so forth.

Here is a view of queries on some of our primary database servers, over the last 4 days. What do you notice? I notice a strange pattern on query 5 and 6.

Is that query getting slower each day till it resets? Or is its response time consistent, and its execution count varies? We can click on the query to highlight it. When we do, the right-hand information pane fills with details about it.

Now we can see

  [Read more...]
Examining Query Samples with VividCortex
+0 Vote Up -0Vote Down

Customers love our Top Queries feature, which lets them rank queries by a metric such as overall execution time or count. This is a great way to examine entire families of similar queries together. We group queries by digesting out the literals, normalizing whitespace, and so forth.

Here is a view of queries on some of our primary database servers, over the last 4 days. What do you notice? I notice a strange pattern on query 5 and 6.

Is that query getting slower each day till it resets? Or is its response time consistent, and its execution count varies? We can click on the query to highlight it. When we do, the right-hand information pane fills with details about it.

Now we can see at a

  [Read more...]
Why aren't you using X, version 2
+1 Vote Up -0Vote Down
Sometimes I get asked why am I not using product X where X is anything but MySQL. The products that are suggested change over time and the value of X very much depends on the person asking the question. An ex-manager from my days at Oracle told me that Oracle would be better and developers from the SQL Server team told me the same. For those keeping score there was a social network that ran SQL Server and they were kind of enough to explain why.

Too often this is an assertion rather than a question and it would be more clear to say "I think you should be using X". A better question would be "Why are you using MySQL". This is the burden we carry for running MySQL at scale, but I am not in search of

  [Read more...]
Slides From Percona Live
+0 Vote Up -0Vote Down

Embedded below are slides for the two talks I gave at Percona Live. The first one is titled knowing the unknowable. It illustrates the special regression technique we developed at VividCortex for computing the amount of CPU, IO, or other resources a query uses within MySQL.

The second one is on building MySQL database applications with Go.

Mats Kindahl on MySQL Fabric
Employee +1 Vote Up -0Vote Down
Check out this interview with Mats on MySQL Fabric:

http://www.youtube.com/watch?v=fHs7yV4zCag&feature=youtu.be
Replication Sync Checking Algorithms
+0 Vote Up -0Vote Down

I was interested to see the announcement of a MySQL replication synchronization checker utility from Oracle recently. Readers may know that I spent years working on this problem. The tool is now known as pt-table-checksum in Percona Toolkit, but the original work started in 2006. I would say that I personally have spent at least 6 months working on that; adding up all the other Percona Toolkit developers, there might be several man-years of work invested. (I’m not with Percona anymore.)

The pt-table-checksum tool has been reinvented about three times as I and others learned more about the difficult and subtle problems involved. But if it were still a project I worked on, I’d still not be happy with it. It causes too much load on servers and does needless work. Solving that

  [Read more...]
MySQL Enterprise Backup 3.10: Teasing compression.
Employee +0 Vote Up -0Vote Down

Ok, so I wanted to look into the new compression options of MEB 3.10.

And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your own results and conclusions, and should I say it, baselines, in order to compare future behaviour, on your own system.

An Oracle Linux 6.3 virtual machine with 3Gb RAM, 2 virtual threads, on a 1x quad core, windows laptop. Not pretty, but hey.

So, these tests are solely about backup. I’ll do restore when I get some *more* time.

 

First up, lets compare like with like, i.e. MEB version 3.9 & 3.10:

Let’s make this interesting, hence, want to use as much resources available as possible, read, write, process threads and number of buffers.

mysqlbackup --user=root --password=oracle
  [Read more...]
MySQL Enterprise Backup 3.10: Teasing compression.
Employee +0 Vote Up -0Vote Down

Ok, so I wanted to look into the new compression options of MEB 3.10.

And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your own results and conclusions, and should I say it, baselines, in order to compare future behaviour, on your own system.

An Oracle Linux 6.3 virtual machine with 3Gb RAM, 2 virtual threads, on a 1x quad core, windows laptop. Not pretty, but hey.

So, these tests are solely about backup. I’ll do restore when I get some *more* time.

 

First up, lets compare like with like, i.e. MEB version 3.9 & 3.10:

Let’s make this interesting, hence, want to use as much resources available as possible, read, write, process threads and number of buffers.

mysqlbackup --user=root --password=oracle
  [Read more...]
New SQLyog and MONyog coming – please upgrade soon!
+1 Vote Up -0Vote Down

We are about to release upgrades to both SQLyog and MONyog with an important fix: linked libraries possibly vulnerable to the ‘Heartbleed’ OpenSSL bug have been upgraded to non-affected versions (the new MONyog release will have a few more fixes as well).

Since this security issue became known a few days ago, media and Internet have swollen with information about vulnerable systems. There is probably both a lot of facts and fiction circulating.

A good summary appeared in the Percona blog. It mostly focuses on server-side vulnerabilities. However

  [Read more...]
Dotdeb repository problems with MariaDB 5.5 (solution)
+0 Vote Up -0Vote Down

Dotdeb is a repository currently targeting Debian and Ubuntu, providing a nice set of packages for LAMP servers.

Recently, MySQL 5.6 was added to the dotdeb repository. On the surface, this is a very harmless addition. MariaDB is a replacement for MySQL and it should be possible for applications designed for MySQL to easily switch to MariaDB. Therefore MariaDB also includes the libraries that applications using MySQL depend upon, such as libmysqlclient18 and mysql-common. The dpkg package manager looks at the MySQL 5.6 packages in dotdeb and assumes that 5.6 is a higher version than 5.5, which results in it removing or replacing libraries during normal apt-get installation and upgrade procedures.

The problems appear in the following scenarios:

  [Read more...]
OpenSSL Heartbleed Security Update
+0 Vote Up -0Vote Down
Fri, 2014-04-11 07:56rasmusjohansson

As some of you may know, CVE-2014-0160 (“Heartbleed”) announced a vulnerability in certain versions of OpenSSL.

After the announcement on Monday 7th April 2014, the team began investigating the level of potential risk to our hosted systems and on-premise software.

Hosted Systems

Since SkySQL.com and MariaDB.com use OpenSSL in its platforms it was deemed necessary to immediately update all platforms with the recommended security patches.

Please be assured that our online systems are no longer at risk from this vulnerability.

We recommend that all users of SkySQL and MariaDB online

  [Read more...]
Korean MySQL Power User Group
+1 Vote Up -0Vote Down

If you are a MySQL power user in Korea, its well worth joining the Korean MySQL Power User Group. This is a group led by senior DBAs at many Korean companies. From what I gather, there is experience there using MySQL, MariaDB, Percona Server and Galera Cluster (many on various 5.5, some on 5.6, and quite a few testing 10.0). No one is using WebScaleSQL (yet?). The discussion group is rather active, and I’ve got a profile there (I get questions translated for me).

This is just a natural evolution of the DBA Dinners that were held once every quarter. Organised by OSS Korea, and

  [Read more...]
MongoDB, TokuMX and InnoDB for concurrent inserts
+0 Vote Up -0Vote Down
I used the insert benchmark with concurrent insert threads to understand performance limits in MongoDB, TokuMX and InnoDB. The database started empty and eventually was much larger than RAM. The benchmark requires many random writes for secondary index maintenance for an update-in-place b-tree used by MongoDB and InnoDB. The test server has fast flash storage. The work per transaction for this test is inserting 1000 documents/rows where each document/row is small (100 bytes) and has 3 secondary indexes to maintain. The test used 10 client connections to run these transactions concurrently and each client uses a separate collection/table. The performance summaries listed below are based on the context for this test -- fast storage, insert heavy with secondary index maintenance. My conclusion from running many insert benchmark tests is that I don't want to load big databases with  [Read more...]
MySQL 5.6.17 Overview and Highlights
+1 Vote Up -0Vote Down

MySQL 5.6.17 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here:

For this release, I counted 7 “Functionality Added” and/or “Incompatible Change” fixes:

  • Incompatible Change: The AES_ENCRYPT() and AES_DECRYPT() functions now permit control of the block encryption mode and take an optional initialization vector argument.
  • Incompatible Change: The ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and NO_ZERO_IN_DATE SQL modes now are deprecated and setting the sql_mode value to include any of them generates a warning. In MySQL 5.7, these modes do nothing. Instead, their effects are included in the effects of
  •   [Read more...]
    Percona Live Recap
    +1 Vote Up -0Vote Down

    I had a great time at Percona Live. I think this was the best MySQL conference I’ve ever been to. (The food was excellent too. The fastest way to a man’s heart is through his stomach.)

    The talks I attended were very good. Jay Janssen’s tutorial on Percona XtraDB Cluster was impressive. I can’t imagine how much time he must have spent preparing for that.

    I was very happy that Oracle, MariaDB, and WebScaleSQL had a strong presence, too. There were also a lot of one-degree-of-separation talks on topics like Hadoop and so forth. I attended a talk by Google on how their F1 database works. The biggest surprise in that talk? F1 is more expensive for them to operate than MySQL. I expected that anything they built in-house would surely be more cost effective, but I was wrong.

    The community awards and lightning talks were fun as always. My co-founder

      [Read more...]
    PHP mysqlnd memory optimizations: from 49MB to 2MB
    Employee +0 Vote Up -0Vote Down

    Inspired by Antony, Andrey has implemented a memory optimization for the PHP mysqlnd library. Depending on your usage pattern and the actual query, memory used for result sets is less and free’d earlier to be reused by the PHP engine. In other cases, the optimization will consume about the same or even more memory. The additional choice is currently available with mysqli only.

    From the network line into your script

    Many wheels start spinning when mysqli_query() is called. All the PHP MySQL APIs/extensions (mysqli, PDO_MySQL, mysql) use a client library that handles the networking details and provides a C API to the C extensions. Any recent PHP will default to use the mysqlnd library. The library speaks

      [Read more...]
    Amazon EC2 Linux AMIs
    +1 Vote Up -0Vote Down

    If you use Amazon Elastic Compute Cloud (EC2), you are always given choices of AMIs (by default; there are plenty of other AMIs available for your base-os): Amazon Linux AMI, Red Hat Enterprise Linux, SUSE Enterprise Server and Ubuntu. In terms of cost, the Amazon Linux AMI is the cheapest, followed by SUSE then RHEL. 

    I use EC2 a lot for testing, and recently had to pay a “RHEL tax” as I needed to run a RHEL environment. For most uses I’m sure you can be satisfied by the Amazon Linux AMI. The last numbers suggest Amazon Linux is #2 in terms of usage on EC2.

    Anyway, recently Amazon Linux AMI came out with the 2014.03 release (see release

      [Read more...]
    The MySQL Optimizer Cost Model Project
    Employee_Team +3 Vote Up -0Vote Down

    You may not be aware of this but the foundation that the MySQL optimizer builds on when choosing a query plan – the cost model – is for the most part very old. At least in tech terms.

    Much of it was written in another millennium, at a time when “Forest Gump” and “Titanic” won Oscars and “Baywatch” was the big thing on TV. Although the revision history doesn’t go that far back, it wouldn’t come as a surprise if it predates that annoying “Macarena” song and even “The Sign” (Ace Of Base) – don’t follow those links unless you’re feeling very brave…

    Thankfully, a lot has happened since Ace of

      [Read more...]
    Oracle MySQL Tech Tour event in Helsinki 7th of May
    Employee +3 Vote Up -0Vote Down

    Marko Mäkelä from InnoDB engineering team will deliver session on " InnoDB on-line schema changes and improved durability in MySQL 5.7"

    Are you about to develop a new modern web-based application, wondering what the best database solution is for you? Would you like to learn how to use NoSQL access to MySQL, as well as the new MySQL Database and MySQL Cluster features to build next generation applications?

    Join us for this “Performance, Scalability and High Availability with MySQL” Tech Tour! You will hear directly from the source about the latest MySQL innovations from Oracle, including how the MySQL 5.7 Development Milestone Releases yet again significantly increase the performance of MySQL, and how the new MySQL Fabric provides you with a framework for both High-Availability and




      [Read more...]
    Percona Live MySQL Conference Highlights
    +0 Vote Up -0Vote Down

    The Percona Live MySQL Conference and Expo 2014 was March 31st through April 4th in Santa Clara, California. I heard numerous positive comments from attendees and saw even more on social media. Our conference team lead by Kortney Runyan pulled together a smooth, enjoyable event which made it easy for attendees to focus on learning and networking. Some of the Percona Live MySQL Conference highlights from this year follow.

    Percona Live MySQL Conference Highlights

    A few stats for the conference this year versus last year:

    • Total registrations were up nearly 15%
    • Attendees represented 40 countries, up from 36 in 2013
    • 34 companies sponsored the conference this year, up from 33 last year
    • This year’s conference covered 5 days including
      [Read more...]
    How Tokutek uses the Random Query Generator framework to test TokuDB
    +0 Vote Up -0Vote Down

    During a typical release cycle for TokuDB at Tokutek, we spend time qualifying and hardening the product using numerous tools.  For example, we run stress and unit tests directly on the Fractal Tree indexes, MySQL Test Runner (MTR) tests on the storage engine as well as numerous performance benchmarks to prevent regressions. In addition, we have recently been implementing the Random Query Generator (RQG) framework internally here at Tokutek to more exhaustively stress TokuDB.  My name is Joel Epstein and I am a Quality Assurance Engineer here at Tokutek who has been integrating RQG into the overall test plan strategy.

    At

      [Read more...]
    Heartbleed OpenSSL Bug: Impact on ClusterControl Users & Recommendations on How to Protect your Systems
    +0 Vote Up -0Vote Down
    April 10, 2014 By Severalnines

     

    In the wake of recent concerns and debates raised around the Heartbleed bug, we wanted to update Severalnines ClusterControl users on any impact this bug might have on ClusterControl & associated databases and/or applications.

     

    Background

     

    If your ClusterControl's web application has been accessible on the internet, then most likely you have also been exposed to the Heartbleed OpenSSL security bug, see: http://heartbleed.com for more details. 

    By default, our database deployment script enables SSL encryption for the

      [Read more...]
    Heartbleed: Separating FAQ From FUD
    +1 Vote Up -0Vote Down

    If you’ve been following this blog (my colleague, David Busby, posted about it yesterday) or any tech news outlet in the past few days, you’ve probably seen some mention of the “Heartbleed” vulnerability in certain versions of the OpenSSL library.

    So what is ‘Heartbleed’, really?

    In short, Heartbleed is an information-leak issue. An attacker can exploit this bug to retrieve the contents of a server’s memory without any need for local access. According to the researchers that discovered it, this can be done without leaving any trace of compromise on the system. In other words, if you’re vulnerable, they can steal your keys and you won’t even notice that they’ve gone missing. I use the word

      [Read more...]
    "Minute-to-win-it" Blue Studio by Beats - Heterogenous Replication Survey
    +0 Vote Up -0Vote Down
    Continuent would like to better understand the relationships and data flows that exist between different database systems that you are using to understand your replication and data integration needs better. In particular, we'd like to know about any heterogeneous data exchanges, including manual dump/load and automated process, and whether non-database sources, such as Twitter and Facebook,
    MySQL for Excel new features (1.2.0): Edit Connections
    Employee +1 Vote Up -0Vote Down

    Welcome to another post of the MySQL for Excel team, this time we will talk about another cool feature you can find in our latest release to date (1.2.0) which can be downloaded directly from our MySQL Installer downloads page.

    If you want to learn how you can easily edit connections directly from the main MySQL for Excel panel now please read this post.

    If you would like to give us your feedback and propose new features you would like to see on future versions of MySQL for Excel we encourage you to please visit our forum and leave us a comment.
    Thank you for your support!

    Porting from Oracle to MySQL
    +0 Vote Up -0Vote Down
    A potential customer asked my about porting her application from Oracle Database to MySQL.

    I always try to start with the "why" (a dear friend bought me this book, recommended: http://www.amazon.com/Start-Why-Leaders-Inspire-Everyone/dp/1591846447).

    She said "cloud!". I said "OK!".

    I conducted a short research, found many things in many places all over the place, brought them to a nice email I sent her back and then thought I'll post it here and make it public as it might be useful for us all. If you feel that I missed something, add comments, send feedback.

    These are the leading tools to do the actual migration of the data structure, data export/import, sprocs, triggers, etc.:
  • MySQL Workbench has a migration feature: http://www.mysql.com/products/workbench/migrate/
  • MySQLYog can be used to migrate:









  •   [Read more...]
    Making Use of Boost Geometry in MySQL GIS
    Employee_Team +1 Vote Up -0Vote Down

    This post talks about how we make use of Boost.Geometry in MySQL to implement reliable and efficient GIS functionality, as well as changes to the GIS features in the lab release.

    Prerequisite

    This article assumes the reader knows about the basic geometry database concepts defined by the OGC. That includes WKT, WKB, the 8 kinds of spatial relationship checks—contains, within, intersects, disjoint, crosses, touches, overlaps, and equals—along with the 4 types of spatial set operations—intersection, union, difference, and symdifference. You can find a list of OGC Simple Feature Access standards, along with additional information on the aforementioned topics here.

    Terms & Abbreviations

    BG: Boost.Geometry

      [Read more...]
    MySQL 5.6.17 Community Release Notes
    Employee +2 Vote Up -0Vote Down

    Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.17.

    In particular:

    • Thanks to Anthony Pong for reporting a confusing error message when mysql_install_db could not locate the required Perl modules. Bug #69844.
    • Thanks to Jervin Real for reporting a recently introduced performance regression with compressed InnoDB tables. Bug #71436.
    • Thanks to Laurynas Biveinis for reporting a race condition in InnoDB on shutdown. Bug #70430.
    • Thanks to Jervin Real for reporting that innodb_data_file_path could not be specified in
      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 32118 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.