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 15773 Next 30 Older Entries

Displaying posts with tag: mysql (reset)

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


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




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


    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...]
    Book in Korean: Real MariaDB
    +1 Vote Up -0Vote Down

    For some months now, there have been some back & forth emails with Matt, one of the senior DBAs behind the popular messaging service, KakaoTalk (yes, they are powered by MariaDB). Today I got some positive information: the book published entirely in the Korean language, titled Real MariaDB is now available.

    It covers MariaDB 10.0. Where appropriate, there are also notes on MySQL 5.6 (especially with regards to differences). This is Matt’s fourth MySQL-related book, and

      [Read more...]
    MySQL 5.7: Performance Schema Improvements, Percona Live
    Employee +1 Vote Up -0Vote Down

    I had a great time last week at Percona Live, meeting up with lots of old friends, and getting to know lots of new ones.

    It was great to meet many of the people that hang around on DBHangOps face to face. Geoff even got a community award (well done)! Unfortunately I had to miss the lunch.

    It was also good to see Oracle getting a community award. Our engineers are extremely hard working, and all want to help community and customers alike be successful with their MySQL environments. There was lots of great positive attitude towards the work we’ve been doing, it was pleasing to hear that we are on the right track.

    I haven’t been to a conference at that venue since

      [Read more...]
    OpenSSL heartbleed CVE-2014-0160 – Data leaks make my heart bleed
    +0 Vote Up -0Vote Down

    The heartbleed bug was introduced in OpenSSL 1.0.1 and is present in

    • 1.0.1
    • 1.0.1a
    • 1.0.1b
    • 1.0.1c
    • 1.0.1d
    • 1.0.1e
    • 1.0.1f

    The bug is not present in 1.0.1g, nor is it present in the 1.0.0 branch nor the 0.9.8 branch of OpenSSL some sources report 1.0.2-beta is also affected by this bug at the time of writing, however it is a beta product and I would really recommend not to use beta quality releases for something as fundamentally important as OpenSSL in production.

    The bug itself is within the heartbeat extension of OpenSSL (RFC6520). The bug allows an attacker to leak the memory in up to 64k chunks, this is not to say the data being leaked is limited to 64k as the attacker can continually abuse this bug to leak data, until they are satisfied with

      [Read more...]
    MySQL-5.7.4- Change master without stopping slave altogether
    Employee_Team +1 Vote Up -0Vote Down
    At MySQL, we have been working on simplifying the failover process
    making it faster, more flexible and easier to use. In MySQL 5.6 we added
    support for Global Transaction Identifiers (GTID), which was a huge leap in the
    direction of easing the failover process hiding the details about
    replication logs and positions. With MySQL 5.7.4, we are introducing a
    new feature that further adds to flexibility and onliness- the user can
    only shut down components that he needs to re-configure. 

    What we allow with this new feature is to execute CHANGE MASTER TO
    command without stopping slave altogether. We realized that stopping
    slave altogether is not mandatory in all cases and doing that was more
    of a cautious approach to switching master restricting more than what’s
    required at times.

    Lets dive

      [Read more...]

    Why TokuDB does not use the ‘uint3korr’ function
    +0 Vote Up -0Vote Down

    The ‘uint3korr’ function inside of the mysqld server extracts a 3 byte unsigned integer from a memory buffer. One use is for ‘mediumint’ columns which encode their value in 3 bytes. MySQL 5.6 and MariaDB 10.0 claims to have optimized this function for x86 and x86_64 processors. There is a big comment that says:

    Attention: Please, note, uint3korr reads 4 bytes (not 3)!
    It means, that you have to provide enough allocated space.

    The ‘uint3korr’ optimization may be fast, but it is not valgrind safe. Here is an example where valgrind detects TokuDB reading beyond the end of a buffer when it uses the ‘uint3korr’ function.

    ==3899== Thread 36:
    ==3899== Invalid read of size 4
    ==3899== at 0xB76C089: tokudb_uint3korr(unsigned char const*) (hatoku_defines.h:533)
    ==3899== by 0xB795C5E:
      [Read more...]
    Summary of Announcements, Blogs, and more...
    Employee_Team +2 Vote Up -0Vote Down

    Considering last week was very rich in terms of announcements, we thought it might be useful to provide a summary of the information we shared, including the blogs from Oracle’s MySQL Engineers aggregated for easier access:

    We sent out this press release last Monday to announce:

    • The latest development milestone release of MySQL 5.7, 2x faster than MySQL 5.6 and 3x faster than MySQL 5.5
    • The Release Candidate of MySQL Fabric, providing high availability management and scale out through sharding (included in the Release Candidate version of MySQL Utilities 1.4.2).
    • The General Availability of MySQL Workbench 6.1, delivering additional capabilities for performance assessment and query optimization.
    • Early access to features under development

      [Read more...]
    Abdel-Mawla Gharieb: Impact of General Query Log on MySQL Performance
    +2 Vote Up -0Vote Down

    Sometimes, it is required to enable the general query log (which is disabled by default). If the general query log is enabled the server writes to this log information when clients connect or disconnect, and each SQL statement received from the client.

    The question is, does enabling the general query log affects the MySQL performance ?
    Also, it is possible to record the output of this log into either file or table in the mysql database (mysql.general_log), what is the performance impact of each one?

    Let's do some simple benchmark for those scenarios to measure the actual impact on the mysql performance.

    System Information:

    HW configurations:

      [Read more...]
    Some anecdotes I learned at Percona Live
    +0 Vote Up -0Vote Down

    While on the plane back home I wrote down all my impressions from Percona Live 2014. Have lots of TODOs and great ideas to implement. Among all my impressions, there were a few anecdotes worth noting.

    • 5.6 GTID is still unfriendly. It will require complete shutdown & reconfiguration of your entire replication topology; and some companies present hacks around this. Notable, Facebook recoded GTID related code (slave agrees to replicate with GTID even though its master still uses binlog coordinates). Booking.com have their own hack around slowly migrating their topologies. And in a great lightning talk we were shown how to patch MySQL such that the relay logs turn into a  consistent GTID-like coordinate system.
    • Galera replication has been implemented for TokuDB (only active-passive mode, not active-active). This came as a surprise to Tokutek ;
      [Read more...]
    Reflections on return to MySQL Community and Ecosystem
    +1 Vote Up -0Vote Down
    After a four year hiatus, my participation in last week’s Percona Live MySQL Users conference marked my official return to the MySQL Community and Ecosystem. As with earlier renditions this year’s “UC” was very well attended with a healthy mix of familiar faces and new blood, all coming together to discuss, present and explore the boundaries of the most popular and widely used open source database on the planet.  There were many good, informative keynote and technical sessions, BoFs and the exhibit hall was packed most of the operating hours with those interested in what the MySQL ecosystem is up to.  I also found it very refreshing that Oracle was among the most active in presenting useful technical content around their current and future MySQL open source product releases. All in  [Read more...]
    PerconaLive Keynote: Getting Serious about MySQL and Hadoop at Continuent
    +0 Vote Up -0Vote Down
    Lean, mean MySQL and hulking Hadoop clusters may seem like an odd couple, but tying them together is now priority #1 for many MySQL users. This keynote talk on 1st day of this year's Percona Live MySQL Conference & Expo 2014 explores the data management trends spurring integration, how the MySQL community is stepping up, and where the integration may go in the future. Robert Hodges, CEO at
    Optimizing MySQL Performance: Choosing the Right Tool for the Job
    +0 Vote Up -0Vote Down

    Next Wednesday, I will present a webinar about MySQL performance profiling tools that every MySQL DBA should know.

    Application performance is a key aspect of ensuring a good experience for your end users. But finding and fixing performance bottlenecks is difficult in the complex systems that define today’s web applications. Having a method and knowing how to use the tools available can significantly reduce the amount of time between problems manifesting and fixes being deployed.

    In the webinar, titled “Optimizing MySQL Performance: Choosing the Right Tool for the Job,” we’ll start with the basic top, iostat, and vmstat then move onto advanced tools like GDB, Oprofile, and Strace.

    I’m looking forward to this webinar and invite you to join us April 16th at 10 a.m. Pacific time. You can learn more

      [Read more...]
    MongoDB, TokuMX and InnoDB for disk IO-bound, read-only point queries
    +0 Vote Up -0Vote Down
    This repeats a test that was done on pure-flash servers. The goals are to determine whether the DBMS can efficiently use the IO capacity of a pure-disk server.  The primary metrics are the QPS that the DBMS can sustain and the ratio of disk reads per query. The summary is that a clustered primary key index makes TokuMX and InnoDB much more IO efficient for PK lookups on IO-bound workloads.

    TokuMX and InnoDB get much more QPS than MongoDB from the same IO capacity for this workload. TokuMX and InnoDB have a clustered primary index. There is at most 1 disk read per query assuming all non-leaf nodes from the index are in memory and all leaf nodes are not in memory. With MongoDB the primary key index is not clustered so there can be a disk read for the leaf node of

      [Read more...]
    Notes on the storage stack
    +0 Vote Up -0Vote Down
    If you want high performance and quality of service from a DBMS then you need the same from the OS. The MySQL/Postgres/MongoDB crowd doesn't always speak with the Linux crowd. On the bright side there is a good collection of experts from the Linux side of things at my employer and we have begun speaking. There were several long threads on the PG hackers lists about PG+Linux and this lead to a meeting at the LSFMM summit. I am very happy these groups met. We have a lot to learn from each other. DBMS people can explain our IO patterns and get motivated to write DBMS workload simulators (like innosim,   [Read more...]
    WordPress and UTF-8
    Employee +2 Vote Up -0Vote Down

    For many years, MySQL had only supported a small part of UTF-8, a section commonly referred to as plane 0, the “Basic Multilingual Plane”, or the BMP. The UTF-8 spec is divided into “planes“, and plane 0 contains the most commonly used characters. For a long time, this was reasonably sufficient for MySQL’s purposes, and WordPress made do with this limitation.

    It has always been possible to store all UTF-8 characters in the latin1 character set, though latin1 has shortcomings. While it recognises the connection between upper and lower case characters in Latin alphabets (such as English, French and German), it doesn’t recognise the same connection for other alphabets. For example, it doesn’t know that ‘Ω’ and ‘ω’ are the upper and lower-case

      [Read more...]
    MySQL Utilities Make a DBA More Efficient and Productive
    Employee_Team +0 Vote Up -0Vote Down

    MySQL Utilities provide a collection of command line utilities that make it easy for database administrators to maintain and administer MySQL servers. The utilities perform a range of otherwise complex operations via a simple command, making DBAs more efficient and productive.

    There are utilities for copying databases, comparing databases running on different servers, checking disk usage and for redundant or duplicate indexes, automatic failover, verifying replication configuration, cloning a running server, and working with audit logs. You can use all these utilities either standalone or with MySQL Workbench.

    You can learn about MySQL Utilities and much more by taking the

      [Read more...]
    Percona Live 2014 Recap
    +0 Vote Up -0Vote Down

    The MySQL community continues to amaze me, everyone is friendly and always willing to answer questions and help others. It’s always nice to meet people in-person that I’ve met virtually in the last 12 months. Percona Live 2014 MySQL Conference and Expo in Santa Clara just wrapped up and I wanted to share my highlights of the event before I unplug for the weekend.

    • I heard several stories of people’s experiences with TokuDB, open sourcing 12 months ago has been a huge success for Tokutek. We have a growing community in our tokudb-user Google Group, please share your experiences and help others.
    • In his “Galera Cluster New Features” presentation, Sappo Jaakola of
      [Read more...]
    MySQL Connector/NET 6.7.5 has been released
    Employee +0 Vote Up -0Vote Down
    Dear MySQL Users,
    MySQL Connector/NET 6.7.5, a new version of the all-managed .NET driver for MySQL has been released.  This is a Maintenance release. It is recommended for production environments.  It is appropriate for use with MySQL server versions 5.0-5.7.
    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.)
    Also Nuget packages are available:

      [Read more...]
    Facebook’s Yoshinori Matsunobu on MySQL, WebScaleSQL & Percona Live
    +3 Vote Up -0Vote Down

    Facebook’s Yoshinori Matsunobu

    I spoke with Facebook database engineer Yoshinori Matsunobu here at Percona Live 2014 today about a range of topics, including MySQL at Facebook, the company’s recent move to WebScaleSQL, new MySQL flash storage technologies – and why attending the Percona Live MySQL Conference and Expo each year is very important to him.

    Facebook engineers are hosting several sessions at

      [Read more...]
    Always use decimal for money
    +0 Vote Up -0Vote Down

    Data types make all the difference in the world when you’re designing your database. The choices you make now will affect the quality of your data, as well as application performance. I’m going to focus on one issue in this article: why you should always use decimals to represent money. Let’s jump in and see why that’s true.

    An example of floats gone wrong

    Let’s use a really, really simplified accounting ledger. It’s just three fields, an entry id, a customer id, and an amount, which has a float for a data type.

    Create Table LedgerEntries
     LedgerEntryID Int Primary Key Auto_Increment Not Null
    ,CustomerID Int Not Null
    ,Amount Float Not Null

    Now let’s load some data.

    Insert Into LedgerEntries (CustomerID, Amount)
      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 15773 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.