Skip to main content

Questions tagged [percona-server]

Percona Server is a fork of MySQL Community Edition, focusing on performance improvements.

Filter by
Sorted by
Tagged with
0 votes
0 answers
22 views

New MySQL 8.0 slave added to a 5.7 Percona Mysql cluster is stuck Waiting for dependent transaction to commit

I've tried following several guides to add a new Percona cluster as a slave to another cluster. The new cluster will run MySQL 8.0 while the old cluster needs to continue running 5.7 for a few more ...
VagrantPaladin's user avatar
0 votes
0 answers
27 views

Can't get hostname for your address flooded in error log even if skip-name-resolve is enabled and many unauth users in processlist in percona 8.0.25

Information about the currently configured percona servers : We are using percona 8.0.25 server. Mysql service is running with skip-name-resolve enabled. host_cache_size=753 but the ...
Sana Ansari's user avatar
4 votes
3 answers
523 views

failed pt-online-schema-change left behind triggers. How to delete?

We had a failed pt-osc - the server ran out of disk space. And now the triggers are left behind SHOW TRIGGERS; pt_osc_xxx_production_orders_ins pt_osc_xxx_production_orders_upd ...
phil's user avatar
  • 153
1 vote
0 answers
33 views

MySQL8 database painfully slow after failed pt-osc

In another question we attempted to update a table in our MySQL8 db. That didn't work out, but since then our database (even after both DB and machine restarts) seems painfully slow at the strangest ...
phil's user avatar
  • 153
1 vote
1 answer
237 views

MySQL upgrade 5.7 to 8.0 with Keyring encrytption failed to complete upgrade

I ran the mysql community installer on Red Hat 7.9 over a 5.7.36 installation. First, I ran xtrabackup for all dbs Then I stopped mysqld Then I ran yum install Everything ended ok I got the below ...
Jesus Uzcanga's user avatar
1 vote
1 answer
88 views

Percona for mysql 8.0.31 unresponsive every day at exact same time?

So… we’re hitting a weird case the last week. Our percona 8.0.31 server on ubuntu 22.04 (128G RAM) becomes unresponsive every day at the same time. The symptoms are a bit weird too. Our usual ...
Crewone's user avatar
  • 21
0 votes
1 answer
66 views

Percona 8 MySQL server restart while restoring backup

I have a problem with Percona 8 on Debian 11, I installed the latest version of Percona 8 for MySQL server, 8.0.29-21 I set these configurations in the mysqld.cnf innodb_buffer_pool_size = 12G ...
Khaled Hussein's user avatar
0 votes
0 answers
22 views

Error installing xtradb percona cluster

I have 2 nodes to join percona cluster . I installed them successfully , node 1 was able to start working . when I switched to node 2 configuration, I fixed the file my.cnf cat >>/etc/my.cnf<&...
jonny hieu nguyen's user avatar
0 votes
2 answers
1k views

Syntax Error when Creating a Temporary Table Using A Subquery That Contains A Union All

So what I'm trying to do is create a temporary table with a unioned set of results that have distinct conditions. The information is largely the same, just in different places that need to be matched. ...
Marisa's user avatar
  • 23
1 vote
1 answer
411 views

Remove node from percona xtradb cluster

I have a 5 node cluster. When I run backups it locks the entire cluster. I use DDL statements in a stored procedure that is used heavily. What I am trying to achieve is taking one node out of the ...
newdeveloper's user avatar
0 votes
1 answer
178 views

mysqlbinlog not showing 'pseudo-SQL' comments for BINLOG statements

We are running Percona mysql server 5.7.36-39.1 and corresponding version of mysqlbinlog. I'm running mysqlbinlog against a binlog file and position (taken from the output of show master status;) with ...
Will's user avatar
  • 341
0 votes
1 answer
2k views

Force kill long running index creation

I have a 192GB table that I started adding an index to over night. This was still going several hours later. At the time the alter table started the database was very quiet. There were other queries ...
Wodin's user avatar
  • 273
1 vote
1 answer
423 views

replicate-wild-do-table=channel_name:db_name.% doesn't work in MySQL 8.0 for channel based replication

I am trying to configure a replication topology where there will be one slave which will connect to two masters. Percona Server 8.0.25. Master1- main master bkp_server - slave to master1 and ...
Avinash Pawar's user avatar
1 vote
1 answer
175 views

Is it possible to join MySQL 8.0 to a cluster of MySQL 5.7

I have a MySQL 5.7 (5.7.19-17-57-log Percona XtraDB Cluster) cluster using Galera, but I am in the middle of upgrading to 8.0 -- 8.0.23-14 Percona Server (GPL), Release '14'. I wasn't sure if it was ...
user3525290's user avatar
0 votes
1 answer
245 views

How to restore percona database from kubernetes?

I got the backup works by setting these on the helm chart values (it works according to the documentation): google-cloud-storage-s3: type: s3 s3: bucket: gcp_bucket ...
Kokizzu's user avatar
  • 1,373
0 votes
2 answers
18 views

How can I select data size group by id for every value in a table

I hope I can explain exactly what I need to get. I have a Table that has a specific column of type MEDIUMBLOB. What I need to do is to determine the size of every value inserted on this column grouped ...
Mihai Cristian's user avatar
0 votes
1 answer
182 views

How to properly replicate and archive at once

I have a 300GB database that is growing around 5GB a day. It stores time-based data, and as such, I currently have around 60 days of data. My main database server has a 450 GB NVMe, so I want to get a ...
ParoX's user avatar
  • 163
2 votes
1 answer
2k views

Missing mysql, sys, performance_schema

I have Percona Mysql 8.0.19-10 on debian 10. A year ago I had some issues restoring a backup that required me to mess with tablespaces. I forget what all I had done but eventually I got the database ...
ParoX's user avatar
  • 163
-1 votes
1 answer
394 views

MYSQL optimization for Magento 2

Im running my magento 2 project on 5 core 10gb ram VM. I did some benchmarks and i see that my DB queries take quite some time to execute. Traffic on this site is almost zero. Mysql is running on 5.7....
ufo56's user avatar
  • 1
0 votes
1 answer
71 views

Percona xtradb cluster 5.7 solution on AWS and on premise. Not all nodes are connected to

We have 3 nodes cluster. 2 in virginia and 1 in ohio. The cluster is working fine we do not have any issues. But nothing pop out when we started doing extensive monitoring using datadog. It shows that ...
black sensei's user avatar
1 vote
0 answers
206 views

2020-07-29T07:44:29.817503Z 108716 [Note] Aborted connection 108716 to db:

We are getting continuously logs in mysql error logs 2020-07-29T07:46:56.534666Z 111536 [Note] Aborted connection 111536 to db: '' user: '' host: '' (Got an error reading communication packets) we ...
devops's user avatar
  • 23
2 votes
2 answers
193 views

Percona XtraDB Cluster - do I add arbiter IP in gcomm://?

I'm configuring Percona XtraDB Cluster 8 on two nodes, and use a 3rd node to act as an arbiter. I cannot make up out of the docs whether to add the IP of the arbiter in the galera nodes addresses of ...
Kevin C's user avatar
  • 113
2 votes
1 answer
380 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 (...
Jdeboer's user avatar
  • 41
0 votes
0 answers
235 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'...
tavlima's user avatar
  • 23
1 vote
1 answer
499 views

Why are there empty transactions in the MySQL binlog?

I am using Percona Server for MySQL 8.0.x. I have setup replication between two instances with GTID mode turned OFF. Almost all UPDATE and INSERTS are wrapped in the transaction from the application ...
Jigar Patel's user avatar
1 vote
1 answer
1k views

Percona Server - binlog not automatically purge with mysqladmin flush-logs

I have a little problem and I need your help please. Here is the story : I have Percona Server in version 8.0.13 with one slave and the old binlogs on master are not deleted automatically when flush-...
Tim's user avatar
  • 11
0 votes
2 answers
93 views

MySQL version appears to be inconsistent?

I have recently upgraded mysqld (percona server) from 5.5.60-38.12 to 5.5.62-38.14. This is on Debian, and the upgrade was done like this: # apt-get update # apt-get upgrade I am surprised to find ...
j4nd3r53n's user avatar
  • 231
0 votes
1 answer
159 views

Intentionally slow down importing of (Percona) MySQL 5.7 dump

I need to move a very large MySQL table (250M rows, 120 columns. 120GB of data, 310GB of index) from one database instance to another (on AWS). For reasons beyond the scope of this question, this is ...
Pooria Azimi's user avatar
1 vote
1 answer
119 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. ...
fajarhide's user avatar
  • 113
1 vote
2 answers
1k views

MySQL swaps on system with more than enough RAM

Om my new dual AMD EPYC 7401 24-Core (128G RAM) MySQL starts swapping even after a restart with no data in memory. NUMA # numactl --hardware available: 8 nodes (0-7) node 0 cpus: 0 1 2 3 4 5 48 49 ...
tersmitten's user avatar
2 votes
1 answer
292 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 ...
Sarthak Shrivastava's user avatar
0 votes
2 answers
304 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 ...
Andrei's user avatar
  • 121
2 votes
1 answer
1k views

innodb buffer pool size not changing

I have Percona fork of MySQL 5.7 installed where I have defined innodb_buffer_pool_size in /etc/percona-server.conf.d/mysqld.cnf as follows innodb_buffer_pool_size = 10G But, when I login to MySQL ...
Farmi's user avatar
  • 121
0 votes
0 answers
49 views

Help with high load MySQL configuraiton

Server: Disk: 2X 500 SSD RAID 1, 3 TB HDD RAM: 256 GB DDR4 CPU: Intel Xeon 10 core Database: Percona for MySQL 5.7.23 Average number of active connections: 1700 I have 4 schemas, and ...
John's user avatar
  • 1
1 vote
1 answer
202 views

Percona Audit Log plugin not auditing account

I have setup the Percona-server-5.6.41-89 Audit plugin with the following settings: audit_log_policy=QUERIES audit_log_handler=FILE audit_log_file=/var/log/mysql/perc_audit.txt audit_log_format=CSV ...
Someone's user avatar
  • 223
3 votes
1 answer
2k views

mysql_upgrade check if it's neccessary to run it

How can I determine, do I need to run 'mysql_upgrade` command on database? Percona-server-5.6.41 is installed and running now for a several monthes. Before it mysql-5.6 was installed. In-place ...
Someone's user avatar
  • 223
0 votes
1 answer
492 views

Percona-server-5.6.41 and sql_mode [duplicate]

When setting sql_mode="" in /etc/mysql/my.cnf server leaves this variable in it default value: mysql> show variables like 'sql_mode'; +-------------------+--------------------------------------...
Someone's user avatar
  • 223
0 votes
0 answers
70 views

MySQL performance_schema NULL users

I was running performance_schema query to check for users performing DDL on our databases, and found a NULL user, which however does not exists when i check the mysql database for users using the ...
The Georgia's user avatar
1 vote
0 answers
37 views

MySQL server-id reset in CentOS

I am running MySQL 5.7 (Percona) on CentOS 7.5.x, and when I set the serser-id the config file, MySQL is somehow changing the server-id value to '4294967295'. This is happening on all my PXC nodes. On ...
The Georgia's user avatar
0 votes
1 answer
139 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 ...
behnamy01's user avatar
1 vote
1 answer
243 views

MySQL optimization for mapping service -- getting MySQL to use more memory?

Time to upgrade hardware? ... I'm not sure if there is much more I can do, spent a few days tweaking/googling -- before taking the upgrade plunge I thought I'd check here... to see if the well ...
Kelly's user avatar
  • 11
1 vote
1 answer
564 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 (...
washingon's user avatar
  • 111
1 vote
0 answers
197 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. ...
Sebastian's user avatar
1 vote
1 answer
343 views

MySQL 5.7 log rotate empty

We upgraded our Percona XtraDB servers from version 5.6 to 5.7, and we noticed that the rotation slow query log files created after the initial file are empty. Is this something known in 5.7? How can ...
The Georgia's user avatar
0 votes
1 answer
373 views

Is it possible to log MySQL variable changes?

I'm using Percona MySQL server 5.7 and after a while my max_allowed_packet change to 1024 bytes and I don't know who or what application changes it. I've set it in config file and after restart it ...
digz6666's user avatar
  • 101
0 votes
1 answer
2k views

wsrep_sst_auth user permissions

In the my.cnf for our PXC cluster nodes, we have been using root user for wsrep_sst_auth with all the admin privileges that comes with the root account. We know using the root user:password inside the ...
The Georgia's user avatar
8 votes
2 answers
33k 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 ...
ODelibalta's user avatar
2 votes
1 answer
5k views

MySQL takes a long time to start

I'm trying to understand why mysql would take 20mn to start. I'm running 5.7.17-13-log, and I have a large ibdata1 file (20GB) even with file per table activated. Here is it's content: # innochecksum ...
Younes's user avatar
  • 171
6 votes
2 answers
6k views

MySQL stuck on "wsrep: initiating replication for write set (-1)"

I ran into a situation with MySQL recently which I hadn't seen before. We have a Percona cluster with 3 nodes. The master stopped processing queries and the PHP FPM web application we host became ...
Josh's user avatar
  • 538
0 votes
1 answer
440 views

Tokudb buggy and plugin gone missing causing mysql to stop starting?

I have actually installed percona mysql and trying to move from oracle mysql. I have been using innodb for quite some time. I heard and read a lot of about tokudb being able to support large db etc. ...
user8012596's user avatar