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

Displaying posts with tag: ibm (reset)

Update on MySQL on POWER8
+2 Vote Up -0Vote Down

About 1.5 months ago I blogged on MySQL 5.6 on POWER andtalked about what I had to poke at to make modern MySQL versions run and run well on shiny POWER8 systems.

One of those bugs, MySQL bug 47213 (InnoDB mutex/rw_lock should be conscious of memory ordering other than Intel) was recently marked as CLOSED by the Oracle MySQL team and the upcoming 5.6.20 and 5.7.5 releases should have the fix!

This is excellent news for those wanting to run MySQL on SMP systems that don’t have an Intel-like memory model (e.g. POWER and MIPS64).

This was the most major and invasive patch in the patchset for MySQL on POWER. It’s absolutely fantastic that this has made it into 5.6.20 and 5.7.5 and

  [Read more...]
Performance impact of MySQL query cache on modern hardware
+4 Vote Up -1Vote Down

Recently, Morgan has been writing on deprecating some MySQL features and inspired by that while working on MySQL on POWER, I wondered “What is the impact of the MySQL query cache on modern hardware?”

We’ve known for over six years (since before we started Drizzle) that the query cache hurt performance. It was for that reason that the query cache was one of the early things to be removed from Drizzle, it just didn’t scale on multi core systems that  we were targeting.

So what about modern hardware? While working on MySQL 5.6 on

  [Read more...]
1 million SQL Queries Per Second: MySQL 5.7 on POWER8
+1 Vote Up -0Vote Down

I’ve previously covered MySQL 5.6 on POWER (with patch), MySQL 5.6 Performance on POWER8 (spoiler: new performance record) and MySQL 5.7 on POWER.

Of course, The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions. Also, these numbers should be considered preliminary, but trust me – I did get them and it’s not April 1st.

From my last post, you saw that with my preliminary patch for MySQL 5.7 to work on POWER, we could easily match the

  [Read more...]
MySQL 5.7 on POWER
+0 Vote Up -0Vote Down

In a previous post, I covered porting MySQL 5.6 to POWER and subsequently, some new record performance numbers with MySQL 5.6.17 on POWER8.

Well, those following at home will be aware that not only is the next sentence sponsored by IBM Legal, but that MySQL 5.7 alleviates a bunch of the mutex contention that we saw with MySQL 5.6. The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.

In looking at MySQL performance on POWER, it’s inevitable that I should look at MySQL 5.7 and what’s coming up in the next stable release of MySQL.

Surprisingly, a bunch of the core code in InnoDB and MySQL dealing with mutexes

  [Read more...]
MySQL 5.6 Performance on POWER8
+0 Vote Up -0Vote Down

The following sentence is brought to you by IBM Legal: The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.

My previous post covered the work needed to get MySQL 5.6.17 running reliably on modern POWER systems. The patch to MySQL 5.6.17 that’s needed is available here.

For those who don’t know, POWER8 is the latest Power Architecture processors from IBM (my employer). These chips will be available in systems from IBM in June 2014 (i.e. Real Soon Now(TM)). There’s

  [Read more...]
MySQL 5.6 on POWER (patch available)
+0 Vote Up -0Vote Down

The following sentence is brought to you by IBM Legal. The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.

Okay, now that is out of the way….

If you’re the kind of person who follows the MySQL bugs database closely or subscribes to the MySQL Internals mailing list, you may have worked out that I’ve spent a small amount of time poking at MySQL on modern POWER systems.

Unlike Intel CPUs, POWER CPUs require explicit memory barriers to synchronize memory state between different CPUs. This means that when you’re implementing synchronization primitives,

  [Read more...]
and now for something completely different…
+0 Vote Up -0Vote Down

As many of you know, I’ve been working in the MySQL (http://www.mysql.com) world for quite a while now. IN fact, it was nearly 10 years ago when I first started hacking on MySQL Cluster (https://www.mysql.com/products/cluster/) at MySQL AB.

Most recently, I was at Percona which was a wonderful journey where over my nearly three years there the company at least doubled in size, launched several new software products and greatly improved the quality and frequency of releases.

However the time has come for something

  [Read more...]
The Data Day, A few days: March 29-April 8 2013
+0 Vote Up -0Vote Down

Tableau preps IPO. Funding for SiSense and Deep. And more.

* For 451 Research clients: Citus Data brings SQL to foreign data environments, starting with Hadoop

* For 451 Research clients: With $20m in series B funding in the bag, Platfora makes its Hadoop-based analysis debut

* Tableau Software Files Registration Statement For Proposed Initial Public Offering.

* SiSense raises $10m series B funding.

*

  [Read more...]
The Data Day, Two days: February 5/6 2013
+0 Vote Up -0Vote Down

Oracle launches MySQL 5.6. IBM expands PureData line. And more

For 451 Research clients: IBM adds to PureData family with new Netezza-based system for analytics bit.ly/UXhZ8G

— Matt Aslett (@maslett) February 6, 2013

For 451 clients: Panopticon illuminates real-time visual analysis business, rides SAP’s HANA coattails bit.ly/YQpemt By Krishna Roy

— Matt Aslett (@maslett) February 5, 2013

Oracle Announces General Availability of MySQL 5.6 mwne.ws/XTC2Se

— Matt Aslett (@maslett)

  [Read more...]
The Data Day, A few days: January 2-4, 2013
+0 Vote Up -0Vote Down

Apache Cassandra and BigTop updates. And more

For 451 Research clients: Kx Systems aims to slipstream the ‘big data’ bandwagon to expanded kdb+ adoption bit.ly/VxkYlC

— Matt Aslett (@maslett) January 3, 2013

For 451 Research clients: IBM sheds light on ‘big data’ integration and governance the Big Blue way bit.ly/ZTAZcw By Krishna Roy

— Matt Aslett (@maslett) January 2, 2013

The Apache Software Foundation Announces Apache Cassandra v1.2 bit.ly/UFGKFN

— Matt Aslett (@maslett)

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