Questions tagged [xtradb]

XtraDB : Enhanced InnoDB Storage Engine

Filter by
Sorted by
Tagged with
0 votes
1 answer
34 views

Percona/XtraDB Database with many of writes to a small table uses less CPU than the same database with less writes?

I'm trying to understand why Percona and xtradb InnoDB/MySQL behaves the way it does and if there's anything I can change in the configuration to fix it. I've a InnoDB database with only one table ...
user avatar
  • 1
0 votes
1 answer
267 views

Can XtraDB be enabled on MariaDB 10.2

Can we create a table in MariaDB 10.2 with XtraDB engine? I have installed MariaDB 10.2 and I am trying to create a table with storage engine XtraDB and I am getting error *mysql> CREATE TABLE T1(ID ...
user avatar
1 vote
1 answer
796 views

MySQL PXC node failing to receive state

I have three nodes that I want to setup into a Percona XtraDB Cluster (PXC). I have bootstrapped the first node and joined the second node, but cannot somehow join the third node. All configuration is ...
user avatar
1 vote
1 answer
70 views

Percona xtradb Backup for OLTP

I have installed MySQL 5.7 community edition installed. Can we use Percona xtradb backup tool for backup DB for banking site databases for OLTP?
user avatar
0 votes
1 answer
283 views

Percona XtraDB cluster backup solution

We have a 3 node percona xtradb cluster and two slaves attached to it. One of the slaves we want to use it for taking backups. We have GTID based replication setup between the slave and the Xtradb ...
user avatar
2 votes
1 answer
648 views

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 ...
user avatar
  • 427
2 votes
1 answer
651 views

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 ...
user avatar
1 vote
1 answer
550 views

In which situations is TokuDB higher performance? [closed]

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 ...
user avatar
1 vote
1 answer
1k views

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 ...
user avatar
4 votes
1 answer
902 views

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 ...
user avatar
  • 143
1 vote
0 answers
350 views

MariaDB Galera Cluster

I have two mariadb servers in cluster that is working galera and xtradb. it is my primary server configuration: [mysqld] datadir=/var/lib/mysql query_cache_size=0 binlog_format=ROW ...
user avatar
  • 11
1 vote
1 answer
835 views

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 ...
user avatar
  • 147
0 votes
1 answer
85 views

Indexes on XtraDB tables

I have old db with myisam tables, using mariadb and want try move to xtradb for row-level locking. Each table have 27 columns, primary index and other 11 indexes. Columns with indexes have many ...
user avatar
  • 233
1 vote
1 answer
8k views

Why should I use InnoDB and MySql instead of XtraDB and MariaDB? [closed]

Why should I use InnoDB and MySql instead of XtraDB and MariaDB, except that InnoDB and Mysql happen to be installed by default on my servers? Why isn't MariaDB and XtraDB installed by default ...
user avatar
  • 199
0 votes
0 answers
46 views

Is RI on a parent XtraDB table maintained after Optimize Table?

$ mysql dbnam -e' optimize table theTable' +----------------+----------+----------+-------------------------------------------------------------------+ | Table | Op | Msg_type | ...
user avatar
2 votes
1 answer
2k views

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 ...
user avatar
3 votes
1 answer
9k views

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 ...
user avatar
  • 33
3 votes
1 answer
3k views

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 ...
user avatar
3 votes
1 answer
2k 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) ...
user avatar
  • 976
2 votes
1 answer
607 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) 1.1.8-...
user avatar
  • 976
2 votes
2 answers
2k views

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

Title says it all. However i have to enter at least 30 characters.
user avatar
  • 131
6 votes
1 answer
2k views

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 ...
user avatar
2 votes
1 answer
4k views

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 ...
user avatar
  • 1,070