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 中文
Showing entries 1 to 30 of 32181 Next 30 Older Entries
MariaDB 10.0.10 uploaded to Debian experimental
+1 Vote Up -0Vote Down

If you’re watching the NEW queue, you’ll notice that MariaDB 10.0.10 has been uploaded targeting Debian/experimental. Package description, and to think the bug was only opened on April 2nd – pretty quick turnaround.

Related posts:

  • MariaDB in Debian unstable
  • Debian releases Lenny, MySQL 5.1 soon
  • MariaDB in Gentoo; updates for Solaris/Debian SPARC
  • Really large NLP corpora
    +0 Vote Up -0Vote Down

    Jeeze people. You’re all noisy. I’m sure it was all done for posterity’s sake.

    23M     irclogs/MagNET/#perl.log
    29M     irclogs/freenode/#mysql.log
    36M     irclogs/freenode/#debian.log
    37M     irclogs/foonetic/#xkcd.log
    39M     irclogs/OFTC/#debian.log
    43M     irclogs/freenode/#jquery.log
    44M     irclogs/freenode/#perl.log
    
    FYI: Galera is just a provider
    +0 Vote Up -0Vote Down

    No news in telling Galera is the synchronous multi master solution for MySQL.
    But Galera is just a provider.

    What do you mean by provider?

    Remember configuring “Galera”?
    There are two options
    wsrep_provider and wsrep_provider_options
    These define the provider (Galera) and the options for the provider.
    The rest of the wsrep_ options are for wsrep.

    https://launchpad.net/wsrep

    wsrep API defines a set of application callbacks and replication library calls necessary to implement synchronous writeset






      [Read more...]
    Concurrent, read-only, not cached: MongoDB, TokuMX, MySQL
    +0 Vote Up -0Vote Down
    I repeated the tests described here using a database larger than RAM. The test database has 8 collections/tables with 400M documents/rows per table. I previously reported results for this workload using a server with 24 CPU cores and a slightly different flash storage device. This time I provide a graph and use a server with more CPU cores. The goal for this test is to determine whether the DBMS can use the capacity of a high-performance storage device, the impact from different filesystem readahead settings for MongoDB and TokuMX and the impact from different read page sizes for TokuMX and InnoDB. It will take two blog posts to share everything. I think I will have much better QPS  [Read more...]
    Help fill the MySQL Track At SELF
    Employee +0 Vote Up -0Vote Down

    Help fill up the MySQL track at the Southeast Linux Fest. RFP for #self2014 has been extended to Mon April 28th at 9 PM ET. Last chance! Get those talk submissions in!


    RW locks are hard
    +1 Vote Up -0Vote Down
    MongoDB and TokuMX saturated at a lower QPS rate then MySQL when running read-only workloads on a cached database with high concurrency. Many of the stalls were on the per-database RW-lock and I was curious about the benefit from removing that lock. I hacked MongoDB to not use the RW-lock per query (not safe for production) and repeated the test. I got less than 5% more QPS at 32 concurrent clients. I expected more, looked at performance with PMP and quickly realized there were several other sources of mutex contention that are largely hidden by contention on the per-database RW-lock. So this problem won't be easy to fix but I think it can be fixed.

    The easy way to implement a reader-writer lock uses the pattern

      [Read more...]
    MariaDB 5.5.37 Overview and Highlights
    +0 Vote Up -0Vote Down

    MariaDB 5.5.37 was recently released (it is the latest MariaDB 5.5), and is available for download here:

    https://downloads.mariadb.org/mariadb/5.5.37/

    This is a maintenance release, and so there are not too many big changes of note, just a number of normal bug fixes. However, there are a few items worth mentioning:

    read more

    Newbie password mistake
    Employee +1 Vote Up -0Vote Down

    I received a panic call from a newbie MySQL DBA. Or should I say the ‘Linux Admin’/’MySQl DBA’/’CSS guru’/’PHP Programmer’/’Network Admin’/’Backup Operator’/’CIO’ of a small business. He had reset his password was was now locked out. Luckily, he had only changed his password and still had root access.

    What he did:
    mysql>use mysql;
    SET PASSWORD for 'mrdoesall'@'10.%' to 'bigsecret';
    mysql>

    Long time MySQL DBAs should be groaning at this with a wince remembering when it happened to them. For those of you who did not catch the problem, what happened is that he value in the user.password table is set to the string ‘bigsecret’. When our friend tries to login, the password is encrypted and compared to the value





      [Read more...]
    MySQL Connect — Reviewing the submitted presentations
    Employee +1 Vote Up -0Vote Down

    The presentations submitted for MySQL Connect are amazing. This year again I am very fortunate and slightly cursed to be on the selection committee again. Fortunate that I get a glimpse of some truly amazing work being done with MySQL. And cursed in that there are a lot of great talks that will not make it that I still want to see.

    We had over 190 submissions for 50 some odd speaking slots. In the past there has been some over lap with two members of the same engineering team proposing slight variations on a topic that can be combined. Sometimes there are blatantly obvious marketing sessions that will not only speed you queries, brighten you teeth, but also walk your dog. Usually it is easy to pick out a few obviously poor proposals. But not this

      [Read more...]
    Percona Live 2014 behind; MySQL ahead
    +0 Vote Up -0Vote Down

    I started using MySQL 11 years ago.  That’s not too long compared to other people in the industry, but nonetheless here’s my perspective on the state of the MySQL industry after attending Percona Live MySQL Conference & Expo 2104.

    In short, the attitude around MySQL has changed from “Does it work?” to “Is it fast and reliable?” to “How do we manage it?” To further generalize, these periods correspond roughly to the original MySQL AB team, Percona and Oracle, and the last period is the current period so key players are emerging, like WebScaleSQL.

    Does it work?

    Peter Zaitsev said in one of his

      [Read more...]
    It is event season for SkySQL and MariaDB: Where will we see you next?
    +0 Vote Up -0Vote Down

    The conference season has begun for us here at SkySQL. It seems like the almost all linux and MySQL shows are in the next four months. This is the time of year that we get to collect those airline points, have our beds made for us, eat out a few times a day and put on a few pounds! I have been practicing for this all year. Check out our Events Section to see all of our upcoming events.

    read more

    It is event season for SkySQL and MariaDB: Where will we see you next?
    +0 Vote Up -0Vote Down

    The conference season has begun for us here at SkySQL. It seems like the almost all linux and MySQL shows are in the next four months. This is the time of year that we get to collect those airline points, have our beds made for us, eat out a few times a day and put on a few pounds! I have been practicing for this all year. Check out our Events Section to see all of our upcoming events.

    read more

    Updates from VividCortex
    +0 Vote Up -0Vote Down

    What's new in VividCortex? We'll do these blog posts once a week to let you know all of the changes such as new features, bug fixes, performance improvements, and even a peek into the future.

    Upcoming Events

    If you haven't seen the VividCortex application in action, please register for a live demo on production systems on May 14th.

    Catch us at the following upcoming events:

    Upcoming Improvements

    • Agent management UI in the web application.
    • Agent performance improvements.
    • Events dashboard redesign and performance improvements.
    • Replication dashboard, for real-time live updating view of your replication topology and
      [Read more...]
    Ubuntu 14.04 – some MySQL ecosystem notes
    +1 Vote Up -0Vote Down

    Following my previous post on the launch, I just rolled Ubuntu 14.04 LTS on an Amazon EC2 t1.micro instance (not something you expect to run a database server on, for sure – 1 vCPU, 0.613GiB RAM). If you do an apt-cache search mysql you get 435 return result sets with the default configuration (trusty: main & universe).

    If you do apt-get install mysql-server, you get MySQL 5.5. You enter the password of choice, and before you know it, MySQL is installed (a SELECT VERSION() will return 5.5.35-1ubuntu1).

    Next you decide to install MariaDB. I run an apt-get install mariadb-server. It pulls in libjemalloc (for TokuDB) and I expect future releases to ship this engine by default. You enter the password, and

      [Read more...]
    Concurrent, read-only & cached: MongoDB, TokuMX, MySQL
    +1 Vote Up -0Vote Down
    This has results for a read-only workload where all data is cached. The test query fetches all columns in one doucment/row by PK. For InnoDB all data is in the buffer pool. For TokuMX and MongoDB all data is in the OS filesystem cache and accessed via mmap'd files. The test server has 40 CPU cores with HT enabled and the test clients share the host with mysqld/mongod to reduce variance from network latency. This was similar to a previous test, except the database is in cache and the test host has more CPU cores. The summary of my results is:
    • MongoDB 2.6 has a performance regression from using more CPU per query. The regression might be limited to simple queries that do single row lookups on the _id index. I spent a bit of time rediscovering how to get hierarchical

      [Read more...]
    Using mysqldump and the MySQL binary log – a quick guide on how to backup and restore MySQL databases
    +0 Vote Up -0Vote Down

    Be sure to check out my other posts on mysqldump:
    - Scripting Backups of MySQL with Perl via mysqldump
    - Splitting a MySQL Dump File Into Smaller Files Via Perl
    - Creating and restoring database backups with mysqldump and MySQL Enterprise Backup – Part 1 of 2
    - Creating and restoring database backups with mysqldump and



      [Read more...]
    MySQL Community Awards: Community Contributor of the Year 2014
    +1 Vote Up -0Vote Down

    As one decompresses from the active month that April brings to the MySQL ecosystem, its worth noting that I received a MySQL Community Award – Community Contributor of the Year 2014 award at the Percona Live MySQL Conference & Expo 2014 in Santa Clara. I was extremely happy and thankful to receive such an award and I still am. Thank you MySQL Community.

    My reason for winning, now immortalised:

    Colin’s list of service to the MySQL Community goes back almost 10

      [Read more...]
    See you at ICTexpo Helsinki 2014
    +0 Vote Up -0Vote Down
    ICTexpo Helsinki 2014 offers two effective days full of innovations, inspiration and information - the biggest professional IT show in the Nordics with large scale of solutions to help you to take your business to the next level. Continuent will be exhibiting in Red Hat Village [booth 5f31], which gathers the most significant enterprise level companies from the Open Source ecosystem in Finland
    MySQL April Newsletter: Latest MySQL Product Releases and More
    Employee_Team +1 Vote Up -0Vote Down

    MySQL April Newsletter is now available! Read this edition to learn more details about the abundant product announcements we made recently, including MySQL 5.7 Development Milestone Release, MySQL Workbench 6.1 GA, as well as the Release Candidate of MySQL Fabric. You'll also find information regarding the latest white papers (http://www.mysql.com/why-mysql/white-papers/), upcoming webinars (http://www.mysql.com/news-and-events/web-seminars/) and events (http://www.mysql.com/news-and-events/events/), and technical blogs for tips and tricks using MySQL.

    Enjoy and hope you find it informative! 

    MySQL for Visual Studio 1.2.0 alpha has been released
    Employee +0 Vote Up -0Vote Down
    MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. The 1.2.0 version is an alpha release of this product that intents to introduce users to the new features in this version.
    Chicago Users Group Meeting May 21st
    Employee +2 Vote Up -0Vote Down

    I will be speaking at the Chicago MySQL Users Group meeting on May 21st at 223 South Wacker Drive. Times, subject of the talk, and other details will be flushed out later but be aware that you will have to RSVP to get you name of the security guard’s list for admission.

    Chicago Pizza and MySQL 5.7

    The meeting will start at 6:30PM in the Oracle office at 233 South Wacker Drive on the 45th floor. The presentation will be on MySQL 5.7.


    Five reasons why vertical scalability matters
    Employee +2 Vote Up -0Vote Down

    The latest benchmarks show that MySQL 5.7 is now able to scale to 60 cores, which is quite an incredible feat when you compare to the 4-8 core scaling of MySQL 5.1 just a few years ago. These improvements are the result of a lot of heavy lifting to reorganize internal locking structures, and I have an earlier blog post on what is a mutex anyway? which may help serve as an introduction.

    While I consider horizontal scaling and projects like MySQL Fabric to be very important, it should be stated that horizontal and vertical scaling are really orthogonal choices. That is to say that a given database technology

      [Read more...]
    Dynamic range access (and recent changes)
    Employee_Team +2 Vote Up -0Vote Down

    Dynamic range access (aka “Range checked for each record” since that is what EXPLAIN will say in the ‘Extra’ column) is one of the big mysteries to MySQL users. The reason is that it is used for queries that are less common, such as queries with non-equality join predicates. The following query is an example; it finds the number of messages sent since the user was last logged in:

    EXPLAIN SELECT user.user_id, COUNT(message.id)
    FROM message, user
    WHERE message.send_date >= user.last_activity
    GROUP BY user.user_id;

    However, although such join predicates are less common, it doesn’t mean that the dynamic range access method is not important.

    How the dynamic range access method works

    It is easier to explain dynamic range access if we consider a “normal” join first, so let’s take a look at this

      [Read more...]
    InfiniDB Joins Hortonworks’ Technology Partner Program to Deliver High-Performance Hadoop Analytics
    +0 Vote Up -0Vote Down
    Combining InfiniDB Database Products with Hortonworks Data Platform Empowers Data-driven Organizations with Analytic Insights that Drive Efficiency Improvements and New Business Opportunities
    ClusterControl 1.2.6 Released
    +0 Vote Up -0Vote Down
    April 22, 2014 By Severalnines

    The Severalnines team is pleased to announce the release of ClusterControl 1.2.6. This release contains key new features along with performance improvements and bug fixes. We have outlined some of the key features below. 

    Highlights of ClusterControl 1.2.6 include:

    • Centralized Authentication using LDAP or Active Directory
    • Role-Based Access Control 
    • OpenStack: Galera Deployment Automation
    • Hybrid setups with Galera and Asynchronous MySQL Replication
    • Manage multiple Galera Clusters with single Controller
      [Read more...]
    MMUG7: Madrid MySQL Users Group meeting to take place on 24th April 2014
    +1 Vote Up -0Vote Down

    Madrid MySQL Users Group will have its next meeting on the 24th of April. Details can be found on the group’s Meetup page.

    We plan to talk about WebScaleSQL and I will give a short presentation on how to build WebScaleSQL RPMs on CentOS 6.  The meeting will be in Spanish.

    We’ve changed the place that we’ll be holding the meeting. See the Meetup URL for details. Looking forward to seeing you there.

    La próxima reunión de Madrid MySQL Users Group tendrá lugar el jueves 24 de abril. Se puede encontrar más detalles en la página del grupo.  Hablaremos sobre WebScaleSQL y ofreceré una breve presentación sobre como

      [Read more...]
    MariaDB Galera Cluster 10.0.10 now available
    +0 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.10. This is a Beta release.

    See the Release Notes and Changelog for detailed information on this release and the What is MariaDB Galera Cluster? page in the MariaDB Knowledge Base for general information about MariaDB Galera Cluster.

    Download MariaDB Galera Cluster 10.0.10

    Release Notes

      [Read more...]
    Making Use of Boost Geometry in MySQL GIS
    +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. Now that InnoDB is the default storage engine for MySQL, our user base is rapidly transitioning to InnoDB. One capability that they have been demanding is a performant and scalable GIS implementation. Along with adding R-tree index support to InnoDB, we also decided to replace the original GIS algorithms with a more powerful, reliable, effective and efficient geometric engine.
    MySQL 5.7 and GIS, an Example
    +1 Vote Up -0Vote Down
    This post will offer a very simple demonstration of how you can use MySQL 5.7 for Spatial features within your applications. In order to demonstrate this, I’ll walk through how we can determine the 10 closest Thai restaurants to a particular location.
    Visualizing The Impact Of An Index Change
    +0 Vote Up -0Vote Down

    One of our top queries updates a table called host_agent with status information from agents checking in with the APIs periodically. I was always a little surprised at how "hot" this particular query is. If you'd asked my intuition, I wouldn't have thought it would be in the top 25.

    Over time, a thought occurred to me -- this table is a bit denormalized and needs to be refactored, and as we made progress towards that in small steps, its primary key was revealed to be wrong. That is, it wasn't truly the natural primary key for the table. And the hot update had to use a secondary index to search for the row it wanted to update. Hmmm, I thought, didn't I write High Performance MySQL and shouldn't I know a little bit about these things?

    I could have tested things endlessly with measurements or benchmarks or

      [Read more...]
    Showing entries 1 to 30 of 32181 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.