Questions tagged [percona-server]
Percona Server is a fork of MySQL Community Edition, focusing on performance improvements.
122
questions
0
votes
1
answer
355
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....
- 86
0
votes
1
answer
110
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 ...
- 1,836
0
votes
1
answer
54
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, ...
- 103
0
votes
1
answer
1k
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,836
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 ...
0
votes
1
answer
3k
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 ...
- 141
3
votes
2
answers
5k
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 ...
- 131
1
vote
0
answers
31
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 ...
- 1,836
0
votes
1
answer
107
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 ...
- 1,836
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
1
vote
2
answers
3k
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,836
0
votes
1
answer
130
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 ...
- 1,836
0
votes
1
answer
387
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 ...
- 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
3
votes
1
answer
8k
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,836
1
vote
4
answers
3k
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 ?
- 321
4
votes
1
answer
3k
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.
...
- 794
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
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
1
answer
3k
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.
- 11
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
2
votes
2
answers
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:
...
- 251
1
vote
1
answer
970
views
InnoDB AUTO_INCREMENT resetting itself without MySQL restart [duplicate]
We've recently noticed the following scenario happening in many of our databases:
A record is inserted, and receives an AUTO_INCREMENT primary key.
The record is deleted.
Another record is inserted, ...
- 11
0
votes
2
answers
529
views
Tokudb HotBackup
I was trying to evaluate the latest tokudb Hotbackup for percona's tokudb engine.
This install is under debian (Ubuntu 14)
I was able to get all the packages installed with out error and get all the ...
- 5,203
6
votes
4
answers
2k
views
Mysql (percona-server 5.5) completely stalls during import (myloader)
While configuring our new servers (IBM X3650M4, 2x Intel Xeon E5-2620, 64G RAM, RAID 10 (4x 240G SSD)) we bumped into a strange problem. We're trying to import dumps (mydumper) from our (old) ...
- 193
0
votes
1
answer
646
views
MySQL percona 5.6 to MySQL 5.5 replication
Scenario 1 I am having a MySQL DB on 5.5 which is compliance, So need to upgrade it to MySQL 5.6. while doing this we see that 5.6 is running slow, were as it runs perfectly on 5.5 backup.
Scenario ...
- 149
7
votes
1
answer
8k
views
Percona mysqld got signal 11
I've googled and searched stackexchange, but can't find anything relevant to this particular issue (there are other error 11 issues, just not for this as far as I can tell).
We have a server that is ...
- 123
2
votes
2
answers
4k
views
Percona xtradb cluster node2 won't start
I have configured Percona Xtradb cluster 5.6. The first node starts fine when bootstrapped, but the second node seems to have an issue with this variable setting:
wsrep_provider=/usr/lib/...
- 333
0
votes
2
answers
3k
views
troubleshoot high value for mysql innodb pages written per second
Our database is writting about 600 pages a second to its innodb buffer pools.
Usually this value is about 10 pages/sec, so the server is experiencing a very high IO utilization, around 50%.
Is there ...
- 99
1
vote
1
answer
815
views
Percona and MariaDB-10.0 ignoring not null on table fields
On the percona-5.6 and MariaDB-10.0 servers, the NOT NULL declared on table field are being ignored. I am able to leave fields declared as NOT NULL empty when inserting data and the servers are not ...
- 333
1
vote
1
answer
846
views
MySQL/Percona Server is taking long and I'd prefer to skip all this waiting even if it means data loss
Originally posted to https://www.facebook.com/groups/GNUAndLinux/permalink/10155020539805019/ but no replies received.
I run Percona Server 5.6.21-70.0-688 x64 on Ubuntu Server 12.04 LTS x64, 64GB ...
- 125
2
votes
1
answer
1k
views
What is the Best way to set Disaster recovery setup for percona Xtra DB Cluster?
We do have a Percona XtraDB Cluster(Master-Master-Master) setup in one country. Now we want to setup a disaster recovery setup in some other country. Please provide us the best possible ways to do ...
1
vote
3
answers
951
views
Integrity constraint violation in Percona XtraDB Cluster
We have a PHP application that uses AWS Load Balancer that connects to 3 Percona Servers.
Before we used a single standard Percona Server and that never happened.
The cluster starts throwing Primary ...
- 368
3
votes
1
answer
114
views
Super slow (day long) count(*) after upgrade to 5.6
After upgrading to Percona 5.6.20 from 5.5.34 I noticed counts on larger tables take a massively long time to execute.
The table is about 27G and 300M rows. It is not compressed and was innodb ...
- 5,203
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
4
votes
2
answers
7k
views
Identifying cause of high I/O
I'm trying to diagnose the bottleneck for high-write I/O activity on a percona master (with replication to a slave). The pattern of behaviour is roughly cyclic and regular: 60 mins of 75-90% write-...
- 61
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 > ...
4
votes
1
answer
4k
views
Is it mandatory to enable --log_slave_updates with MySQL Replication using GTID? [duplicate]
I'm setting up 5.6 Percona Mysql, in order to enable GTID should I have to enable log_slave_update on both Master and Slave ?
If I should enable log_slave_update, then I'm counting this to CONS for ...
- 1,511
0
votes
2
answers
526
views
MySQL excessive tmp disk tables after Upgrade to 5.6
After upgrading two MySQL-Servers which run Master-Slave replication from Percona MySQL 5.5 to Percona MySQL 5.6 an excessive amount of temporary Tables gets created on the slave.
The Master seems to ...
- 101
4
votes
1
answer
7k
views
Error 1236 From Master After Restored Replication
I've been trying to restore a broken replication caused by power interruption. upon checking the slaveDB, it was already broken so I setup a new replication. And upon supposedly completing the ...
- 45
2
votes
2
answers
2k
views
Is it necessary to run apply-log immediately after innobackupexec has run?
i have been trying to read other questions, but i did not find a answer to suit me. So excuse me if i ask something that has been already asked.
I'm trying to organize my self and backup all my mysql ...
- 121
2
votes
1
answer
3k
views
slow writes on percona / mariadb server only when replication is running
Hi I am trying to migrate to percona server from mysql 5.6 on windows.
In my development machine for percona is running of centos 6.5 which is installed on vmware 5.5 sphere.
Our business ...
- 21
0
votes
1
answer
356
views
Seg faults in Percona Server 5.6.19
Trying to figure out what went wrong here. Any advice would be appreciated. This server is running a new installation of Percona Server 5.6.19 on CentOS 6.5
16:05:46 UTC - mysqld got signal 11 ;
This ...
- 53
2
votes
1
answer
1k
views
Optimize Percona MySQL InnoDB 3.2TB database
(Before you will call me an idiot or start laughing, please remember it's a real deal on my side and I cannot cancel this assignment as it is a part of a bigger project)
I have a database server that ...
- 23
1
vote
1
answer
2k
views
Cannot execute statement: impossible to write to binary log?
When I try to create a user story/issue in my my percona xtradb cluster I am getting below error. How to fix it?
Error creating issue:
Could not create workflow instance: root cause: while inserting:...
- 11
1
vote
2
answers
2k
views
Baffled with MySQL LEFT JOIN query that I have to speed it up
I am kind of a puzzled with this query trying to optimize it but no way I am able to (due to my limited knowledge as a DBA). So, I asked the experts.
In my setup I have three (primary) tables. ...
- 205
4
votes
1
answer
963
views
Is the innodb_lazy_drop_table problem solved?
I'm researching database configuration for MySQL/MariaDB. I've been reading the configuration chapter in "High Performance MySQL". In there, it suggests that innodb_lazy_drop_table can be used to ...
- 143
5
votes
1
answer
1k
views
Online Schema migration in MySQL : When to start?
I'm the tech lead of a Social Media SAAS, where we're currently experiencing a big increase in data amount we're storing in our mySQL-database.
We're having a single MySQL db, and besides many ...
- 153
0
votes
1
answer
681
views
Trouble installing percona 5.6 on Google compute engine debian
I've been trying to install percona server on a fresh Google compute engine instance.
I haven't installed mysql server previously.
I followed the instructions from here.
I get this when I use:
apt-...
- 103
3
votes
1
answer
3k
views
MySQL: mysqld_safe options
Is there a way to specify these options in configuration file?
I've tried to add them into [mysqld_safe] section but it doesn't work:
[mysqld_safe]
numa-interleave = 1
flush-caches = 1
-
# ps -ww -...
- 459