Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [xtradb]

XtraDB : Enhanced InnoDB Storage Engine

XtraDB is an ACID compliant Storage Engine modeled around InnoDB but with the following:

  • Better scaling for modern hardware
  • Enhanced Performance Metrics
  • More tuning options

This was first released by Percona on December 16, 2008. They created it as a Drop-In Replacement for InnoDB. It comes standard with Percona Server.

Learn about it ...

22 questions
6
votes
1 answer

Tuning dedicated Percona Server with XtraDB for OLTP

Hardware specs for an OLTP DB dual quad core xeon with hyperthreading 24GB ram Hardware RAID10 BBU Software specs Standard install of Ubuntu 10.04LTS with default LVM partitioning Installed Percona Server with XtraDB My priority is data…
Jessie Evangelista
  • 61
  • 2
4
votes
1 answer

Is the innodb_lazy_drop_table problem solved?

I'm researching database configuration for MySQL/MariaDB. I've been reading the configuration chapter in "High Performance MySQL". In there, it suggests that innodb_lazy_drop_table can be used to avoid server stalls when dropping tables if…
Alex
  • 151
  • 5
3
votes
1 answer

Very poor insert performance MySQL / Percona Server

I'm running a Percona-Server instance off an Ubuntu server install. I'm using an application that needs to access this database, and its having VERY poor performance. Once the database has been established, the application goes in (upon install)…
Tony
  • 133
  • 1
  • 3
3
votes
1 answer

MariaDB and XtraDB/InnoDB plugins

In my vps, I thought of switching from MySQL to MariaDB (using Monty's repository for Debian Squeeze). Copying over my.cnf from MySQL to MariaDB, I saw that the new config file (the one from the MariaDB package) does not mention any plugins commands…
GoofyX
  • 239
  • 2
  • 12
3
votes
1 answer

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) 121003 7:16:06 [Note] WSREP: Synchronized with group,…
quanta
  • 1,006
  • 9
  • 22
  • 36
3
votes
1 answer

Hybrid Synchronous / Asynchronous Replication?

We have a situation where we would like to have synchronous replication in our main data center, but replicate asynchronously to another region. Our second data center is 3,000 miles away (Site B) and we use it as a warm backup in case we need to…
amatusko
  • 507
  • 1
  • 5
  • 11
2
votes
1 answer

Unknown storage engine 'XtraDB'

I installed Percona Server 5.6.12-rc60.4, when I want create table such as : CREATE TABLE IF NOT EXISTS `mydb`.`table` ( `id` INT NOT NULL AUTO_INCREMENT , `title` VARCHAR( 64 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = XtraDB DEFAULT CHARACTER…
Arash Mousavi
  • 673
  • 2
  • 12
  • 21
2
votes
1 answer

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) 1.1.8-rel28.1 started; log sequence number…
quanta
  • 1,006
  • 9
  • 22
  • 36
2
votes
2 answers

Is there any performance difference among MariaDB (xtradb plugin) and XtraDB Server for InnoDB?

Title says it all. However i have to enter at least 30 characters.
cedivad
  • 131
  • 1
  • 4
2
votes
1 answer

MariaDB XtraDB Performance Tuning

I believe that innodb has a single read thread. However, with MariaDB you can set multiple read threads. I'm unsure what the recommended value would be. Questions Does anyone have any experience with MariaDB and performance tuning? Can you think of…
Mark D
  • 1,140
  • 4
  • 16
  • 28
2
votes
1 answer

SQLyog and MariaDB engine

I am quite new in MariaDB and I use SQLyog Community Edition as the frontend GUI. Whenever I create a new table, on the Engine dropdown, there is no XtraDB option. Is there any additional steps I am missing? As I've read, XtraDB is the InnoDB…
Dan_The_Man
  • 23
  • 3
1
vote
1 answer

In which situations is TokuDB higher performance?

I noticed that WordPress runs quite a bit faster when I use XtraDB (MariaDB's InnoDB replacement) instead of TokuDB. This is strange, because TokuDB is advertised as being 20x faster. However, I noticed that YOURLS stat pages are a tiny bit faster…
Andrew Sun
  • 111
  • 5
1
vote
1 answer

mariadb 5.5.36 with innodb plugin

I installed mariadb 5.5.36 on a win32 system. Everything runs fine except innodb requests are 2 x slower than an identical MySQL installation. So I want to switch back to original innodb plugin to test the performance with it. In my.ini I put under…
user212901
  • 11
  • 2
1
vote
0 answers

MariaDB Galera Cluster

I have two mariadb servers in cluster that is working galera and xtradb. it is my primary server…
Dimitar
  • 11
  • 1
1
vote
1 answer

Native replication from Percona XtraDB Cluster to a standard stand-alone slave

I'm replicating from one node of a three-member Percona XtraDB cluster to a separate slave, using regular MySQL replication. The node is set to write binlog in ROW mode, with log_slave_updates=true specifically for this. Replication seems to work…
Alexy
  • 157
  • 2
  • 6
1
2