EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Live 2016: Sometimes “Less is More” for dash-boarding and graphing

Latest MySQL Performance Blog posts - April 21, 2016 - 2:12pm

We’re starting to wind down here at Percona Live 2016, but there are still talks to see even this late in the conference! One of the talks I saw was Sometimes “Less is More” for dash-boarding and graphing with Michael Blue, Senior DBA at Big Fish Games.

In this talk, Michael discussed how monitoring specific metrics can be more help than all the metrics. In a monitor/measure everything environment, to get the big picture sometimes “Less is More.” There are good monitoring tools available for DBAs, with tons of metrics to measure, but at a larger scale it seems impossible to get that big picture view of your environment without spending much of your time going over all the metrics your graphing, sifting through emails of false positives alerts, and reading tons of your cron job outputs. In the talk, Michael explained the approaches he took at Big Fish to create better dashboards for all audiences without visual overload, which helped the DBAs find potential issues that were not caught via conventional monitoring. This session included:

This session included:

  • The basics of visualization
  • Picking metrics to measure at scale
  • How they leverage custom dashboards, Graphite, and the MySQL Enterprise Monitor

I had a chance  to speak with Michael after his talk:

 Check out more of the Percona Live 2016 schedule here.

Percona Live 2016: Percona Live Game Night!

Latest MySQL Performance Blog posts - April 21, 2016 - 1:09pm

Wednesday night at Percona Live 2016 was reserved for fun, fun, fun! Once again, the Percona Live Game Night proved to be a popular and amazing event. There were more games this year than last, as well as food, drinks, and lots of friendly competition!

This year, besides the ever-crowd-pleasing Meltdown Challenge, there were Segway Races, pool, foosball, shuffleboard, Wii Boxing, Pac-Man Attack, a shootout gallery, darts, as well as virtual reality stations and a death-defying trampoline.

You can see Percona’s CEO Peter Zaitsev demonstrating how you use it, pro-level:

Below are some more photos of this outstanding night:

Coed boxing: guys, you need to improve your skills!

.

Some very intense foosball action!

.

This Pac-Man Attack reminds me of 1983!

.

Keep an eye on your wallets, gentlemen, I detect a hustle.

.

More trampoline.

.

For those who like less effort with their trampoline, virtual reality.

.

A little social lubrication.

.

Happy attendees (must have stopped at the previous picture).

.

Hmm, that guy looks a bit confused. Must be too much tech talk for one day!

.

I’d stay away from this table. Just saying.

.

More happy.

.

Thanks to everybody who came out and participated in an awesome night! We’ll see you all next year!

 

 

Percona Live 2016: MySQL Community Awards Ceremony

Latest MySQL Performance Blog posts - April 21, 2016 - 12:23pm

We wrapped up Thursday morning’s Percona Live 2016 keynotes (April 21)  with The MySQL Community Award Ceremony. The MySQL Community Awards is a community-based initiative, with the goal of publicly recognizing contributors to the MySQL ecosystem. 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 on past winners or their representatives, as well as known contributors. It is a self-appointed, self-declared, self-making-up-the-rules-as-it-goes committee. It is also very aware of the importance of the community; a no-nonsense, non-political, adhering to tradition, self-criticizing committee.

The categories can be found here.

We celebrated the members of the open source community, and some big open source contributors from the past year! The winners this year were:

Community Contributors of the Year:

  • Bill Karwin, Senior Database Architect and Software Engineer at SchoolMessenger
  • Domas Mituzas, Small Data Engineer at Facebook
  • Yoshinori Matsunobu, Data Engineer at Facebook

Application of the Year:

Corporate Contributor of the Year:

 

Congratulation to all the winners! You can watch the whole ceremony below (it’s about 15 minutes long).

Percona Live 2016: Day Three Keynote Talks

Latest MySQL Performance Blog posts - April 21, 2016 - 11:52am

We’re heading into the final day here at Percona Live 2016! People are looking a little tired, but still excited for some excellent talks today. Once again the day started off with two great keynote lectures. Read to the end for an important announcement!

Peter Zaitsev, CEO of Percona
Winning with Open Source Databases

Peter discussed what makes the open source community so vibrant and powerful, and why it is essential to preserve that spirit. Data is critical to the success of your business. You rely on your database and its supporting systems to power the applications that drive your business. These systems must be reliable, scalable, efficient – and increasingly, open source. With the complexity of today’s web applications and the databases, systems and hardware that support them, organizations must use the right open source tools and technology for each job – without getting locked into a proprietary solution. With Percona, customers are assured a choice in technology options that are completely open source (and include enterprise features). We help our customers find the right technology for their specific needs, rather than sell a one-size-fits-all product. Percona is a true open source partner that helps you optimize your database performance to better run your business.

Patrick McFadin, Chief Evangelist at DataStax

Take back the power in your cloud applications with Apache Cassandra

Patrick discussed how cloud applications can help you to develop the applications you need in your business, but also outline why the cloud isn’t a panacea for every business issue. Database engineers have had to support the crazy dreams of application developers since the beginning of the internet. Patrick says it’s time to take back the power! He believes that Apache Cassandra is the tool that can help you eliminate downtime or span your data around the world with ease. Deploying to the cloud isn’t always easy, but Cassandra might be able to give your application developers the best chance they can get and sleep easy at night.

 

Post MongoDB World New York Conference, June 30th, Hilton Mid-Town Manhattan

Peter also made an important announcement: Percona and ObjectRocket/Rackspace will be sponsoring a free post-MongoDB World Community Event! The event will take place on Thursday, June 30th at the Hilton Mid-Town Manhattan.

All are welcome.

Don’t miss out on this amazing opportunity to share ideas and get insights after MongoDB World.

Check out the rest of today’s Percona Live 2016 schedule here.

OS user for backup and restore of Percona

Lastest Forum Posts - April 21, 2016 - 10:49am
Hello,

When you install percona-server 5.7 from the repository the user mysql doesn't allow a login shell. Actually, it has been like this for awhile so that is not the issue. My issue is with how to use xtrabackup to backup and restore the database. Assuming I don't want mysql to have a login shell how do you run xtrabackup as it requires access to the files in /var/lib/mysql. How are people setting up their OS backup users to be able to backup and restore a database on CentOS 7 or any RH derivative. ( perhaps the issue is the same on any OS )

Thanks
Scott.

MySQL varaible innodb_file_per_table in production activate

Lastest Forum Posts - April 21, 2016 - 5:29am
Hey Community,

I have a MySQL-Server 5.5 with around 5.000.000 records in each table.
Now i want to activate the variable "innodb_file_per_table = 1".
The Reason is for activating the option, is to optimize performance.

For rebuild the tables to store each table in its own file i must execute the below statement.
Is that correct or any other steps are needed?

ALTER TABLE table_name ENGINE=InnoDB;

Thanks and Regards
chris



Percona Live 2016: What’s New in MySQL

Latest MySQL Performance Blog posts - April 20, 2016 - 10:14pm

The second day of Percona Live 2016 is wrapping up, but I still wanted to get to one last lecture. Fortunately, there was a great one available: What’s New in MySQL with Geir Høydalsvik, Senior Software Development Director at Oracle, and Simon Mudd, DBA at booking.com.

MySQL 5.7 is an extremely exciting new version of the world’s most popular open source database that is 2x faster than MySQL 5.6, while also improving usability, manageability, and security. MySQL 5.7, now in GA, is the result of almost three years of development and brings improvements to all areas of the product. Some key enhancements include:

  • MySQL improved InnoDB scalability and temporary table performance, enabling faster online and bulk load operations, and more.
  • They’ve added native JSON support.
  • For increased availability and performance, they’ve included multi-source replication, multi-threaded slave enhancements, online GTIDs, and enhanced semi-sync replication.
  • They’ve added numerous new monitoring capabilities so the Performance Schema for better insights, reduced the footprint and overhead, and significantly improved ease of use with the new SYS Schema.
  • They are fulfilling “secure by default” requirements, and many new MySQL 5.7 features will help users keep their database secure.
  • They have rewritten large parts of the parser, optimizer, and cost model. This has improved maintainability, extendability, and performance.
  • GIS is completely new in MySQL 5.7, as is InnoDB spatial indexes, the use of Boost.Geometry, and increased completeness and standard compliance.

 I had a chance to talk with Geir and Simon after their lecture:

Check out the Percona Live 2016 schedule for more talks!

Percona Live 2016: MySQL and Docker Strategies

Latest MySQL Performance Blog posts - April 20, 2016 - 6:19pm

The afternoon sessions at Percona Live 2016 are just as intriguing as the morning sessions. I’m trying to hit as many as I can, especially talks on interesting and upcoming technologies that are improving deployments and manageability. One of the talks I saw in this vein was MySQL and Docker Strategies, given by Patrick Galbraith, Senior Systems Engineer at Hewlett Packard, and Giuseppe Maxia, Quality Assurance Director at VMware.

Docker is a great new project for managing containers. Containers provide operating system resource isolation and allocation benefits as virtual machines, yet are more lightweight and allow you a lot of flexibility in how you can design your application and database architecture. This talk covered many of the useful things one can do with Docker and MySQL, such as:

  • Build ready-to-launch containers that are “batteries included” MySQL servers
  • Backup and restore MySQL databases using a container strategy that allows both containers and host systems access to the same data
  • Network containers across hosts
  • Implement container clustering solutions such as CoreOS, Kubernetes, and Mesos and how each of these solutions solves a similar requirement
  • Automate containerized MySQL using Ansible

Patrick and Giuseppe also provided summary details and a demonstration of their recent contribution to Kubernetes (a Galera cluster application), which showed how one can have a quickly deployable MySQL synchronous replication cluster in minutes and use it with other Kubernetes applications.

I had a chance to speak with Giuseppe after the talk:

 

Check out the Percona Live 2016 schedule for more talks!

Percona Live 2016: Indexing Strategies and Tips for MongoDB

Latest MySQL Performance Blog posts - April 20, 2016 - 3:57pm

The second day at Percona Live 2016 is moving along, and there is just too much to see to get to it all. Percona acquired Tokutek last year and with it a MongoDB platform. I was interested in learning more about MongoDB this year at Percona Live 2016, and I’m not disappointed! There is at least one MongoDB lecture ever hour, along with a MongoDB 101 track led by Percona experts who take attendees through the fundamentals of MongoDB tools and techniques.

One of the MongoDB lectures I attended was lead by Kimberly Wilkins, Principal Engineer/Databases at ObjectRocket by Rackspace. Her lecture was titled Indexing Strategies and Tips for MongoDB. In this presentation, Kimberly covered general indexing, options, and strategies. With the new indexing improvements and changes in MongoDB 3.2, there are more indexing options than ever before – including automated index builds and partial indexes. After this talk, I was able to walk away with real world examples of index use cases for running at scale and for high performance that have been tested with multiple high-level clients in small to very large MongoDB databases.

After the talk, I was able to chat with Kimberly for a minute:

See the rest of the Percona Live 2016 schedule here.

Percona Live 2016: Operational Buddhism — Building Reliable Services From Unreliable Components

Latest MySQL Performance Blog posts - April 20, 2016 - 1:55pm

It’s another packed day here at Percona Live 2016, with many, many database topics under discussion. Some technical, some strategical, and some operational. One such talk I sat in on was given by Ernie Souhrada, Database Engineer and Bit Wrangler at Pinterest. His talk was called Operational Buddhism: Building Reliable Services From Unreliable Components.

In it he discussed how the rise of utility computing has revolutionized much about the way organizations think about infrastructure and back-end serving systems, compared to the “olden days” of physical data centers. But success is still driven by meeting your SLAs. If services are up and sufficiently performant, you win. If not, you lose. In the traditional data center environment, fighting the uptime battle was typically driven by a philosophy Ernie calls “Operational Materialism.” The primary goal of OM is preventing failures at the infrastructure layer, and mechanisms for making this happen are plentiful and well-understood, many of which boil down to simply spending enough money to have at least N+1 of anything that might fail.

Ernie contends that in the cloud, Operational Materialism cannot succeed. Although the typical cloud provider tends to be holistically reliable, there are no guarantees that any individual virtual instance will not randomly or intermittently drop off the network or be terminated outright. Since we still need to keep our services up and running and meet our SLAs, we need a different mindset that accounts for the fundamentally opaque and ephemeral nature of the public cloud.

Ernie presented an alternative to OM, a worldview that he referred to as “Operational Buddhism.” Like traditional Buddhism, OB has Four Noble Truths:

  1. Cloud-based servers can fail at any time for any reason
  2. Trying to prevent this server failure is an endless source of suffering for DBAs and SREs alike
  3. Accepting the impermanence of individual servers, we can focus on designing systems that are failure-resilient, rather than failure-resistant
  4. We can escape the cycle of suffering and create a better experience for our customers, users, and colleagues.

To illustrate these concepts with concrete examples, he discussed how configuration management, automation, and service discovery help Pinterest to practice Operational Buddhism for both stateful (MySQL, HBase) and stateless (web) services. He also talked about some of the roads not taken, including the debate over Infrastructure-as-a-Service (IaaS) vs. Platform-as-a-Service (PaaS).

I was able to have a quick chat with Ernie after the talk:

 

See the rest of the Percona Live 2016 schedule here.

Percona Live 2016: Day Two Keynote Talks

Latest MySQL Performance Blog posts - April 20, 2016 - 1:23pm

We’ve started the second full day at Percona Live 2016, and again we had some pretty impressive and fascinating keynote speakers. This morning featured four keynote talks from some pretty heavy hitters in our industry:

Anurag Gupta, Vice President of Big Data Services, Amazon Web Services
AWS Big Data Services: Reimagining Big Data Processing in the Cloud

In this talk, we found out about the data challenges and trends that drove AWS to reimagine data processing and bet the future on new Big Data services that are innovating data infrastructure (from NoSQL databases to data warehouses). Anurag (and AWS) believe that one size doesn’t fit all, and multiple services are often necessary to address different challenges of Big Data. He provides an under-the-hood view of some of the most popular Big Data services at AWS, including:
  • Amazon DynamoDB – a NoSQL service
  • Amazon Redshift – a petabyte-scale data warehouse service
  • Amazon EMR – an elastic map-reduce service
  • Amazon Aurora – a massively scalable relational database service

He also discussed best practices in understanding customer desires and behavior from Big Data and how to achieve 1:1 customer experience at scale.

Data in the Cloud Keynote Panel: Cloudy with a chance of running out of disk space? Or Sunny times ahead?

Moderated by Matt Yonkovit, Percona’s Vice President of Professional Services, this panel discussion focused on the fact that larger and larger datasets are moving to the cloud, creating new challenges and opportunities in handling such workloads. As such, new technologies, revamped products, and a never ending stream of idea’s follow in the wake of this advance to keep pace. Even as these solutions attempt to improve the performance and manageability of cloud-based data, the question is are they enough? The panel brought our several areas that need to be addressed to keep ahead of the “data crisis,” including:

  • Compression
  • Visibility
  • Optimizing Storage
  • The trifecta of storage/analytics/processing
  • Security and privacy

Tomas Ulin, Vice President for the MySQL Engineering team, Oracle
MySQL: Combining SQL and NoSQL

In this talk, Tomas Ulin discussed how, now that MySQL 5.7 is GA, it’s delivered major improvements in performance, scalability and manageability. He explored how MySQL can deliver on the promises of NoSQL, while keeping all the proven benefits of SQL. This lecture allowed the audience to better understand the MySQL development priorities and what the future holds for the world’s most popular open source database.

Mark Callaghan, Software Engineer, Database Infrastructure, Facebook
MyRocks, MongoRocks and RocksDB

In this lecture, we learned about RocksDB, MyRocks, and MongoRocks. RocksDB is an embedded database engine. MyRocks and MongoRocks are RocksDB storage engines for MySQL and MongoDB. All of this is open-source. Facebook started these projects to get better performance, efficiency and compression with fast storage devices like flash-based SSD but they also work great with disks. Mark explained how and why MyRocks provides better performance, efficiency and compression using real and synthetic workloads. In one case, they got 2X better compression compared to compressed InnoDB for a production workload. Mark (and Facebook) expect MyRocks to become the web-scale storage engine for MySQL.

Those were the morning lectures today! And there is more to come! Check out our schedule here.

Percona 5.5 (sorry to post here, there was no channel for 5.5)

Lastest Forum Posts - April 20, 2016 - 10:34am
hello,
I have a droplet on DigitalOcean, and i was using Mysql 5.5 with my ubuntu 14.04. Recently i switched to Percona (i used 5.5 as my mysql was 5.5). After replacing my mysql, i realized that my server was MyISAM instead of InnoDB.

I've read that MyISAM is not as good as InnoDB, and in my configuration i could see that Percona XtraBackup was not visible.

It should look like -
Code: Engine: InnoDB Support: DEFAULT Comment: Percona-XtraDB, Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES But it actually looks like -
Code: Engine: MyISAM Support: YES Comment: MyISAM storage engine Transactions: NO XA: NO Savepoints: NO As you can see, my configuration does not even support Transactions, which i dont feel very good about. But it seems Percona is actually running without XtraDB. Is this a bad thing? Any suggestions? Thanks!

Another way to ALTER table on heavily loaded database

Lastest Forum Posts - April 19, 2016 - 11:40pm
Hello.
There is a big table with 2 billions records with very huge amount of queries (80% from all queries). Direct way to execute ALTER (add 1 column) isn't possible, of cource. I think about

Code: insert into table_new ... select ... from table_old but when i rename tables after, query cache will be dropped, and new uncached queries can hang database.
Does any other way to done alter?
Mysql 5.6.26, there is anorher database with master-master replication with origin.
Thanks.

Percona Live 2016: Running MongoRocks in Production

Latest MySQL Performance Blog posts - April 19, 2016 - 11:38pm

It’s been a long first day at Percona Live 2016, filled with awesome insight and exciting topics. I was able to get to one more lecture before calling quits. For the final talk I saw today I listened to Igor Canadi, Software Engineer at Facebook, Inc., discuss Running MongoRocks in Production.

Facebook has been running MongoDB 3.0 with RocksDB storage engine (MongoRocks) at Parse since March of last year (2015). At this talk, they wanted to share some lessons learned about running MongoRocks in production. Igor was able to provide some interesting war stories and talk about performance optimization. Along with a little bit about RocksDB internals and which counters are most important to watch for.

RocksDB compares favorably to both the MMAP and WiredTiger storage engines when it comes to large write workloads.

The audience came away from the talk ready to get their feet wet with MongoRocks.

Below is a quick chat I had with Igor about RocksDB and MongoDB:

 

See the rest of the Percona Live schedule here.

 

Percona Live 2016: High Availability Using MySQL Group Replication

Latest MySQL Performance Blog posts - April 19, 2016 - 11:16pm

Percona Live 2016 had a great first day, with an impressive number of speakers and topics. I was able to attend a session in the afternoon with Luis Soares, Principal Software Engineer at Oracle, on High Availability Using MySQL Group Replication. MySQL Group Replication is a MySQL plugin under development that brings together group communication techniques and database replication, providing both high availability (HA) and a multi-master update everywhere replication solution.

At MySQL Group Replication’s  core is a set of group communication primitives that act as the building blocks to creating reliable, consistent and dependable messaging between the servers in the group. This allows the set of MySQL servers to coordinate themselves and act as a consistently replicated state machine. As a consequence, the group itself is fault-tolerant, and so is the service it provides (i.e., the MySQL database service). The plugin also provides multi-master update-anywhere characteristics with automatic conflict detection and handling.

In this discussion, we learned about the technical details of the MySQL Group Replication plugin, and discussed how this fits into the overall picture of the MySQL HA. For instance, how it can be deployed together with MySQL Router to automate load balancing and failover procedures. We also discovered the newest enhancements and how to leverage them when deploying and experimenting with this plugin.

Listen to a brief chat I had with Luis on MySQL Group Replication:

Check out the rest of the conference schedule here.

Percona Live 2016: A quick chat with Bill Nye, the Science Guy!

Latest MySQL Performance Blog posts - April 19, 2016 - 5:18pm

Percona Live is humming along, and we had quite a whirlwind keynote session this morning. Bill Nye the Science Guy gave an amazing talk, Bill Nye’s Objective – Change the World, on how the process of science and critical thinking can help us not only be positive about the challenges we face in our world today, but also help us to come up with the big ideas we need to solve them. He discussed many topics, from how his parents met, their involvement in science (his mother worked on the Enigma Code in World War 2!), working at Boeing as an engineer, his involvement with Carl Sagan, and how he has worked to help harness renewable energy through solar panels, a solar water heater, and skylights at his own home in Studio City.

Bill Nye is also the CEO of The Planetary Society. The Planetary Society, founded in 1980 by Carl Sagan, Bruce Murray, and Louis Friedman, works to inspire and involve the world’s public in space exploration through advocacy, projects, and education. Today, The Planetary Society is the largest and most influential public space organization group on Earth.

After the talks, I was able to quickly catch Bill Nye and ask him a few questions.

 

 

Percona Live 2016: Let Robots Manage your Schema (without destroying all humans)!

Latest MySQL Performance Blog posts - April 19, 2016 - 4:55pm

We’re are rapidly moving through day one of the Percona Live Data Performance Conference, and I’m surrounded by incredibly smart people all discussing amazing database techniques and technology. The depth of solutions represented here, and the technical know-how needed to pull them off is astounding!

This afternoon I was able to catch Jenni Snyder, MySQL DBA  at Yelp deliver her talk on Let Robots Manage your Schema (without destroying all humans). While vaguely frightening, it was a fascinating talk on how automating schema changes helped Yelp’s development.

You’re probably already using automation to build your application, manage configuration, and alert you in case of emergencies. Jenni asks what’s keeping you from doing the same with your MySQL schema changes? For Yelp, the answer was “lots of things”. Today, Yelp uses Liquibase to manage their schema changes, pt-online-schema-change to execute them, and Jenkins to ensure that they’re run in all of their environments. During this session, she explained the history of MySQL schema management at Yelp, and how hard it was for both developers and DBAs.

Below is a video of her summarizing her team’s efforts and outcomes.

Check out the Percona Live schedule to see what is coming up next!

 

Percona Live 2016: Performance of Percona Server for MySQL on Intel Server Systems using HDD, SATA SSD, and NVMe SSD as Different Storage Mediums

Latest MySQL Performance Blog posts - April 19, 2016 - 2:33pm

We’re moving along on the first day at Percona Live 2016, and I was able to attend a lecture from Intel’s Ken LeTourneau, Solutions Architect at Intel, on Performance of Percona Server for MySQL on Intel Server Systems using HDD, SATA SSD, and NVMe SSD as Different Storage Mediums. In this talk, Ken reviewed some benchmark testing he did using MySQL on various types of storage mediums. This talk looked at the performance of Percona Server for MySQL for Linux running on the same Intel system, but with three different storage configurations. We looked at and compared the performance of:

  1. a RAID of HDD,
  2. a RAID of SATA SSD, and
  3. a RAID of NVMe SSD

In the talk,  Ken covered the hardware and system configuration and then discuss results of TPC-C and TPC-H benchmarks, as well as the overall system costs including hardware and software, and cost per transaction/query based on overall costs and benchmark results.

I got a chance to speak with Ken after his talk, check it out below!

 

Connection required?

Lastest Forum Posts - April 19, 2016 - 1:49pm
With xtrabackup 2.2 (and up through 2.3.0-alpha), I could backup a database with only the datadir. Now with xtrabackup (2.3.1-beta and onwards), it appears it needs a connection. Is it no longer possible to backup a database using only the datadir?

New versions:
Code: # xtrabackup --backup --datadir=/data --target-dir=/tmp/foo 160419 20:41:15 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;my sql_socket=/var/lib/mysql/mysql.sock' (using password: NO). Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup;mysq l_socket=/var/lib/mysql/mysql.sock','',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at - line 1314. Connecting to MySQL server host: (null), user: (null), password: not set, port: 0, socket: /var/lib/mysql/mysql.sock Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). Old versions:
Code: # xtrabackup --backup --datadir=/data --target-dir=/tmp/foo xtrabackup version 2.3.0alpha1 based on MySQL server 5.6.21 Linux (x86_64) (revision id: ) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /data xtrabackup: open files limit requested 0, set to 8192 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 >> log scanned up to (10214186) [01] Copying ./ibdata1 to /tmp/foo/ibdata1 [01] ...done (...truncated...)

Day One of the Percona Live Data Performance Conference 2016 is off and running!

Latest MySQL Performance Blog posts - April 19, 2016 - 1:35pm

Today was day one of the Percona Live Data Performance Conference! The day began with some excellent keynote speakers and exciting topics, and the packed room was eager to hear what our speakers had to say!

Peter Zaitsev, CEO, Percona
Percona Opening  Keynote
Peter kicked it off today by thanking the sponsors, the speakers, the Percona Live committee, and the attendees for contributing and participating in this year’s event. It has grown and changed quite a bit from its initial creation. Peter emphasized how this a gathering of members of a community, one that changes and adapts, and discusses and debates many different points of views and opinions. No longer is just a conference about MySQL, but now includes MongoDB, Cassandra, and many other solutions and products that are all a part of the open source community. The purpose of the conference is to provide open and diverse opinions, quality content, a technical focus, and useful and practical ideas and solutions.

Chad Jones, Chief Strategy Officer, Deep Information
Transcending database tuning problems: How machine learning helps DBAs play more ping pong

Next up was Chad Jones discussing how just as machine learning enables businesses to gain competitive advantage through predictive analytics, by looking deeper into the data stack we find the need for the same predictive capabilities for MySQL tuning. With over 10^13 possible tuning permutations, some requiring reboots or a rebuild, DBAs spend way too much time on MySQL tuning for a point-in-time situation that changes constantly. He demonstrated how unsupervised machine learning based on resource, workload and information modeling could predictively and continuously tune databases. DBAs can transcend the tuning game, saving precious time to work on important things, like improving your mad ping pong skills!

Bill Nye, The Planetary Society, CEO
Bill Nye’s Objective – Change the World
F
inally this morning, we were treated to an outstanding lecture from world-renown scientist and media personality Bill Nye the Science Guy. Bill spent his time discussing his life, how he came to love science, and the ability it brings to understand the world. His experiences as an engineer at Boeing helped him appreciate the value in investing time and money into excellent design strategies and processes. Through the power of critical thinking and science, we can embrace optimism in a world that has many touch challenges. Bill Nye fights to raise awareness of the value of science, critical thinking, and reason. He hopes that the data he brings will help inspire people everywhere to change the world!

Those were the morning lectures today! Such a great set of speakers, I can’t wait for tomorrow! Check out our schedule here.

 



General Inquiries

For general inquiries, please send us your question and someone will contact you.