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 32946 Next 30 Older Entries
The InnoDB Mutex, part 3
+0 Vote Up -0Vote Down
I repeated tests from part 1 and part 2 using a system that has an older/smaller CPU but more recent versions of glibc & Linux. In this case the CPU has dual sockets with 6 cores per socket and 24 vCPUs with HT enabled. The host uses Fedora, glibc 2.17 and Linux kernel 3.11.9-200. Tests were run up to 512 threads. There was an odd segfault at 1024 threads with the TTASFutexMutex that I chose not to debug. And tests were run for 1, 4 and 12 mutexes rather than 1, 4 and 16 because of the reduced vCPU count. The lock hold duration was ~6000 nsecs rather than ~4000 because of the different CPU.

My conclusions from this platform were less strong than from the previous tests.
  • The InnoDB syncarray mutex still

  [Read more...]
ConFoo is looking for speakers
+0 Vote Up -0Vote Down

ConFoo is currently looking for web professionals with deep understanding of PHP, Java, Ruby, Python, DotNet, HTML5, Databases, Cloud Computing, Security and Mobile development to share their skills and experience at the next ConFoo. Submit your proposals between August 25th and September 22nd.

ConFoo is a conference for developers that has built a reputation as a prime destination for exploring new technologies, diving deeper into familiar topics, and experiencing the best of community and culture.

  • ConFoo 2015 will be hosted on February 18-20 in Montreal, at the Hilton Bonaventure Hotel.
  • We take good care of our speakers by covering most expenses including travel, accommodation, lunch, full conference ticket, etc.
  • Presentations are 35min + 10min for questions, and may be delivered in
  [Read more...]
HowTo Video: Using MySQL ASP.NET MVC Project Wizard
Employee +0 Vote Up -0Vote Down
MySQL for Visual Studio 1.2.x recently became a GA version. One of the main features included in this version was the new MySQL ASP.NET MVC Wizard. This wizard allows the creation of a new ASP.NET MVC application using a MySQL existing database and a data entity model with Entity Framework 5 or 6 version. In this video you will see this feature in action and will show you how to generate a complete MVC application that includes authentication, registration and browsable pages for each table in your MySQL database without any code needed.
The InnoDB Mutex, part 2
+1 Vote Up -0Vote Down
I updated the innotsim client to include a new custom mutex from InnoDB in MySQL 5.7. This is called TTASFutexMutex in the source. I also fixed a bug in innotsim - the benchmark timer was started too soon so these results are more accurate than the original post.

The original post has much more detail on the tests. In the graphs below, TTASFutexMutex has the label inno futex and the old-style custom mutex that uses a sync array has the label inno syncarray. My updated conclusions are:
  • TTASFutexMutex is worse than pthread default when the lock

  [Read more...]
Second MySQL User Group Korea meeting
Employee_Team +0 Vote Up -0Vote Down

We are pleased to announce the second MySQL User Group meeting in Seoul, South Korea.

This time Daesang Information & Technology sponsors venue and snack. Please find more information below.

Date & Time: 29th Aug, 2014, 7pm to 9 pm

VenueTOZ Kangnam tower, 2nd floor


1. MySQL Fabric intro

2. MySQL Cluster intro & demo

3. Select MUG Staff

See more details

We are looking forward to talking to you! 

OpenStack Trove Day 2014 Recap: MySQL and DBaaS
+0 Vote Up -0Vote Down

OpenStack Trove Day

I just returned from a week in Cambridge, Massachusetts where I was attending the OpenStack Trove Day and the Trove mid-cycle meetup, both sponsored by the great folks at Tesora.

I am relatively new to the OpenStack and Trove arenas so this was a fantastic opportunity for me to learn more about the communities, the various components within OpenStack, and what part Trove plays. I found the entire event very worthwhile – I met a lot of key people in the community, learned more about Trove and its potential, and in general felt a great energy and

  [Read more...]
Resources for Database Clusters: Performance Tuning for HAProxy, Support for MariaDB 10, Technical Blogs & More
+0 Vote Up -0Vote Down
August 28, 2014 By Severalnines

Check Out Our Latest Resources for MySQL, MariaDB & MongoDB Clusters


Here is a summary of resources & tools that we’ve made available to you in the past weeks. If you have any questions on these, feel free to contact us!


New Technical Webinars


  [Read more...]
Baron Schwartz to Speak on the Power of Regressions
+0 Vote Up -0Vote Down

Baron Schwartz, our CEO and founder, is speaking at the Performance and Capacity Conference by CMG on November 6th. CMG, the Computer Measurement Group is a not-for-profit organization that focuses on the efficiency and scalability of IT service delivery through measurement, quantitative analysis and forecasting. It has been a reputable, worldwide resource for best practices in the IT profession since 1974.

Baron will be contributing to these efforts when he presents on “Using Regressions to Estimate Query Resource Consumption.” VividCortex uses regression to generate metrics for many things that cannot be measured directly, allowing us to provide robust sets of data while reducing the measurement intrusion effect on systems. In particular, our customers are

  [Read more...]
Trawling the binlog with FlexCDC and new FlexCDC plugins for MySQL
+0 Vote Up -0Vote Down

Swanhart-Tools includes FlexCDC, a change data capture tool for MySQL. FlexCDC follows a server’s binary log and usually writes “changelogs” that track the changes to tables in the database. I say usually because the latest version of Swanhart-Tools (only in github for now) supports FlexCDC plugins, which allow you to send the updates to a remote data source, or to any other place of your liking.  You can find out more about FlexCDC basics in a previous blog post.

Please note that FlexCDC still needs to have source and destination

  [Read more...]
The InnoDB mutex
+3 Vote Up -0Vote Down
InnoDB provides a custom mutex and rw-lock implementation. I wondered how the InnoDB mutex performance compares to a pthread mutex on modern hardware and finally had time to test it. My test client is innotsim and includes code copied from InnoDB in MySQL 5.6. There is a lot of work-in-progress for InnoDB mutexes in 5.7 and I have yet to catch up to that work. 


Generally, the performance is more constant for pthread mutex and more a function of the number of threads for the InnoDB mutex. The interesting result is the point (number of threads in the test) at which the lines cross and the InnoDB mutex changes from being faster to slower than
  [Read more...]
Query Sphinx with Node.js
+0 Vote Up -0Vote Down
You probably already know that Sphinx supports MySQL binary network protocol. But, if you haven’t heard– Sphinx can be accessed with the regular ol’ MySQL API. Pretty much any language you use to query MySQL can be used to query Sphinx. So, in this post, to demonstrate how using ‘SphinxQL’ (our subset of SQL) makes [...]
Replicating from MySQL to Amazon Redshift
+0 Vote Up -0Vote Down
Continuent is delighted to announce an exciting Continuent Tungsten feature addition for MySQL users: replication in real-time from MySQL into Amazon RedShift.   In this webinar we'll survey Continuent Tungsten capabilities for data warehouse loading, then zero in on practical details of setting up replication from MySQL into RedShift.  We'll cover: Introduction to real-time movement from
mysqld_multi: How to run multiple instances of MySQL
+0 Vote Up -0Vote Down

The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines, is not very common. Yet from time to time the Percona Support team receives a request from a customer to assist in the configuration of such an environment. MySQL provides a tool to facilitate the execution of multiple instances called mysqld_multi:

“mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports. It can start or stop servers, or report their current

  [Read more...]
Workbench 6.2, CakePHP’s new ORM, and OKC Meetup on Wednesday
Employee +1 Vote Up -0Vote Down

In the beginning was the MySQL command line and it was good. Verbose yes, error prone yes, and even tedious. But it was good. The UPDATE USER set SELECT_PRIV=’Y’, DROP_PRIV_’Y”, UPDATE_PRIV=’Y’,……,LAST_BLOODY_PRIV=’Y”; type errors have caught of us old timers. But it was still good.

Then came some GUI tools that were okay. Not great but they had their uses.

And then came MySQL Workbench. And it was very good.

Now there is MySQL Workbench 6.2 and it is excellent. It came out in Beta last week and has built on the proven success of its predecessors. All the usual stuff is there – Server Status, Users & Privileges, Startup/Shutdown, logs, Dashboard, Performance Reports and more. But there area whole bunch of subtle little tweaks that make it easier

  [Read more...]
MySQL at the Malaysian OpenSource Conference
Employee_Team +1 Vote Up -1Vote Down

MySQL team attends and speaks at the MOSC 2014 on September 24-25, 2014 in Kuala Lumpur, Malaysia. We are having a MySQL booth and above that our local colleague Ricky Setyawan has secured one 45 minutes talk scheduled for Wed, Sep 24 @2:15-3:00pm on the MySQL Web Reference Architecture.

We will also run two hours workshop on MySQL Fabric scheduled for Thursday, Sep 25 @2:30-4:30pm. If you are around do not forget to come to our booth and/or visit our MySQL session & workshop!

How to use value from row derived column from a table in another query?
+1 Vote Up -1Vote Down
SELECT...INTO can be used to store the single row column result value from a query to be used in another query depending on that value.

"accounts" table

| Field        | Type        | Null | Key | Default | Extra          |
| account_id   | int(11)     | NO   | PRI | NULL    | auto_increment |
| account_name | varchar(50) | NO   |

  [Read more...]
OpenStack’s Trove: The benefits of this database as a service (DBaaS)
+1 Vote Up -0Vote Down

In a previous post, my colleague Dimitri Vanoverbeke discussed at a high level the concepts of database as a service (DBaaS), OpenStack and OpenStack’s implementation of a DBaaS, Trove. Today I’d like to delve a bit further into Trove and discuss where it fits in, and who benefits.

Just to recap, Trove is OpenStack’s implementation of a database as a service for its cloud infrastructure as a service (IaaS). And as the mission statement declares, the Trove project seeks to provide a scalable and reliable cloud database service providing functionality for both relational and non-relational database engines. With the current

  [Read more...]
OurSQL Episode 197: NoSQL for MySQLers
+0 Vote Up -0Vote Down

This week, we talk with Tim Callaghan of Tokutek about NoSQL for MySQLers. Ear Candy is getting rid of InnoDB temporary tables and At the Movies is about "Disaster Recovery Lessons I Hoped I'd Never Have to Learn".

Learn All About MySQL Cluster
Employee_Team +0 Vote Up -0Vote Down

Just released - the all new MySQL Cluster training course.

This MySQL Cluster training teaches you how to install and configure a real-time database cluster at the core of your application. Expert instructors will teach you how to design and maintain your clusters for high availability and scalability by using MySQL Cluster's open-source and enterprise components.

This 4-day training course is a must for those who want to learn about MySQL Cluster as you will not only learn about the concepts and features but you will get extensive hands-on experience. You can follow this training course from your own desk via a live-virtual training or by traveling to an education center to follow this course.

  [Read more...]
Use of loops in MySQL stored procedures
+1 Vote Up -1Vote Down
Loops -> Repetitive tasks

3 types of loops in MySQL stored program:
- Simple loop using LOOP and END LOOP clauses
- WHILE and END WHILE clauses that runs while a condition is true
- REPEAT  and UNTIL clauses that runs until a condition is true

Termination of loop -> LEAVE statement.

I will demonstrate the use of loops the simple loop way.

Simple counter from 1 to 10:

Store below stored procedure in a file named my_loop.sql


  [Read more...]
FromDual.en: MySQL Environment MyEnv 1.1.0 has been released
+1 Vote Up -0Vote Down
Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackupcatalog

FromDual has the pleasure to announce the release of the new version 1.1.0 of its popular MySQL, MariaDB and Percona Server multi-instance environment MyEnv.

The majority of improvements happened in the MySQL Backup Manager (mysql_bman) where we added a backup catalog.

You can download MyEnv from

  [Read more...]
Using conditional expressions inside MySQL Stored Procedure
+1 Vote Up -1Vote Down
Sometimes there is need to use conditional expression inside stored procedure to control the flow of execution.
We can use IF or CASE statements for this.

Below is a stored procedure to check the performance of a student based on its score.
Store the below stored procedure in a file called get_performance.sql


DROP PROCEDURE IF EXISTS get_performance$$

CREATE PROCEDURE get_performance
    (score NUMERIC(8, 2),
    OUT result VARCHAR(11))


  [Read more...]
9 Tips for Going in Production with Galera Cluster for MySQL
+0 Vote Up -0Vote Down
August 25, 2014 By Severalnines

Are you going in production with Galera Cluster for MySQL? Here are 9 tips to consider before going live. These are applicable to all 3 Galera versions (Codership, Percona XtraDB Cluster and MariaDB Galera Cluster). 


1. Galera strengths and weaknesses


There are multiple types of replication and cluster technologies for MySQL, make sure you understand how Galera works so you set the right expectations.

  [Read more...]
When (and how) to move an InnoDB table outside the shared tablespace
+0 Vote Up -0Vote Down

In my last post, “A closer look at the MySQL ibdata1 disk space issue and big tables,” I looked at the growing ibdata1 problem under the perspective of having big tables residing inside the so-called shared tablespace. In the particular case that motivated that post, we had a customer running out of disk space in his server who was looking for a way to make the ibdata1 file shrink. As you may know, that file (or, as explained there, the set of ibdata files composing the shared tablespace) stores all InnoDB tables created when innodb_file_per_table is disabled, but also other InnoDB structures, such as undo logs and data dictionary.

For example, when you run a transaction involving

  [Read more...]
How to make MaxScale High Available with Corosync/Pacemaker
+1 Vote Up -0Vote Down
Fri, 2014-08-22 09:55massimiliano_pinto_g

MaxScale, an open-source database-centric router for MySQL and MariaDB makes High Availability possible by hiding the complexity of backends and masking failures. MaxScale itself however is a single application running in a Linux box between the client application and the databases - so how do we make MaxScale High Available? This blog post shows how to quickly setup a Pacemaker/Corosync environment and configure MaxScale as a managed cluster resource.

Anyone following the instructions detailed here, modifying configuration files and issuing system and software checks could create a complete setup with three Linux Centos 6.5 servers and unicast heartbeat mode.

In a few steps MaxScale will be ready for basic HA

  [Read more...]
How to install sysbench 0.5 on Debian 7
+2 Vote Up -0Vote Down
Normally, sysbench 0.4.12 version can be installed from repositories like “apt-get install sysbench” but the newer version 0.5 is not added in any repo yet (AFAIK) so, it’s bit difficult to install it. 1. Install bzr package if it’s not Continue reading →   [Read more...]
How to use and get output arguments in stored procedure using OUT parameter mode?
+1 Vote Up -0Vote Down
It is sometimes required to get the result of a stored procedure in a variable which can be used later or to output the result.

To do so, we can use the "OUT" parameter mode while defining stored procedures.

In the below section, we will be writing a stored procedure to get the square root of a number returned in an output variable provided by us.

Stored Procedure Definition:

Store the below stored procedure in a file named my_sqrt.sql and save it.




  [Read more...]
New XAMPP with PHP 5.5.15 and 5.4.31 versions
+0 Vote Up -0Vote Down

Hi Apache Friends!

We are happy to announce a new release of XAMPP for all platforms. This release updates the main components to the latest stable versions. You can download new versions at http://www.apachefriends.org/download.html.


  • Updated Apache to 2.4.10
  • Updated PHP to 5.5.15
  • Updated MySQL to 5.6.20
  • phpMyAdmin
  • Fixed MySQL issue for OS X Yosemite
  • Updated OpenSSL to 1.0.1i for OS X and Linux


  • Updated Apache to 2.4.10
  • Updated PHP to 5.4.31
  • phpMyAdmin
  • Fixed MySQL issue for OS X Yosemite
  • Updated OpenSSL to 1.0.1i for OS X and Linux

We also expanded the number of Bitnami-packaged applications compatible with XAMPP. In

  [Read more...]
Connector/Python 1.2
+2 Vote Up -0Vote Down
Connector/Python 1.2 (1.2.3 GA, published on Friday, 22 Aug 2014)
Review of the MariaDB Cookbook
+0 Vote Up -0Vote Down

Disclosure -- I received a copy of this book from the publisher for review.


The MariaDB Cookbook is well written by someone who knows the MariaDB database server quite well. Writing a 300 page book by yourself is no small feat and Daniel has done it with aplomb. I am most familiar with Percona server and Oracle's MySQL server but I have been interested in MariaDB for some of its new features -- especially the multi-source replication. I took a look at this section in particular and it was well done with clear step by step instructions on how to accomplish multi-source replication. Each of the recipes follow this pattern with clear, concise steps. My only complaint about the cookbook items are that they might be that they are a little too concise at times -- although to Daniel's credit there are frequent See Also sections that point to deeper details.


As I read through the

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