Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Filter by
Sorted by
Tagged with
1
vote
1answer
8 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. *** ...
0
votes
0answers
8 views

Problems importing innodb tablespaces

I am struggling with restoring a backup of a MySQL 5.5 database, which has been created with innobackupex --databases .... These are the steps to set up mysql and prepare the backup for restore: # ...
0
votes
0answers
13 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
24 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
23 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
22 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
36 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
0answers
297 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
26 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
30 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
78 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
60 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
123 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
38 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
140 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
31 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
69 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
260 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
137 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 ...
2
votes
2answers
165 views

Using CONVERT TO CHARACTER SET for changing only collation?

I think the answer to this is an obvious yes, but I'm having trouble finding confirmation on it. All the questions related to charsets seems to be about changing the charset and not only collations. ...
0
votes
0answers
20 views

Learning Percona Monitoring - CPU Usage

I've just started using the Percona Monitoring. I am not necessarily a db admin but I ended up with the task. I am enjoying it but truth be told I am not sure what I am looking at. There is an ...
0
votes
0answers
14 views

do tmpdir is cleaned up automatically

While testing a 3 node percona cluster we often get: Errcode: 28 - No space left on device After login to the servers and checking the defined tmpdir I notice that is empty and clients can connect ...
0
votes
0answers
27 views

Proper way to fully backup and restore a database including indexes in a low-resource shared web host with ssh access?

I'm rather new to database management and I would like some advice on better practices by using the following experience as an example. Every time I update php software I do a quick export from ...
0
votes
1answer
96 views

Is it safe to use pt-online-schema-change in a multimaster environment?

I have 2 MySQL servers with row-based replication between them. Both of them are masters and slaves for each other (active-active master-master setup). If I understand it correctly pt-osc creates ...
0
votes
0answers
363 views

Is ProxySQL Suitable for Connection Pooling Apps?

I'm looking for some guidance on whether ProxySQL is suitable as a method of failing over Java connection pool based apps in a multi-master replication (with read/write split) set up? I've found ...
0
votes
1answer
30 views

Xtrabackup corrupt incremental backup

I have 3 nodes PXC 5.6 cluster. Xtrabackup 2.3.10. Centos 7.6 Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64 I am using only single Node-1 for both read and write. And I use to take backup ...
0
votes
1answer
214 views

Percona PAM with AD authentication using SSSD

I have installed percona PAm plugin on my Percona server as shown below: mysql> show plugins; ... | auth_pam | ACTIVE | AUTHENTICATION | auth_pam.so | GPL | | ...
0
votes
2answers
136 views

Safe backup of PXC / Galera cluster

I have 3 nodes 'master master' cluster and using PXC 5.6 But I am only using a single node for both read and write. Before using pxc, i was using standalone Mariadb 5.5 and I was taking backup using ...
0
votes
1answer
37 views

Convert MyISAM to InnoDB in PXC master master

I have 3 nodes PXC 5.6 master master cluster. I have few tables that are using MyISAM. Total MyISAM table = 120 Total MyISAM table size = 80MB I have also read few recommendations where it suggests ...
0
votes
1answer
21 views

Character set warning in PXC logs

I am using PXC 5.6 (Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64) and my log file is flooded with this warning: [Warning] Client failed to provide its character set. 'latin1' will be used ...
-1
votes
1answer
101 views

Auto increment gap in percona xtradb cluster master master setup

I was using mariadb 5.5 before but now I have upgraded it and using percona xtradb cluster 5.6 I have 3 nodes cluster. I am only using single node for read and write. I saw some increment gaps in ...
2
votes
0answers
96 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 ...
0
votes
1answer
48 views

Missing wsrep variables in mysql / percona / galera cluster

I set up a small mysql/percona/galera cluster using the percona cluster docker image, with 3 nodes. I followed the documentation written here After starting up the whole cluster, I'm missing some of ...
0
votes
1answer
334 views

InnoDB Buffer causing a lot of deadlocks and connection/client timeouts

I have a PXC cluster (5.7) with three nodes running on CentOS 7 VMs, each with the following system info: mysql_db# free total used free shared buff/cache ...
5
votes
1answer
268 views

MongoDB Migrating away from RocksDB to WiredTiger

We have been working for some time with RocksDB as our engine and we are now trying to migrate to WiredTiger. We have some pretty big databases around 4~12 TB of data and according to the process ...
1
vote
0answers
119 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
1answer
252 views

MySQL PXC node failing to receive state

I have three nodes that I want to setup into a Percona XtraDB Cluster (PXC). I have bootstrapped the first node and joined the second node, but cannot somehow join the third node. All configuration is ...
1
vote
0answers
37 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 ...
0
votes
1answer
67 views

ProxySQL in PXC and failing all nodes

I'm going to install Percona XtraDB Cluster, and I have two questions about it: 1- Is it the last step? https://www.percona.com/doc/percona-xtradb-cluster/LATEST/verify.html Or installing ProxySQL ...
0
votes
2answers
138 views

MySQL Solution to Sync 3 servers data

I have 3 servers which there is a load-balancer in front of them and sends the requests to these servers randomly. The script is the same in all of these 3servers, but I need to sync the DB in all of ...
0
votes
1answer
149 views

Percona pt-table-sync Can't determine Master

We have following Multi master replication scenario. We are using MariaDB 10.1.34 and Percona 3.0.11 Master: Name: db-master1 (192.168.14.5) Slave: Name: db-slave2 (192.168.15.5) Replica Connection ...
0
votes
1answer
191 views

Percona pt-table-checksum output is in infinite loop “Waiting for the --replicate table to replicate”

We have following Multi master replication scenario. We are using Mariadb 10.1.34 and percona 3.0.11 Master: Name: db-master1 (192.168.14.5) Slave: Name: db-slave2 (192.168.15.5) Replica ...
0
votes
1answer
210 views

Enable GTID on one node in Percona/Galera

Im having 3 node percona cluster. (5.6) Server ID is enabled on each node but all are different IDs. Binlog and log slave updates are enabled. Now I want to enable GTID on the third node alone. I ...
1
vote
1answer
56 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 ...
0
votes
1answer
52 views

Point In Time recovery on Mysql

Can someone please advise best methods to do a mysql PITR from binary logs that are saved in MIXED format. I am finding it difficult to identify the wrong queries that executed to avoid from restore ...
1
vote
1answer
61 views

Percona xtradb Backup for OLTP

I have installed MySQL 5.7 community edition installed. Can we use Percona xtradb backup tool for backup DB for banking site databases for OLTP?
1
vote
1answer
446 views

what is MDL? (e.g. 'MDL semantics' or 'MDL locks') Probably Galera related

I found a guy talking about MDL semantics in a Galera/XtraDB bug report. What is MDL? The term MDL also in Galera logs MDL conflict. Please explain in detail. 2018-06-14 17:07:10 140112699321088 [...
1
vote
0answers
311 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
2answers
587 views

Mysql backup of remote server in local machine using percona xtrabackup

I had asked this question in serverfault.Later, i came to know about this site. I have percona xtrabackup installed in my ubuntu client machine. My local machine IP address is 192.168.0.100. The ...
3
votes
0answers
156 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, ...