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

Displaying posts with tag: skysql (reset)

Biggest MySQL related news in the last 24 hours
+5 Vote Up -0Vote Down

For me, the biggest news in the last 24 hours so far has been:

  • SkySQL merges with Monty Program, developers of MariaDB. This of course affects me directly and leads to a change in affiliation in a few months.
  • TokuDB goes opensource. I think this is really big news. Beyond just the fact that it can now be a storage engine in the main MariaDB tree, I love the work they’re doing to extend it to be an engine for MongoDB as well.
  • Continuent
  •   [Read more...]
    SkySQL merges with Monty Program Ab, makers of MariaDB
    +8 Vote Up -1Vote Down

    SkySQL has signed a merger agreement with Monty Program Ab, creators of the popular MariaDB database. Read more about it, as it features important tidbits from Patrik Sallner (CEO, SkySQL Ab), Simon Phipps (CEO, MariaDB Foundation), and Michael “Monty” Widenius (CTO, MariaDB Foundation).

    A key takeaway is that SkySQL will work alongside & collaborate closely with the MariaDB Foundation, plus continue to invest in the development of the MariaDB server.

    SkySQL Merges With MariaDB Developers To Create ‘Next Generation Open Source’ Database Company
    +5 Vote Up -0Vote Down

    SkySQL today announced that it has signed a merger agreement with Monty Program Ab, creators of the fastest growing open source database technology: MariaDB.  This merger reunites key members of the original MySQL AB developer and services teams. Their aim is to develop MariaDB into a truly interoperable, NewSQL open source database in collaboration with its customers, partners and the community. The company also pledges to further evolve its offering for users of the MySQL database.

    read more

    SkySQL named 2013 Top 100 Europe winner, more dates added for MySQL & Cloud Database Solutions Day
    +0 Vote Up -0Vote Down

    We were delighted last week to find out that we’d been named one of the ‘2013 Top 100 Europe’ winning companies by the Red Herring editorial team. Congratulations to all companies involved!

    read more

    Celebrate the end of a full week dedicated to MySQL and related technologies, with Black Vodka!
    +1 Vote Up -0Vote Down

    Join in our Finnish ritual, next Friday, at the closing of MySQL & Cloud Database Solutions Day after Percona Live!

    read more

    Continuent Tungsten at SkySQL & Cloud Database Solutions Day, Friday 4/26
    +1 Vote Up -0Vote Down
    Join Continuent, SkySQL and MariaDB for a day of free tutorials and interactive discussions around the MySQL and Maria databases, the Cloud, and High Availability, immediately following Percona Live: MySQL User Conference and Expo 2013. Robert Hodges (CEO, Continuent) and Edward Archibald (CTO, Continuent) will be talking about "Scalable MySQL Operation in the Cloud with Continuent Tungsten" at
    Latest Addition to MySQL & Cloud Database Solutions Day: Calpont CTO Jim Tommaney joins as guest speaker
    +1 Vote Up -0Vote Down

    Join us next Friday in Santa Clara for a free day of learning and fun from the SkySQL & MariaDB gang & their partners

    We’re proud to announce that Jim Tommaney, CTO of Calpont, has just signed on to speak at the MySQL & Cloud Database Solutions Day, hosted by SkySQL and MariaDB - taking place next Friday, April 26, directly after Percona Live: MySQL Conference & Expo.

    read more

    Solutions Lounge and Giveaway Details for MySQL & Cloud Database Solutions Day, hosted by SkySQL and MariaDB
    +1 Vote Up -0Vote Down

    Finish off the day and week with Continuent-sponsored Biergarten!

    read more

    Upcoming talks in Santa Clara
    +4 Vote Up -0Vote Down

    I’m planning my calendar and thought I’d share what talks I’d be giving in Santa Clara in a couple of weeks for the Percona Live MySQL Conference & Expo 2013 and the MySQL & Cloud Database Solutions Day 2013. Its going to be a busy April 22-26 2013.

  • MariaDB Cassandra Interoperability with Sergei Petrunia on 23 April 1:20pm – 2:10pm @ Ballroom D
  • MariaDB BoF on 23 April 6:00pm – 7:00pm @ Ballroom F
  • MariaDB
  •   [Read more...]
    More SkySQL Experts Speaking at Percona Live: MySQL Conference & Expo
    +2 Vote Up -1Vote Down

    Stick around one more day for the 2nd Annual MySQL & Cloud Database Solutions Day, hosted by SkySQL and MariaDB

    read more

    April is the Coolest Month
    +0 Vote Up -0Vote Down

    If T.S. Eliot were a MySQL DBA, I think he would have been more upbeat about April.

    We are gearing up for an incredible second half of April. We will be presenting three separate sessions at the Percona Live: MySQL Conference and Expo 2013, April 22-25, in Santa Clara, CA. In addition, we will be presenting at SkySQL’s MySQL & Cloud Database Solutions Day on Friday, April 26 at the same location.

    Come by to see us in Booth #114, or stop by one of our sessions:

      [Read more...]
    This just in: Tokutek Joins the MySQL & Cloud Database Solutions Day Speaking Roster
    +0 Vote Up -0Vote Down

    Tokutek Technical Lead, Gerry Narvaja, among list of experts at free event hosted by SkySQL and MariaDB

    read more

    Building MySQL and MariaDB on Windows using Visual Studio 2012 Express versus Visual Studio 2010 Express
    +2 Vote Up -0Vote Down

    I mentioned in a recent post (and another recent, related post) I was going to try Visual Studio 2012 Express (as opposed to VS 2010 Express) for building MySQL 5.6 and MariaDB 10.0. on Windows.

    I followed the exact same steps, but MySQL 5.6.10 would not build without fatal errors in 2012 (whereas it worked fine with VS 2010). Unfortunately, the fail errors were not too descriptive, so not quite sure what to do yet to fix it. Here is a brief snippet for those interested:

    ...
    Done Building Project "C:\...\bld\sql\udf_example.vcxproj" (default targets).
    Done Building Project "C:\...\bld\ALL_BUILD.vcxproj" (default targets) -- FAILED.
    Done Building Project "c:\...\bld\package.vcxproj" (default targets) -- FAILED.
    ...
    Build FAILED.
    ...
    
    "c:\mysql\mysql-5.6.10\bld\package.vcxproj" (default target)
      [Read more...]
    Speaker Details For MySQL & Cloud Database Solutions Day, hosted by SkySQL & MariaDB, in Santa Clara
    +0 Vote Up -0Vote Down

    Check out who’s talking, and about what, at our annual event on all things MySQL, MariaDB and Cloud - straight after Percona Live!

    As we mentioned earlier this week, we’re gearing up for Percona Live: MySQL Conference and Expo in a few weeks.

    But of course, we’re getting particularly excited as we prep for the 2nd annual SkySQL and MariaDB MySQL & Cloud Database Solutions Day, which takes place on the day (Friday, April 26) right after Percona Live: MySQL Conference and Expo.

    read more

    Gearing up for the Percona Live: MySQL Conference & Expo!
    +1 Vote Up -0Vote Down

    Join the SkySQL and MariaDB Crews in Santa Clara and Save on Registration

    Percona Live: MySQL Conference and Expo 2013 starts in just 3 weeks, and it’s the premiere event for MySQL users, open-source enthusiasts, and the technology movers ‘n shakers that make up the rich and diverse MySQL ecosystem.

    read more

    Awesome to see the MySQL Ecosystem Flourishing
    +6 Vote Up -0Vote Down

    I just wanted to take a moment and thank, notice, what ever you want to call it, but share some love with all those and all things MySQL.

    I read the post Let’s Celebrate MySQL 5.6 GA! – MySQL Community Reception by Oracle by Oracle MySQL Group and it got me to thinking of how proud I am of (and proud to be a part of) the whole MySQL Ecosystem.

    We *should* all celebrate MySQL 5.6 GA! I well remember the 3.22 and 3.23 days, and there were many folks before me already using MySQL!!!

    I love to see how it has continued to grow, the ecosystem and all things MySQL, that is. MySQL is better than ever. MariaDB is better than ever. Percona Server is better than ever. You have great Support options with MySQL/Oracle, SkySQL/MariaDB, and Percona as well – not to mention numerous others. I

      [Read more...]
    How to Build MySQL 5.6 on Windows from Source Code
    +2 Vote Up -0Vote Down

    I just set up a new Windows 7 machine, and built MySQL 5.6 for the first time, so I wanted to share my steps for anyone interested.

    ** Prerequisites **
    1. Install Microsoft Visual Studio (I installed VS 2010 Express – free)
    2. Install cmake
    3. Install bison (make sure no spaces in path)

    ** Build Instructions **

    cd c:\mysql\mysql-5.6.10
    mkdir bld
    cd bld
    cmake ..
    cmake --build . --config relwithdebinfo --target package

    (You don’t technically need the ‘bld’ dir, but I prefer it to keep the main dir ‘clean’. Then if you need to re-build, you can quickly just delete the whole ‘bld’




      [Read more...]
    How to Build MariaDB 10.0 on Windows from Source Code
    +2 Vote Up -0Vote Down

    I just wanted to share my steps for building MariaDB 10.0 on Windows (10.0.1 in this case):

    cd maria-10.0.1
    mkdir bld
    cd bld
    cmake .. -G "Visual Studio 10"
    cmake --build . --config relwithdebinfo --target package

    That’s it! The zip file is created right there in bld/.

    Hope this helps.

     

    SkySQL & MariaDB’s 2nd Annual MySQL & Cloud Database Solutions Day
    +1 Vote Up -0Vote Down

    As the press release says: “Come have a (free) beer with Monty: SkySQL & MariaDB’s 2nd Annual MySQL & Cloud Database Solutions Day”!

    “Are you planning on being in Santa Clara for Percona Live: MySQL Conference and Expo in April? If so, don’t let the learning and networking stop on Thursday!

    We invite you to join SkySQL & MariaDB for our 2nd Annual MySQL® & Cloud Database Solutions Day, Friday, April 26, 2013 at the Hyatt Regency Santa Clara. This event will be taking place directly after the Percona Live event.

    During this free one-day event, you will receive hands-on training and consulting on MySQL and MariaDB database solutions from the experts at SkySQL, MariaDB, and their partners.”

    Speakers will include Big Data, Analytics and Cloud experts, as well as SkySQL customers and MariaDB users. Including:

    Monty Widenius

      [Read more...]
    Enabling the Verbose InnoDB Lock Monitor in MariaDB and Percona Server for XtraDB+ and XtraDB
    +0 Vote Up -0Vote Down

    I enabled the InnoDB Lock Monitor in my MariaDB 5.5 instance (using XtraDB+ as the InnoDB – which is the default in MariaDB) and noticed that while the SHOW ENGINE INNODB STATUS was being logged to the error log, it wasn’t logging the “additional” lock information – it just looked like the plain ‘ole INNODB STATUS.

    Long story short, Percona added a new variable so one has better control over what gets logged:

    innodb_show_verbose_locks

    If off (default), then the InnoDB Lock Monitor logs the normal INNODB STATUS, and if enabled, then it logs it with the extended lock information.

    They also created another variable that goes along with this one (and the InnoDB Lock Monitor), which is:

    innodb_show_locks_held

    This

      [Read more...]
    Exciting Group of Speakers for MySQL & Cloud Solutions Day, Friday, April 26th in Santa Clara
    +1 Vote Up -0Vote Down

    Agenda includes speakers from Calpont, Codership/Galera, Craigslist, MariaDB, SkySQL and the OpenStack Foundation

    Today, SkySQL and MariaDB jointly announce an exciting lineup of speakers for their MySQL and Cloud Solutions Day on Friday, April 26th, at the Hyatt Regency Santa Clara. This year’s agenda will feature database and cloud tutorials, as well as keynotes, featuring speakers from Calpont, Codership, Craigslist, MariaDB, SkySQL and the OpenStack Foundation.

    read more

    Exciting Group of Speakers for MySQL & Cloud Solutions Day, Friday, April 26th in Santa Clara
    +0 Vote Up -0Vote Down

    Agenda includes speakers from Calpont, Codership/Galera, Craigslist, MariaDB, SkySQL and the OpenStack Foundation

    Today, SkySQL and MariaDB jointly announce an exciting lineup of speakers for their MySQL and Cloud Solutions Day on Friday, April 26th, at the Hyatt Regency Santa Clara. This year’s agenda will feature database and cloud tutorials, as well as keynotes, featuring speakers from Calpont, Codership, Craigslist, MariaDB, SkySQL and the OpenStack Foundation.

    read more

    Dealing with the dreaded “The printer is out of paper” or ERROR_OUT_OF_PAPER Error on Windows ;)
    +3 Vote Up -0Vote Down

    Caution: This is just a fun post.

    I was performing some testing on Windows the other day and encountered the following error in the error log:

    130313  9:40:03 [ERROR] Error writing file 'G:\mysql\log.txt' (errno: 28)

    Quickly, I ran “perror 28″ from the command line:

    c:\>perror 28
    Win32 error code 28: The printer is out of paper.

    Hehe, really, Windows?!?

    In fact, the drive was out of space. No more could be written to the general log, hence the error.

    Fwiw, the Linux OS code 28 reports what you would expect:

    OS error code  28:  No space left on device

    So, if you ever run into “The printer is out of paper” error, you’ll know what to do.

     

    InnoDB Plugin Version Numbering in MySQL and MariaDB
    +2 Vote Up -0Vote Down

    As some of you may or may not know, I’ve maintained a list of all InnoDB Plugin versions as they’ve historically contained a different version (entirely different numbering scheme) than the MySQL distribution they were included with.

    This list was most helpful for troubleshooting various InnoDB issues when the plugin may (or may not) have been involved, and/or for benchmarking, etc. And it’s fair to say it was more useful when the InnoDB plugin was not the mainstream, which it is now.

    However, with the latest releases, in MySQL and MariaDB, the “InnoDB Version” simply matches the “MySQL Version”. These “latest releases” include: MySQL 5.6.10, MySQL 5.5.30, MySQL 5.1.68, and MariaDB 5.5.30

    Of course this isn’t the most newsworthy story, but having maintained this

      [Read more...]
    Troubleshooting MySQL Crashes related to Metadata Locking
    +2 Vote Up -0Vote Down

    I just wrote an article about “Troubleshooting ‘Waiting for table metadata lock’ Errors for both MyISAM and InnoDB Tables” and then ran into a new, different metadata locking issue right after I posted it, and so I thought I’d share that too, just in case anyone ever encounters a similar situation.

    In this case, mysqld kept crashing on restart, reporting “out of memory” errors:

    /opt/app/mysql/product/mysql/bin//mysqld: Out of memory (Needed 840 bytes)
    stack_bottom = 7fb4ebaeae58 thread_stack 0x40000
    mysqld: /mysql/mysys/my_new.cc:52: int __cxa_pure_virtual():
      Assertion `! "Aborted: pure virtual method called."' failed.
    mysqld: /mysql/mysys/my_new.cc:52: int __cxa_pure_virtual():
      Assertion `! "Aborted: pure virtual method called."' failed.
    Fatal signal 6 while backtracing

    There is a

      [Read more...]
    Troubleshooting “Waiting for table metadata lock” Errors for both MyISAM and InnoDB Tables
    +1 Vote Up -0Vote Down

    With the introduction of metadata locking in MySQL 5.5, it is much more common to see queries stuck in the “Waiting for table metadata lock” state.

    If you see a query stuck in the “Waiting for table metadata lock” state, waiting for a MyISAM table, then it is because this table has been included as part of some uncommitted transaction (whether intentionally or not).

    In fact, it could be as simple as issuing SET AUTOCOMMIT=0 followed by a SELECT against a MyISAM table (a transaction can be started 3 ways: START TRANSACTION, BEGIN, and SET AUTOCOMMIT=0). After that, the table will be locked to other DDL statements until the transaction is committed (or ended).

    This metadata lock is meant for DDL statements, and so that is what it blocks. However, once a DDL





      [Read more...]
    Tracking down strange “Can’t find file” (ER_FILE_NOT_FOUND) Errors
    +2 Vote Up -0Vote Down

    Ever see an error like this in your console or error log, respectively, and wonder where it originated from?

    Console (5.5.30):

    ERROR 1017 (HY000): Can't find file:
    '.\test\select@0020@002a@0020from@0020t1.frm' (errno: 22)

    Error Log (5.5.30):

    130307 23:22:04 [ERROR] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: 
    Can't find file: '.\test\select@0020@002a@0020from@0020t1.frm' (errno: 22)

    (Fwiw, they are harmless, unless it is indicative of some sql injection – but you may want to sanitize your data better, unless it’s just a one-time user error. Also, if you’re seeing it from the command line, then you’ll likely realize what you did immediately, and thus no need to ‘figure out’ what happened. However, when you *only* see this entry in the error log, and you want to know how that happened after the fact, then this is more

      [Read more...]
    MySQL Events
    +3 Vote Up -0Vote Down
    The last MySQL User Group NL meeting was last Friday. It's always nice to learn about MySQL and meet other MySQL users. There were two presentations: one about MySQL User Defined Functions (UDF's) and one about MySQL TCO. The slides are available from the meetup page.

    There are already a number of MySQL events announced for the next few months. I'll only list events in the Netherlands and Virtual events.

    MySQL Virtual Developer Days
    This is a virtual event which will take place on March 19 (EMEA region, NA event is on March 12). There are many interesting topics: Performance Schema, New 5.6 Features, Replication, MySQL Enterprise Monitor
    The eVite

    SkySQL and MariaDB roadshow
    21 March 2013 in Amsterdam
    This event  have









      [Read more...]
    Brush Up Your MySQL Skills, Including Transitioning to the Cloud, and Meet the SkySQL Team!
    +2 Vote Up -0Vote Down
    Latest training events calendar & class schedule now available

    read more

    The SkySQL and MariaDB Meetup in Amsterdam - with Monty Widenius, the 'father' of MySQL®
    +5 Vote Up -0Vote Down

    SkySQL and Monty Program are on the road with our joint Meetup in Amsterdam where Monty Widenius - the origninal creator of MySQL - will unveil his vision of the future of the MySQL database via MariaDB.

    Seppo Jaakola from Codership will give a presentation about Galera Cluster for MySQL and MariaDB.

    In addition we will have speakers from Booking.com as well as Anders Karlsson from SkySQL who will talk about Big Data.

    read more

    Previous 30 Newer Entries Showing entries 61 to 90 of 253 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.