Skip to main content

Questions tagged [percona-server]

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

29 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
tesla747's user avatar
  • 1,896
2 votes
1 answer
384 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
2 votes
1 answer
293 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
2 votes
1 answer
261 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 ...
phil-lavin's user avatar
1 vote
0 answers
34 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
429 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
177 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
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
1 vote
0 answers
38 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
1 vote
1 answer
252 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
0 answers
198 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
1k 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 ...
Altimit's user avatar
  • 11
1 vote
1 answer
65 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 ...
Narasimha T. Juvvigunta's user avatar
1 vote
1 answer
222 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 ...
che's user avatar
  • 119
0 votes
0 answers
24 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
35 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
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
0 votes
1 answer
183 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
0 answers
237 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
0 votes
0 answers
51 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
0 votes
0 answers
71 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
0 votes
1 answer
558 views

Unable to start mysql slave due to the error: Unknown table engine 'InnoDB'

I had to install my mysql slave server due to storage issue. I have synced my master disk to the slave disk. Now i'm not able to start my slave server (4GB RAM) due to the error: Unknown table engine ...
Omri's user avatar
  • 353
0 votes
1 answer
509 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....
tesla747's user avatar
  • 1,896
0 votes
1 answer
52 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 ...
tesla747's user avatar
  • 1,896
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 ...
tesla747's user avatar
  • 1,896
0 votes
1 answer
115 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 ...
user12920's user avatar
  • 101
0 votes
1 answer
46 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 > ...
Artem Yartsev's user avatar
-1 votes
1 answer
406 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