by Borys Belinsky | Jan 19, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management (PMM) 1.6.0. In this release, Percona Monitoring and Management Grafana metrics are available in the Advanced Data Exploration dashboard. We’ve improved the integration with MyRocks, and its data...
by Michael Coburn | Jan 16, 2018 | Insight for DBAs, Monitoring, MySQL, Percona Software, Webinars
Join Percona’s Product Manager Michael Coburn as he presents MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) Part 2 on Thursday, January 18, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Register Now Tags: Percona...
by Dave Avery | Jan 15, 2018 | Cloud, Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Live
Take a look at the sneak peek of the breakout sessions for the Percona Live 2018 Open Source Database Conference, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, California. Early Bird registration discounts are available until...
by Agustín | Jan 11, 2018 | Insight for DBAs, MySQL
In this short blogpost, we’ll show you how to use the mysql_random_data_load tool to insert random data into tables. This is a great aide in testing when you have empty tables and need them to be populated with data. We’ve all done it manually (the INSERT...
by Alexander Rubin | Jan 10, 2018 | Insight for DBAs, MySQL
In this blog post, I’ll provide an explanation of why you should avoid using the CREATE TABLE AS SELECT statement. The SQL statement “create table <table_name> as select …” is used to create a normal or temporary table and materialize the...
by Jervin Real | Jan 9, 2018 | Insight for DBAs, MySQL
In this post, we’ll look at updating and deleting rows with ClickHouse. It’s the first of two parts. You can see Part 2 of this post here. ClickHouse is fast Blazing fast! It’s quite easy to pick up, and with ProxySQL integrating with existing...
by Peter Zaitsev | Jan 9, 2018 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Join Percona’s, CEO and Co-Founder, Peter Zaitsev as he presents Why We’re Excited About MySQL 8.0 on Wednesday, January 10, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Experience: Basic Tags: Developer, DBAs, Operations, Executive, MySQL There are many great...
by Peter Zaitsev | Jan 8, 2018 | Insight for DBAs, MySQL
In this blog post, we’ll look at how ioping can be used with other tools to understand and troubleshoot storage performance, specifically as it relates to MySQL workloads. I recently ran into ioping, a nice little utility by Konstantin Khlebnikov that checks storage...
by Peter Zaitsev | Jan 5, 2018 | MySQL, Webinars
Thank you for attending my webinar on Wednesday, December 20, 2017, InnoDB Performance Optimization. In this blog, I will provide answers to the Q & A for the webinar. Are the T2 CPUs similar to the M4 series? I would expect them to be similar. Amazon does not...
by Borys Belinsky | Jan 4, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.6 on January 4, 2018. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona...
by Lorraine Pocklington, Community Manager | Jan 3, 2018 | Cloud, Insight for DBAs, Monitoring, MySQL, Percona Services, Percona Software
In 2017 we have welcomed many new customers into the Percona fold. It’s always interesting to find out what challenges the Percona team helped them to address and how they chose their relationship with Percona. As unbiased champions of open source database software,...
by David Ducos | Jan 2, 2018 | Insight for DBAs, Insight for Developers, MySQL, ProxySQL
In this post, we’ll look at how to improve queries using generated columns and ProxySQL instead of implementing a referenced table. Developers and architects don’t always have the time or complete information to properly analyze and design a database. That is...
by Dave Avery | Dec 29, 2017 | Benchmarks, MariaDB, MongoDB, MySQL
Let’s look at some of the most popular Percona Database Performance Blog posts in 2017. The closing of a year lends itself to looking back. And making lists. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open...
by Colin Charles | Dec 22, 2017 | MySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. I think the biggest news from last week was from cPanel – if you haven’t already read the post, please do – on Being a...
by Colin Charles | Dec 20, 2017 | Cloud, MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL
Percona is extending the Percona Live 2018 call for papers deadline to January 12, 2018! Percona’s gift to you this holiday season is the gift of time – submit your speaking topics right up until January 12, 2018! As the year winds up, we received many requests...
by Krunal Bauskar | Dec 19, 2017 | Insight for DBAs, MySQL, Percona Software, Webinars
In this blog, we will answer questions from our webinar on Percona XtraDB Cluster 101. Recently (7 Dec 2017) I presented a webinar about Percona XtraDB Cluster 101. Firstly, thanks to all the attendees: we had a great webinar with quite some interesting questions and...
by Borys Belinsky | Dec 18, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Monitoring and Management 1.5.3. This release contains fixes for bugs found after the release of Percona Monitoring and Management 1.5.2, as well as some important fixes and improvements not related to the previous release....
by Dave Avery | Dec 13, 2017 | Cloud, MongoDB, MySQL, Percona Live
Get your Percona Live Open Source Database Conference 2018 Super Saver tickets now. The countdown is on for the annual Percona Live Open Source Database Conference 2018! The conference takes place in Santa Clara, CA from April 23-25, 2018. The theme is Championing...
by Roel Van de Paar | Dec 12, 2017 | Insight for DBAs, MySQL, Percona Software
Percona’s Technical Director of Quality Assurance Roel Van de Paar shares his findings on the quality of MySQL 8.0.3 RC. On 21 September 2017, our upstream friends at Oracle released MySQL 8.0.3 RC as the first MySQL 8.0 Release Candidate. I tested the MySQL...
by Colin Charles | Dec 11, 2017 | Insight for DBAs, MariaDB, MongoDB, MySQL, Webinars
Join Percona’s Chief Evangelist, Colin Charles as he presents 2017 Year in Review for Open Source Database Software on Wednesday, December 13, 2017 at 7:00 am PST / 10:00 am EST (UTC-8). Register Here 2017 is soon coming to an end, and it’s good to pause and...
