Stack Overflow
Stack Overflow

Questions tagged [xtradb]

50 questions
1
vote
1 answer

Percona Xtradb Cluster failing

I have setup Percona Xtradb cluster with 3 nodes. The first node starts fine with bootstrap, but when I try to start the second node to join the cluster, I get the following error: 2015-08-27 18:08:08 25990 [Warning] WSREP: Failed to prepare for…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
1
vote
1 answer

percona replication error after shutting down the slave

We had a shutdown on slave server (at 13:47) and after that slave does not follow the master. I have all the data until the shutdown in the slave server. Here is the slave: mysql> show slave status \G
*************************** 1. row…
IAmAliYousefi
  • 1,132
  • 3
  • 21
  • 33
1
vote
1 answer

Percona Xtradb Cluster nodes won't start

I setup percona_xtradb_cluster-56 with three nodes in the cluster. To start the first cluster, i use the following command and it starts just fine: #/etc/init.d/mysql bootstrap-pxc The other two nodes however fail to start when i start them…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
1
vote
2 answers

How come I still get deadlocks even after setting wsrep_retry_autocommit really high?

I have a cluster of 3 percona xtradb 5.5.34-55 servers and since they are all writable, I get deadlock errors under any substantial load. Increasing wsrep_retry_autocommit variable helped with it to some extent, but ER_LOCK_DEADLOCK did not…
Fluffy
  • 27,504
  • 41
  • 151
  • 234
1
vote
1 answer

Percona XtraDB deadlocks on inserting with unique PK

I have a cluster of 3 percona db servers, and this table: CREATE TABLE `metric` ( `metricid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `host` varchar(50) NOT NULL, `userid` int(10) unsigned DEFAULT NULL, `name` varchar(255) NOT NULL, …
Fluffy
  • 27,504
  • 41
  • 151
  • 234
1
vote
1 answer

Percona XtraDB Cluster with HandlerSocket

The main question - is it possible to use HandlerSocket together with PXC? I've noticed that during high load writing socket crashes rather frequently with the error HNDSOCK unlock tables: commit failed.
Lisio
  • 1,571
  • 2
  • 15
  • 22
1
vote
1 answer

InnoDB: custom auto-increment using insert select. Can there be duplicate-key error?

I have a table like: idx (PK) clmn_1 Both are INTs. idx is not defined as auto-increment, but I am trying to simulate it. To insert into this table, I am using: "INSERT INTO my_tbl (idx, clmn_1) \ SELECT IFNULL(MAX(idx), 0) + 1, %s \ FROM…
Ethan
  • 4,915
  • 1
  • 28
  • 36
1
vote
2 answers

Percona/XtraDB insllation + replication setup - tips/guides for Centos 5.2

I am looking for good articles on how to install and setup Percona's patched server with XtraDB and master/slave replication setup on Centos 5.2 64 bit. I believe they can be downloaded at http://www.percona.com/mysql/5.1.34-5/RPM/rhel5/? and is…
Aaron
0
votes
2 answers

Apache, PHP and Percona Database

I have just upgraded MySQL 5.0 to Percona XtraDB 5.1. I had to yum remove all the mysql stuff first. Everything was working fine, until I restarted Apache and now I get: Fatal error: Call to undefined function mysql_connect() Any ideas? I have a…
David
  • 16,246
  • 34
  • 103
  • 162
0
votes
1 answer

Why undo log entries in MySQL innodb buffer pool (MySQL 5.7)

Long transactions generate several old versions of the rows in the undo log which are stored in ibdata file.Is there any possibility that undo log entries are also stored in the innodb buffer pool.
Saikumar A
  • 213
  • 1
  • 2
  • 12
0
votes
0 answers

MySQL information_schema change COLLATIONS IS_DEFAULT

I'm having problems with setting the default collation for the utf8mb4 and utf8 charsets on a Percona XtraDB setup. If I write a query such as this: SET @ue = 'test@email.com'; SET @u = (SELECT u.ID FROM db.users u WHERE u.user_email = @ue); It…
Tom
  • 1,275
  • 1
  • 18
  • 51
0
votes
1 answer

Percona storage engine in Workbench

I'm using Percona Server with XtraDB, but in Workbench I see the storage engine of the tables is InnoDB. How can I configure the server to use XtraDB?
mneu
  • 427
  • 3
  • 14
0
votes
2 answers

Percona/XtraDB storage volumes

One of Percona Server with XtraDB's main benefits is enhanced scalability over regular MySQL. Does anyone know how the data stored on disk for a given table compares between Percona/XtraDB and MySQL, i.e. is the same table stored in each system…
eclipse31
  • 364
  • 4
  • 16
0
votes
3 answers

Locking a MySQL INNODB row in PHP

I have a table called meta, with two columns name and value. In a php script, which is called by many clients concurrently, I do this:- $mysqli->multi_query("SELECT id FROM links WHERE id > (SELECT value FROM meta WHERE name='scan') LIMIT…
servermanfail
  • 2,532
  • 20
  • 21
0
votes
0 answers

msqldbcompare failed because of special characters

I'm trying to compare master and slave using mysqldbcompare utility, but observed that it's getting failed and in compare result its not showing difference rows.so I manually compared tables and observed that there is some special character in…
Saikumar A
  • 213
  • 1
  • 2
  • 12
1
2
3 4