Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Filter by
Sorted by
Tagged with
1
vote
0answers
47 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, ...
1
vote
0answers
127 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
0answers
41 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 ...
1
vote
1answer
77 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 ...
1
vote
0answers
328 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
1k views

ProxySQL user not connecting - XtraDB

I'm trying to set up a xtraDB Cluster consisting of 3 nodes. Now i've got the cluster up and running and per the instructions i'm trying to set up ProxySQL for load balancing. So i've installed ...
1
vote
2answers
761 views

MySQL InnoDB .ibd file growing extreme

We have a database with a few larger tables were one (yes only one) table grows extremely. It contains only 50 gigabytes of data while the .ibd file (we use innodb_file_per_table) takes up about 1.2 ...
1
vote
1answer
203 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
0answers
151 views

TokuDB table stats row count decreases very fast while adding/updateing data

We run an Percona server with the newest version(5.7.19-17). After a while the cardinality of multiple tables drop to zero. A new created index also have an cardinality of 0 if the existing are zero. ...
1
vote
1answer
315 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-...
1
vote
0answers
108 views

MySQL Insert from Select and schema alter Busy Production without downtime

Strategy for migration of Huge MySQL (Percona 5.7) Table (InnoDB) in production. The aim is to have minimum downtime (offline schema change would take a week or more...) old has a 100 plus columns ...
1
vote
0answers
233 views

why pt-table-checksum lock my whole table?

mysql> desc user_donate_request; +-------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------...
1
vote
0answers
22 views

Innodb file format - Percona Server [duplicate]

I had my innodb file format changed from antelope to barracuda recently. Is it safe to have both antelope and barracuda at the same time? I have my setup running properly now. What issues I would ...
1
vote
0answers
1k views

Trying to install Audit_log Plugin on MySQL

I'm trying to install the Percona Audit_log plugin for my instance of MySQL. I ran it previously so I know it works ok with MySQL (I'm sure it says so in the documentation anyway). I have MySQL 5.5....
1
vote
0answers
39 views

New percona xtradb node shuts itself down shortly after launch

We currently have a 3 node percona xtradb cluster running on premises. We are trying to add a 4th, remote node ( Obviously split-brain is a concern in this situation but it is only temporary while we ...
1
vote
0answers
397 views

Memory leak on MySQL slave?

I have a Percona MySQL master-slave server configuration(5.6.20-68.0). The memory usage by MySQL on the slave server is constantly growing. Now it reached 68G despite the fact that ...
1
vote
1answer
660 views

InnoDB AUTO_INCREMENT resetting itself without MySQL restart [duplicate]

We've recently noticed the following scenario happening in many of our databases: A record is inserted, and receives an AUTO_INCREMENT primary key. The record is deleted. Another record is inserted, ...
1
vote
1answer
55 views

Why does Table Definitions Opened differ this much between cluster nodes?

I have a Percona/Galera cluster and see this when i monitor the different cluster nodes. What does this really mean? And is this something erroneous that needs to be taken care of? This is how one of ...
1
vote
2answers
374 views

What options in /etc/mysql/my.cnf are applicable to percona-server-client-5.6?

I installed percona-server-client-5.6 on Ubuntu; there is no mysql server installed on that same machine. In /etc/mysql/, the only file is my.cnf. That file contains many sections of options and I am ...
1
vote
0answers
85 views

MySQL/Percona Audit Log Plugin Not Working

I've been looking to implemement the Percona Audit Log plugin. So far I have installed it and configured it, and it seems to be working ok. Except, I have installed it on a slave Database as I don't ...
1
vote
0answers
316 views

Innobackupex restore steps from 1 incremental and multiple incremental steps

My current backup plan is: Full -> Incremental1 based on full -> incremental2 based on incremental1 -> incremental3 based on incremental2... Please validate if this steps is correct during emergency ...
1
vote
1answer
536 views

Percona MySQL 5.6 databases ignoring key length at constrait creation

We have a 3 servers running Percona MySQL 5.6 in a Master/Master configuration that are all reporting errors on key length, either too long or not specified. The structure of the databases is all ...
1
vote
1answer
871 views

pt-table-sync for 3 master servers

We had a mysql multi master with 3 nodes and unfortunately the replication broke. We have some set of tables which has to be in sync with other database servers, so i was looking into Percona-Toolkit ...
1
vote
0answers
533 views

pt-archiver and foreign keys?

How does pt-archiver handle foreign keys? Does it archive associated data? (seems not but the documentation is not very clear to me) And if not, how could one perform an archive of a table with all ...
1
vote
1answer
2k views

Design for active/passive Master-Master mysql Setup

I have a dozen virtual machines running application + mysql instances (version 5.1 up to 5.5). Due to the bad I/O of the virtualization I want to buy a physical server for mysql and move all mysqldata ...
1
vote
0answers
446 views

Percona XtraDB Cluster With Async slaves

I have set up a 3 node percona cluster in amazon ec2. As our client required, i also had to set up an asynchronous slaves in another datacenter as well. Each async slave pointed to single percona ...
1
vote
0answers
123 views

pt-table-checksum generates no output

I've been using pt-table-checksum on our staging server successfully, but when I run ./pt-table-checksum h=localhost,u=user --ask-pass --lock-wait-time=50 --databases prod It just sits there. No ...
0
votes
2answers
233 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
123 views

SQL Server to MySQL, which fork? [closed]

I have to migrate a SQL Server database to MySQL but i have no idea which fork to use (MySQL, Percona or MariaDB). We don't have so much experience with MySQL and we haven't used it for high ...
0
votes
1answer
449 views

MySQL Backups - Full vs incremental - innobackupex

So I'm implementing a backup strategy for our project and came across some text which I need absolute clarification, false positives are the death nell of IT. I am looking to do your typical backup ...
0
votes
1answer
731 views

How password can be prompted in percona xtrabackup

How password can be prompted while using percona xtrabackup.--ask-pass option is not working with xtrabackup. Thanks in advance.
0
votes
3answers
351 views

What is happening when Seconds_Behind_Master oscillates between two very different sets ov values?

I have a Percona 5.6 slave, newly set up, that is replicating from a server that is itself a slave to a third. The middle server (dbS2, the master for dbS3) is currently ~260000 seconds behind the ...
0
votes
1answer
228 views

Is using the alpha version of Percona 5.6 safe? [closed]

I'm really sorry if my question is kind of very basic, but is something that is really making me thinking a lot about it for a long time. As Percona has a lot of lines of optimizing codes, I run it ...
0
votes
1answer
633 views

percona mysql crashing at innodb initialization

i have a slave percona db setup that also maintains few of it's own tables it started crashing with this in error.log: InnoDB: In a MySQL replication slave the last master binlog file InnoDB: ...
0
votes
1answer
930 views

mysql-community-server5.7.18 conflicts file /etc/my.cnf with Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64

When i tried to install percona-xtrabackup on Master server db yum install percona-xtrabackup-24 I got this error: file /etc/my.cnf from install of Percona-Server-shared-51-5.1.73-rel14.12.625....
0
votes
2answers
779 views

InnoDB Read and Write speed constantly spikes

I am not a dedicated mysql admin but my friend and I have been working hard to fix the badly configured mysql files. We have reduced our number of pools to 2 from 20 and increased pool size to 90GB ...
0
votes
1answer
86 views

Routines backup in Percona xtrabackup

I am using Percona xtrabackup for creating backup of mysql server. Does backup file includes all the procedures, functions and triggers ? Does it get restored when i restore it ?
0
votes
1answer
47 views

One MySQL table for all data vs Several Different Engines MySQL Tables

I did quite good research and went through some information on this regard. But I am not satisfied yet, so preferred to ask directly about it. I'm designing the schema of an application database, ...
0
votes
1answer
713 views

Database Growth in a table - MySQL

I would like to store the database size for a particular database on daily basis on to a table which would help in understand the growth of the database over a period of time. SELECT table_schema AS "...
0
votes
2answers
592 views

Mysqldump failing while restoring database - MySQL 5.6

I have dumped one of my databases of size 5-6GB. I'm trying to restore to another instance but the same is getting failed after sometime with the following error: ERROR 2013 (HY000) at line 12006: ...
0
votes
1answer
338 views

Doubts on Setting up Master-Master replication (Percona)

I have two 5.6 Percona servers in which I'm planning to setup Active master- Passive master replication. Secondary master will be in read-only mode. Caveat is that the servers in which i'm going to ...
0
votes
3answers
1k views

Memory(buffer pool) not populating on mysql start on Percona 5.6.28

We are testing Percona 5.6.28 at the moment, during our testing we found out even though the innodb_buffer_pool_populate is set to ON, it doesn't populate the memory(buffer pool) during mysql start. ...
0
votes
1answer
620 views

MySQL how to find top consuming queries

I have the need to find top resource consuming queries in my Percona 5.6 server so that those queries can be fine tuned to improve the performance of the database. Also, is it possible to get the ...
0
votes
1answer
36 views

Rescue truncated data from incorrect column type

I have mistakenly inserted a variable 18-20 digit variable into an unsigned INT() column. The data has been truncated to the max 32bit length so all my data is displayed as "4294967295" Is there ...
0
votes
2answers
4k views

Percona Xtradb Cluster : How to speed up insert?

I recently installed a 3 full master node cluster based on Percona Xtradb (very easy install). But now i need to make some tuning to increase INSERT/UPDATE requests. Actually, i made around 100 ...
0
votes
1answer
84 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 ...
0
votes
2answers
67 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
2answers
182 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
55 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
168 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 ...