The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [percona-server]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
9 views

Is it possible to replicate a cluster (not just a node)?

Making a master-master cluster is easy, as is replicating one of the master nodes to a read only slave. As is replicating that RO slave to other slaves. But, of course if the master node which ...
1
vote
1answer
24 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. ...
1
vote
2answers
105 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 ...
0
votes
0answers
40 views

How do I use the .ibd/.frm files to recover an InnoDB table that went missing when MySQL crashed during OPTIMIZE TABLE?

I have seen How to Recover an InnoDB table whose files were moved around but I am not sure if it's relevant, since MySQL renamed the files and there was no tablename.frm afterwards. I ran OPTIMIZE ...
1
vote
1answer
53 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
2answers
50 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
1answer
134 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
16 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
24 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
29 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
72 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
310 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
69 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
18 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 ...
1
vote
0answers
17 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
63 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
66 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
354 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
133 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
179 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
66 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
1k 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
5k 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
2k 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
335 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
1answer
288 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
205 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
278 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
250 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
75 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
561 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
37 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
20 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
80 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
137 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
415 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
67 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
331 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
41 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
3k 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
1k 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
193 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
196 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
2k 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.