Percona : MySQL open source fork with performance improvements

learn more… | top users | synonyms

1
vote
1answer
192 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
332 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
2answers
293 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 ...
2
votes
1answer
4k 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
210 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
131 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
12 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
1answer
88 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
30 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
1answer
385 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
1answer
199 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 ...
0
votes
0answers
22 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
18 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
23 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 > ...
2
votes
1answer
81 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 ...
2
votes
2answers
351 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 ...
1
vote
2answers
44 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
15 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
41 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
6 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
175 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
65 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
138 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
469 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
16 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
23 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
275 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 ...
0
votes
1answer
175 views

Percona cluster + Wordpress blogs, low performance

We currently run ~ 900 WordPress blogs on several machines so was decided to move to load balanced environment with clustered db. I followed instructions from ...
3
votes
1answer
370 views

How to migrate from MySQL to MariaDB or Percona with minimum downtime?

I want to migrate my MySQL 5.1 database to one of these databases: MariaDB, PerconaDB or MySQL 5.6 Is there any way to do this operation with no downtime or with minimum downtime possible? How? The ...
0
votes
1answer
40 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
78 views

MySQL my.cnf: innodb_log_file_size is missing

How to set innodb_log_file_size to MySQL database if there is no innodb_log_file_size in my.cnf configuration file? I'd like to backup via Percona Xtrabackup and the backup crashes at this point ...
3
votes
2answers
4k views

query_cache_type = 0 vs query_cache_type = 1

Recently, I moved from standard MySQL to Percona, and used the Percona Wizard to generate my.cnf. However, I can see that, by default, the generated settings for my.cnf use query_cache_type = 0. ...
0
votes
0answers
56 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 ...
2
votes
2answers
46 views

Is it necessary to run apply-log immediately after innobackupexec has run?

i have been trying to read other questions, but i did not find a answer to suit me. So excuse me if i ask something that has been already asked. I'm trying to organize my self and backup all my mysql ...
1
vote
1answer
263 views

Debugging error report percona 5.6

I'm running percona 5.6 on a new centos 6.4 server. Things seem to work OK. I personally only really use InnoDB tables for my databases, but only the standard 'mysql' table is in MyISAM format. I ...
1
vote
1answer
136 views

Archive partition before delete it?

I have manage to create an event and with the following scripts could both create and delete the partition. The issue now I need help on how to save the partition before its deleted? Should I use ...
2
votes
1answer
79 views

MySQL Replication - Master Master - Single Master write

I am looking to improve our fault tolerance for our persistent store. After reading several online docs about how to set-up master <> master replication, I'd still like to ask the experts about the ...
0
votes
0answers
60 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
217 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
100 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 ...
5
votes
1answer
175 views

Percona MySQL 5.5 Unique key is duplicated

I'm totally out from ideas, so maybe somebody else could answer my question. We have a MySQL 5.5 server from Percona with high traffic. The application is in PHP and writes always to master. We have ...
0
votes
0answers
87 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 ...
1
vote
1answer
205 views

one node in cluster got crashed ,how to recover it?

we are using percona galera cluster with 3 nodes. In my cluster one node got crashed due to low disk space ,we have cleared some log files and provided sufficient disk space.Now we are trying to start ...
1
vote
2answers
101 views

Any way to force “garbage collection” in TokuDB?

Playing around with TokuDB I'm finding even after "optimize table" for things such as changing row compression or other DDLs it takes a non deterministic amount of time for freed space to be reflected ...
1
vote
1answer
468 views

Mysql error : Slave SQL Could not execute …on table

Im running a percona cluster of 3 nodes. Yesterday I needed to throw some more memory in them, so I had to power down all nodes Now I booted up and then my 3rd Node, Gave me this error : 140701 ...
0
votes
0answers
48 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 ...
1
vote
1answer
128 views

percona xtrabackup to backup mysql database

I'm trying to use percona xtrabackup to backup a mysql database. in the restoring the database according to the documentation: rsync -avrP /data/backup/ /var/lib/mysql/ this will copy the ibdata1 ...
0
votes
1answer
328 views

trouble installing percona 5.6 on google compute engine debian

I've been trying to install percona server on a fresh google compute engine instance. I havent installed mysql server previously. i followed the instructions from here ...