Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Filter by
Sorted by
Tagged with
0
votes
1answer
378 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 ...
2
votes
3answers
4k views

Is it possible to search within a MySQL JSON array in a case insensitive manner?

e.g. with the table: create table test (id int primary key, tags json); insert into test (id, tags) values (1, '["Lorem ipsum", "dolor", "sit"]'), (2, '["foo", "bar"]'); This will match: select id ...
0
votes
1answer
76 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), ...
1
vote
1answer
220 views

Percona-Server: slow TokuDB queries after upgrading from 5.6 to 5.7. ANALYZE TABLE doesn't resolve the problem

After upgrading from Percona-TokuDB 5.6.29-76.2 to 5.7.19-17 we see some very slow queries on some tables without primary keys, but multiple non-unique indexes. The box we migrated to is pretty well ...
1
vote
1answer
146 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 ...
2
votes
1answer
996 views

Flush Host Connection Blocked, but some connections allowed

We are running Percona MySQL 5.6.30. We've had an issue where a PHP script on a different host was reporting an issue connecting to the database: Database may be down : SQLSTATE[HY000] [1129] Host ...
1
vote
1answer
34 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 ...
2
votes
1answer
380 views

Slow ranking values in MySQL

I have a table of around 30 million retail products, with various INT columns that describe sales counters and pricing at different retailers. I'm supposed to display well over 70 different rankings ...
2
votes
1answer
698 views

Full database backup using xtrabackup stream

I'm new to Percona XtraBackup. I've been trying to perform a full backup stream from my local ( test server around 600GB ) to remote server. I just have some questions and I need guides, and I think ...
3
votes
2answers
632 views

Percona MySQL 5.7 | XtraBackup 2.4 - xb_load_tablespaces() failed witherror code 11

I am attempting to upgrade MySQL from 5.6 to 5.7 and everything seems to be working, but when I try to run xtrabackup I am now getting this error: InnoDB: Allocated tablespace ID 12 for percona/...
6
votes
1answer
513 views

MySQL Partitions with Partition limit

I have a partitioned table on the basis of the Primary key having 1.5 Billion rows in it. But when I check the .ibd files only 80 ibd show in GB's whereas 120ibd shows 1MB file. I would like to know ...
4
votes
2answers
10k views

How to set MySQL binlog retention in hours?

I'm in a situation where the MySQL log partition is being filled in less than a day. I can't disable binlogs, since I need them for replication. I know I can set log retention but that accepts days, ...
0
votes
2answers
714 views

High “Pending normal aio writes”

During daily batch operations (mass delete/upsert operations), regular throughput is sometimes affected, e.g. operations such as a single lookup on a PK or a small range (7 rows examined, 1 row ...
0
votes
1answer
278 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
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 `...
2
votes
1answer
110 views

MySQL users not visible after import

I have a Percona MySQL database 5.6 running in a linux machine. I have created new users called test1 and test2. What I did was I imported mysql database from my test setup to this new setup. After ...
0
votes
2answers
536 views

how to make sure pt-sync-table data is the latest?

the first step is to checksum difference and record into percona.checksum table pt-table-checksum h=xx,P=xx,u=xx,p=xx method=dsn=h=xx,D=xx,t=xx --databases=kobe the second step is to print the ...
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
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 ...
1
vote
1answer
97 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 ...
2
votes
1answer
2k views

Percona mysql xtradb cluster doesn't start properly and node restarts don't work

tl;dr When starting a fresh percona cluster of 3 kubernetes pods, the grastate.dat seq_no is set at -1 and doesn't change. On deleting one pod and watching it restart, expecting it to rejoin the ...
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
1answer
269 views

Percona XtraDB cluster backup solution

We have a 3 node percona xtradb cluster and two slaves attached to it. One of the slaves we want to use it for taking backups. We have GTID based replication setup between the slave and the Xtradb ...
0
votes
1answer
236 views

Can't bring up slave from ec2-consistent-snapshot due to uncommitted prepared transaction

I'm struggling with bringing up a slave instance using a snapshot created by ec2-consistent-snapshot, in my log it's describing the fact that an unprocessed transaction exists, but isn't that what ec2-...
0
votes
0answers
28 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
1answer
389 views

how to setup percona pmm monitoring of percona 5.7 in docker container

I want to monitor percona running in docker with the percona monitoring and management client. I have percona monitoring and management installed, running and monitoring other percona instances (...
0
votes
1answer
347 views

Suddenly a massive amount of binlog files

I've seen a sudden increase of binlog files, very large in number and size, in all three nodes of a Percona XtraDB cluster: -rw-rw---- 1 mysql mysql 1,1G 19 oct. 16:11 binlog-32.000001 -rw-rw---- ...
0
votes
1answer
263 views

Does Percona Xtrabackup support RedHat release 4

I downloaded Percona's Xtrabackup rpm file for RedHAT. I attempted to install but hit into an error. The error seems to point to missing dependencies and libraries. I have no issue with RedHat 6 OS. I ...
0
votes
1answer
329 views

Insert into table select - Replication lag - Percona Server 5.6

I have two MySQL instances (Percona server 5.6.31) in Master-Slave replication setup. I have set the below configuration: ROW based replication is set. Transaction Isolation is set to read-committed....
0
votes
2answers
471 views

Optimization causes tmpdir to fill up with 'deleted' file handle

Using Percona 5.6.34-79.1. Storage Engine is InnoDB. One of the table to be optimized is 300Gb in size. tmpdir is a separate partition, and datadir is separate. datadir has 500Gb of space, so ...
4
votes
1answer
6k views

How to prevent “ibdata files do not match the log sequence number”?

I am dealing with a very large set of databases that are all innodb. I've enountered this on mysql restart too many times for my comfort: ibdata files do not match the log sequence number But I've ...
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
27 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 ...
1
vote
1answer
341 views

Percona/MySql Table does not exist after innobackupex restore on Vagrant Ubuntu 16.04

This question is cross posted here from stack overflow at the suggestion of stack overflow commenters (https://stackoverflow.com/questions/47086329/percona-mysql-table-does-not-exist-after-...
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
28 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
47 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
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
1answer
107 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
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
1answer
102 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
0answers
65 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@...
5
votes
2answers
9k views

What is the optimal solution for storing real time time-series in MariaDB / MySQL?

Use case: A measurement creates a given number of images. For each image we need to store a small set of quality indicators (floats, doubles) along with an image integer [1 ...N], a timestamp and one ...
1
vote
1answer
8k views

Difference between FIND_IN_SET and LIKE

Is there a difference in behavior or performance in choosing FIND_IN_SET over LIKE for a operation that looks like: SELECT * FROM my_table WHERE column_1 LIKE '%string%'; vs SELECT * FROM my_table ...
0
votes
1answer
34 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
94 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
2 3 4 5
7