Percona : MySQL open source fork with performance improvements

learn more… | top users | synonyms

0
votes
1answer
12 views

Cannot overwrite file: /var/lib/mysql/ibdata1 when using Percona xtrabackup

I am receiving an error when I am trying to restore from a percona backup to my local mysql server. Cannot overwrite file: /var/lib/mysql/ibdata1 at /usr/bin/innobackupex line 2128. sudo ...
0
votes
1answer
234 views

pt-table-checksum - Verify MySQL replication integrity

export/import: $ mysqldump -h6dhdbm01 -p clee2 users > 6dhdbm01-clee2.users.sql Enter password: $ echo $? 0 $ mysql clee2 < 6dhdbm01-clee2.users.sql $ echo $? 0 $ pt-table-checksum: $ ...
0
votes
0answers
14 views

MySQL Cluster - Adding more storage space

I have spent a few days looking into different MySQL Cluster options, such as Percona and MariaDB Galera, however from what I understand neither of them can do what I would like it to do. What I am ...
0
votes
1answer
432 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) ...
0
votes
0answers
22 views

How to troubleshoot, find and fix query Percona 5.6 with error “SQLSTATE[HY000]: General error: 1785 When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1”

i'm running Magento CMS, and underneath there are 2 physical servers both with Percona Server version: 5.6.23-72.1-log Percona Server (GPL), Release 72.1, Revision 0503478 in Master/Slave ...
2
votes
1answer
169 views

How mysql (innodb) handles auto increment column

I am working on a OLTP environment with multiple parallel write operation. I found this in documentation about auto increment locking but still i am interested to know much about it in details. Can ...
1
vote
1answer
217 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 ...
1
vote
1answer
265 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 ...
1
vote
0answers
34 views

pt-archiver and foreign keys?

How does pt-archiver handle foreign keys? Does it archive associated data? (seems not but the documentation is not very clear to me) And if not, how could one perform an archive of a table with all ...
3
votes
2answers
491 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 ...
0
votes
1answer
35 views

How to determine if an Index is uselss in Percona MySQL?

Using Percona Server 5.5 I've a table which stores user activty (lets call it user_activity). It was created quite a few years ago when I had only a little bit of knowledge about database ...
0
votes
1answer
39 views

set session wait_timeout inside of phpmyadmin for export/import

I need to increase wait_timeout variable in mysql only when access mysql from phpmyadmin. I don't want to edit my.cnf file or set it globaly in mysql server. I've read documentation, but haven't ...
0
votes
1answer
164 views

Mariadb Galera Cluster using Xtradb backup is not working

I am trying out the first test of MariaDB Galera cluster setup without success. This is the error in the log innobackupex: Created backup directory /tmp tar: -: Cannot write: Broken pipe tar: Error ...
1
vote
1answer
33 views

percona cluster 5.6 - handshake with remote endpoint failed, but endpoint is not part of config

I set up a cluster of 3 database nodes using a percona 5.6 cluster. Everything works, all nodes are replicated. I configured SSL for state transfer. The cluster recently changed its topography, ...
2
votes
1answer
211 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
37 views

Percona MySQL 5.6 databases ignoring key length at constrait creation

We have a 3 servers running Percona MySQL 5.6 in a Master/Master configuration that are all reporting errors on key length, either too long or not specified. The structure of the databases is all ...
0
votes
1answer
21 views

Mysql Multiple data files rollover size

we want to setup the mysql ibdata files in such a way that after every 100M , new data is added to another file specified in innodb_data_file_path i.e. ...
2
votes
1answer
44 views

Will large inserts crash a 3-node MySQL database cluster?

We have a 3 node MySQL database cluster than runs on Percona. I have a stored procedure that inserts a lot of rows in one hit, potentially over a million rows. I've been warned (by our DBA) this ...
2
votes
1answer
125 views

Mysql Cluster vs Percona/Maridb Cluster [closed]

We want to setup a mysql cluster with master-master sync replication, to provide HA so that one db for write from one app, other for write from other app. It is a webapp with high write and medium ...
0
votes
0answers
35 views

InnoDB Recovery failed after Percona5.6 crash

The Server has crashed and now there is a problem when starting Percona5.6: 2015-03-19 17:26:45 2060 [Note] InnoDB: The log sequence numbers 365752853 and 365752853 in ibdata files do not match the ...
1
vote
1answer
595 views

Difference between FIND_IN_SET and LIKE

is there a difference in behavior or performance in choosing FIND_IN_SET over LIKE for a operation that looks like: SELECT * FROM my_table WHERE column_1 LIKE %string% vs SELECT * FROM my_table ...
0
votes
0answers
17 views

Percona XtraDB Cluster: Node going in hang stage again and again

I am getting below error again and again on Percona XtraDB Cluster nodes and after this my MySQL service is going in hang state. 2015-03-16 08:39:05 13254 [ERROR] WSREP: Unsupported key prefix: ^B: ...
2
votes
2answers
470 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 ...
0
votes
1answer
47 views

Does Percona Xtrabackup support RedHat release 4

I downloaded Percona's Xtrabackup rpm file for RedHAT. I attempted to install but hit into an error. The error seems to point to missing dependencies and libraries. I have no issue with RedHat 6 OS. I ...
1
vote
1answer
94 views

MySQL 5.5 Replication to Galera/Percona XtraDB Cluster

We are currently investigating moving our current MySQL 5.5 Master > 5 x Slaves (with Statement Based Replication, apx 250GB data and growing) to a HA clustering option. Mainly to provide greater ...
1
vote
1answer
579 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 ...
3
votes
1answer
5k 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 ...
0
votes
1answer
45 views

Mysql master master with high latency

We have a single master setup with many slaves in germany and some slaves in australia. To have faster writes in australia we want a master-master setup between germany and australia. Read slaves ...
1
vote
2answers
51 views

How pt-online-schema-change ensures consistency during data copy

I have read pt-online-schema-change documentation and understood that it works by creating triggers and copying data in chunks with in chunk-time seconds(0.5 seconds in default) Let us consider this ...
0
votes
1answer
45 views

Mysql JOIN with 25million rows

Recently I got stucked with a table where its grown to +25million and I have got a query that's doing a JOIN on it. The query take 2.5hours to execute even though I got Good 96GB RAM and RAID10 with ...
1
vote
1answer
43 views

Mysql Partitions with Partition limit

I have a partition table on basis of Primary key having 1.5 Billion rows in it. But when i check ibd files only 80 ibd show in GB's whereas 120ibd shows 1MB file. I would like to know how does the ...
0
votes
1answer
60 views

Slow ranking values in MySQL

I have a table of around 30 million retail products, with various INT columns that describe sales counters and pricing at different retailers. I'm supposed to display well over 70 different rankings ...
0
votes
1answer
218 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
19 views

Does pt-table-checksum work in circular replication environments?

I have 3 masters in circular replication. I run pt-table-checksum in one of the masters only. A->B->C->A The queries do get replicated the "next" server B but I don't think they are being replicated ...
0
votes
0answers
68 views

What could be causing mysql to spike CPU load?

I'm running Mysql 5.5.28 and it seems at random times I get high CPU on mysql, during the high load I cant find anything wrong in the process list, as the load increases the longer it takes to run ...
0
votes
0answers
62 views

Very slow IO on mysql percona server

Our site goes down because the IO on our database servers is too slow. Troubleshooting this we found that mysql is really really slow. It's constantly reading from disk and I think not using enough ...
0
votes
1answer
20 views

Is this normal binary logging behaviour - maintaining one ever growing file despite expire_logs_days?

I have a Percona MySQL DB running on a dedicated server. I have in my.cnf # REPLICATION # log_bin=/var/lib/mysql/binlogs/mysql-bin expire_logs_days=7 My issue is that the log file mysql-bin.000001 ...
0
votes
1answer
34 views

Any recommendation on my.cnf on aws.large instance?

Any best recommendation variables for my.cnf on percona server on a high 256GB RAM and 32 CPU with 4000 IOPS? How about below ones? > innodb_buffer_pool_size=180G > ...
1
vote
2answers
94 views

OOM in mysql-percona

Every 4th day I run in to OOM problem. [Sat Dec 27 12:20:21 2014] Out of memory: Kill process 3662 (mysqld) score 990 or sacrifice child [Sat Dec 27 12:20:21 2014] Killed process 3662 (mysqld) ...
0
votes
0answers
61 views

Is impossible percona xtrabackup restore backup data on mysqld?

I am testing percona xtrabackup. I hear a lot advantage of it. I have purpose to use it instead of mysqldump. Based on document ...
1
vote
1answer
359 views

Upgrading mysql percona server from 5.5.40 to 5.6.71

2014-12-26 05:18:20 13215 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2014-12-26 05:18:20 13215 [ERROR] Native table ...
0
votes
0answers
15 views

Percona XtraDB and innodb_flush_log_at_trx_commit=2

I'm running Percona XtraDB on a three nodes cluster. Each one has this piece of configuration: innodb_flush_log_at_trx_commit=2 sync_binlog=0 I perfectly know that this is not the safest ...
1
vote
3answers
310 views

HA - MySQL Master Master replication - Duplicate entry errors

I am running Percona MySQL 5.5.39 on two masters with keepalived monitoring a VIP which will failover to the standby master if the primary master goes dark. While testing the fault tolerance of my ...
2
votes
1answer
183 views

What is the Best way to set Disaster recovery setup for percona Xtra DB Cluster?

We do have a Percona XtraDB Cluster(Master-Master-Master) setup in one country. Now we want to setup a disaster recovery setup in some other country. Please provide us the best possible ways to do ...
1
vote
1answer
218 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 ...
6
votes
2answers
803 views

Transaction speed benchmarks for mySQL v5.6 replication - seems very slow

I'm trying to select the best configuration for our new infrastructure but got a bit confused about the results. I used sysbench v0.5 for the tests: prepare data sysbench ...
0
votes
1answer
29 views

Rescue truncated data from incorrect column type

I have mistakenly inserted a variable 18-20 digit variable into an unsigned INT() column. The data has been truncated to the max 32bit length so all my data is displayed as "4294967295" Is there ...
0
votes
0answers
29 views

Choose prefered node for IST in Percona XtraDB Cluster

Percona XtraDB Cluster 5.5. Is it possible to use only selected donor node for IST? Like wsrep_sst_donor option for SST.
0
votes
0answers
28 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
2answers
2k views

How to resolve: Specified key was too long; max key length is 767 bytes [duplicate]

Our server is creating a lot of tables and one of them is the Lock_ table. We are using MySQL 5.5 on Percona. Also we are using utf8_general_ci and utf8. It throws the following error when creating ...