News-Feeds

Der Angriff auf Afghanistan war kein Verteidigungsakt

Telepolis - Fr, 2016-09-02 08:00
Auch nach 15 Jahren Krieg kehrt kein Frieden ein und entwickeln Afghanen wieder Sympathien für die Taliban als "Befreier"
Kategorien: Politik + Kultur

Der Luxus-Effekt: Artenvielfalt und Wohnviertel

Telepolis - Fr, 2016-09-02 06:00
In reicheren Stadtvierteln gibt es nicht nur mehr Grün im Außenbereich, die Artenvielfalt von Spinnen und Insekten ist auch in den Häusern höher als in ärmeren Vierteln
Kategorien: Politik + Kultur

"Volksrepublik Donezk" eröffnet mit rechten Tschechen eine erste "Vertretung" in der EU

Telepolis - Do, 2016-09-01 22:00
Die Umsetzung des Minsker Abkommens steckt fest, weil keine Seite einen ersten Schritt machen will
Kategorien: Politik + Kultur

Unruhen im Gabun

Telepolis - Do, 2016-09-01 22:00
Moslem und Sohn eines Chinesen streiten um Wahlsieg - Parlament angezündet
Kategorien: Politik + Kultur

Percona Live Europe featured talk with Manyi Lu — MySQL 8.0: what’s new in Optimizer

MySQL High Performance - Do, 2016-09-01 21:09

Welcome to a new Percona Live Europe featured talk with Percona Live Europe 2016: Amsterdam speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference. We’ll also discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona Live Europe registration bonus!

In this Percona Live Europe featured talk, we’ll meet Manyi Lu, Director Software Development at Oracle. Her talk will be on MySQL 8.0: what’s new in Optimizer. There are substantial improvements in the optimizer in MySQL 5.7 and MySQL 8.0. Most noticeably, users can now combine relational data with NoSQL using the new JSON features. I had a chance to speak with Manyi and learn a bit more about the MySQL 8.0:

Percona: Give me a brief history of yourself: how you got into database development, where you work, what you love about it.

Manyi: Oh, my interest in database development goes way back to university almost twenty years ago. After graduation, I joined local startup Clustra and worked on the development of a highly available distributed database system for the telecom sector. Since then, I have worked on various aspects of the database, kernel, and replication. Lately I am heading the MySQL optimizer and GIS team.

What I love most about my work are the talented and dedicated people I am surrounded by, both within the team and in the MySQL community. We are passionate about building a database used by millions.

Percona: Your talk is called “MySQL 8.0: what’s new in Optimizer.” So, obvious question, what is new in the MySQL 8.0 Optimizer?

Manyi: There are a number of interesting features in 8.0. CTE or Common Table Expression has been one of the most demanded SQL features. MySQL 8.0 will support both the WITH and WITH RECURSIVE clausesA recursive CTE is quite useful for reproducing reports based on hierarchical data. For DBAs, Invisible Index should make life easier. They can mark an index invisible to the optimizer, check the performance and then decide to either drop it or keep it. On the performance side, we have improved the performance of table scans, range scans and similar queries by batching up records read from the storage engine into the server. We have significant work happening in the cost model area. In order to produce more optimal query plans, we have started the work on adding support for histograms, and for taking into account whether data already is in memory or needs to be read from disk.

Besides the optimizer, my team is also putting a major effort into utf8mb4 support. We have added a large set of utf8mb4 collations based on the latest Unicode standard. These collations have better support for emojis and languages. Utf8 is the dominating character encoding for the web, and this move will make the life easier for the vast majority of MySQL users. We also plan to add support for accent and case sensitive collations.

Please keep in mind that 8.0.0 is the first milestone release. There are quite a few features in the pipeline down the road.

Percona: How are some of the bridges between relational and NoSQL environments (like JSON support) of benefit to database deployments?

Manyi: The JSON support that we introduced in 5.7 has been immensely popular because it solves some very basic day-to-day problems. Relational database forces you to have a fixed schema, and the JSON datatype gives you the flexibility to store data without a schema. In the past, people stored relational data in MySQL and had to install yet another datastore to handle unstructured or semi-structured data that are schema-less in nature. With JSON support, you can store both relational and non-relational data in the same database, which makes database deployment much simpler. And not only that, but you can also perform queries across the boundaries of relational and non-relational data.

Clients that communicate with a MySQL Server using the newly introduced X Protocol can use the X DevAPI to develop applications. Developers do not even need to understand SQL if they do not want to. There are a number of connectors that support the X protocol, so you can use X DevApi in your preferred programming language. We have made MySQL more appealing to a larger range of developers.

Percona: What is the latest on the refactoring of the MySQL Optimizer and Parser?

Manyi: The codebase of optimizer and parser used to be quite messy. The parsing, optimizing and execution stages were intermingled, and the code was hard to maintain. We have had a long-running effort to clean up the codebase. In 5.7, the optimization stage was separated from the execution stage. In 8.0, the focus is refactoring the prepare stage and complete parser rewrite.

We have already seen the benefits of the refactoring work. Development time on new features has been reduced. CTE is a good example. Without refactoring done previously, it would have taken much longer to implement CTE. With a cleaner codebase, we also managed to reduce the bug count, which means more development resources can be allocated to new features instead of maintenance.

Percona: Where do you see MySQL heading in order to deal with some of the database trends that keep you awake at night?

Manyi: One industry trend is cloud computing and Database as a Service becoming viable options to in-house databases. In particular, it speeds up technology deployments and reduces initial investments for smaller organizations. MySQL, being the most popular open source database, fits well into the cloud data management trend.

What we can do is make MySQL even better in the cloud setting. E.g., better support for horizontal scaling, fail-over, sharding, cross-shard queries and the like.

Percona: What are looking forward to the most at Percona Live Europe this year?

Manyi: I like to speak and get feedback from MySQL users. Their input has a big impact on our roadmap. I also look forward to learning more about innovations by web-scale players like Facebook, Alibaba and others. I always feel more energized after talking to people who are passionate about MySQL and databases in general.

You can learn more about Manyi and her thoughts on MySQL 8.0 here: http://mysqlserverteam.com/

Want to find out more about Manyi, MySQL and Oracle? Register for Percona Live Europe 2016, and see her talk MySQL 8.0: what’s new in Optimizer.

Use the code FeaturedTalk and receive €25 off the current registration price!

Percona Live Europe 2016: Amsterdam is the premier event for the diverse and active open source database community. The conferences have a technical focus with an emphasis on the core topics of MySQL, MongoDB, and other open source databases. Percona live tackles subjects such as analytics, architecture and design, security, operations, scalability and performance. It also provides in-depth discussions for your high-availability, IoT, cloud, big data and other changing business needs. This conference is an opportunity to network with peers and technology professionals by bringing together accomplished DBA’s, system architects and developers from around the world to share their knowledge and experience. All of these people help you learn how to tackle your open source database challenges in a whole new way.

This conference has something for everyone!

Percona Live Europe 2016: Amsterdam is October 3-5 at the Mövenpick Hotel Amsterdam City Centre.

Merkel: "Rückführung, Rückführung und nochmals Rückführung"

Telepolis - Do, 2016-09-01 18:30
Die Kritik am Flüchtlingskurs der Kanzlerin zeigt Wirkung - und vielleicht auch die Umfragen, mit einem Rekord-Tief nach dem anderen
Kategorien: Politik + Kultur

Deutschland hilft Erdogan bei der Kurdenverfolgung

Telepolis - Do, 2016-09-01 17:00
Kurdische und türkische linke Oppositionelle werden in Deutschland inhaftiert, ohne dass sie Straftaten begangen haben. Das kurdische Kulturfestival in Köln wurde faktisch verboten
Kategorien: Politik + Kultur

Kein Frieden ohne Abdullah Öcalan

Telepolis - Do, 2016-09-01 16:00
Hochrangige kurdische Politikerinnen und Politiker kündigen Hungerstreik an, um das Ende der Kontaktsperre zu dem PKK-Gründer zu erzwingen
Kategorien: Politik + Kultur

"Viele Bürger haben schlicht Angst vor weiteren Veränderungen"

Telepolis - Do, 2016-09-01 14:00
Silke Gajek, Spitzenkandidatin der Grünen in Mecklenburg-Vorpommern, über getriebene Politiker, Wendeverlierer und die hohen Umfragewerte der AfD
Kategorien: Politik + Kultur

Türkei: Wenn alle zu Putschisten erklärt werden

Telepolis - Do, 2016-09-01 13:00
Der Aachener Friedenspreis ehrt Akademiker, die sich in der Türkei für Frieden engagieren. Seit dem Putschversuch wurden die Repressionen gegen sie verstärkt
Kategorien: Politik + Kultur

DGB-Studie: Auszubildende im Stress

Telepolis - Do, 2016-09-01 12:00
In der Küche wird geklagt, die Mechatroniker sind zufrieden
Kategorien: Politik + Kultur

Verschärftes Glühlampenverbot ab September 2016

Telepolis - Do, 2016-09-01 11:58
Ab dem 1. September 2016 verbietet eine EU-Verordnung in der Konsequenz der aktuellen EU-Ökodesign-Richtlinie, dass 230/240 Volt-Halogen-Spot-Lampen in den Handel gebracht werden - Restbestände dürfen noch abverkauft werden
Kategorien: Politik + Kultur

CSU will Verfassungsänderungen durch Volksentscheid in ihr Grundsatzprogramm aufnehmen

Telepolis - Do, 2016-09-01 11:00
Änderung könnte Auswirkungen auf die Kandidatenaufstellung haben
Kategorien: Politik + Kultur

Trump: "Mexiko wird für die Mauer zahlen"

Telepolis - Do, 2016-09-01 10:00
Der Besuch beim mexikanischen Präsidenten war eine Show-Einlage, um sein unverändert scharfes Einwanderungsprogramm zu präsentieren
Kategorien: Politik + Kultur

Die vergessene Whistleblowerin Chelsea Manning

Telepolis - Do, 2016-09-01 08:00
Ihr Selbstmordversuch und ihre verschärften Haftbedingungen wurden in Deutschland kaum wahrgenommen
Kategorien: Politik + Kultur

Afghanische Flüchtlinge sind Pakistans Sündenböcke

Telepolis - Do, 2016-09-01 06:00
Die drei Millionen Flüchtlinge, die teils schon Jahrzehnte in Pakistan leben, sind zahlreichen Repressalien ausgesetzt
Kategorien: Politik + Kultur

Keine "stabile und dauerhafte Regierung" in Spanien

Telepolis - Mi, 2016-08-31 22:01
Der konservative Rajoy fiel wie erwartet bei der Abstimmung im Parlament durch, doch er hofft noch auf den zweiten Wahlgang
Kategorien: Politik + Kultur

Debatte über Streichung der Homöopathie aus den Leistungskatalogen

Telepolis - Mi, 2016-08-31 22:00
Heilpraktikergesetz aus der Nazizeit soll reformiert werden
Kategorien: Politik + Kultur

Parlamentsputsch in Brasilien ist nun offiziell

Telepolis - Mi, 2016-08-31 22:00
Gewählte Präsidentin Dilma Rousseff ist abgesetzt. Ex-Vizepräsident führt Amt fort, zahlreiche Gegner der Politikerin sind mutmaßlich korrupt
Kategorien: Politik + Kultur

Mecklenburg-Vorpommern: Die AfD macht der CDU Konkurrenz

Telepolis - Mi, 2016-08-31 17:00
Umfragen deuten auf größere Verluste links von der Mitte, bei der SPD und den Linken. Insa sieht die AfD vor der CDU
Kategorien: Politik + Kultur