Explore Percona on Experts Exchange

Expert Solutions for Your Tech Problems

Percona

Percona is the only company that delivers enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB...

Read more
  • 79 Content
  • 26 Contributors

Expert Spotlight
Database Administrator / Software Engineer

Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.

Leading Experts In
Percona
<
Monthly
>
Troubleshooting Solution

mysql table open definition cache alert

12

Percona monitoring management is alerting on too many table open cache. 


Labels
 alert name =

Troubleshooting Solution

mariadb rebooted and no warnings reported

6

Mariadb suddenly rebooted and no errors or warnings reported in the log. I have percona tools

Troubleshooting Solution

How To Generate Report From Percona Monitoring Management (PMM)

1

How will you generate a performance baseline report from the percona monitoring management server?

Troubleshooting Solution

Galera cluster out-of-sync

10

Hi, I have a Galera cluster with 3 nodes. I had a network outage, and the nodes weren't able to

Research Solution

MariaDB Xpand

4
hi,

 I studied about MariaDB Xpand, the new distributed SQL for MariaDB and serve the same purpose as …
Research Solution

tail log backup of MySQL

22
hi,

I am checking the way to do the tail log backup for any MySQL, like MariaDB and Percona xtraDB …
Research Solution

DB native to the cloud

18
hi,

from time to time I hear people said as MySQL is more native to the cloud, so they choose MySQL …
Research Solution

optimized the galera replication setting for Percona XtraDB cluster 8.0.19

14
hi,

hi,
how to optimized the galera replication setting based on :
1) gcs.fc_limit (usually …
Troubleshooting Solution

my percona xtraDB cluster suddently dead and how to fix it

30
hi,

my PXC is down and this is the error message I got from error log:


any idea on why it even can't …
Troubleshooting Solution

when I create a function it fails and it seems it need log_bin_trust_function_creators =1 ON

12
hi,

when I clone a function from Percona xtraDB cluster 5.7.x to 8.0.18 , it shows me the error:

once …
Troubleshooting Solution
Troubleshooting Solution

Percona xtraDB cluster 8.0.19 ERROR 1067 (42000) at line 42: Invalid default value for 'LAST_UPD_DT'

4
hi,
when applying a mysql database dump from percona xtraDB cluster 5.7 to 8.0.19, there is an error: …
Troubleshooting Solution

change of mysql server data directory.

11
Hi,

Now we have add one more volume for Peronca XtaDB cluster data as we know the data we are going …
Research Solution

percona xtraDB cluster 8.0.19 HA and DR solution across 2x data centers

7
hi,

we are having a percona xtraDB cluster 5.7x with 2 nodes in primary and another 2 x nodes in DR …
Research Solution

after ran the mysqltuner.pl for percona xtaDB cluster 8.0.19 , I need to understand it

14
hi,

I just built up a percona xtraDB cluster 8.0.19 and found out the existing global variable for …
Troubleshooting Solution

Error message when restoring percona xtraDB cluster 8.0.19

5
hi,

1) Today when restoring one of the DB by mysqldump, it said:

ERROR 1231 (42000) at line 1222: …
Troubleshooting Solution

running pt-query-digest for percona xtraDB cluster 8.0.19

6
hi,

Today want to make sure this toolkit works:
Troubleshooting Solution

my percona xtraDB cluster 8.0.19 do not replicate well

1
hi,

I found sth funny about my percona xtraDB cluster 8.0.19, I can create database and it is …
Troubleshooting Solution

lower down the security password requirement for Percona xtraDB cluster 8.0,19

3
hi,
When setting mysql_secure_installation script in percona xtraDB cluster 8.0.19, the script will …
Troubleshooting Solution

THE PROXYSQL-ADMIN TOOL WITH PROXYSQL V2

15
hi,

I am following percona xtraDB cluster 8.0.19 installation guide and when I go to this section
THE …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more