Skip to main content

Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

Where is my memory leaked?

I'm running Percona MySQL 8.0.36-28 on Kubernetes (GKE) and I am suffering of a constant memory leak I am not able to identify. MySQL reports the memory usage is 1.8G, while when I check the memory ...
Dani Lou's user avatar
0 votes
1 answer
36 views

Why does PostgreSQL not add padding for column alignment at the end of tuple?

In the example here: https://www.percona.com/blog/postgresql-column-alignment-and-padding-how-to-improve-performance-with-smarter-table-design/ Why doesn't PostgreSQL add 2 bytes padding after the ...
Amr Elmohamady's user avatar
0 votes
0 answers
13 views

Percona Xtra backup -File ./ib_logfile0: 'open' returned OS error 71. Cannot continue operation

Is there any way to solve this error? xtrabackup --backup --user=backupuser2 --password='pass' --target-dir=/u02/backup/ xtrabackup: recognized server arguments: --server-id=1 --log_bin=mysql-bin.log -...
datascinalyst's user avatar
0 votes
1 answer
14 views

how to stop on-site db from also killing cloud db

we have a master-master (two-way sync) configuration with our cloud and on-site DB. we're using "Server version: 5.7.28-31-57 Percona XtraDB Cluster (GPL)" Our problem is when the on-site DB ...
magicianiam's user avatar
0 votes
0 answers
26 views

Percona XtraBackup questions about full and incremental backups

I had a few questions on the Percona forum, and I'm unsure if I was being clear in my questions or not, however I'm curious how full and incremental backups work with XtraBackup. When doing ...
alturic's user avatar
0 votes
0 answers
24 views

Getting OOM when trying to change id from int to bigint in MySQL w/ percona

We have 2.5tb table with id column as int in Aurora 3 (MySQL 8.0.26). We need to change it to bigint as ids will run out soon. We tested it with pt-online-schema-change and the server crashed because ...
Nir's user avatar
  • 533
1 vote
1 answer
46 views

MySQL/MariaDB/Percona replication for tables without a primary key

While creating tables without primary keys is definitely a bad practice, there are third-party applications with their own schemas, and altering third party's schema by adding a primary key might turn ...
kamazee's user avatar
  • 113
0 votes
1 answer
105 views

innodb_buffer_pool_size complications

I had some complications regarding innodb_buffer_pool_size. I read the official documentation, and I found out the formula innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances. so if my ...
datascinalyst's user avatar
2 votes
1 answer
74 views

how percona hot backup works / innodb crash recovery works?

I am trying to understand the process of how percona does hot backup. from what in understand is, they use innodb crash recovery mechanism and execute the following steps. store/remember start LSN ...
Rajat Aggarwal's user avatar
3 votes
2 answers
94 views

Different Percona XtraDB nodes use different indexes for the same query

We have three Percona XtraDB nodes arranged in a master-master replication topology. One of our databases contains a heavily utilized table. This table has multiple indexes, as well as a few foreign ...
Anne Douwe's user avatar
1 vote
0 answers
42 views

Slow database performance after mysqldump backup [closed]

we are using mysql 5.6-91 (percona) as the backend database. Everyday morning mysqldump is used to back up the entire database and upload it to s3. The database size is around 70GB. The issue we are ...
Shreehari's user avatar
  • 119
2 votes
0 answers
60 views

Why does this query cause tmp table to be stored on disk even though its size is smaller than tmp_table_size?

I have MySQL server (8.0.29-21 - Percona Server) with: tmp_table_size=67108864 max_heap_table_size=67108864 log_slow_filter="tmp_table_on_disk" And in the slow query log, I can see lots of:...
elderapo's user avatar
  • 121
0 votes
1 answer
350 views

xtrabackup --prepare and --apply-log-only question

I need to run the --prepare immediately after the backup with xtrabackup to make the backup consistent, or can I perform this step only when I am restoring the database? For example, running the --...
Astora's user avatar
  • 733
1 vote
1 answer
61 views

Updating gcache.size on a Three Node Cluster

Is it possible to update this value on Percona 5.7 without restarting a node? Also, do I need to bring the entire cluster down to update the setting, or can I update one node at a time?
Ndeb's user avatar
  • 11
0 votes
1 answer
39 views

command: apply_migration, originalError: Error 1845: LOCK=NONE is not supported for this operation. Try LOCK=SHARED

I've got this error during app schema migration {"timestamp":"2023-01-11 11:53:09.043 Z","level":"fatal","msg":"Failed to apply database ...
laimison's user avatar
  • 113
0 votes
0 answers
54 views

Permanent node removal from Percona cluster

There are instructions about temporary removal a node from Galera, for backup, upgrade or testing. But I couldn't find a safe step-by-step procedure for permanent removal. I have a cluster with 4 ...
sa7's user avatar
  • 101
2 votes
2 answers
124 views

Difference Between Full Scan and No Index Used in MySQL?

What is the difference between Full Scan and No Index Used Handler in MySQL?
Asuwini P's user avatar
1 vote
1 answer
30 views

Syntax issues when uploading backup from mysql5.7 to percona xtradb 5.7

Greetings to those readying the thread and thank you for devoting your time to answering the question. I have encountered a problem when uploading a MySQL 5.7 backup database to a Percona xtradb 5.7 ...
michael peychev's user avatar
1 vote
1 answer
147 views

What is the best way to migrate a multi-TB MySQL database from on-prem to gcloud Cloud SQL?

I have several multi-TB on-prem MySQL databases I need to migrate into Google Cloud's managed MySQL offering, Cloud SQL. I have migrated two of size ~1TB so far with mysqldump but this method is far ...
CClarke's user avatar
  • 133
1 vote
1 answer
498 views

MySQL InnoDB's History Length is growing while mysqldump is in progress

I'm using a 3-node group replication cluster of Percona MySQL (8.0.25) behind ProxySQL nodes (2.3.2). The transaction-isolation param is set to READ-COMMITTED. While I'm running mysqldump (through ...
Pavel Sapezhko's user avatar
0 votes
1 answer
260 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 ...
Ilake Chang's user avatar
0 votes
0 answers
22 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<&...
jonny hieu nguyen's user avatar
0 votes
1 answer
669 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 ...
Mike's user avatar
  • 3
0 votes
1 answer
96 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 ...
magicianiam's user avatar
1 vote
1 answer
408 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 ...
newdeveloper's user avatar
3 votes
2 answers
4k 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 ...
Volodymyr Bilovus's user avatar
0 votes
1 answer
271 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/...
Ongu's user avatar
  • 1
2 votes
3 answers
533 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 ...
Andrei's user avatar
  • 121
1 vote
0 answers
377 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 ...
Tyralcori's user avatar
  • 111
1 vote
3 answers
9k 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
0 votes
1 answer
346 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 ...
Nir's user avatar
  • 533
0 votes
2 answers
539 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 ...
newdeveloper's user avatar
1 vote
1 answer
512 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=/...
Eng7's user avatar
  • 229
0 votes
1 answer
516 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/+...
user1541301's user avatar
-1 votes
1 answer
900 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: ...
ImranRazaKhan's user avatar
0 votes
0 answers
859 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 ...
Mr. Javaist's user avatar
0 votes
1 answer
39 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; ...
j4nd3r53n's user avatar
  • 231
0 votes
2 answers
715 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 ...
Les's user avatar
  • 1
1 vote
1 answer
3k 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 ...
Shiwangini's user avatar
1 vote
1 answer
665 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 ...
Hassan Khodadadeh's user avatar
0 votes
1 answer
2k 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 ...
gecko's user avatar
  • 3
1 vote
1 answer
677 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. ...
user1458792's user avatar
1 vote
1 answer
527 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 ...
Storm's user avatar
  • 11
0 votes
1 answer
426 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 = ...
clarkk's user avatar
  • 157
1 vote
0 answers
1k 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 ...
ellegix78's user avatar
2 votes
3 answers
3k 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-...
ParoX's user avatar
  • 163
1 vote
0 answers
366 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 ...
Perica Jakimov's user avatar
1 vote
1 answer
237 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
devops's user avatar
  • 23
1 vote
0 answers
197 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 ...
Deb's user avatar
  • 115
1 vote
1 answer
232 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 ...
Sevak's user avatar
  • 11

1
2 3 4 5
7