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
2
votes
1 answer

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 errors were found. The followings are the…
technoob
  • 142
  • 1
  • 14
2
votes
2 answers

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 and systemctl reports failure. I have also tried…
Jai
  • 141
  • 1
  • 3
  • 14
2
votes
3 answers

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 mysql-devel I get the following error: Error: Package:…
Latheesan
  • 357
  • 2
  • 6
  • 19
2
votes
0 answers

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 message Lost connection to the server or Mysql server…
Daniel Costa
  • 327
  • 1
  • 4
  • 12
2
votes
0 answers

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 and user actions are being CRUD evenly during the…
Radek
  • 153
  • 2
  • 7
2
votes
0 answers

How to compile MySQL (Percona) with jemalloc installed under custom prefix?

My jemalloc is installed under /opt/jemalloc, how to compile MySQL/Percona with the support of jemalloc? The standard option is cmake . -DCMAKE_EXE_LINKER_FLAGS='-ljemalloc' -DWITH_SAFEMALLOC=OFF But how about my case since they are in custom…
Ryan
  • 5,831
  • 24
  • 72
  • 91
2
votes
0 answers

Recurring locks and slowdowns on a Percona XtraDB Cluster

I have 5 dedicated servers (identical machines: 32 cores, 96GB of RAM, SSD drives in RAID and gigabit ethernet link) configured with Percona XtraDB Cluster. There's a recurring problem causing a severe slowdown of the cluster for usually about 30 to…
Axel DominatoR
  • 21
  • 1
2
votes
1 answer

Percona and MySQL audit

I am trying to audit MySQL commands for users on Percona. Current version of Percona is 55-5.5.22-rel25.2.237.rhel5. The following URL gives guidance, however I do not know how to get it…
Diden
  • 129
  • 3
  • 12
2
votes
3 answers

Find which mysql is running

I have installed mysql 5.5 and percona 5.5 in the same machine. I am not able to identify wheather the running db is mysql or percona. IS there is any way to identify the difference.
Bathakarai
  • 121
  • 3
2
votes
0 answers

Percona backup to different database name

Possible Duplicate: MySQL: How to backup and restore using different schema name using xtrabackup I'm using percona backup tool Xtrabackup for backing up different MySQL server, right now I would like to setup another instance of database I have,…
wlk
  • 1,713
  • 3
  • 14
  • 19
2
votes
1 answer

How to install Percona XtraDB Cluster on x86 server?

I'm going to migrate from MySQL replication to Percona XtraDB Cluster. The problem I'm facing is one node is running on x86, and I cannot install Percona-XtraDB-Cluster-server from the Percona repo due to the depsolving problems: ... --> Finished…
quanta
  • 51,413
  • 19
  • 159
  • 217
2
votes
3 answers

Percona XtraDB Cluster node recovery

I have been reviewing XtraDB clustering and produced a P.o.C. environment on Openstack using 4 instances, which has fallen over during my resilience testing. Per the pxc documentation:…
Oneiroi
  • 2,063
  • 1
  • 15
  • 28
2
votes
2 answers

Percona XtraDB Cluster with GlusterFS

We are deploying a GlusterFS cluster with 4 nodes, and we want to deploy the Percona XtraDB Cluster on top of it with 4 nodes, each node will have a mounted folder from the GlusterFS, each mount will be a separate one, not a shared one. The total…
ElMangau
  • 31
  • 2
2
votes
1 answer

Error updating Percona Server

I'm getting errors doing a regular aptitude safe-upgrade of percona-server-server-5.5, I'm already running a version of percona server 5.5 Setting up libmysqlclient18 (5.5.20-rel24.1-217.squeeze) ... Setting up percona-server-common-5.5…
Poe
  • 321
  • 1
  • 5
  • 18
2
votes
3 answers

MySQL failed to start due to many InnoDB tables?

I have around 6000 InnoDB tables across 15 databases, and using the innodb_file_per_table, I found out when everytime I reboot the Ubuntu server, the MySQL failed to start, with error.. Version: '5.1.56-rel12.7-log' socket:…
Howard
  • 2,135
  • 13
  • 48
  • 72
1 2
3
…
10 11