Questions tagged [percona]
Percona : MySQL open source fork with performance improvements
318
questions
0
votes
0answers
6 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
28 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/+...
-1
votes
1answer
54 views
InnoDB: Assertion failure on executing select Query - MySQL 5.7.31
I am using pt-archiver for daily archiving of tables, but while selecting data from one tables I am getting following error and it restart mysql instance
2021-07-07 13:21:17 0x7fe0dffdc700 InnoDB: ...
0
votes
0answers
105 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
12 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
71 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 ...
1
vote
1answer
211 views
ERROR 1180 (HY000): Got error 5 during COMMIT
We're using Galera cluster and I'm running below statement to make a new table:
create table tab2 select distinct id , report from my_table ;
It runs for sometime and after that it fails/cancel ...
0
votes
1answer
66 views
truncate table in mysql 8.0 is slower than older version
I have few hundreds of tests which use mysql. I was using Mysql 5.7 (percona) and I changed it to Mysql 8.0 . My problem is that before every test I truncate ALL my tables. This was fine with 5.7 but ...
0
votes
1answer
200 views
"Percona-XtraDB-Cluster prohibits use of ALTER command on a table (<example>) that resides in non-transactional storage engine"
I installed a Percona XtraDB cluster with pxc_strict_mode set to ENFORCING, and am trying to import databases from non-Galera MariaDB servers. This works fine for some databases, by dumping them via ...
0
votes
0answers
10 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 ...
1
vote
1answer
141 views
MySQL 8.0.20 - Master Replica scheme, increasing delay between Source and Replica
We have a Source Database of about 1TB, and a Replica on another server (similar architecture).
We have setup Master Slave replication and delay between Master and Slave is always growing since.
...
1
vote
0answers
152 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 ...
0
votes
1answer
200 views
Can't restore master/slave replication from Percona backup (slave server)
A slave is restored from a master backup created with Percona xtrabackup
On the master binlog is set to expire in 14 days and this backup is less than 24 hours old
my.cnf (master)
expire_logs_days = ...
0
votes
0answers
117 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 ...
1
vote
3answers
318 views
Can I disable binlogs to save space temporarily
I am using percona mysql 8.
I do not use any type of replication, but I read that binlogs are useful for data recovery. I would like to turn of binlogging and flush them while I run pt-online-schema-...
0
votes
0answers
113 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 ...
0
votes
0answers
39 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 ...
1
vote
1answer
31 views
mysql percona 5.7 not releasing memory
we are using percona mysql 5.7 version.
MySQL not releasing the memory after operation complete.
we are very much grateful if anyone can guide us to resolve issue.
Thanks
1
vote
0answers
63 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
59 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 ...
0
votes
2answers
102 views
Monitoring slow queries on large database (Percona 5.6)
I am looking for a solution to monitor very large production database (many replicas, over 200 tables, some of tables have 10-50 GB of data) with a lot of traffic (a wide set of query complexity).
The ...
0
votes
1answer
100 views
Need help with some recovery
So i've gone and did something terribly wrong out of haste and not thinking properly.
I have a PXC (percona cluster. I guess mysql cluster with Galera?) running with just 1 one being bootstrapped (...
0
votes
0answers
96 views
MySQL error when trying to import tablespace
I'm following the steps described here, but the import of one of the tables is failing with the error below. It's a large table, with a ~22GB .idb file.
[ERROR] [MY-012762] [InnoDB] Page offset doesn'...
0
votes
1answer
67 views
Innobackupex (Xtrabackup) 2.4.8 incremental backups take the same time as full backup
We have our operational as well as decision making databases both running on Percona MySQL 5.7.10. The OS is Ubuntu 16.04. On these various database instances we have been using Percona Innobackupex (...
1
vote
1answer
275 views
Transferring innodb table
I have a 30GB innoDB-only database that keeps having Lost connection to MySQL server during query when dumping when running mysqldump -u root -p --compress --max_allowed-packet=1G --net-buffer-...
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 ...
0
votes
1answer
1k views
MySQL: how to prevent deadlock on concurrent inserts
Percona Server 5.6.39-83.1-log
Table structure:
CREATE TABLE `myTable` (
`column_1` VARCHAR(50) NOT NULL DEFAULT '',
`column_2` VARCHAR(50) NOT NULL DEFAULT '',
`column_3` VARCHAR(50) ...
0
votes
2answers
81 views
Percona XtraDB Cluster (5.6.28-76.1-56-log) - random OOM events
We have a multi-node (each of 64G RAM) cluster. The main (the one we use for mutating data) node randomly just OOMs, this happens both in peak times and in extremely quiet times.
What we've noticed ...
0
votes
1answer
62 views
Unusually low insert rate on MySQL Slaves
I have 4 MySQL nodes replicating like this:
M1 - S1
|
M2 - S2
Only the M1 master is writing, the hardware is similar (the slaves are a bit beefier), they all run Percona 5.7.
The trouble is that ...
0
votes
1answer
66 views
right syntax to use near 'TOKUDB_DEFAULT'
mysql> CREATE TABLE stable1 ( column_a INT NOT NULL PRIMARY KEY, column_b INT NOT NULL) ENGINE=TokuDB, ROW_FORMAT=TOKUDB_DEFAULT;
ERROR 1064 (42000): You have an error in your SQL syntax; check the ...
0
votes
0answers
23 views
MySQL oomkiller crashes after backup [duplicate]
I am using percona and the backups run successfully. However after the backup is done and sometimes during the backup MySQL is crashing and I am not certain where to start.
Running show engine ...
0
votes
1answer
114 views
Need help in leveraging MySQL auditing
We are setting up password rotation policy to rotate account/password quarterly. We are also planning to use MySQL/Maria/Percona Auditing. Need to figure out the most efficient and feasible way to ...
1
vote
1answer
28 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.
*** ...
2
votes
0answers
477 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:~...
1
vote
1answer
37 views
Percona 5.7.24 : How to fix disk slave storage full
I find that my slave disk is full, but I don't understand what makes it full.
Can anyone help me explain what this file is?
And how it is formed, so that it makes lots of files that make storage full.
...
0
votes
1answer
62 views
Slow logs are not showing full details
I am new to mysql DB.
I have set log_slow_verbosity value to full.
root@localhost/(none)> SELECT @@global.log_slow_verbosity;
+-----------------------------+
| @@global.log_slow_verbosity |
+------...
0
votes
0answers
37 views
Percona: Analyze table doesn't work
I have a Percona 5.6.28 servers with a=some TokuDB tables. The biggest table has ~120 million rows. Statics keeps changeing in the past hald year:
At first. Analyze table with recount model toke ...
0
votes
1answer
145 views
MySql Galera Multi site high availability
We have a datacenter with 3 percona glera nodes
We have a store that wants to be in sync with our datacenter(multi master)
our store's internet connection is not reliable ( may be down for 30 min), ...
0
votes
1answer
2k views
Error: ERROR 1047 (08S01) at line 6955: WSREP has not yet prepared node for application use
While restoring a dump from a CloudSQL instance into a node of a Percona xtradb cluster, I am getting this error. The line 6955 in the .sql dump file is in bold below:
DROP TABLE IF EXISTS `...
0
votes
1answer
33 views
Percona/XtraDB Database with many of writes to a small table uses less CPU than the same database with less writes?
I'm trying to understand why Percona and xtradb InnoDB/MySQL behaves the way it does and if there's anything I can change in the configuration to fix it.
I've a InnoDB database with only one table ...
1
vote
0answers
71 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
195 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 ...
0
votes
2answers
156 views
MySQL (Percona): Multiple simultaneous long-running connections
I'm running a distributed app in the cloud where clients keep open multiple long-running connections to a MySQL (Percona) server.
After updating to the latest Percona release, the maximum number of ...
0
votes
1answer
467 views
MySQL replication slave using percona and docker
I am trying to run a MySQL replication slave in a docker container. We are running MySQL 5.7.24-27-log in production and it's from the percona repository (Ubuntu 18.04).
I have used xtrabackup to ...
1
vote
0answers
78 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, ...
0
votes
1answer
581 views
Is it possible to setup MySQL replication through ProxySQL?
We currently have replication working through haproxy so that if a node goes down replication continues with one of the other nodes. We're trying to completely replace haproxy with proxysql. Due to ...
0
votes
0answers
91 views
deadlock when transaction is waiting for itself
Sypnosis: percona-server 5.7.12, sometimes deadlocking
Am I right interpreting this output in a way that transaction 2 is waiting on itself ? And, if yes - why ?
------------------------
LATEST ...
0
votes
0answers
102 views
Where and how to set the variables for Percona MySQL Audit Variables
I am trying to set the variable values for Percona MySQL Audit Plugin in my.cnf file before installing the audit plugin on MySQL Server like 'audit_log_rotate_on_size','audit_log_rotations' and '...
0
votes
2answers
703 views
Percona Xtradb cluster 56 node 2 rejoin cluster failed
I have following DB cluster:
Node 1: Percona-XtraDB-Cluster-56-5.6.39-26.25.1
Node 2: Percona-XtraDB-Cluster-56-5.6.39-26.25.1
Node 3: Percona-XtraDB-Cluster-56-5.6.41-28.28.1
I start in order ...
0
votes
0answers
385 views
MySQL InnoDb crash when importing tablespace from remote machine
InnoDB crashes when importing ibd file from remote machine. Source version is MySQL-5.6.40, Destination version is MySQL-5.6.40.
Database was backed up was backed Percona Xtrabackup with xbstream ...
