Percona : MySQL open source fork with performance improvements
11
votes
2answers
3k views
How do I properly perform a MySQL bake-off?
I want to performance test (aka bake-off) MySQL server rpm against some other forks such as Percona server, MariaDB, and possibly some others. I'm hoping that by asking this question I can better ...
6
votes
2answers
390 views
Investigate peak in MySQL throughput
Recently one of our servers has ran out of memory and crashed. After reviewing the munin graphs, it appears that the only metric (other than memory usage) that peaked just before the crash was the ...
4
votes
1answer
971 views
What is the difference between XtraBackup and rsync?
Yes, I'm going to run strace on them both... However, I would like to know ...
What is XtraBackup is doing over and above rsync -ac src dest ?
What's so special about XtraBbackup ?
How is XtraBackup ...
4
votes
2answers
1k views
Scaling Percona datacenters: setup and replication
Since our startup has taken off nicely we are now meeting with some of those issues that you always assumed would NEVER effect you.
We have already scaled alot of our application stack: we offloaded ...
3
votes
2answers
2k views
Percona vs MySQL
What is Percona?
How does it differ from MySQL?
When should we consider switching (or upgrading) from stock MySQL to Percona?
To add some specifics in our situation we almost exclusively use ...
3
votes
3answers
191 views
Is it possible to pass parameters to pt-table-checksum using an options file?
We're using Percona's pt-table-checksum for MySQL replication integrity check.
Is it possible to pass some or all of the options using some sort of configuration file?
For instance, can we write the ...
3
votes
1answer
83 views
Backup and off-site restore setup
I've been reading a lot of threads about different backup options for MySQL and was hoping for some more insight so I can settle on one.
Our current situation is ~100 GB of InnoDB and MySAM data in ...
3
votes
1answer
3k views
Fixing tables out of sync as reported by pt-table-checksum, pt-table-sync is not working
I have several tables being reported by pt-table-checksum with CRC_DIFF between my master and slave servers using the following commands:
$ pt-table-checksum h=master,u=user,p=password ...
3
votes
1answer
423 views
MySQL Handler_read_rnd_next == tablescans without indexes?
I am in the process of tuning our Percona 5.5 server, and have been using percona's tools to plot our database's performance.
In the MySQL Handlers Plot, i have been noticing alot of ...
3
votes
0answers
202 views
XtraDB Cluster Error : “IST first seqno 7 not found from cache, falling back to SST” in replication
I have a problem with MySQL clustering. My systems consist of:
xtrabackup: version 2.0.2
MySQL: version 5.5.27
Distro: CentOS 5.7 64-bit
my.cnf on the donor:
[mysqld]
binlog_format=ROW
...
2
votes
2answers
287 views
What is an “empty query” in information_schema.CLIENT_STATISTICS?
The client stats table has an "empty queries" column. What does that mean? Simple googling just tells me "The number of times this client's connections sent empty queries to the server." /facepalm
2
votes
1answer
162 views
Why are my queries getting really slow?
I own a WordPress installation, and Updated to 3.4.1.
After the upgrade, I experienced a very strange slow-down.
After all, I used the
define('SAVEQUERIES', true);
in my wp-config.php with ...
2
votes
1answer
366 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. ...
2
votes
1answer
178 views
Percona XtraDB Cluster: How to skip SST when starting?
Is there a way to skip State Snapshot Transfer (SST) at startup on Percona XtraDB Cluster Server?
wsrep_sst_mode=skip doesn't work:
121003 6:49:55 Percona XtraDB (http://www.percona.com) ...
2
votes
1answer
138 views
Does this make my XtraDB Cluster hang?
After seeing the following in the error log on the second node:
121003 7:16:06 [Note] WSREP: Member 0 (joiner) synced with group.
121003 7:16:06 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
...
2
votes
1answer
189 views
Assertion failure from InnoDB while restoring using Innobackupex
I thought I would give back to all those people who help me when I have a problem. This might be something old, but I did not find it anywhere so here goes:
We recently upgraded our production DBs ...
2
votes
1answer
93 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
21 views
xtrabackup backup grants?
I'm using MySQL 5.5 + Opensuse 12.3 .
After face an issue with mysqldump (appear be a bug with OpenSuse Mysql distribution) I have looking for others backup solution.
I found the xtrabackup from ...
1
vote
2answers
133 views
Ubuntu / MySQL / Percona XtraBackup gives error “sh: 1: xtrabackup_55: not found”
Hello I installed Ubuntu 12.04.2 LTS on a fresh box.
This installed MySQL 5.5.29.
I installed percona-xtrabackup-2.0.6-521.tar.gz, and moved the executables to /usr/bin/
But innobackupex is ...
1
vote
1answer
252 views
Should a MySQL replication slave be set to read only?
I've got replication running on Percona Server 5.5 by following this guide and wondered if I should add read-only=1 to my slave's my.cnf to make it read only?
The guide sets up replication for the ...
1
vote
1answer
472 views
Why default character_set_server is latin1?
I am using MySQL 5.5 and when I show variables about charset, I have
+--------------------------+----------------------------+
| Variable_name | Value |
...
1
vote
1answer
139 views
xtrabackup “failed to read metadata” [closed]
Doing a staging run setting up a new xtrabackup restore script I'm running into a somewhat cryptic error I can't readily google a solution for.
I'm working with an incremental backup design. During ...
1
vote
1answer
37 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 ...
1
vote
0answers
49 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
1answer
109 views
Is using the alpha version of Percona 5.6 safe? [closed]
I'm really sorry if my question is kind of very basic, but is something that is really making me thinking a lot about it for a long time. As Percona has a lot of lines of optimizing codes, I run it ...
0
votes
1answer
259 views
percona mysql crashing at innodb initialization
i have a slave percona db setup that also maintains few of it's own tables
it started crashing with this in error.log:
InnoDB: In a MySQL replication slave the last master binlog file
InnoDB: ...
0
votes
0answers
11 views
Percona Xtradb cluster only replicating DDL statements
I'm having a hard time with percona xtradb cluster. The cluster has 3 nodes, and is up and running (all tip top according to wsrep status indicators).
It did the SST perfectly fine from one node to ...
0
votes
0answers
17 views
Can i use XAMMP mysql server with Percona Xtradb cluster?
I just wanted to know if I can use a normal MySQL server (XAMPP) as part of the cluster on my EC2 Server running Percona XtraDB Cluster.
Can I just change the my.cnf config file on XAMPP with the ...
0
votes
0answers
26 views
Many databases - Which MySQL Clustering to use? [closed]
Our intention is not to host one big database but to host many small databases (~30k databases).
MySQL Cluster 7.3/7.2
By default auto sharding based on primary key of table.
Reference : ...
0
votes
1answer
526 views
Problem with Error: InnoDB: page … log sequence … number is in the future!
i know this question was asked before, but i am at a point where i am really stuck and do not know how to continue with this problem and i would really like to know, what causes this error to come up.
...
