Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 816 10 Older Entries

Displaying posts with tag: community (reset)

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 …

  [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 …
  [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:

  1. By design, data collection for SHOW ENGINE …
  [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 …
  [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. …
  [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 …

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

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

  [Read more...]
10 Newer Entries Showing entries 61 to 70 of 816 10 Older Entries

Planet MySQL © 1995, 2015, 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.