Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Percona is a company that features their compilation of MySQL with emphasis on performance. That MySQL software is best known as Percona Server. They have downloads for MySQL 5.5, 5.1, 5.0, and MariaDB.

162 questions
0
votes
1 answer

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 ; This could be because you hit a bug. It is also…
Beekums
  • 1
  • 1
0
votes
1 answer

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 incremental backups should I keep between full…
Nate
  • 229
  • 4
  • 9
0
votes
0 answers

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?
Jeffrey04
  • 145
  • 1
  • 8
0
votes
0 answers

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 my.cnf file was deleted and the reboot mysql. When…
user3636892
  • 1
  • 2
0
votes
1 answer

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 Percona-XtraDB-Cluster-devel marked as a conflict against…
DevOops
  • 315
  • 4
  • 13
0
votes
1 answer

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 that they should come build into mysql 5.5.8-20.0…
user44384
  • 129
  • 7
0
votes
3 answers

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 (usually after periods of inactivity) where the DB…
i-CONICA
  • 648
  • 1
  • 9
  • 22
0
votes
1 answer

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

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 /opt/local/lib/percona/bin/mysql_secure_installation NOTE:…
kratos
  • 131
  • 1
  • 8
0
votes
2 answers

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 refused to rejoin the cluster. The other three nodes…
ceejayoz
  • 32,910
  • 7
  • 82
  • 106
0
votes
1 answer

Dev mysql node with Percona

I have been tasked with creating a Development mysql instance, We currently have a 7 node Xtradb cluster, is there any way to have this node a few hours behind, or not allow replication back to the rest of the cluster? I would love for it to update…
user1265191
  • 1
0
votes
1 answer

mysqld: unrecognized service after installing Percona mySQL

Fresh cloud server running Centos6. Trying to install latest Percona $ sudo rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm $ sudo yum install Percona-Server-server-56 $ sudo yum install…
Dan J
  • 135
  • 2
  • 6
0
votes
1 answer

PHP fails to load MySQL modules - "libmysqlclient.so.18" error

I'm installing a new CentOS 6.4 box, to move my websites over from my current 5.9 box. I've ended up with Apache 2.2.4, PHP 5.4.16 (via "powerstack" repo), and Percona 5.6.13 (via percona's own repo). I was briefly on PHP 5.3.3 via the standard…
Codemonkey
  • 1,086
  • 4
  • 19
  • 41
0
votes
1 answer

MySQL high memory consumption with poor performance for queries, which settings to tweak?

I have a scenario with a rather large database. It is about 3GB and I'm hitting some walls with system resources. For example, here is an example of htop output: You can observe that there are a lot of unutilized threads here, however I am seeing…
ylluminate
  • 1,155
  • 2
  • 17
  • 35
0
votes
1 answer

MySQL to Percona page load time increase?

Page Time: 0.0915s Memory: 5.0191 MB (Peak: 5.4852 MB) Queries (10, time: 0.0037s, 4.1%) After doing a change from MySQL to Percona my Page Time actually increased. Is that just because it lessens somewhere and tightens elsewhere? I don't mind,…
Lucas Gomez
  • 25
  • 1
  • 7
0
votes
1 answer

Percona server won't restar after datadir change

I installed percona from percona repository on a ubuntu 12.04 server which has a solid state drive. I thought i would rather put the datadir on the Solid state drive and put partition on normal sata drive. below are my settings essentially a copy of…
black sensei
  • 609
  • 3
  • 10
  • 25
1 2 3
…
10 11