Questions tagged [percona-server]
Percona Server is a fork of MySQL Community Edition, focusing on performance improvements.
27
questions with no upvoted or accepted answers
3
votes
0
answers
156
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,836
2
votes
1
answer
273
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 ...
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 ...
- 141
1
vote
0
answers
24
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 ...
- 111
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 ...
1
vote
1
answer
133
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 ...
- 113
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 ...
- 23
1
vote
1
answer
910
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 ...
- 111
1
vote
0
answers
33
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 ...
- 333
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 ...
- 11
1
vote
0
answers
184
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.
...
- 11
1
vote
1
answer
966
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 ...
- 11
1
vote
1
answer
56
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
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 ...
- 119
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
2
answers
668
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.
...
- 13
0
votes
1
answer
124
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 ...
- 321
0
votes
1
answer
237
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 (...
- 21
0
votes
0
answers
166
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
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
0
votes
0
answers
43
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 ...
- 333
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....
- 1,836
0
votes
1
answer
49
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 ...
- 1,836
0
votes
0
answers
56
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 ...
- 1,836
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 ...
- 101
0
votes
1
answer
42
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 > ...
-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....
- 1