Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

97 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
1answer
7k views

How to prevent "ibdata files do not match the log sequence number"?

I am dealing with a very large set of databases that are all innodb. I've enountered this on mysql restart too many times for my comfort: ibdata files do not match the log sequence number But I've ...
4
votes
1answer
919 views

Full database backup using xtrabackup stream

I'm new to Percona XtraBackup. I've been trying to perform a full backup stream from my local ( test server around 600GB ) to remote server. I just have some questions and I need guides, and I think ...
3
votes
0answers
515 views

RESET MASTER; does not reset GTID_EXECUTED

I'm trying to get replication up and running between two kubernetes pods, and am getting the dreaded @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty. error. root@central-vm:~...
3
votes
0answers
230 views

TokuDB/Percona - Insert Performance worse as table grows

We have a bunch of existing servers which run just fine, inserting our thousand rows/second, but the new batch just will not do it. As the day goes on and the table grows, it gets slower and slower, ...
3
votes
2answers
818 views

Percona MySQL 5.7 | XtraBackup 2.4 - xb_load_tablespaces() failed witherror code 11

I am attempting to upgrade MySQL from 5.6 to 5.7 and everything seems to be working, but when I try to run xtrabackup I am now getting this error: InnoDB: Allocated tablespace ID 12 for percona/...
2
votes
0answers
183 views

Percona Xtradb Cluster not accepting options on command line

I am using Percona Xtradb Cluster 5.6 and trying to start my cluster through a donor node via command line and I am getting this error: CentOS 7: systemctl start mysql --wsrep-sst-donor=srv1 ...
2
votes
1answer
2k views

Percona mysql xtradb cluster doesn't start properly and node restarts don't work

tl;dr When starting a fresh percona cluster of 3 kubernetes pods, the grastate.dat seq_no is set at -1 and doesn't change. On deleting one pod and watching it restart, expecting it to rejoin the ...
2
votes
0answers
329 views

why pt-table-checksum lock my whole table?

mysql> desc user_donate_request; +-------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------...
2
votes
1answer
1k views

Flush Host Connection Blocked, but some connections allowed

We are running Percona MySQL 5.6.30. We've had an issue where a PHP script on a different host was reporting an issue connecting to the database: Database may be down : SQLSTATE[HY000] [1129] Host ...
2
votes
1answer
211 views

MySQL users not visible after import

I have a Percona MySQL database 5.6 running in a linux machine. I have created new users called test1 and test2. What I did was I imported mysql database from my test setup to this new setup. After ...
2
votes
1answer
436 views

Slow ranking values in MySQL

I have a table of around 30 million retail products, with various INT columns that describe sales counters and pricing at different retailers. I'm supposed to display well over 70 different rankings ...
1
vote
0answers
29 views

PHP PDO Connect sometimes takes a long time to connect using mysql percona

I have a more or less simple application, written in php 7.4, using PDO to connect to my database. This connect usually takes under 0.0002 seconds > we are talking about 99.9% of my requests. On ...
1
vote
0answers
202 views

Proxysql setup for Percona PXC Multimaster cluster

I have a clean Ubuntu lab setup for PXC Cluster and Proxysql (each a separate VM)and i'm seeing this issue (error below). Is there a specific installation that needs to be followed for PXC cluster? I ...
1
vote
0answers
153 views

MySQL 5.7 (Percona Server) PAM LDAP authentication from Workbench 8.0 on Windows

I have a server running Percona Server 5.7 and enabled PAM LDAP authentication. I can connect with LDAP user from: mysql client MySQL Workbench 8.0 on Linux (Ubuntu) with dialog.so plugin copied from ...
1
vote
0answers
77 views

Xtrabackup 8.0 Error

I'm using Percona MySQL 8.0.20 running on Ubuntu 18.04 on an AWS ec2 m5.2xlarge instance. The Xtrabackup version being used is 8.0.14. While testing the restore process, I'm getting the error as ...
1
vote
1answer
69 views

mysql client auto reconnect in case of ERROR 2013

I'm searching for a way how to instruct mysql client to reconnect in case of ERROR 2013. I'm testing PXC with ProxySQL and want to keep sql statements flowing from the client in case when the writer ...
1
vote
0answers
14 views

Upgrading Debian version of PXC production cluster

I have a 3 node PXC 5.7 cluster behind a ProxySQL instance. The cluster is still running on Debian 8. I have setup recently a testing PXC 5.7 cluster with a copy of the database on Debian 10 without ...
1
vote
1answer
34 views

DB locks being created on temp tables. Can percona ignore temp tables for replication

I have a stored procedure that I am using that creates a temp table. Recently I've noticed the logs are filling up with locks. I think the temp table is trying to be replicated but I am unsure. *** ...
1
vote
0answers
72 views

MySQL Percrona 8.0 became suddenly slow until restart mysql

My website today suddenly became slow and all requests were taking about 2 seconds to complete. Usually it takes like 0.2 second I checked available space on disk and I have a lot. Memory and CPU ...
1
vote
1answer
204 views

Percona Server 5.6.40 restarting with singal 11

We recently migrated our mysql to new hardware and it was running in slave mode for 15 days. We made it the master 11th June. On 13th June it restarted for the first time with signal 11. Stacktrace ...
1
vote
0answers
87 views

Preserving some data on rollback in InnoDB?

I want to keep log of attempted, sucessful, and failed operations (both for troubleshooting, and also for detecting malicious users trying things). I want to keep that log in InnoDB MySQL table. Now, ...
1
vote
0answers
154 views

Percona 5.6.28-76.1: optimize config for database (Invision Power Board)

At the beginning I would like to explain that I'm not a DB expert. My hosting provider is struggling with DB optimization for my website. Unfortunately seems that they are out of ideas. I would like ...
1
vote
0answers
66 views

Database with lots of writes to a big table uses less CPU than the same database with less writes?

I'm trying to understand why InnoDB/MySQL behaves the way it does and if there's anything I can change in the configuration to fix it. I have a table with nearly 5M rows, about 9GB in size. I also ...
1
vote
1answer
168 views

Does wsrep_cluster_address only accept the intranet IPs?

I was installing Percona XtraDB Cluster with 3 nodes. Each node has a unique Internet IP address. Following the docs Quick Start Guide for Percona XtraDB Cluster, I got the first node running but ...
1
vote
0answers
374 views

DPKG error: uninstall percona xtradb server 5.7

Trying to uninstall percona, as I broke installation. No luck: >$ sudo apt remove percona-xtradb-cluster-server-5.7 Reading package lists... Done Building dependency tree Reading state ...
1
vote
1answer
240 views

Percona-Server: slow TokuDB queries after upgrading from 5.6 to 5.7. ANALYZE TABLE doesn't resolve the problem

After upgrading from Percona-TokuDB 5.6.29-76.2 to 5.7.19-17 we see some very slow queries on some tables without primary keys, but multiple non-unique indexes. The box we migrated to is pretty well ...
1
vote
1answer
430 views

how to setup percona pmm monitoring of percona 5.7 in docker container

I want to monitor percona running in docker with the percona monitoring and management client. I have percona monitoring and management installed, running and monitoring other percona instances (...
1
vote
0answers
174 views

TokuDB table stats row count decreases very fast while adding/updateing data

We run an Percona server with the newest version(5.7.19-17). After a while the cardinality of multiple tables drop to zero. A new created index also have an cardinality of 0 if the existing are zero. ...
1
vote
1answer
441 views

Percona/MySql Table does not exist after innobackupex restore on Vagrant Ubuntu 16.04

This question is cross posted here from stack overflow at the suggestion of stack overflow commenters (https://stackoverflow.com/questions/47086329/percona-mysql-table-does-not-exist-after-...
1
vote
0answers
138 views

MySQL Insert from Select and schema alter Busy Production without downtime

Strategy for migration of Huge MySQL (Percona 5.7) Table (InnoDB) in production. The aim is to have minimum downtime (offline schema change would take a week or more...) old has a 100 plus columns ...
1
vote
0answers
1k views

Trying to install Audit_log Plugin on MySQL

I'm trying to install the Percona Audit_log plugin for my instance of MySQL. I ran it previously so I know it works ok with MySQL (I'm sure it says so in the documentation anyway). I have MySQL 5.5....
1
vote
0answers
47 views

New percona xtradb node shuts itself down shortly after launch

We currently have a 3 node percona xtradb cluster running on premises. We are trying to add a 4th, remote node ( Obviously split-brain is a concern in this situation but it is only temporary while we ...
1
vote
0answers
426 views

Memory leak on MySQL slave?

I have a Percona MySQL master-slave server configuration(5.6.20-68.0). The memory usage by MySQL on the slave server is constantly growing. Now it reached 68G despite the fact that ...
1
vote
0answers
94 views

MySQL/Percona Audit Log Plugin Not Working

I've been looking to implemement the Percona Audit Log plugin. So far I have installed it and configured it, and it seems to be working ok. Except, I have installed it on a slave Database as I don't ...
1
vote
0answers
329 views

Innobackupex restore steps from 1 incremental and multiple incremental steps

My current backup plan is: Full -> Incremental1 based on full -> incremental2 based on incremental1 -> incremental3 based on incremental2... Please validate if this steps is correct during emergency ...
1
vote
0answers
610 views

pt-archiver and foreign keys?

How does pt-archiver handle foreign keys? Does it archive associated data? (seems not but the documentation is not very clear to me) And if not, how could one perform an archive of a table with all ...
1
vote
0answers
481 views

Percona XtraDB Cluster With Async slaves

I have set up a 3 node percona cluster in amazon ec2. As our client required, i also had to set up an asynchronous slaves in another datacenter as well. Each async slave pointed to single percona ...
1
vote
0answers
123 views

pt-table-checksum generates no output

I've been using pt-table-checksum on our staging server successfully, but when I run ./pt-table-checksum h=localhost,u=user --ask-pass --lock-wait-time=50 --databases prod It just sits there. No ...
1
vote
2answers
559 views

Suddenly a massive amount of binlog files

I've seen a sudden increase of binlog files, very large in number and size, in all three nodes of a Percona XtraDB cluster: -rw-rw---- 1 mysql mysql 1,1G 19 oct. 16:11 binlog-32.000001 -rw-rw---- ...
0
votes
0answers
13 views

replicate-wild-do-table causes unknown database error My-001049 for CREATE PROCEDURE on not replicated schema

OS: RHEL 7.7 Percona server 8.0.26-16 I am trying to create a simple replication topology with one master and one slave. The master has 9 schema out of which three are being replicated to the slave. ...
0
votes
1answer
14 views

Cannot prepare backup with innobackupex

I taken full backup from a Master server with innobackupex. Now I am restoring backup with innobackupex on a Slave server. I prepare backup with the command: innobackupex --defaults-file=/var/lib/...
0
votes
0answers
60 views

Unable to join new node to new percona cluster 8.0

I created a new cluster xtradb cluster 8.0. I bootstrapped the first node. When I try to join a node it fails. The donor error 211209 19:46:20 >> log scanned up to (10790811284585) xtrabackup: ...
0
votes
0answers
30 views

MySQL8: xtrabackup Invalid stream argument: tar

I am using xtrabackup to take full backup and send it to another host as .tar file using the following backup command: xtrabackup --backup -u root -p --no-lock --compress --stream=tar --datadir=/...
0
votes
0answers
69 views

Install Percona Data Recovery Tool for InnoDB on Ubuntu 18

Has anyone successfully installed the Percona Data Recovery Tool for InnoDB on Ubuntu 18? I downloaded the tool here: https://launchpad.net/percona-data-recovery-tool-for-innodb/trunk/release-0.5/+...
0
votes
0answers
201 views

Importing A Database Into MySQL Has A Cluster System

I have a big issue. I want to import a database to mysql-server in a Centos 7 system. But there is a cluster structure on the servers. I set pxc_strict_mode=ENFORCING in wsrep.conf file. I have not to ...
0
votes
1answer
16 views

Percona MySQL: Restore incremental backup to a new server

I know it is possible to set up a new database instance on a new server, using a full backup that has been prepared. This is useful for several things, not least if your server has failed completely; ...
0
votes
2answers
110 views

Connect two Percona XtraDB Clusters in two data centers

I have been trying to figure this out the past couple of weeks. We used to have a five-host Percona cluster at different providers. When it started acting up I read that it is a bad idea to have ...
0
votes
0answers
17 views

percona cluster victim thread on duplicate key updates

Recently, I've been getting this in the log and its creating chaos when not addressed. I totally understand the error, but what are the typical sources of this showing up in the cluster. I've been ...
0
votes
0answers
152 views

MySQL undo logs not truncating

I have MySQL Percona version 5.7, with 3 undo logs, but I don't know why truncating logs is not working. I enabled innodb_undo_log_truncate, decreased innodb_purge_rseg_truncate_frequency to 32 show ...
0
votes
0answers
48 views

Will Federated engine work with pxc cluster

I'm a bit new to MySQL specific settings and I can't find any hint/insight to this question. I have several Federated tables that work great for their current purpose, the rest of the database is in ...