Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Filter by
Sorted by
Tagged with
1
vote
2answers
959 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
390 views

MySQL XtraDB/Galera Cluster High Availability RamDisk *SuperFast*

Ok, So this is going to be a speculative question, mostly design oriented and a rather long one. I'd grab a cuppa' covfefe, if I were you. Preface: So I have been researching into databases and ...
0
votes
2answers
363 views

Percona XtraDb cluster auto increment

Help me please clarify a very important question on which I can't find the answer. It only can be proven with tests. Let's say we have XtraDB Cluster (or Galera Cluster) with three nodes. We have ...
2
votes
0answers
442 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 ...
2
votes
1answer
471 views

Using Pt-online schema change on multi master MYSQL

We are using two MYSQL servers in ring replication where master is also a slave of the other master. Both have slaves connected to each other. We want to run pt-online-schema-change to add couple of ...
1
vote
1answer
236 views

How can I make an Async Slave track all of the nodes in a Percona XtraDB Cluster?

I'm seeing a lot of tutorials that claim I have to pick just one of the nodes in my master-master replicated PXC to act as master for an async slave using vanilla mysql replication, and if something ...
0
votes
2answers
515 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 ...
1
vote
2answers
671 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
2answers
2k views

MySQL memory usage keeps growing. 30GB growth in 3 weeks

We have a server with 64GB memory. After restarting MySQL, in 3 weeks memory is almost full. MySQL was installed using Debian Percona packages. Version: Percona Server Release 17 5.7.19-17-log In ...
0
votes
1answer
95 views

(re)creating empty tables in partially restored mysql database fails with “table exists”

Following situation: I have a MySQL Server (running Percona Server 5.7) set up as a replication slave. This server should hold only a partial replication. To get to this I made a partial backup of ...
1
vote
1answer
188 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 ...
0
votes
1answer
362 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 (...
1
vote
1answer
509 views

xb_stream_read_chunk(): wrong chunk magic at offset 0x0

I have taken a backup of mysql instance like this innobackupex \ --user=$MYUSER \ --password=$MYPASS \ --no-timestamp \ --parallel=$DUMP_THREADS \ --stream=xbstream \ --slave-info \ ...
1
vote
0answers
135 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. ...
3
votes
2answers
6k 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
4k views

Percona - Unable to start mysql after restart

I just configured a percona xtradb cluster in ubuntu with 2 node. This is what I did. launched 2 new servers. Installed percona cluster on both nodes. Stopped mysql on both nodes. On server1: /...
0
votes
1answer
39 views

MySQL Troubleshooting workflow

In a couple of interviews i have had recently, i have been asked to explain my workflow when troubleshooting or resolving an incident with MySQL. Here are ways they have asked the question: Explain ...
1
vote
1answer
302 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
1answer
48 views

Calculating Galera gcache for PXC

I was trying ti figure out how to calculate the right gcache for my server and came across the following post discussing just how to do that: https://www.percona.com/blog/2014/09/08/calculate-correct-...
0
votes
0answers
223 views

PXC duplicate entry issue

We have a Percona PXC with three nodes. last week, we had a third node, db-node-3, go down with an error: 2017-03-12T10:41:22.070396+08:00 30 [ERROR] Slave SQL: Could not execute Write_rows event on ...
1
vote
1answer
518 views

MySQL Error: “Table storage engine for `proc` doesn't have this option (ERROR 1031)”

I'm running into a strange problem with MySQL. Searched everywhere for a fix but cannot find anything. Running Ubuntu 14.04. I have a database running on Percona MySQL 5.7.18-16. I want to update ...
0
votes
1answer
50 views

Will DROP TABLE of an empty table with a large tablespace file cause a long lock?

Let's say I have a reasonably large (100GB) INNODB table on a 3-node Percona Xtradb Cluster that uses innodb_file_per_table=1 and has about 80GB buffer_pool per node and uses ext4. I want to drop this ...
2
votes
1answer
820 views

Problem with aborted PT-online-schema change command

I aborted a pt-online-schema change command to change a table definition. Now, when I run pt-online-schema change again, I get this error: The table <db name>.<table name> has triggers. ...
0
votes
1answer
413 views

Pagination: Slow ORDER BY with large LIMIT range

I have a forum that run this query to do pagination for category pages: mysql> SELECT thread.threadid,thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, ...
0
votes
1answer
297 views

percona-online-schema-change is taking a lot of time

We have a table with 600M+ records and using AWS Aurora with master-slave replication. Requirement: We need to add two columns with index in customer table. Aurora Instance Specs: Ram: 30.5 GB ...
1
vote
1answer
379 views

Transfer data from standard mysql server to Percona XtraDB Cluster

My old mysql 5.5 server is having some hardware issue, so now I'm going to setup a new Percona 5.7, two node cluster in my environment and connect my app into it. Now the problem is, How should I ...
3
votes
1answer
601 views

Percona xtrabackup transaction log corrupted

I am attempting to prepare and restore a full backup taken through xtrabackup via a scheduling script called surrogate. I have tarred and gzipped the backup, transferred to a local machine running ...
1
vote
3answers
610 views

pt-online-schema-change trigger problem

I need to run an alter with Percona tool but it gives error: The table gts.xml_bookings has triggers. This tool needs to create its own triggers, so the table cannot already have triggers So I ...
4
votes
3answers
6k views

What should I set my table_definition_cache to?

I just discovered table_definition_cache and I am trying to decide what to set it to. I am messing with my config because of performance issues. On one server I have 36599 tables and when I run SHOW ...
0
votes
1answer
595 views

Optimise Percona 5.7 my.cnf for a 32GB mixed nginx/php/mysql server

I have a dedicated server which I run my website from. It's got 32GB of ram, Xeon E5-1650 3.2Ghz (6 core, 12 with HT) and two 3TB drives in RAID 1. I'm running Percona 5.7.18 99% of my tables are ...
0
votes
2answers
258 views

Is it possible to backup and restore InnoDB tables on Oracle's MySQL 5.7.19 Server with Percona Xtrabackup?

I have the next configuration: OS: Ubuntu 16.04.2 x86_64 MySQL Server: Ver 5.7.19-0ubuntu0.16.04.1 for Linux on x86_64 ((Ubuntu)) installed from Ubuntu's repos Percona Tools: innobackupex version 2....
4
votes
2answers
1k views

How does MySQL manage its memory with regards to indexes?

To start off, the reason I'm asking this, is because I feel I have a database that - according to my own estimates - should have been killing the disks with massive I/O, because of indexes not fitting ...
1
vote
1answer
3k views

MySQL not using PRIMARY KEY to sort by default [duplicate]

I have a large MySQL table on 5.6.35-81.0 Percona Server with gaps in the PRIMARY key. The table has around 53 Million records and the auto-increment key is now at around 370 million. The table is a ...
3
votes
2answers
369 views

How to optimize this specific MySQL query which examines 2.84M rows and 29.49k InnoDB distinct pages

I am trying to figure out why one query need ~5 seconds to be completed and how to optimize it. Here is what information I gathered so far: 1. EXPLAIN statement for the query: EXPLAIN EXTENDED ...
0
votes
1answer
113 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
849 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
681 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 ...
2
votes
1answer
525 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/...
0
votes
1answer
248 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 ...
1
vote
2answers
625 views

MySQL restore only Incremental backups with innobackupex

I am migrating a product to AWS and we have 1.5TB of MySQL database. I want to migrate it to AWS with minimum downtime possible. I am planning to achieve following. Take one full backup with Percona ...
2
votes
1answer
666 views

pt-table-checksum and mysql 5.7 with binlog_format=ROW

How to use pt-table-checksum in mysql 5.7 where binlog_format=ROW is default I also need binlog_format=ROW to be set this way in relation to other parameters in the mysql configuration # pt-table-...
0
votes
1answer
1k views

Galara take too much time for pre-commit stage

Our system has 3 Percona XtraDB servers, laid in the same network (we are using azure cloud). Our database has around 100 tables, ~120GB. The biggest table contains about 100M rows. Ping time between ...
2
votes
1answer
1k 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 ...
3
votes
1answer
618 views

Tokudb 5.7 [Warning] The partition engine is deprecated and will be removed in a future release

I am running upgrade from Tokudb 5.6.30 to 5.7.17 (Percona distribution) and I am getting this warning [Warning] The partition engine, used by table ‘my_table’, is deprecated and will be removed in ...
2
votes
2answers
3k 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 ...
3
votes
3answers
207 views

MySQL can take more than an hour to start

I have a mysql (Percona) 5.7 instance with over 1Million tables. When I start the database, it can take more than an hour to start. Errorlog doesn't show anything, but when I trace mysqld_safe, I ...
2
votes
2answers
298 views

Race condition in mysql / percona innodb binlog for master -> slave

I'm having a really hard time diagnosing and working around a race condition that is causing problems on my slave and knocking it offline due to a foreign key relationship. We're using MIXED format ...
0
votes
1answer
223 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-...
3
votes
1answer
655 views

Galera cluster into Google cloud platform

We have a galera cluster with 3 nodes, on 3 different physical machines but all located in the same datacenter. From what I understood, the reason they deployed this in the past was to increase ...
0
votes
2answers
371 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 ...