Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Filter by
Sorted by
Tagged with
0 votes
1 answer
20 views

pt-online-schema-change failed when creating new tablle, specified key was too long; max key length is 767 bytes issue

The version, mysql is InnoDB 5.6.10-log, pt-online-schema-change 3.1.0. table info is `email` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid` varchar(255) COLLATE utf8mb4_unicode_ci ...
user avatar
0 votes
0 answers
13 views

Error installing xtradb percona cluster

I have 2 nodes to join percona cluster . I installed them successfully , node 1 was able to start working . when I switched to node 2 configuration, I fixed the file my.cnf cat >>/etc/my.cnf<&...
user avatar
0 votes
0 answers
8 views

Percona MySQL 5.7 to 8.0

I wondered if anyone has successfully upgraded percona 5.7 to 8.0 with a fully populated database. All the articles I've read suggest it is possible but I've tried twice in a test environment and ...
user avatar
  • 1
0 votes
1 answer
51 views

MySQL insert on an empty table takes 38.91ms

This DB is running in a cluster. Insert/Update queries are taking more than 30ms to execute. Select queries are quick with less than 5ms. We are already following this guide: here From Laravel Query ...
user avatar
1 vote
1 answer
44 views

Remove node from percona xtradb cluster

I have a 5 node cluster. When I run backups it locks the entire cluster. I use DDL statements in a stored procedure that is used heavily. What I am trying to achieve is taking one node out of the ...
user avatar
0 votes
0 answers
45 views

pt-table-sync perfomance/load on a production MySQL RDS instance

Hi Percona User group, I’m trying to access the performance implication of using pt-table-sync tool to replicate a collection of tables from a schema on production server (on load) to a replica schema ...
user avatar
2 votes
2 answers
410 views

How to avoid replication lag in case all writes on master and reads on replica?

I have stuck with the replication lag problem. I am trying to refactor my DB infrastructure. The first step was read-write split. I used ProxySQL то implement it. Now I have masterDb where all INSERT ...
user avatar
0 votes
0 answers
100 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. ...
user avatar
0 votes
1 answer
56 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/...
user avatar
  • 1
1 vote
3 answers
81 views

Improving performance for large volume of simultaneous reads/writes on Percona 8

A general description of the environment and the use case: Technical: We're running a distributed application with a single server and ~25 clients; each client is running ~75 threads. At one ...
user avatar
  • 111
1 vote
0 answers
73 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 ...
user avatar
  • 111
0 votes
3 answers
2k views

Downgrade mysql 8.0.27 to 8.0.26 ubuntu 20.04

I set up a new AWS EC2 instance with Ubuntu 20.04, php, Apache, and mySQL. I also installed N-Able (Solarwinds) server backup. I am able to do system and file backups but the mySQL backup fails. N-...
user avatar
-1 votes
1 answer
91 views

Drop column with percona does not shrink table size

I have a table in Aurora MySQL 5.7. table has few partitions with 800m rows and weights 2tb. Recently I dropped few column using percona. Surprisingly the table size did not change (looking in ...
user avatar
  • 393
0 votes
2 answers
180 views

Steps to remove node from percona cluster

I have to update the os on a few servers and I need to remove a db from the cluster. wsrep_cluster_address='gcomm://192.168.2.59,192.168.2.60,192.168.2.61,192.168.2.62,192.168.2.63' Do I remove the ...
user avatar
1 vote
1 answer
88 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=/...
user avatar
  • 189
0 votes
1 answer
152 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/+...
user avatar
-1 votes
1 answer
218 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: ...
user avatar
0 votes
0 answers
329 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 ...
user avatar
0 votes
1 answer
24 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; ...
user avatar
  • 221
0 votes
2 answers
188 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 ...
user avatar
  • 1
1 vote
1 answer
849 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 ...
user avatar
1 vote
1 answer
153 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 ...
user avatar
0 votes
1 answer
654 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 ...
user avatar
  • 3
1 vote
1 answer
276 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. ...
user avatar
1 vote
0 answers
284 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 ...
user avatar
  • 11
0 votes
1 answer
277 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 = ...
user avatar
  • 123
0 votes
0 answers
232 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 ...
user avatar
2 votes
3 answers
1k 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-...
user avatar
  • 163
1 vote
0 answers
222 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 ...
user avatar
0 votes
0 answers
63 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 ...
user avatar
  • 11
1 vote
1 answer
51 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
user avatar
  • 23
1 vote
0 answers
104 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 ...
user avatar
  • 15
1 vote
1 answer
105 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 ...
user avatar
  • 11
0 votes
2 answers
192 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 ...
user avatar
  • 111
0 votes
1 answer
126 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 (...
user avatar
  • 21
0 votes
0 answers
109 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'...
user avatar
  • 13
0 votes
1 answer
105 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 (...
user avatar
  • 15
1 vote
1 answer
489 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-...
user avatar
  • 163
1 vote
0 answers
16 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 ...
user avatar
1 vote
1 answer
2k 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) ...
user avatar
0 votes
2 answers
104 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 ...
user avatar
  • 3
0 votes
1 answer
93 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 ...
user avatar
0 votes
1 answer
76 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 ...
user avatar
0 votes
0 answers
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 ...
user avatar
0 votes
1 answer
122 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 ...
user avatar
  • 56
1 vote
1 answer
37 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. *** ...
user avatar
3 votes
0 answers
596 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:~...
user avatar
  • 475
1 vote
1 answer
56 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. ...
user avatar
  • 113
0 votes
1 answer
69 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 | +------...
user avatar
0 votes
0 answers
45 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 ...
user avatar
  • 1

1
2 3 4 5
7