Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [percona-server]

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

1
vote
0answers
15 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 ...
0
votes
1answer
25 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
0answers
31 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 ...
0
votes
0answers
10 views

Stand by Percona 5.7 RAM utilization reach 95%

I'm new to MySQL and Linux OS. I'm more an MS SQL Server Developer, not even a DBA, but I've been assigned this role os MySQL DBA. We have an instance of Percona 5.7 in a virtual node with 12Gb of ...
0
votes
0answers
22 views

pt-table-checksum infinte loop

pt-table-checksum 3.0.12 mysqld Ver 5.6.41-84.1 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release 84.1, Revision b308619) Command to run: pt-table-checksum --no-check-binlog-format --...
0
votes
0answers
53 views

XtraDB Cluster 5.7 - IST failes

Long story short: IST of a 5.7 node works against 5.6, but not against another 5.7 node. Since several days, I try to upgrade our three node Percona 5.6 cluster by adding two 5.7 nodes and then ...
0
votes
0answers
28 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
vote
1answer
50 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 ...
3
votes
1answer
156 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 ...
0
votes
1answer
52 views

Percona-server-5.6.41 and sql_mode

When setting sql_mode="" in /etc/mysql/my.cnf server leaves this variable in it default value: mysql> show variables like 'sql_mode'; +-------------------+--------------------------------------...
0
votes
0answers
13 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
0answers
282 views

percona slave ERROR 1872 (HY000)

I have setup PXC on CentOS 7.5 and replication between PXC nodes is working just fine. However, when I try to set up a slave on one of the PXC nodes, I get this error when I run "START SLAVE". root@...
1
vote
0answers
13 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 ...
0
votes
1answer
56 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 ...
1
vote
1answer
54 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 ...
0
votes
1answer
327 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 (...
1
vote
0answers
126 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
156 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 ...
0
votes
1answer
57 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 ...
0
votes
1answer
894 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 ...
4
votes
3answers
4k 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 ...
1
vote
1answer
2k 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 ...
5
votes
2answers
1k 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 ...
0
votes
1answer
320 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. ...
1
vote
0answers
260 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 ...
3
votes
3answers
194 views

MySQL can take more than an hour to start

I have a mysql (Percona) 5.7 instance with over 1Million tables. When I start the database, it can take more than an hour to start. Errorlog doesn't show anything, but when I trace mysqld_safe, I ...
0
votes
1answer
248 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
235 views

Can I seed Percona XtraDB cluster from the existing backup?

I have a running setup of Percona MySQL 5.7. I would like to try out Percona XtraDB cluster. The current data size is ~500GB. From what I've observed (seen in a couple of YouTube videos: https://www....
0
votes
1answer
65 views

MySQL tuning query - 5.6

I'm using Percona Server 5.6.31 on RHEL 6. 64G RAM/16vCPU - VMware. It's Completely InnoDB and the database size is 300G. I have set Innodb_buffer_pool to 52G, innodb_buffer_pool_instances to default ...
0
votes
1answer
47 views

One MySQL table for all data vs Several Different Engines MySQL Tables

I did quite good research and went through some information on this regard. But I am not satisfied yet, so preferred to ask directly about it. I'm designing the schema of an application database, ...
0
votes
1answer
435 views

Database Growth in a table - MySQL

I would like to store the database size for a particular database on daily basis on to a table which would help in understand the growth of the database over a period of time. SELECT table_schema AS "...
1
vote
1answer
35 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 ...
0
votes
1answer
1k views

IO thread error : 1595 (Relay log write failure: could not queue event from master)

Slave status : Last_IO_Errno: 1595 Last_IO_Error: Relay log write failure: could not queue event from master Last_SQL_Errno: 0 from error log : [ERROR] Slave ...
2
votes
2answers
2k 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 ...
1
vote
0answers
18 views

Innodb file format - Percona Server [duplicate]

I had my innodb file format changed from antelope to barracuda recently. Is it safe to have both antelope and barracuda at the same time? I have my setup running properly now. What issues I would ...
0
votes
1answer
78 views

MySQL Monitoring Tools

I want to deploy tools to monitor my Production Percona servers (5.6 on Linux). I never used Nagios or any tool before. I did go through this great link but I wanted to clarify few things before ...
3
votes
0answers
134 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 ...
0
votes
2answers
301 views

Mysqldump failing while restoring database - MySQL 5.6

I have dumped one of my databases of size 5-6GB. I'm trying to restore to another instance but the same is getting failed after sometime with the following error: ERROR 2013 (HY000) at line 12006: ...
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 ...
0
votes
1answer
63 views

MySQL - Upgrading from 5.5 to 5.6

I have MySQL community version 5.5.50 running in linux having 4-5 databases on it. Requirement is to upgrade to Percona Server 5.6.31-77.0. What are the pre-requisites that I need to check before ...
0
votes
1answer
326 views

Doubts on Setting up Master-Master replication (Percona)

I have two 5.6 Percona servers in which I'm planning to setup Active master- Passive master replication. Secondary master will be in read-only mode. Caveat is that the servers in which i'm going to ...
0
votes
1answer
40 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 ...
2
votes
1answer
2k views

MySQL - Persistent values in my.cnf

I have a small doubt regarding making variables persistent in Percona Server 5.6 in Linux. I need to make log-bin-trust-function-creators persistent so that I need not make it to true everytime on ...
1
vote
4answers
943 views

20 mysqld processes using only 1 port?

These are from Aliyun Cloud DB Servers,20 mysqld processes using one 3306 port Has anyone seen this before ? Can anybody explain how to do that ? Are there any advantages to this ?
4
votes
1answer
1k views

How to clear gcache pages in Percona PXC

I have a 4 node cluster(percona PXC) and one of the nodes have more than 150 gcache disk files each of size ~128 MB. I would like to purge or flush them so that the server user fresh gcache disk file. ...
2
votes
1answer
190 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
188 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 ...
1
vote
1answer
1k views

How can I disable xb_doublewrite?

Getting error while service restart. [ERROR] InnoDB: A parallel doublewrite file /test/mysql/xb_doublewrite found on startup.
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 ...
2
votes
2answers
1k views

Percona 5.7 tokudb poor query performance - wrong (non-clustered) index chosen

I have a table with about 8.5m rows in it. The table is tokudb and it has the indexes described below. I'm experiencing dismal performance when trying to run update statements like the following: ...