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 91 to 120 of 32118 Next 30 Older Entries
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...]
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...]
The Reborn MySQL Community
Employee +4 Vote Up -0Vote Down

The Percona Live MySQL Conference and Expo ends today but it signals a rebirth of the MySQL Community. 2014 has been the most vibrant, upbeat, and cheerful show in many years. A multitude of new technology, approaches and energies emerged this year.

WebScale is partnership of several of MySQL’s biggest users to pool patches to make a bigger, badder server. Frankly these companies have more resources than MySQL in some areas and will be able to add in features very quickly. And Oracle really wants to add these changes quickly.

Fusion-IO is changing the way we think about writing to disks. The costs of a write is low and the speed is very high. For those of us having cut our teeth on systems where you had to plan for rotational delay and disk arm movements, this is almost spooky. SSDs are going to change many design ideas in the database world and

  [Read more...]
Server-side SELECT statement timeouts
Employee_Team +8 Vote Up -0Vote Down

MySQL 5.7.4 introduces the ability to set server side execution time limits, specified in milliseconds, for top level read-only SELECT statements. This feature is introduced as part of WL#6936. It is based on a contribution submitted by Davi Arnaut with Bug#68252. Thank you, Davi!

The statement timeouts work by interrupting the execution of the statement when it takes longer than a specified number of milliseconds to complete. After the specified number of milliseconds has passed, the server aborts the individual query without affecting the larger transaction or connection contexts. The following error is then reported to

  [Read more...]
MySQL community recognition
Employee +8 Vote Up -0Vote Down

On behalf of myself and the MySQL Engineering team, I’d like to thank everyone for naming Oracle the Corporate Contributor of the year at the MySQL Community awards ceremony at Percona Live 2014.

I’d also like to thank everyone who have come up to me and my fellow colleagues in person to thank us for the great work they have seen in MySQL 5.6 as well as 5.7. I only wish that more people in the MySQL Engineering team would be able to share that experience.

Therefore I cannot stress enough how important it is for my team to hear such positive feedback through talks, blogs, and tweets. Thank you for doing so, and please continue sharing your positive experience with MySQL openly. Why not read about the latest mysql engineering work and leave a comment on mysqlserverteam.com, it is a huge motivator.

Tomas

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!

MariaDB 10 and SkySQL's enhanced MariaDB Enterprise offerings in the news
+0 Vote Up -0Vote Down
Fri, 2014-04-04 08:32juergengiesel

The announcement of MariaDB 10 with it's NoSQL integration features as well as SkySQL's enhanced MariaDB Enterprise offering has reached several news sites this week. Here are a few of the articles that have been published in Europe.

English

  [Read more...]
MySQL Performance Schema : Prepared Statements Instrumentation
Employee_Team +3 Vote Up -0Vote Down

MySQL 5.7.4 has a new Performance Schema feature, namely instrumentation for prepared statements. This instrumentation gives details of PREPARE and EXECUTE statistics for a prepared statement.

New Table
New table added to display run time statistics of Prepared Statements is named as prepared_statements_instances.

mysql> describe performance_schema.prepared_statements_instances;
+———————–+——————————————————
| Field                        | Type
+———————–+——————————————————
|




  [Read more...]
Connector/Net 6.7
+0 Vote Up -0Vote Down
Connector/Net 6.7 (6.7.5 GA, published on Friday, 04 Apr 2014)
pt-online-schema change and row based replication
+0 Vote Up -0Vote Down

The way online schema changes have historically worked with statement based replication is to create an empty table on a slave, setup triggers to capture changes to a log table, copy the old table to the new table, apply the changes from the log table and atomic rename. This process breaks when using statement based replication because triggers don’t fire on events replicated to the slave. Triggers will fire on the master and the row events for any modified tables just replicate to the slave. This makes traditional online schema change break with statement based replication.

The workaround I’ve seen a few times at the conference is to run schema changes on the master when using row based replication. This is means either significantly reducing replication capacity during a schema change or having the change run really slowly so replication

  [Read more...]
MariaDB Client Library for C 2.0 and Maria JDBC Client 1.1.7 released
+1 Vote Up -0Vote Down

The MariaDB Foundation is pleased to announce the releases of MariaDB C Client Library 2.0 and MariaDB JDBC Client 1.1.7

The MariaDB Client Library for C 2.0 is a major release which contains more than 70 bug fixes and a lot of new functions and features, e.g.

  • SSH support
  • Dynamic Columns API
  • Support for MinGW and Objective/C
  • Read-ahead cache

…and much more!

For a complete list of all new features please visit MariaDB Client Library for C 2.0.0 Release Notes

We are very proud for getting a tremendous amount of contributions: bug reports, ports, patches and suggestions which helped

  [Read more...]
Help MariaDB gather some statistics!
+0 Vote Up -0Vote Down

I was browsing around the Internet (don’t remember what for) and I accidentally found one cool aspect of MariaDB. There is a feedback plugin and this short post is meant to encourage you to use it!

Ok, so what it does and why should you opt-in to be spied on It takes some information about your MariaDB server including it’s usage and it will send it to the MariaDB folks. It doesn’t send private data from your database. It sends stuff like what OS are you running, what version of various plugins, how did you tweaked the default

  [Read more...]
Uninitialized data in the TokuDB recovery log
+0 Vote Up -0Vote Down

A TokuDB MySQL test run with valgrind reported an uninitialized data error when writing into the TokuDB recovery log.

==1032== Syscall param write(buf) points to uninitialised byte(s)
==1032== at 0x3EFA60E4ED: ??? (in /lib64/libpthread-2.12.so)
==1032== by 0xB894038: toku_os_full_write(int, void const*, unsigned long) (file.cc:249)
==1032== by 0xB83248A: write_outbuf_to_logfile(tokulogger*, __toku_lsn*) (logger.cc:513)
==1032== by 0xB83326C: toku_logger_maybe_fsync(tokulogger*, __toku_lsn, int, bool) (logger.cc:836)
==1032== by 0xB8327DE: toku_logger_fsync_if_lsn_not_fsynced(tokulogger*, __toku_lsn) (logger.cc:586)
==1032== by 0xB8493E6: toku_txn_maybe_fsync_log(tokulogger*, __toku_lsn, bool) (txn.cc:600)
==1032== by 0xB7B4EBB: toku_txn_commit(__toku_db_txn*, unsigned int, void (*)(__toku_txn_progress*, void*), void*, bool, bool) (ydb_txn.cc:198)
==1032==
  [Read more...]
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...]
Why Boost.Geometry in MySQL?
Employee_Team +5 Vote Up -0Vote Down

In the newly released MySQL 5.7 labs release, users will find refactored GIS functions, as well as R-tree indexes in InnoDB. One notable change is that we have replaced a lot of the native code for geometry computation with an external library, namely Boost.Geometry. In fact, 5.7 will be the first MySQL release that depends on Boost. So why did we make such a move?

In recent years, we have seen a tremendous growth in location based services, and consequently GIS has become a strategically important area for MySQL. Our existing customers require more GIS features, and we believe this is a growing market opportunity.

Up to MySQL 5.6, GIS support in MySQL has been very limited, and the geometry algorithms implemented in MySQL were

  [Read more...]
Install Apache2, PHP5 And MySQL Support On CentOS 6.5 (LAMP)
+0 Vote Up -0Vote Down

Install Apache2, PHP5 And MySQL Support On CentOS 6.5 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 6.4 server with PHP5 support (mod_php) and MySQL support.

New! MySQL Utilities release-1.4.2-RC
Employee +2 Vote Up -0Vote Down
The MySQL Utilities Team is pleased to announce the latest release candidate (RC) release of MySQL Utilities. This release includes a number of improvements for useabilty, stability, and a few enhancements. A complete list of all improvements can be found in our release_notes.

New Utilities!


We have also included two new utilities.
  • The mysqlrplsync utility was added, which checks data consistency between servers in a replicated setup. 
  • The mysqlrplms utility was added, which provides round-robin multi-source replication (a slave server continually cycles through multiple masters in order to store a consolidated data set).

How Can I Download MySQL Utilities?


You can download MySQL Utilities 1.4.2 from





  [Read more...]
SQL parser refactoring in 5.7.4 LAB release
Employee_Team +6 Vote Up -0Vote Down

We are refactoring the SQL parser: the sql_yacc.yy file and friends.

Refactoring the parser consists of a base task that provides the common framework for refactoring, and several follow-up tasks to refactor individual types of SQL statements. We have already completed two follow-up tasks: one to refactor SELECT statements, and another to refactor SET statements.

Parser refactoring goals and tasks

The old parser had critical limitations because of its grammar complexity and top-down parsing style:

  • The top-down parsing style is not natural for
  [Read more...]
Data Encryption with MySQL Enterprise Backup 3.10
Employee_Team +0 Vote Up -0Vote Down

Introduction

MySQL Enterprise Backup (MEB) 3.10 introduces support for encrypted backups by allowing backup images, or single-file backups, to be encrypted. However, backups stored in multiple files in a backup directory can not be encrypted.

Any MEB command that produces a backup image can be optionally requested to encrypt it. The encrypted backup image can be stored in a file or tape in the same way as an unencrypted backup image. Similarly, any MEB command that reads data from a backup image accepts also an encrypted backup image. This means that encrypted backups can be used in all the same situations as unencrypted backup images.

MEB encrypts data with Advanced Encryption Standard (AES) algorithm in CBC mode with 256-bit keys. AES is a symmetric block cipher which means that the same key is used both for encryption and

  [Read more...]
Test improvements in 5.7.4
Employee_Team +2 Vote Up -0Vote Down

Here is a summary of the improvements to MTR test tool and suite in 5.7.4

New Tests

Added 69 new tests and enhanced several existing tests in the MTR suite.

Test Suite migration

Test suite migration activity is continuing and in 5.7.4 we completed migration of replication suites rpl/binlog and about 75% of main suite. Relevant WLs are:

  • WL#6921  Migrate rpl suite to run with innodb engine
  • WL#6922  Migrate binlog suite to run with innodb storage engine
  • WL#7263 Migrate myisam specific tests
  • WL#7405 Migrate partition tests
  [Read more...]
New Variables in MariaDB 5.5 not in MySQL 5.5
+0 Vote Up -0Vote Down
By doing a diff between  MySQL 5.5 and MariaDB 5.5 with show global variables, the following are new variables in MariaDB 5.5.35 not found in MySQL 5.5

Documentation for these variables can be found on MariaDB's knowledge base:  Server System Variables

aria_block_size
aria_checkpoint_interval
aria_checkpoint_log_activity
aria_force_start_after_recovery_failures
aria_group_commit
aria_group_commit_interval
aria_log_file_size
aria_log_purge_type
aria_max_sort_file_size
aria_page_checksum
aria_pagecache_age_threshold
aria_pagecache_buffer_size
aria_pagecache_division_limit
aria_recover
aria_repair_threads
aria_sort_buffer_size
aria_stats_method
aria_sync_log_dir




















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

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

http://downloads.skysql.com/archive/index/p/mysql/v/5.5.37

This release, similar to the last 5.5 release, is mostly uneventful.

There was one new feature added (Solaris-specific + obscure), and only 21 bugs fixed.

The new feature is this:

  • On Solaris, mysql_config –libs now includes -R/path/to/library so that libraries can be found at runtime.

Out of the 21 bugs, most were benign, but there was one definitely worth mentioning (because it is a regression bug with performance degradation):

  • A regression introduced by Bug #14329288 would result in a performance degradation when a compressed table does not fit into memory. (Bug #18124788,
  [Read more...]
A Quick Tour of VividCortex
+2 Vote Up -0Vote Down

This is a quick overview of top-level app features available with VividCortex.

Installation that Literally Takes a Few Minutes

Our install process requires only a few steps, running a CURL install command and entering some credentials and you are done. The agents automically configure, discover MySQL and start reporting data faster than you could have read this. Installation instructions are available once you signup.

Instant Visual Checks on Thousands of Servers

We provide a real-time dashboard of server load, or any other metric. Imagine a real-time view of critical MySQL errors, or replication problems. It's really hard to quickly evaluate hundreds or even thousands of servers, but with this view, we've built that flexibility into our app.

You can start from this page and

  [Read more...]
Announcing General Availability of VividCortex
+2 Vote Up -0Vote Down

VividCortex Launches MySQL Database Performance Saas Solution

Available for Free Trial

After a year and a half of coding, planning, customer feedback, bug fixes, lots of coffee, blood, sweat and tears, we're happy to announce that VividCortex is now generally available and you can install a free, fully-featured trial that will last for 30 days. Thank you so much to everyone involved. We have a great team and a fantastic group of early customers.

When we founded VividCortex, we decided to make people who manage systems happy. When you, as a database administrator, devops person, etc., possess such a unique skill-set and an entire company depends on you and your relatively small team for performance and management of

  [Read more...]
Announcing General Availability of VividCortex
+0 Vote Up -0Vote Down

VividCortex Launches MySQL Database Performance Saas Solution

Available for Free Trial

After a year and a half of coding, planning, customer feedback, bug fixes, lots of coffee, blood, sweat and tears, we're happy to announce that VividCortex is now generally available and you can install a free, fully-featured trial that will last for 30 days. Thank you so much to everyone involved. We have a great team and a fantastic group of early customers.

When we founded VividCortex, we decided to make people who manage systems happy. When you, as a database administrator, devops person, etc., possess such a unique skill-set and an entire company depends on you and your relatively small team for performance and management of

  [Read more...]
A Quick Tour of VividCortex
+0 Vote Up -0Vote Down

This is a quick overview of top-level app features available with VividCortex.

Installation that Literally Takes a Few Minutes

Our install process requires only a few steps, running a CURL install command and entering some credentials and you are done. The agents automically configure, discover MySQL and start reporting data faster than you could have read this. Installation instructions are available once you signup.

Instant Visual Checks on Thousands of Servers

We provide a real-time dashboard of server load, or any other metric. Imagine a real-time view of critical MySQL errors, or replication problems. It's really hard to quickly evaluate hundreds or even thousands of servers, but with this view, we've built that flexibility into our app.

You can start from this page and

  [Read more...]
Improve your Stored Procedure Error Handling with GET DIAGNOSTICS
+0 Vote Up -0Vote Down

In a previous post, I discussed debugging stored procedures with RESIGNAL, which is of great value when troubleshooting errors raised by your stored procedures, functions, triggers, and events as of MySQL/MariaDB 5.5.

However, as of MySQL 5.6 and MariaDB 10.0, there is GET DIAGNOSTICS, which can be used to get the exact error details as well.

RESIGNAL just outputs the error, as it comes from the server, for instance:

ERROR 1146 (42S02): Table 'db1.t1' doesn't exist

read more

Quickly Debugging Stored Procedures, Functions, Triggers, and Events with RESIGNAL
+0 Vote Up -0Vote Down

I was recently debugging a stored procedure and could not easily identify the underlying reason for why it was failing.

It had a standard exit handler catch-all for SQLEXCEPTION, which was:

DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
SELECT ...;
END;

When there was an error, it didn't really output anything useful.

As of MySQL 5.5, there is RESIGNAL:

"RESIGNAL passes on the error condition information that is available during execution of a condition handler within a compound statement inside a stored procedure or function, trigger, or event."

read more

Previous 30 Newer Entries Showing entries 91 to 120 of 32118 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.