Questions tagged [percona-server]
Percona Server is a fork of MySQL Community Edition, focusing on performance improvements.
121
questions
1
vote
1
answer
285
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 ...
CommunityBot
- 1
1
vote
1
answer
961
views
IMPORT TABLESPACE is hanging in the 'System lock' state
We have a development database server with Percona-server 5.7.15-9 on it. It replicates two schemas from two different production servers using multi-source GTID replication. Lets call these schemas ...
CommunityBot
- 1
0
votes
1
answer
233
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 (...
CommunityBot
- 1
1
vote
1
answer
64
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 ...
- 486
0
votes
1
answer
473
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....
CommunityBot
- 1
1
vote
1
answer
221
views
TokuDB table stats row count decreases to 1
I have a few Percona 5.6.30 servers with a TokuDB table that has ~120 million rows. On some of these servers, row count in SHOW TABLE STATUS mysteriously decreases until is hits 1. This is accompanied ...
CommunityBot
- 1
2
votes
1
answer
249
views
Replicating into a Percona XtraDB Cluster
We have a 2 node (plus an arbiter) Percona XtraDB cluster. It is used for data indexing/archiving. It has it's own database called archive but it is also the replication slave for a database called ...
CommunityBot
- 1
1
vote
1
answer
40
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 ...
- 21
1
vote
1
answer
908
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 ...
CommunityBot
- 1
0
votes
2
answers
658
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.
...
CommunityBot
- 1
0
votes
1
answer
123
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 ...
2
votes
1
answer
272
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 ...
CommunityBot
- 1
1
vote
1
answer
199
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 ...
CommunityBot
- 1
0
votes
1
answer
49
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
...
1
vote
1
answer
497
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 (...
CommunityBot
- 1
0
votes
0
answers
19
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<&...
0
votes
1
answer
108
views
Moved database (percona mysql) to larger disk, now everything is missing (though the files exist)
I dont know anything about databases or MySQL beyond the absolute basics so lets start with that. I moved the /var/lib/mysql from the / to a mounted volume which I remounted as /var/lib/mysql after ...
CommunityBot
- 1
11
votes
1
answer
10k
views
Capabilities of InnoDB INSERT Performance
Hi I am running the most recent version of Percona Server.
Server version: 5.5.24-55 Percona Server (GPL), Release 26.0
I have a 10 cpu box of these characteristics.
processor : 0
vendor_id ...
- 103
1
vote
1
answer
236
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 ...
- 6,161
27
votes
3
answers
61k
views
Should a MySQL replication slave be set to read only?
I've got replication running on Percona Server 5.5 by following this guide and wondered if I should add read-only=1 to my slave's my.cnf to make it read only?
The guide sets up replication for the ...
- 179k
0
votes
1
answer
1k
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 ...
- 18.9k
1
vote
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 ...
1
vote
1
answer
131
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 ...
- 6,161
0
votes
1
answer
179
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
...
- 1,313
2
votes
1
answer
3k
views
Queries getting stuck on very simple COUNT queries
process list:
| 16004 | metrics | xxx:64616 | metrics | Query | 29064 | Sending data | SELECT COUNT(*) FROM Plugin where LastUpdated >= '1356856200' | ...
- 179k
2
votes
1
answer
728
views
How often should MySQL (stock, Percona, etc.) be upgraded?
My organization runs several data-driven web applications backed by various flavors of MySQL on RHEL (i.e. we're just like everyone else!) Some of our web apps use the standard build of MySQL, and we ...
- 179k
3
votes
1
answer
9k
views
Very poor insert performance MySQL / Percona Server
I'm running a Percona-Server instance off an Ubuntu server install. I'm using an application that needs to access this database, and its having VERY poor performance. Once the database has been ...
CommunityBot
- 1
0
votes
2
answers
16
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 ...
-1
votes
1
answer
241
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....
8
votes
1
answer
11k
views
Do you still use MyISAM or prefer Aria storage engine?
If Aria storage engine (previously called Maria) is the "new" MyISAM, which supports transaction and automatic crash recovery:
Why still use MyISAM ?
Should changing storage engine from MyISAM to ...
- 179k
0
votes
1
answer
122
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 ...
- 74.8k
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 ...
- 163
0
votes
1
answer
64
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 ...
- 258
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 ...
CommunityBot
- 1
1
vote
0
answers
198
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 ...
- 7,843
2
votes
2
answers
151
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 ...
- 692
0
votes
0
answers
160
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'...
- 23
0
votes
1
answer
391
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';
+-------------------+--------------------------------------...
CommunityBot
- 1
1
vote
1
answer
359
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 ...
- 131
0
votes
1
answer
118
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 ...
CommunityBot
- 1
1
vote
1
answer
855
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-...
- 179k
0
votes
2
answers
80
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 ...
- 816
0
votes
1
answer
133
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 ...
- 74.8k
1
vote
1
answer
94
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.
...
CommunityBot
- 1
0
votes
2
answers
265
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
0
answers
45
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 ...
- 1
6
votes
2
answers
5k
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 ...
- 201
3
votes
2
answers
5k
views
What are the causes of InnoDB Index Corruption?
I'm running into issues where many of my database servers are experiencing repeat index corruption. The index corruption across several physical hosts, and many different tables. Whenever I restore a ...
CommunityBot
- 1
1
vote
1
answer
181
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
...
- 16.6k
3
votes
1
answer
1k
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 ...
- 14.5k