Questions tagged [percona-server]
Percona Server is a fork of MySQL Community Edition, focusing on performance improvements.
28
questions with no upvoted or accepted answers
3
votes
0answers
143 views
SSL for security - Percona MySQL
I have been told to implement SSL in my Master-Master MySQL instances by my security team to have secure traffic only to be received at the database end. I have never implemented SSL in a database ...
1
vote
0answers
55 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 ...
1
vote
1answer
163 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 ...
1
vote
1answer
411 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 ...
1
vote
0answers
27 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 ...
1
vote
1answer
113 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 ...
1
vote
0answers
164 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
380 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 ...
1
vote
1answer
41 views
Will alone bin log ignore DB mysql helps in slave read only mode
Please correct me if I'm wrong .
In Master - Slave setup:
Case 1:
If I didn't enable Binlog ignore DB mysql: In future ill lose all
users created in master node incase of master crash or slave ...
1
vote
0answers
1k views
MYSQL Extremely slow - Heavy CPU Load
I am having an issue with my Percona MySQL 5.7 node. Since past 3 days, MySQL is processing queries very slowly. When I run top, the % CPU usage of MySQL is always 600.
# top | grep mysqld
8409 ...
1
vote
1answer
209 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 ...
1
vote
1answer
209 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 ...
0
votes
1answer
21 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 ...
0
votes
0answers
27 views
MYSQL optimization for Magento 2
Im running my magento 2 project on 3 core 8gb 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....
0
votes
1answer
55 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
0answers
37 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
13 views
How to install Percona Server 8.0 at Ubuntu 19.04 / 19.10?
I have 2 Ubuntu servers with OS versions 19.04 (disco) and 19.10 (eoan). Running latest MySQL 8.0 on both servers.
I would like to try out Percona Server to see if it gives any speed boost as it ...
0
votes
0answers
30 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 ...
0
votes
0answers
29 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 ...
0
votes
1answer
399 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
339 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
1answer
46 views
Percona server Master-Slave version query
I have a master with percona server (5.6.25) running in RHEL host and a slave of the same version. I'm facing some corruption issues in replication slave and I'm thinking of rebuilding the slave from ...
0
votes
0answers
50 views
MySQL Upgrade query
I have 5.5.44-log MySQL Community Server (GPL) running in one of my RHEL 6.4 server. I need to upgrade the server to Percona Server-5.6.29-76.2. How to go about the upgrade? Should I completely remove ...
0
votes
0answers
788 views
How to troubleshoot, find and fix query Percona 5.6 with error “SQLSTATE[HY000]: General error: 1785 When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1”
i'm running Magento CMS, and underneath there are 2 physical servers both with Percona
Server version: 5.6.23-72.1-log Percona Server (GPL), Release 72.1,
Revision 0503478
in Master/Slave with ...
0
votes
0answers
196 views
Temporary tables and Fetch times
We've noticed something curious in our office which no one seems to know the answer to. I'll explain:
We have some mildly complex queries, one of which executes in under 3 seconds and then has a ...
0
votes
0answers
315 views
Very slow IO on mysql percona server
Our site goes down because the IO on our database servers is too slow.
Troubleshooting this we found that mysql is really really slow. It's constantly reading from disk and I think not using enough ...
0
votes
1answer
97 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 ...
0
votes
1answer
39 views
Automatic slave reconfiguration after updating master
I have development mysql master and slave servers and a prod server. I need to set up regular (once a week) syncronization of dev and prod databases. It would be easy for me to use prod# mysqldump > ...
