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]

Percona : MySQL open source fork with performance improvements

-1
votes
2answers
97 views

Increasing the number of connections MySQL 8 can handle (Debian 9 server) and auto restart event scheduler

I have a Debian 9 server (12 CPUs, 80GB of RAM), running Percona server for MySQL 8.0, about 1100 clients per second, the load is not very high around 0.3 to 2.30 Latested numbers from show engine ...
0
votes
0answers
21 views

File cannot be read - Configure MySQL Backups with Percona XtraBackup

I'm following this Digital Ocean guide on creating MySQL backups with Percona xtrabackup. My only difference in setup to the guide is that I'm using Ubuntu 18.04. I had incremental and full backups ...
0
votes
2answers
72 views

Enabling Encryption at Rest for MongoDB Generates Error

Running Percona Server for MongoDB server version: v3.6.8-2.0. I am attempting to enable encryption at rest using the procedure outlined in the following: https://www.percona.com/blog/2018/11/01/...
0
votes
2answers
507 views

Mysql backup of remote server in local machine using percona xtrabackup

I have percona xtrabackup installed in my ubuntu client machine. My local machine IP address is 192.168.0.100. The database that i need to backup is in 192.168.0.200. Is it possible to do the backup ...
0
votes
0answers
487 views

Entire proxmox Xen Node has grey question marks + database container gone

Firstly, i've recently taken on the management of a proxmox cluster which I have had no experience managing previously (i'm completely new to cluster management, but not too bad at linux). pve-...
0
votes
1answer
57 views

How to monitor mysql status variables and push to slack?

I've been trying to find a free way to monitor mysql status variables and push a slack notification when certain variables hit a threshold (ie: large number of connections). At the moment, all the ...
0
votes
2answers
224 views

Nginx: location with proxy_pass, including uri (Percona PMM)

I'm trying to setup a proxy with Nginx for Percona Monitoring and Management (PMM). I'm using their public demo site for a testing purpose. The goal is to expose PMM interface via URL like https://...
-2
votes
1answer
101 views

How to run pt-kill on CentOS Server [closed]

So, I have downloaded pt-kill file with: wget percona.com/get/pt-kill Now, I tried running it, but everything is not working? How do you run this file?
0
votes
2answers
102 views

Recover a failing node on Percona 5.5.41-37.0-55

I have a 3 node percona cluster of where 1 of the nodes has, because of a server crash, InnoDB log sequence problems. 180425 17:32:53 InnoDB: Error: page 151555 log sequence number 12431827692 ...
0
votes
0answers
65 views

Percona XtraDb cluster auto increment

Help me please clarify a very important question on which I can't find the answer. It only can be proven with tests. Let's say we have XtraDB Cluster (or Galera Cluster) with three nodes. We have ...
0
votes
0answers
145 views

How do I determine what is causing MySQL (Percona server) to crash on Linux

I am running the Percona version of MySQL Server v5.6 and every few days the MySQL seems to crash and then automatically restart itself. How can I work out what the reason is for the crash? I've seen ...
0
votes
0answers
146 views

Curruption error during percona Xtrabackup backup in ubuntu 14.04

I have Ubuntu 14 server having my software loaded. I had scheduled cron for taking percona backup of my server. But My Backup fails giving Corruption errors. I am posting my percona logs, Pls find ...
0
votes
0answers
211 views

Having trouble updgraring mysql (Obsoleted By: Percona … )

I'm trying to upgrage mysql 5.1 to 5.5. Following this link step by step : https://www.zerostopbits.com/how-to-upgrade-mysql-5-1-to-mysql-5-5-on-centos-6-7/ But yum -y update mysql* gives me errorrs....
0
votes
1answer
243 views

Connect MySQL using SSL only with the --ssl-ca option

I copied the ca.pem from server (Percona default 5.7 Ubuntu deb) able to make a secure connection with mysql --ssl-ca=/var/lib/mysql/ca.pem -u root I find that the options --ssl-cert and --ssl-key ...
0
votes
1answer
190 views

How to set config file to percona-mongodb

I have an percona/percona-server-mongodb image of mongo. I tried to mount my mongod.conf. How to set config and run mongo with config file? docker run --name mongo1 -v /opt/mongo/mongod3.conf:/etc/...
0
votes
2answers
164 views

mysql to percona replication

Recently my employer was acquired by a bigger company and the new CTO wants us to move to their software stack. We have MySQL as the DB server, and they have Percona. So... what are the option to do ...
0
votes
1answer
365 views

Initial Xtradb Cluster setup — each node comes up isolated

I'm setting up a percona-xtradb-cluster-57 (3 nodes) on Ubuntu 16.04. They are to communicate using a private network, 10.254.10.101 through 10.254.10.103. When I follow the instructions on Percona'...
3
votes
2answers
2k views

centos yum remove mysql will remove core components

Centos 7 x64, mysql-community 5.7 is installed from mysql57-community repo. I am in the process of switching from mysql to percona. However, the first step is scary when I try to uninstall mysql. ...
1
vote
1answer
734 views

mysql tries to connect to localhost at startup, [Note] Access denied for user 'root'@'localhost' (using password: NO)

When I start/restart the mysql service, I always see this row in the log: 2017-07-19T17:35:02.379166Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO) What is it trying to ...
0
votes
1answer
113 views

how to speedup SELECT BENCHMARK(1000000,ENCODE('hello',RAND()));

I would like some ideas for speeding up the the query below: SELECT BENCHMARK(1000000,ENCODE('hello',RAND())); Currently, I've been playing around with the my.cnf option and I can execute this in 9....
0
votes
0answers
804 views

MYSQL: Aborted connection to db: 'unconnected' user: debian-sys-maint' host: 'localhost' (Got timeout reading communication packets)

I recently migrated all my logs to a new service, where I could see a recurring bug in mysql. The message is the following: Aborted connection <NUM> to db: 'unconnected' user: debian-sys-maint'...
0
votes
2answers
751 views

Percona-Server-shared my.cnf file conflicts with file from package mysql-community-server-5.5

I'm trying to install Percona Toolkit on the server where there is already mysql-community-server5.5.52 is running. I require pt-table-checksum and pt-table-snc utility, so I ran: yum install ...
7
votes
1answer
7k views

mysqldump: The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled

When I try to run mysqldump on a Percona Server 5.7.17-12, I get this error: # mysqldump -u backups -pxxxx -h 127.0.0.1 --single-transaction --quick dbname mysqldump: [Warning] Using a password on ...
0
votes
1answer
46 views

Percona xtradb cluster 1 node consuming memory

I've installed percona xtradb cluster on 3 nodes and all is good until i noticed that 1 node is consuming memory much more the other nodes So i decided to stop all traffic going to this nodes and ...
1
vote
1answer
207 views

Is there a way to load large BLOBs without restarting MySQL?

I'm trying to move the last few databases off an older mysql server, but one in particular has me stumped: ERROR 1118 (42000) at line 595: The size of BLOB/TEXT data inserted in one transaction is ...
2
votes
1answer
296 views

mysqladmin not waiting for full shutdown (or debian init.d script broken?)

I'm running Percona MySQL server 5.6 (from packages) on debian wheezy (same behavior on jessie). Unfortunately I always get this: # service mysql stop [FAIL] Stopping MySQL (Percona Server): mysqld ...
0
votes
1answer
920 views

Will running mysqldump on one Percona XtraDB cluster node affect performance on the others?

I have a Percona XtraDB cluster with 3 nodes. Only one of these nodes is connected to by the application that uses the database. I would like to perform 'hot backups' simply using mysqldump on one of ...
0
votes
0answers
115 views

Cannot create InnoDB tables

I have a working Percona database server running multiple databases with mostly InnoDB tables (maybe a few hundred tables total). Any table that exists is working fine, yet I cannot convert any ...
3
votes
1answer
334 views

Is there a (mostly) safe way to backup live MySQL databases using zfs snapshots

Basically what I'm looking for is a way to tell mysql (percona-flavored) to take the following steps: Flush all committed transactions to the filesystem Start buffering all transactions (keep the ...
0
votes
1answer
201 views

Activating PAM configuration for Percona

I'm trying to configure Percona with LDAP support via PAM including group mappings and restriction. My Percona authentication setup is as follows: INSTALL PLUGIN pam SONAME 'auth_pam.so'; create ...
0
votes
0answers
57 views

pt-pmp fails to run on percona 5.5 ubuntu 12.04

Command: [mysql] root:/mnt# pt-pmp --pid 16898 Wed Dec 7 18:41:51 UTC 2016 warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7fffd4126000 18 libaio::??(libaio....
0
votes
1answer
87 views

Percona 5.7 restarting and drop my connection

i have fight with this bug a long time now, when i run scripts to MySQL (Percona) i disconnect me, and when i try to import a mysql dump from a live server its here disconnect me to. So what i'm ...
0
votes
0answers
571 views

MySQL Can't create a new thread (errno 11)

We recently upgraded to Percona MySQL Server 5.7 on Ubuntu 16.04 (from 5.6 on 12.04) and started getting the Can't create a new thread (errno 11); if you are not out of available memory, you can ...
0
votes
2answers
567 views

Percona mysql-server on ubuntu 16.04

Issue: Can't install Percona mysql server. Platform: Ubuntu 16.04 x64 Server is an Openvz container. Memory: 1.5GB installation method apt-get install percona-xtradb-cluster-server-5.6 Source: ...
0
votes
1answer
2k views

CentOS6 box: yum remove Percona-Server-shared-51 dependencies

I want to install Percona 5.7, but when I run the relevant yum command it tells me that 57 clashes with Percona-Server-shared-51. I don't really know why I even have that installed, since I also have ...
0
votes
1answer
60 views

PerconaDB cant run without innodb_recovery 4

My Percona 5.7.11-4 crashed without cause. Now I can run only with innodb force recovery = 4. Here is backtrace from log. Can you help? Thank you. > Thread pointer: 0x0 Attempting backtrace. You ...
1
vote
1answer
895 views

Percona XtraDB Cluster 5.6 does not start

All the good days. I want to run for test purposes Percona XtraDb Cluster on ubuntu 14.04. The basis here took these two articles https://habrahabr.ru/post/152969/ https://www.percona.com/doc/percona-...
2
votes
0answers
144 views

mysql Alter table to compress data fails with “Duplicate entry”

I was trying to compress few tables, but one of them caused this error alter table MY_table row_format=compressed, algorithm=INPLACE, LOCK=NONE; Query OK, 0 rows affected (0.00 sec) ERROR 1062 ...
0
votes
1answer
439 views

docker: Percona how to populate mysql server with initial data

I have created percona container in the following way: docker run --name=sql -v /path/to/dump:/tmp/dump:ro -d -e MYSQL_ALLOW_EMPTY_PASSWORD=True -e MYSQL_DATABASE=config percona:5.6 mysqld --...
0
votes
0answers
18 views

Home became 主页

After I ran software upgrade "apt-get upgrade" on DB server, chinese characters become weird Joomla 2.5.16 PHP 5.5.9-1ubuntu4.14 with fpm-fcgi/php5-fpm nginx 1.4.6 mysqld (Percona XtraDB Cluster) ...
0
votes
1answer
260 views

MySQL creates huge files every night, bringing down the server

I have an Ubuntu 12.04 LEMP server with shop app ontop, running MySQL 5.5 as DB (currently since this problem started I've already switched to Percona with no success). So, current facts: every night ...
0
votes
0answers
484 views

Error enabling TokuDB - Percona Server not running with jemalloc enabled

I have installed: Ubuntu 14.04.3 LTS (GNU/Linux 3.13.0-63-generic x86_64) Percona Server 5.6.26-74.0-1.trusty Percona Server TokuDB 5.6.26-74.0-1.trusty libjemalloc1 3.6.0-2.trusty In /etc/mysql/my....
1
vote
1answer
2k views

Percona DB not starting: initscript mysql, action “start” failed

After I installed Percona server I got this message: * Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit. * Run the following commands to create ...
-2
votes
1answer
1k views

How does one add commands to nrpe.cfg for Percona MySQL plugins on NRPE client? [closed]

How do you add commands to nrpe.cfg for Percona MySQL plugins on NRPE client? To configure percona-nrpe plugins for mysql you will have to do 3 things viz : 1. define commands in command.cfg 2. ...
0
votes
1answer
354 views

XtraBackup restore gives duplicates on slaving?

We've recently upgraded a MySQL 5.0 master-master setup to Percona 5.6. Slaving went b0rken due to some failures on our side, but we thought we could simply fix it by using xtrabackup to create a ...
0
votes
1answer
275 views

Percona: What are the implications of changing repl.commit_order?

I'm currently doing some trials of Galera Cluster with Percona 5.6. I've progressed to testing a 2 node cluster on baremetal. With repl.commit_order set to 0 (off) the TPS performance as measured with ...
4
votes
2answers
946 views

99% disk IO spikes with Percona

So we have a server that has seemingly random spikes in disk I/O, going up to 99.x% at random times and for no obvious reason, staying high for a while, and then going back down. This didn't use to be ...
2
votes
2answers
441 views

Can I run Percona xtrabackup on my desktop?

I have successfull running xtracbackup on the db server, but I really want to run the backup on the other machine (not the machine that have the MySQL running). I try to run the xtrabackup tool on my ...
1
vote
0answers
573 views

Installing php-mysql on centos 6.5 fails due to conflicts when percona client 5.5 also installed

Some background: I'm writing a Chef cookbook to set up a LNMP stack for local development. It requires the php-mysql library for PHP 5.4 (using the php package). We're using the yum-remi repository ...
0
votes
1answer
599 views

How do I install mysql2 gem with percona 5.6 on Ubuntu 14.04 Trusty?

I've setup percona-server-server and percona-server-client packages as per the instructions on the percona website, but when I try to install the mysql gem, I see the following message: Gem::...