Questions tagged [percona]
Percona : MySQL open source fork with performance improvements
306
questions
1
vote
1answer
32 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
63 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
36 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
26 views
Xtrabackup Incremental Backups Failing After Enabling Change Page Tracking on MySQL 5.7
A week back I'd enabled the parameter innodb_track_changed_pages=ON on one of our Percona MySQL 5.7.10 database instances that we use as a Data Warehouse. The OS is Ubuntu 16.04. So far the ...
0
votes
0answers
27 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
0answers
26 views
How to “catchup” data after a backup
I need to transfer a database to another server with hopefully 0 downtime.
I have Percona Mysql 8 on the destination and Mariadb on the source.
I have successfully used Percona XtraBackup to create ...
0
votes
0answers
10 views
Does mcafee mysql audit plugin not work on Percona Server 5.7.27-30?
My environment is 5.7.27-30-log Percona Server on CentOS 7.4.
When I installed this plugin (audit-plugin-percona-5.7-1.1.7-866), I got the following error messages.
mysql> INSTALL PLUGIN AUDIT ...
0
votes
1answer
27 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
46 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
7 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
104 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
59 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
0answers
12 views
PMM QAN changing time-zone
How can I change the time-zone for the QAN page? The issue is that when I check the first-seen and last seen for any particular query, it shows in my local time (IST) + 5:30hrs. PFA screenshot, the ...
0
votes
1answer
30 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
0answers
63 views
Unable to add new node to Percona eXtraDB Cluster
I have a machine which was bootstrapped once for a Percona eXtraDB Cluster which is no longer available. See systemctl status mysql@bootstrap.service below:
[root@RH7 ~]# systemctl status mysql@...
0
votes
1answer
33 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
93 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
19 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
32 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:
# ...
1
vote
0answers
137 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
27 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
45 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
27 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
74 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
1k 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
30 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
50 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
144 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
92 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
321 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
57 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
375 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
54 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
80 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
494 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
260 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
463 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
31 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
153 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
718 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
40 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
419 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
250 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
44 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
27 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
140 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
151 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
68 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
478 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 ...
