Percona : MySQL open source fork with performance improvements

learn more… | top users | synonyms

0
votes
1answer
13 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
21 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 ...
0
votes
0answers
11 views

percona cluster schema change with RSU issues?

I have a setup with three percona cluster servers. I am doing some tests with online schema changes using the manual RSU method [1]. I have a question regarding what happens when you drop a column on ...
0
votes
0answers
44 views

Installation for mysql_config with Percona already installed

I have a CentOS 6.6 installation with Percona XtraDB Cluster client installed on it. This version of Percona is a project requirement and can not be uninstalled. But I need the MySQLdb for Python ...
4
votes
2answers
149 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
32 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 ...
0
votes
0answers
45 views

Percona 5.6 UDF lost connection - Proper my.cnf

I am using the haversine query as a UDF and I'm testing the st_distance calculation to see which is faster and provides the results I'm looking for. The UDF query is throwing the "Error Code: 2013. ...
1
vote
0answers
222 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
127 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: ...
0
votes
0answers
58 views

Percona cluster signal 11

We have a percona cluster that is randomly getting signal 11's on different cluster nodes. I've exhausted everthing I know. Here's the .err file with the signal 11. We're running Server version: ...
0
votes
0answers
108 views

MySQL/Percona Server sudden CPU usage spikes

I've got some trouble with Percona Server 5.5: suddenly abnormous MySQL CPU usage caused the system to become unresponsive as it was eating up all CPU with a large number of threads. It's a 24 core ...
1
vote
1answer
142 views

Can't add Nodes to Percona XtraDB cluster

In my case, I have two nodes in cluster, but when I use $service mysql bootstrap-pxc to start XtraDB cluster, I found nodes were not added to cluster. I also check /var/log/mysql/error.log, but no ...
0
votes
0answers
91 views

Percona xtradb cluster MASTER MASTER asynchronously

I have setup a percona master-master cluster the same way as detailed here: http://www.percona.com/doc/percona-xtradb-cluster/5.5/features/multimaster-replication.html The document doesn't say but I ...
0
votes
1answer
117 views

InnoDB “Table xx Is Full” during database alterations

I am running Percona Mysql Server 5.6.14-56 on CentOS 6.3 64bit. Server has plenty ram (96gb) and storage free. File system type: ext4 dev/sda6 ext4 1093623528 56576512 981494148 6% ...
0
votes
1answer
46 views

Cacti - Interpreting values for Network statistics

I've downloaded and installed the Percona Linux template. I noticed the values for tx-drop had values of 'm' and 'u' and don't quite understand why I'm getting values of micro and milli. I was ...
0
votes
1answer
88 views

MySQL backups/Replication using xtrabackup and Native Mysql Replication

This aspect of using Percona Xtrabackup over Native Replication has been in my head for sometime now and I just cant seem to find an answer to this, I am posting this as a last resort seeking advice ...
0
votes
1answer
116 views

Percona Server & MySQL server on the same server on different ports

I have MySQL installed from ports, running and listening on port 3306. On the same server I have Percona Server compiled from sources, running and listening on port 3307. Here are the process list ...
1
vote
2answers
970 views

Automatic MySQL shutdown is RHEL7

When I execute systemctl start mysql it starts MySQL but I don't get command prompt back, it just stays like that. Database starts normally. After couple of minutes database automatically shutdowns ...
0
votes
0answers
53 views

Percona connectivity issue, user cannot connect?

I am trying to authenticate a user in percona but I am seeing the error message below each time I try... 2014-09-29 12:43:37 5028 [Warning] The plugin '0' used to authenticate user 'user@' is not ...
0
votes
0answers
52 views

Percona MySQL and my.cnf (Ubuntu 12.04)

So I am trying to move the database following the directions here: http://stackoverflow.com/questions/11069422/what-to-do-when-mysql-has-no-space-left/11070334#11070334 (option #3 in the long post ...
0
votes
1answer
123 views

New nagios/cacti monitoring setup, should I use a dedicated VM?

Currently we have 4 bare metal servers and one small VM server (all running centos6) and I'm looking at setting up monitoring for the Percona MySQL db server and replication slave (bare metal), as ...
0
votes
1answer
216 views

Percona slave crashes with “unexpected PLT reloc type”

I have 2 data centers each with a master/slave database running Percona server 5.5.23. For some reason, one of the slave databases crashed with this error: 03:00:40 UTC - mysqld got signal 11 ; ...
0
votes
0answers
100 views

WSREP galera cluster warning conflict state 7

I have started to use a pxc cluster, after a flow control deadlock I had to kill all but one instance. And now on this single instance I have the below warnings streaming in the log all the time: ...
0
votes
1answer
151 views

How many incremental backups to keep with Percona xtrabackup?

I'm looking to replace an aging and decidedly suboptimal mysqldump-based database backup strategy with Percona's Xtrabackup. This all looks pretty straightforward, except that I'm wondering: how many ...
0
votes
1answer
704 views

Percona startup fails: mysql can't access directory for file creation

I found a few questions and suggestions for similiar problem, unfortunately nothing seems to work for me, so please excuse me if this is double (and point to right source)... Server is Fedora Beefy ...
0
votes
0answers
77 views

Percona MySQL LDAP authentication fails through .NET MySQL connector

Basically, MySQL uses its native authentication, where usernames and passwords are stored in mysql.user table. MySQL authenticates user against the credentials stored in mysql.user table. Our ...
1
vote
1answer
1k views

Percona XtraBackup: Getting an error regarding “Too many open files”, how can I solve this issue?

I'm trying to backup using Percona XtraBackup and getting the following error: [root@ads-dev1 ~]# innobackupex /root/db InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and ...
0
votes
0answers
60 views

Mixing percona and mariadb in a galera cluster

Assuming both percona and mariadb runs the same engine (innoDB), can i use them interchangeably in a galera cluster? If it is possible, is there anything I should know before doing it?
2
votes
2answers
5k views

can't install mysql-devel on centos 6.5

I need mysql-devel package to be installed on my CentOS 6.5 running Percona 5.5 (already installed & running). When I try to install the devel package like this: yum --enablerepo=remi install ...
1
vote
0answers
115 views

PHP-FPM slowlog and Mysql lost connection

I was having an issue with PHP-FPM and mysql. When I needed to process an input file that would generate several selects/inserts/updates for each line, it would stop after approximately 60s with ...
0
votes
0answers
417 views

my.cnf doesn't work in my server

now i am using percona server 5.6 on CentOS 6.5. I wanna change query cache setting. I tried to change setting /etc/my.cnf. but it didn't applied. To investigate whether my.cnf is read correctly,all ...
0
votes
1answer
717 views

How can I resolve libmysql with Percona now that they've caused a yum conflict with their packages?

A script I wrote a few months ago has provisioned probably 100 or more virtual servers with a LAPP stack (Linux Apache Percona PHP). Recently, the following line is failing because yum has ...
1
vote
0answers
85 views

MySQL SSL Problems

I need to configure SSL for a MySQL server. I've read all of the directions for doing self-signed certs but it's preferred that I sign and use the certs from a different CA running AD Certificate ...
0
votes
1answer
115 views

Percona UDF - FUNCTION MURMUR_HASH does not exist

We have a 5.5.28-29.3-log mysql master that has the percona UDFs installed including murmur_hash. We installed mysql on new host but I can't seem to find where to get the UDFs from. This doc suggests ...
1
vote
0answers
81 views

Unexplained excessive database response times - very powerful hardware, tiny database

I've a strange problem that's repeatedly troubled me across 3 different servers now. The problem Please see the graph from NewRelic showing the huge amount of time spent in the database. The ...
1
vote
1answer
457 views

Duplicating data between two Percona Xtradb clusters using MySQL replication

We currently have a 3 node Percona Xtradb cluster running in a single data center. We want to add fault tolerance in case of disaster to prevent reliance on a single data center and synchronize our ...
2
votes
1answer
3k views

MySQL Socket configuration issue in my.cnf

I've got an issue that's causing very long "time in database" in my application. The DB is Percona MySQL 5.5.35. The application works perfectly, and can read/write from the database just fine. The ...
2
votes
1answer
1k views

Percona Xtrabackup incremental backup based on prepared full backup

I want to create an hourly backup of our MySQL database to a staging system using Percona XtraBackup. Is it possible to prepare the $BACKUPBASE and then use this prepared backupbase as base for the ...
0
votes
1answer
253 views

Cannot open './/ib_buffer_pool' for reading: No such file or directory

I've realised that my Percona DB which has several InnoDB tables doesn't actually have InnoDB buffer pool running as it wasn't specified in the my.cnf. I had a buffer pool size specified of 256MB, ...
0
votes
3answers
181 views

What could cause these (see graph) spikes in DB response times?

I've a LAMP stack running Percona MySQL. Via New Relic, I'm monitoring/tweaking/tuning my new server ready for it to be used live. Something that's irritating me though, is that I get periodic ...
0
votes
0answers
148 views

Force execution of a chef script before the first one finishes

Following is section of code that is creating the problem for me. Everything works fine but then in order to upgrade percona, I need to run the 'mysql_upgrade' step while the 'mysql_safe' step is ...
1
vote
4answers
1k views

Heavy production MySQL/Percona Database in openvz container

So I'm currently running a MySQL 5.1 database, with the following specs: Proc: Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz RAM: 64 Go disks: 2x 100 Go SSD (RaidSoft) I'm planning to migrate my ...
0
votes
1answer
265 views

Percona on EC2 ephemeral storage (part of XtraDB cluster)

We have a MySQL DB of roughly 100GB and want to move it into EC2. EBS volumes seem fairly slow for running MySQL databases (even with provisioned IOPS) and although we could use RAID10 to improve this ...
1
vote
0answers
85 views

mysql - measure amount of write

System : Centos 6.4, PerconaDb/MySQL 5.5.31 Im running relatively small mysql database with some 30 databases, total amount of 12Gb, but heavy on reads, updates and writes (texts, posts, user data ...
1
vote
1answer
1k views

installing XtraBackup with libmysqlclient.so.18

Current situation I'd like to install XtraBackup on my VPS (Centos 5) where my main database is running. During the rpm install it told me that it misses a dependency called perl(DBD::mysql). When I ...
0
votes
1answer
1k views

Can't connect to local MySQL server through socket '/opt/local/var/run/percona/mysqld.sock' [closed]

I have installed percona server using using macports on my mac machine however I am running into the socket error above as you can see below: Sauds-MacBook-Pro:percona jini$ sudo ...
0
votes
2answers
2k views

new Percona XtraDB nodes unable to join cluster

I have a four node Percona XtraDB cluster. Each night, one node shuts down for a backup and subsequently rejoins the cluster. This has run fine for quite some time now. Last night, the backup node ...
8
votes
2answers
7k views

Installing a third party application package on CentOS 6.4 fails due to missing dependencies libcrypto.so.10 and libssl.so.10

This is a Canonical Question about OpenSSL binary compatibility issues between Red Hat Enterprise Linux (and its derivatives) 6.4 and 6.5. This issue applies to a wide variety of third party ...
3
votes
1answer
803 views

MySQL memory usage - Periodically need to run FLUSH TABLES or memory usage keeps growing with large-pages turned on

After switching our rather memory + physical core rich database server to large-pages, we have noticed a small issue. The memory usage almost looks like there is some sort of memory leak. But ...
1
vote
2answers
346 views

Percona 5.6 not starting automatically after server reboot on Ubuntu with Virtualmin

I've got a new install of Ubuntu 12.04 + Virtualmin. I've upgraded from the default mysql 5.5 to Percona 5.6. Everything works except for one problem: when the server reboots, Percona is not ...