by Sveta Smirnova | Mar 27, 2018 | Insight for DBAs, MySQL, Storage Engine
In this post, I’ll discuss the fix for lp:1704195 (migrated to PS-2503), which prevents ANALYZE TABLE from blocking all subsequent queries on the same table. In November 2017, Percona released a fix for lp:1704195 (migrated to PS-2503), created by Laurynas...
by Yves Trudeau | Mar 27, 2018 | Insight for DBAs, MySQL, Webinars
Please join Percona’s Principal Architect in Architecture & Projects, Yves Trudeau, as he presents ZFS with MySQL on Wednesday, March 28, 2018, at 7:00 am PDT (UTC -7) / 10:00 am EDT (UTC -4). Are you curious about ZFS? Would you like to learn how to setup and...
by Jaime Sicam | Mar 26, 2018 | Insight for DBAs, MySQL, Percona Software
In this post, we’ll look at the MySQL 8.0 innodb_dedicated_server variable. MySQL 8.0 introduces a new variable called innodb_dedicated_server. When enabled, it auto tunes innodb_buffer_pool_size, innodb_log_file_size and innodb_flush_method at startup (if these...
by Colin Charles | Mar 23, 2018 | Cloud, MongoDB, MySQL, Percona Events, Percona Live, PostgreSQL, ProxySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Writing to you on the ground from FOSSASIA 2018, where I gave a track introduction yesterday since we have a pretty awesome...
by David Murphy | Mar 22, 2018 | Insight for DBAs, Insight for Developers, MongoDB
In this blog post, we’re going to break down what constitutes a MongoDB replica set. While replica sets are not a specific environment or solution, understanding what you can do with their sophisticated features helps fit a multitude of situations. With many...
by Adamo Tonete | Mar 22, 2018 | Cloud, Insight for DBAs, Insight for Developers, MongoDB
Have you ever had performance issues with your MongoDB database? A common situation is a sudden performance issue when running a query. The obvious first solution is “let’s create an index!” While this works in some cases, there are other options we...
by Dave Avery | Mar 21, 2018 | Cloud, MySQL, Percona Live, PostgreSQL
Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post...
by Krunal Bauskar | Mar 21, 2018 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll look at how Percona XtraDB Cluster (PXC) executes FLUSH and LOCK handling. Introduction Percona XtraDB Cluster is a multi-master solution that allows parallel execution of the transactions on multiple nodes at the same point in time....
by Agustín | Mar 20, 2018 | MySQL
In this blog post, we’ll see how to use different mount points on PMM Docker deployments (Percona Monitoring and Management). This is useful if you want to use other mount points for the different directories, or even if you want to use a custom path that is not...
by Matt Yonkovit | Mar 20, 2018 | Percona Software
This blog post contains a poll that helps us find out what Percona software the open source database community is using. Nearly 20 years ago, Netscape released the source code for its Netscape Communicator web browser. This marked one of the biggest moments in...
by Krunal Bauskar | Mar 20, 2018 | Insight for DBAs, MySQL, Percona Software, ProxySQL, Webinars
Please join Percona’s Ramesh Sivaraman (QA Engineer) and Krunal Bauskar (Software Engineer, Percona XtraDB Cluster Lead) as they present Percona XtraDB Cluster 5.7 with ProxySQL for Your MySQL High Availability and Clustering Needs on Thursday, March 22, 2018 at 8:30...
by Kenn Takara | Mar 19, 2018 | Insight for DBAs, MySQL, Percona Software
Recently, I’ve been looking into issues with the interactions between MySQL asynchronous replication and Galera replication. In this blog post, I’d like to share what I’ve learned. MySQL asynchronous replication and Galera replication These...
by Tibor Korocz | Mar 19, 2018 | Insight for DBAs, MySQL
From time to time I see pattern matching queries with conditions that look like this: “where fieldname like ‘%something%’ “. MySQL cannot use indexes for these kinds of queries, which means it has to do a table scan every single time....
by Dmitriy Kostiuk | Mar 16, 2018 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.2.19-3.10 on March 16, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database...
by Borys Belinsky | Mar 16, 2018 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.8 on March 16, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and...
by Colin Charles | Mar 16, 2018 | MariaDB, MongoDB, MySQL, Open Source, PostgreSQL, ProxySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. SCALE16x is over. Percona had a large showing — both Peter Zaitsev & myself had talks, and the booth in the expo...
by Tibor Korocz | Mar 15, 2018 | Monitoring, MySQL, Percona Software, ProxySQL
In this blog post, we’ll look at how you can verify query performance using ProxySQL. In the previous blog post, I showed you how many information can you get from the “stats.stats_mysql_query_digest” table in ProxySQL. I also mentioned you could...
by Dave Avery | Mar 15, 2018 | MongoDB, Percona Live
Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post...
by Dave Avery | Mar 14, 2018 | Cloud, MariaDB, MongoDB, MySQL, Percona Live
Did you see Percona at SCaLE 16x? I spent a couple of days there learning about open source software, databases, and other interesting topics. You can get even more open source database information at Percona Live 2018. SCaLE is the largest community-run open-source...
by Daniel Guzmán Burgos | Mar 14, 2018 | Monitoring, MySQL, Percona Software
In this blog post, we’ll look at how to create PMM custom graphs and dashboards to track what you need to see in your database. Percona Monitoring and Management (PMM)’s default set of graphs is pretty complete: it covers most of the stuff a DBA requires...
