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

Displaying posts with tag: community (reset)

Proposal to deprecate mysqlhotcopy
Employee +0 Vote Up -0Vote Down

In the MySQL team, we are considering deprecating the mysqlhotcopy utility. To provide some background, here is an excerpt from the MySQL manual:

mysqlhotcopy is a Perl script that was originally written and contributed by Tim Bunce. It uses FLUSH TABLES, LOCK TABLES, and cp or scp to make a database backup. It is a fast way to make a backup of the database or single tables, but it can be run only on the same machine where the database directories are located. mysqlhotcopy works only for backing up MyISAM and ARCHIVE tables. It runs on Unix.

And now let me explain the motivations leading to our proposal:

  • The name implies that this utility will work for ‘MySQL’ and is hot, but actually neither are true:
  • Only MyISAM
  [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...]
MySQL Community Awards 2014: the Winners
+3 Vote Up -0Vote Down

The MySQL Community Awards initiative is an effort to acknowledge and thank individuals and corporates for their contributions to the MySQL ecosystem. It is a from-the-community, by-the-community and for-the-community effort. The committee is composed of an independent group of community members of different orientation and opinion, themselves past winners or known contributors to the community.

The 2014 community awards were presented on April 3rd, 2014, during the community event at the Percona Live conference. The winners are:

MySQL Community Awards: Community Contributor of the year 2014

  • Colin Charles
    Colin's list of service to the MySQL Community goes back almost 10 years. He was a community engineer starting in 2005, chaired some of the O'Reilly MySQL conferences, ran the MySQL projects for Google Summer of Code. As a
  [Read more...]
MySQL at OpenSource Developer Conference, Taiwan (Apr 11-12, 2014)
Employee_Team +0 Vote Up -0Vote Down

It is our pleasure to announce MySQL presence at the OpenSource Developer Conference in Taipei, Taiwan next week. MySQL has secured 2 talks and the booth where you can meet our MySQL experts. Please mark your calendars for April 11-12, 2014, especially for following MySQL talks:

  • Sharding and Scale-out Using MySQL Fabric by Ryusuke Kajiyama, the OSS specialist with over 10 years of experience in system design utilizing MySQL and Open Source solutions. His talk is scheduled for Apr 11 @ 10:20-10:50.
  • MySQL Utilities by Ivan Tu, the MySQL Sales Consultant in Taipei. Ivan has Java programming background and is experienced in both, MySQL and Oracle database. His talk is scheduled for Apr 11 @ 11:50-12:20.
We are looking forward to talking to you at the OSDC next week!

MySQL at LOADays Conference in Antwerp, Belgium (Apr 5-6, 2014)
Employee_Team +0 Vote Up -0Vote Down

This weekend we are going to be part of the LOADays Conference (Linux Open Administration Day) a free open source event hold in Antwerp, Belgium, followed by the tutorial on Monday, April 7th.

Do not miss to attend this small but friendly event hold in Antwerp, the second biggest city in Belgium and the capital of the Antwerp province. So, you can join the sightseeing with attending LOADays and getting in touch not only with a Linux people but also with MySQL!!

MySQL is represented by our colleague Carsten Thalheimer who is going to have a talk about "Why MySQL in a Business critical environment". His talk is planned for Sunday, April 6, 2014 @ 13:30.

For the whole conference plan you can check the Schedule section of the LOADays website.

See you there! 

Annual EMEA User Group Leaders' Summit - May 21-22, 2014
Employee_Team +1 Vote Up -0Vote Down

Are you already a MySQL User Group Leader?

or

Are you thinking about taking this role in the near future?

If yes, please let me invite you to the Annual User Group Leaders' Summit organized by Oracle User Group team. The purpose of this 2 days meeting is sharing the expertise, knowledge and share experience with leading the UG as well as learning of the new ways how to handle groups by using new technologies & tools (i.e. Cloud..).

It is great opportunity to talk to other User Group leaders and share the experience and knowledge with them. There will be Java User Group, Oracle User Group and of course MySQL User Group Leaders!

Find details about this event below and if you are interested and/or want to know more, please do not hesitate to contact

  [Read more...]
MariaDB and WebScaleSQL
+2 Vote Up -0Vote Down

On Thursday MySQL technology saw a huge boost. It’s hard for anyone now to argue that MySQL isn’t in the game of extreme scalability and performance, which some NoSQL vendors have been using as a tagline for the last years. To see four of the largest MySQL and MariaDB users come together to bootstrap a branch of MySQL for extreme scaling needs is simply fantastic. The improvements done inside these companies will now be available to the rest of the community. In all fairness Facebook and Twitter, in particular, have been making their improvements publicly available also before. Google has also made some improvements available publicly over the years and have lately been active in the MariaDB project with code reviews, bug fixes and other patches. But broadening the public contributions further and combining it all, is new.

Engineering of MySQL technology happens in many places. Aside from

  [Read more...]
MariaDB in Google Summer of Code 2014
+1 Vote Up -0Vote Down

MariaDB is participating in the Google Summer of Code 2014. Students are encouraged to propose a project before the deadline (this Friday!).

This is our second year participating, and as always we have an ideas page available. We also have a list of things we think are achievable in JIRA – check out our gsoc14 tag.

In 2013, we had three projects, of which two are in MariaDB 10.0: PCRE regular expressions and Roles. The other will be targeted towards MariaDB 10.1. There’s nothing like having GSoC students participate and have their code

  [Read more...]
Snippet: Fetching results after calling stored procedures using MySQL Connector/Python
Employee +3 Vote Up -0Vote Down

Problem

Using MySQL Connector/Python, you are calling a stored procedure which is also selecting data and you would like to fetch the rows of the result.

Solution

For this example we create a stored procedure which is executing SHOW SLAVE STATUS.

cnx = mysql.connector.connect(user='scott', password='tiger',
                              database='mining')
cur = cnx.cursor()
cur.execute("DROP PROCEDURE IF EXISTS slave_status")
proc = "CREATE PROCEDURE slave_status () BEGIN SHOW SLAVE STATUS; END"
cur.execute()
cur.call("slave_status")

for result_cursor in cur.stored_results():
 for row in result_cursor:
   print(row[0])

The result from the above would be:

shell> python foo.py
Waiting for master to send event

Discussion

The

  [Read more...]
Plan to remove unused command line programs (10 out of 43)
Employee +1 Vote Up -0Vote Down

Have you ever noticed the vast number of command line programs that ship with MySQL? Here is an ls from MySQL 5.6.16′s bin directory:

morgo@Rbook:~/Documents/mysql-installs/5.6.16/bin$ ls
innochecksum
msql2mysql
my_print_defaults
myisam_ftdump
myisamchk
myisamlog
myisampack
mysql
mysql_client_test
mysql_client_test_embedded
mysql_config
mysql_config_editor
mysql_convert_table_format
mysql_embedded
mysql_find_rows
mysql_fix_extensions
mysql_plugin
mysql_secure_installation
mysql_setpermission
mysql_tzinfo_to_sql
mysql_upgrade
mysql_waitpid
mysql_zap
mysqlaccess
mysqlaccess.conf
mysqladmin
mysqlbinlog
mysqlbug
mysqlcheck
mysqld
mysqld-debug
mysqld_multi
mysqld_safe
mysqldump
mysqldumpslow
mysqlhotcopy
mysqlimport
mysqlshow
mysqlslap
mysqltest
mysqltest_embedded
perror
replace
resolve_stack_dump
resolveip

For MySQL 5.7 we are

  [Read more...]
A followup on SHOW ENGINE INNODB MUTEX
Employee +2 Vote Up -1Vote Down

In November, I wrote about the command SHOW ENGINE INNODB MUTEX and sought feedback as to how it continues to be used post introduction of performance_schema.

The outcome from this feedback is that the MySQL team has decided to remove this command from MySQL 5.7.

These decisions are not light ones for the team to make. I wanted to thank everyone for their feedback, and also share why this decision was an important one for the future of MySQL:

  • By design, data collection for SHOW ENGINE INNODB MUTEX was always enabled, with no switch to disable it. We believe that for some workloads being able to disable the collection is useful, and in the case of performance_schema this is possible.
  •   [Read more...]
    Upcoming EMEA Events with MySQL 2014
    Employee_Team +0 Vote Up -0Vote Down

    As a follow up to the previous blog announcement we are pleased to announce following conferences in EMEA & APAC which MySQL Community Team supports. As usual not only MySQL staff is attending, we are sharing our resources with Oracle VM, Linux and Java (where applicable). Please come to meet us at: 

    EMEA 

    • OpenSUSE Conference - Dubrovnik, Croatia, April 24-28, 2014
      • You can meet the MySQL team at our booth or at any of approved talks. Schedule for this event is not yet approved/published. Please watch the OpenSUSE website for current program schedule. 
    • JavaScript UnConference, Hamburg, Germany,
      [Read more...]
    On the road again - FOSSAsia
    +0 Vote Up -0Vote Down

    On the road again - FOSSAsia

    It has been a few busy months until now. I have moved from Italy to Thailand, and the move has been my first priority, keeping me from attending FOSDEM and interacting with social media. Now I start catching my breath, and looking around for new events to attend. But before I get into this, let’s make a few things clear:

    • I am still working for Continuent. Actually, it’s because of my company flexibility that I could move to a different country (a different continent, 6 time zones away) without much trouble. Thanks, Continuent! (BTW: Continuent is hiring! )
    • I am still involved with MySQL activities, events, and community matters. I just happen to be in a different time zone, where direct talk with
      [Read more...]
    Hot Off The Press: MySQL February Newsletter
    Employee_Team +6 Vote Up -1Vote Down

    The MySQL February Newsletter is available! Find out the latest news on MySQL products and MySQL Connect 2014, and read the technical tips written by MySQL experts at Oracle and in the community. Below are the highlights in this edition:

    • Start Preparing for MySQL Connect 2014 Call for Papers
    • New GA Release: MySQL for Visual Studio
    • Blog: State of the UNION
    • Blog: New MySQL Web Installer -- Have You Tried It Yet?
    • Blog: MySQL Workbench: Frequent Crashes on Mac OS X? This Might Be The Fix
    • Event: MySQL Seminars Are Coming to a City Near You

    You can read it online or

      [Read more...]
    MySQL 5.6.16 Community Release Notes
    Employee +7 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.16.

    In particular:

    • Thanks to Honza Horak for suggesting we make tmpdir configurable at build-time, and for providing a patch. Bug #68338.
    • Thanks to Hartmut Holzgraefe for reporting a memory leak when using the InnoDB memcached API and replication. Bug #70757.
    • Thanks to Justin Swanhart for reporting that InnoDB reported an incorrect operating system error code when it failed to initialize. Bug #70867.
    • Thanks to Yoshinori Matsunobu who reported that
      [Read more...]
    MySQL Community Awards 2014: Call for Nominations!
    +1 Vote Up -0Vote Down

    The 2014 MySQL Community Awards event will take place, as usual, in Santa Clara, April 2014, during the Percona Live MySQL Conference & Expo (currently scheduled at Thursday, April 3rd 2014).

    The MySQL Community Awards is a community based initiative. The idea is to publicly recognize contributors to the MySQL ecosystem. The entire process of discussing, voting and awarding is controlled by an independent group of community members, typically based of past winners or their representatives, as well as known contributors.

    It is a self-appointed, self-declared, self-making-up-the-rules-as-it-goes committee. It is also very aware of the importance of the community; a no-nonsense, non-political, adhering to tradition, self criticizing

      [Read more...]
    MaxScale, ProxySQL and MySQL Proxy
    +2 Vote Up -0Vote Down

    At FOSDEM 2014 ProxySQL and MaxScale were both presented. Both are proxy that can help build sophisticated MariaDB/MySQL architectures. But currently what is the most used proxy with MySQL? It is HAproxy. HAproxy is a level 4 proxy that has no knowledge of the MySQL protocol. Being low level makes it very fast but it [...]

    SF MySQL Meetup Presentation: Changes in MySQL 5.7
    Employee +4 Vote Up -0Vote Down

    Last Wednesday, I spoke at the San Francisco MySQL Meetup on the topic of changes coming in MySQL 5.7 (and later).  We actually went through two different slide decks; the first on features being considered for deprecation in MySQL 5.7 (or later), and the second set providing a brief overview of the new features and benefits already introduced in MySQL 5.7 via the development milestone releases (DMRs) published to date.  A big thanks to the entire SF Meetup group, and in particular the organizers (Erin, Mike and Darren), for having me.  The event was streamed and recorded, and you can view the full presentation on YouTube.  The slide deck can be found here.

    The discussion around proposed

      [Read more...]
    Percona Live 2014 schedule released; BoF and Lightning Talks Call for Papers continues
    +0 Vote Up -0Vote Down

    The complete tutorial & session schedule for Percona Live MySQL Conference & Expo 2014 is released. This schedule offers both a sense of achievement as well as a sense of regret; for I believe the schedule is very good, and yet some good proposals had to be left out.

    This is an inevitable result of a conference that is popular and receives far more proposals than can fit within the time frames. This conference offers 96 session slots and 16 3-hour tutorial slots. We got well over 300 proposals -- I'm not even sure how to count them -- and they just can't all fit in. My sincere apologies to all those left out. A proposal of mine was just rejected yesterday from another conference; I can sympathize and

      [Read more...]
    Why a professional conference must have a committee, and what that committee does
    +3 Vote Up -0Vote Down

    What exactly is it that a conference committee does? This post comes as response to a comment on A sneak peek at the Percona Live MySQL Conference & Expo 2014, reading:

    Why the same committee each year? Community should vote on proposals and committee should just work schedule,etc.

    I'll pick the glove and shed some light into the work of the committee. While this specific comment related to the Percona Live conference, I trust that my opinions expressed below apply just as well to any (technical?) professional conference; the point below can equally apply to conferences from Oracle MySQL Connect, O'Reilly Velocity to FOSDEM & PyCon.

    I can sum up the entire answer with one word:

      [Read more...]
    MySQL Connect 2014, Save The Date!
    Employee_Team +7 Vote Up -0Vote Down

    We're very pleased to announce that MySQL Connect will next year take place from Monday September 29 to Thursday October 2, 2014, in San Francisco. And there will be a welcome reception on Sunday September 28 evening.


      [Read more...]
    Old and new MySQL verbosity
    +0 Vote Up -0Vote Down

    I was pleased to see Morgan’s announcement about a fix to an old problem of mine. In March 2012 I complained about MySQL verbosity during installation.

    In MySQL 5.7.3, this behavior was changed. While the default is still as loud as it can, you can now add an option (log_error_verbosity) to send only errors to STDERR, which allows you to hide the output of mysql_install_db, and still get the errors, if they occur.

    Well done!

    However, the same obnoxious verbosity is also in MariaDB 10.0.x. Since I discussed this specific bug with a few MariaDB developers early in 2012, I was disappointed to see this same output when running mysql_install_db with MariaDB.

      [Read more...]
    Call for papers (with lightning talks): Percona Live MySQL Conference 2014
    +1 Vote Up -0Vote Down

    The call for participation for Percona Live MySQL Conference 2014 is still open. As part of the review committee, I will be looking at the proposals, and I hope to see many interesting ones.

    There is a novelty in the submission form. In addition to tutorials and regular sessions, now you can submit proposals for lightning talks, to which I am particularly interested, as I have organized the lightning talks in the past two editions, and I am in charge to continue the tradition for the next one.

    If you want to be a speaker at the conference, here are some tips to get your proposal accepted:

    • Propose a topic that you know well;
    • Take some time to write a well thought and meaningful proposal: nothing gets me faster to the rejection button
      [Read more...]
    MariaDB CONNECT Storage Engine and parallelism
    +1 Vote Up -1Vote Down

    The CONNECT Storage engine implement the concept of a table made of multiple tables. These underlying tables can be distributed remotely. For example the underlying remote tables can be of ODBC or MySQL table type. this allows to execute distributed queries. What is nice is that we can execute this distributed query with parallelism.

    How [...]

    Percona Live London MariaDB-related schedule
    +0 Vote Up -0Vote Down

    Percona Live London 2013 is almost here: November 11-12 2013. Team MariaDB & SkySQL will be present, and here’s an agenda if you’re interested in all things MariaDB:

  • Monday, 11.11.2013 – 2-5pm – What’s New in MariaDB 10 and MariaDB Tools – a tutorial from Ivan Zoratti. This is a hands-on lab, complete with virtual machines provided by Ivan. You’ll also get to see MariaDB Manager from the abstract.
  • Tuesday 12.11.2013 – 9.45-10.00am – What’s New in MariaDB 5.5 and what will happen with MariaDB 10.0 – a
  •   [Read more...]
    Speaking at the MySQL NoSQL & Cloud Conference & Expo in Buenos Aires
    +1 Vote Up -0Vote Down

    I am on my way to Argentina, where I will be speaking at the MySQL NoSQL & Cloud Conference & Expo.

    I have two talks: one on my pet project MySQL Sandbox and one on replication between MySQL and MongoDB (using another project dear to me, Tungsten Replicator.

    It’s my first visit to Argentina and I will try to look around a bit before the conference. And I look forward to see many ex colleagues and well known speakers at the conference. The lineup includes speakers from Percona, EffectiveMySQL, PalominoDB, MariaDB, SkySQL, Tokutek, and OpenStack.

    I am looking forward to this trip. My presentation on MongoDB replication is a first for me, and I am always pleased when I can break new ground. I have the

      [Read more...]
    Forking MySQL/ for how long can forks keep up?
    +13 Vote Up -3Vote Down
    • Fact: MySQL 5.6 was released as GA in February 2013
    • Fact: MySQL 5.6 has been available with its complete set of features since September 2012
    • Fact: On September 21st, Oracle has released MySQL 5.7.2, which is the de facto major release after MySQL 5.6 (5.7.1 was just a token “we’re-still-in-business” release).
    • Fact: As of today, there is no GA-ready fork of MySQL 5.6.

    Percona Server is still in RC state, while MariaDB, with its runaway version 10, is still in alpha state. Of these releases, Percona Server seems the one in the better shape. Their problem was to adapt Percona Server to the enhanced codebase for 5.6, and the merging problems were bigger than the ones encountered in 5.1 and 5.5. Percona Server is a business oriented

      [Read more...]
    MySQL 5.7.2 : Good job Oracle! (Well, almost)
    +5 Vote Up -4Vote Down

    On September 21st, during the opening keynote at MySQL Connect 2013, Tomas Ulin disclosed the release of MySQL 5.7.2. This is a milestone release that includes several new features. Unlike the Previous one, which was just a point of pride, where Oracle was stating its continuous commitment to releasing new versions of MySQL. In MySQL 5.7.2, we see several new features:

    • First and foremost, performance. The announcement slides say MySQL 5.7.2 is 95% faster than MySQL 5.6 and 172% faster than MySQL 5.5. I don’t know yet in which circumstances these numbers hold true, but I am sure someone at Percona will soon prove or disprove the claim.
    • Performance Schema tables for several aspects:
      [Read more...]
    PLUK Attendees: Show of hands
    +1 Vote Up -0Vote Down
    It will soon be November and we'll be queuing up to register for the Percona Live conference once again. I spoke with some of this year's Percona Live London committee we all agreed that it would be great to arrange a community dinner if there was a community interest. In the past years of the PLUK conference there has not been a community event to attend in order to discuss sessions and make new friends. I for one love the `Pythian-arranged Community Dinner` at Pedro's that occurs annually in Santa Clara during the Percona Live Conference. I know that there are many attendees that do London and CA each year and wager that they'd agree that it's a great event. So lets have it... please r.s.v.p here and if the numbers are good enough we'll schedule something the evening of the tutorials. Please let me know of your interest in the comments below. Thanks :D
    Shi...pment happens - Tungsten Replicator 2.1.2
    +3 Vote Up -0Vote Down

    It was just a few days ago that we announced, with celebratory enthusiasm, Tungsten Replicator 2.1.1, and today we are at it again, with Tungsten Replicator 2.1.2.

    What happened? In a surfeit of overconfidence, we released Tungsten 2.1.1, with faith on the test suite and its result. The faith was justified, as the test suite was able to catch any known problem and regression. The overconfidence was unjustified, because, due to a series of unfortunate events, some sections of the test suite were accidentally disabled, and the regression that was lurking in the dark was not caught.

    Therefore, instead of having a quiet post-release week-end, the whole team

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