Percona : MySQL open source fork with performance improvements

learn more… | top users | synonyms

3
votes
2answers
119 views

Percona Toolkit Installation Error

[root@localhost ~]# rpm -ivh percona-toolkit-2.2.7-1.noarch.rpm error: Failed dependencies: perl(DBD::mysql) >= 1.0 is needed by percona-toolkit-2.2.7-1.noarch perl(Time::HiRes) is needed ...
1
vote
2answers
211 views

Upgrading to MySQL 5.6, benefits to switching to GTID replication?

We have the most basic of MySQL replication setups, a single Master doing statement-based replication to a single Slave, a 90/10 mix of innodb/myisam tables. Both run Percona MySQL 5.5 at the moment ...
2
votes
1answer
2k views

MySQL requires FORCE INDEX on huge table and simple SELECTs

We have an application which stores articles from different sources in a MySQL table and allows users to retrieve those articles ordered by date. Articles are always filtered by source, so for client ...
2
votes
1answer
187 views

innobackupex is failing while exporting backup

I am using perl script which is working fine in one of my other box which used to take individual schema backups & finally take all schema together using percona innobackupex. I have following ...
1
vote
1answer
146 views

Innodb buffer pool indexes versus data usage

The server has 128GB of RAM. The innodb_buffer_pool_size is set to 106GB. mysql> show global variables like 'innodb_buffer_pool_size'; +-------------------------+--------------+ | Variable_name ...
0
votes
1answer
82 views

MySQL slave taking too long on “Queueing master event to the relay log”

I have two mysql mysql slave servers. The DB version is: mysql> show variables like '%version%'; +-------------------------+-----------------------------------------------------+ | Variable_name ...
0
votes
1answer
30 views

can i use percona to do the mapreduce job?

i am wondering that percona might can do mapreduce job like mongo, it has a handlersocket implementation isnt it? is it can do a mapreduce job? actually what i want to do is the i have to process ...
0
votes
1answer
32 views

pt-table-sync for 3 master servers

We had a mysql multi master with 3 nodes and unfortunately the replication broke. We have some set of tables which has to be in sync with other database servers, so i was looking into Percona-Toolkit ...
0
votes
1answer
115 views

Consolidated realtime mysql backup with master/slave setup or binlog

I have 20+ mysql servers and their have low write requirements. So, I want to see if any way I can replicate the data/binlog from these servers to a single slave so realtime backup purpose. If I ...
0
votes
1answer
325 views

Strange Locking issues while playing back logs via percona playback

Problem while replaying logs I am in the process of benchmarking a new DB node (specs at the end) and have run across some strange behavior: As described here i: Created a dump (innobackupex ftw) ...
2
votes
0answers
955 views

How to prevent “ibdata files do not match the log sequence number”?

I am dealing with a very large set of databases that are all innodb. I've enountered this on mysql restart too many times for my comfort: ibdata files do not match the log sequence number But I've ...
1
vote
0answers
72 views

pt-table-checksum generates no output

I've been using pt-table-checksum on our staging server successfully, but when I run ./pt-table-checksum h=localhost,u=user --ask-pass --lock-wait-time=50 --databases prod It just sits there. No ...
0
votes
0answers
5 views

Migrate from Percona Cluster to MariaDB Cluster

We are at present running latest version (5.6) of Percona Cluster. Since 5.6 upgrade we are having major stability problems and all minor updates are getting worse. Is there any possibility of ...
0
votes
0answers
14 views

How to migrate a mysql server in production to Percona XtraDB Cluster

I need some help : I have a mysql server in production and i want to migrate all the database to an existing cluster (percona xtradb). For now , my idea is : 1) Lock all tables 2) do a dump per ...
0
votes
0answers
61 views

Change a query so it no longer takes 20 mins and uses a 93G tmp table

Edit: So how would I go about changing this query to something more sane (given that I can work around the hibernate madness) This might be a whole different problem, but Hiberate has created a ...
0
votes
0answers
32 views

Percona MySQL LDAP authentication fails through .NETmysql connector

Basically MySQL uses its native authentication, where the username and passwords are stored in mysql.user table. MySQL authenticates user against the credentials stored in mysql.user table. Our ...
0
votes
0answers
56 views

Why Percona MySQL is crashing again and again

We have Percona MySQL Cluster running with three nodes on CentOS. Server : Percona-XtraDB-Cluster-server-56-5.6.19-25.6.824.el6.x86_64 One node is crashing repeatedly. Thread pointer: 0x18910ba30 ...
0
votes
0answers
36 views

LDAP authentication with Percona Server

Reading over this post it seemed to indicate this plugin allowed user authentication via LDAP Percona Server is bundled with the PAM plugin which opens a plethora of ways to authenticate to ...
0
votes
0answers
36 views

MySQL insert Needed data only then send it to crystal report

I'm Working on a big project more than 200 table, I'm using MySQL(Percona), Java & Crystal Report JRC. I have some reports which so big & has a lot of joins between multiple tables. Inside the ...
0
votes
0answers
30 views

Percona slower than vanilla Mysql 5.6

A lot of folks had suggested to use Percona as more robust and enhanced version of Vanilla Mysql. I just setup Percona 5.6 today on our server to see how it holds up against our traffic. I noticed ...
0
votes
0answers
184 views

Low Query cache efficiency after mariadb 5.5 migration

First of all, many thanks in advance for your creating this nice site/place where people can find help to our "big" issues/problems. I usually use every day and you dont know how many times I fix my ...
0
votes
0answers
135 views

SQL queries are very slow

I have noticed that my queries are getting slower. Some update queries take about 48-50 seconds. Here's how it looks: [root@db-1 ~]# tail /var/lib/mysql/mysql-slow.log # Time: 131113 17:09:48 # ...
0
votes
0answers
65 views

Percona cluster performance issue

We have 3 servers running in a percona mysql cluster. Two of the servers in the cluster are running on older hardware specs. The third is a real monster with a lot of RAM and SSD hard drives and so ...
0
votes
0answers
105 views

Is STRICT_TRANS_TABLES required for replication?

Is STRICT_TRANS_TABLES required for replication? Particularly, I need to know about it for Percona Cluster.
0
votes
0answers
143 views

Percona XtraDB Cluster With Async slaves

I have set up a 3 node percona cluster in amazon ec2. As our client required, i also had to set up an asynchronous slaves in another datacenter as well. Each async slave pointed to single percona ...
0
votes
0answers
154 views

mysql died with stack trace

My mysql server died while running select queries. Status of every table is good. When I went to the error log I found this: Thread pointer: 0x2ab63e0f49e0 Attempting backtrace. You can use the ...